Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Row Heights
When I copy a sheet the row hieghts do not copy over as well.
How can I make the Row hieghts and for that matter column widths copy over when I copy a range of a spreadsheet? Thank you... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Row Heights
Mixed message in your description.
"copy a sheet" and "copy a range" are not the same thing. If copying a sheet using right-clickmove or copycreate a copy the formatting will not change. If you copy entire rows and columns the heights and widths will be copied. If you simply copy a range of cells, the heights and widths will not copy. Gord Dibben MS Excel MVP On Thu, 29 Oct 2009 21:04:23 -0400, "Dorian C. Chalom" wrote: When I copy a sheet the row hieghts do not copy over as well. How can I make the Row hieghts and for that matter column widths copy over when I copy a range of a spreadsheet? Thank you... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Row Heights
If you copy a range you can use paste specialcolumn widths. There is no row
height option. -- Ken "Using Dbase dialects since 82" "Started with Visicalc in the same year" "Gord Dibben" wrote: Mixed message in your description. "copy a sheet" and "copy a range" are not the same thing. If copying a sheet using right-clickmove or copycreate a copy the formatting will not change. If you copy entire rows and columns the heights and widths will be copied. If you simply copy a range of cells, the heights and widths will not copy. Gord Dibben MS Excel MVP On Thu, 29 Oct 2009 21:04:23 -0400, "Dorian C. Chalom" wrote: When I copy a sheet the row hieghts do not copy over as well. How can I make the Row hieghts and for that matter column widths copy over when I copy a range of a spreadsheet? Thank you... . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Row Heights
Gord; Yes I am sorry...I am copying a Range since when I tried to copy a sheet I was getting error because of the llookup functions I was using were linked to external tables I was getting errors. When I tried to do just a range the errors did not occur and my function could run to completion. Only now I do loose my Row Height, Clumn Widths being kept when I copy the range. Is there some code I could write to restore that formating? Thank you "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Mixed message in your description. "copy a sheet" and "copy a range" are not the same thing. If copying a sheet using right-clickmove or copycreate a copy the formatting will not change. If you copy entire rows and columns the heights and widths will be copied. If you simply copy a range of cells, the heights and widths will not copy. Gord Dibben MS Excel MVP On Thu, 29 Oct 2009 21:04:23 -0400, "Dorian C. Chalom" wrote: When I copy a sheet the row hieghts do not copy over as well. How can I make the Row hieghts and for that matter column widths copy over when I copy a range of a spreadsheet? Thank you... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Copy range of Row heights from one sheet to another in XL? | Excel Worksheet Functions | |||
how to copy row heights from one sheet to another in Excell | Excel Discussion (Misc queries) | |||
how to copy row heights from one sheet to another in Excell | Excel Discussion (Misc queries) | |||
Excel: copy grid, widths & heights down page: heights wrong! why? | Excel Discussion (Misc queries) | |||
how can I repeat row heights in the same sheet | Excel Discussion (Misc queries) |