Copying part of Spreadsheet while keeping Columns Widths and Rows Heights

[Amr Tabbarah]

I want to copy part of an existing spreadsheet to a new empty sheet.

The normal Copy & Paste do not carry the Columns Widths and the Rows
Heights to the new sheet, hence they have to be adjusted manually.

Does anyone have a way to make this possible?

 

[Judy Freed]

In Excel XP, I made this work by doing a sort of a "double copy" Copy what
you want, then select Edit, Paste Special, All. That copies the data. (I
found that if I was copying an entire column, the column widith was copies
also. ) But, for partial data, it was not, so after I did Edit, Paste All,
I reselected Edit, Paste All, Column Width (any other options, etc.) There
is probably a better way but that worked for me.

Judy Freed

 

[Amr Tabbarah]

Thank you Judy.

Now I have half the problem resolved. I still need a similar result
with the rows.

Any clues?


Amr

 

[Judy Freed]

I just remembered this - when you copy the data from the cells, and the
smart tag displays, click on the smart tag and select Keep Source
Formatting. There are additional options there, Keep Column Width, etc. I
use the Smart Tags all the time, and cant believe I did not think of them
first. Sorry.

Judy Freed

 

[Amr Tabbarah]

Thanks again Judy.

I have tried the Smart Tag. However, the default option "Keep Source
Formatting" gave me a similar result to the copy/paste. The option
"Keep Source Columns Widths" worked fine.

I am still looking for a way to have a silimar result with the rows
formatting.


Amr