View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Hayseed Hayseed is offline
external usenet poster
 
Posts: 6
Default how to copy row heights on the same sheet to another position.



"Hayseed" wrote:

After the spreadsheet is created (with several altered row heights),it is
copied to a new worksheet, the copied sheet does not have the same row
heights as the original sheet. The only way I have found to correct the
incorrect row heights is to either manually alter the incorrect row height,
or use the format painter. I would hope that I could just copy the original
sheet with the altered row heights and paste and be done.


Your response worked great, THANKS, but there is another problem.
When I make a copy of the expense report (with altered row heights) and then
attempt to make a copy below the created report,on the same sheet, the row
heights are not the same. A row height that was set in the original at say 30
will be 25.5 in the copy. All altered row heights will be reduced except the
rows that were not altered.