Copy sheet including column width / row heights
Copy sheet including column width / row heights
(OP)
Greetings from Montreal:
We need to copy spreadsheets (values and/or formulas) from an existing sheet to a blank sheet including column width / row heights. Paste special doesn't retain this info. Any other ways?
tg
We need to copy spreadsheets (values and/or formulas) from an existing sheet to a blank sheet including column width / row heights. Paste special doesn't retain this info. Any other ways?
tg





RE: Copy sheet including column width / row heights
try paste special and select the format option? worked for me using xl 2000.
what version of xl is being used?
i believe that versions 2000 or recent have the capability to paste column widths - yes, now confirmed!
-pmover
RE: Copy sheet including column width / row heights