Pasting

[Slyslap]

When I copy a range of cells that have wraped text, Columns wider than others and cells deeper tan others, why when I copy and paste them on to a new sheet does it cram up into columns and cells all the same size. Can I paste in a way to do it as it was copied?

Ta! Paul

 

[Juan Pablo González]

I think it works if you copy the entire column.

 

[Slyslap]

Hmmm! It is when i filter information from a master sheet, I want to pase the selected range of information onto a new shhet. When I do this it does not retain the original width of of the copied column.

Regards
Paul

 

[Barry Katcher]

The copy/paste seems to copy the wrapped text properly, increasing the row heights of those cells that have increased row height in the original, without having to copy the entire column(s). To get the same column width - after you copy/paste, click on "Edit/Paste Special", check "Column widths" and click on "O.K.".

 

[Slyslap]

It looks like I need to take a typing coarse also!!!!

Paul

 

[Barry Katcher]

Your typing seems o.k., but check your spilling.

 

[Slyslap]

Thanks for the tip! Very funny

Thanks again
Pale

 

[Slyslap]

Just noticed that in PASTE SPECIAL that I do not have a column width option!!!!!

Paul

 

[Barry Katcher]

What version of Excel do you have? Mine is 2000; don't know about previous versions.

 

[Slyslap]

Many moons ago (Hooowwwll) Excel 97 existed and I still have a copy. I guess that is my problem wolf man

Paul