Thread: Copying Formats
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JoeSpareBedroom JoeSpareBedroom is offline
external usenet poster
 
Posts: 87
Default Copying Formats

I know how to use the paste special / format command for things like fonts,
alignment, number formats, etc. But, I've got a sheet whose first 5 rows
have had their heights changed in various ways. I need to continue this
formatting down the page. (Row 1 height =20, Row 2 height = 40, for
instance). In other words, each batch of 5 rows needs to have heights like
the first 5 rows.

Any easy way to do this?