Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Excel won't copy outside sheet | Excel Discussion (Misc queries) |