![]() |
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 |
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