how to copy row heights from one sheet to another in Excell

H

Hayseed

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. I am using Office
student and teachers edition 2003
 
P

Prasadkakarla

Hi Hayseed
i got u r question in that my idea u want copy a sheet with same format and
row,col height width same u want....

copy paste option i tried but i didnt get same formate height and all there
is one way to get same format and row height width and all.

Sheet 1 ..... mouse right click........ move or copy just click ....copy a
sheet ... target place where u want to copy that sheet , if it is in same
file no neet select target address.. if u want to copy some other open
excel file just drop down the target add and select the file name ..

thats all u will get the same sheet copied to same file or anther select new
file...

check and give me reply
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top