ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to copy row heights from one sheet to another in Excell (https://www.excelbanter.com/excel-discussion-misc-queries/127607-how-copy-row-heights-one-sheet-another-excell.html)

Hayseed

how to copy row heights from one sheet to another in Excell
 
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

Prasadkakarla

how to copy row heights from one sheet to another in Excell
 
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

--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI



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



All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com