Yes.... I highlight all my cells, right click, select copy... I then
try pasting into a separate sheet (using either "Paste" or
"Paste Special". It pastes all the cell colors, fonts and data.
The only thing missing is the cell and column sizes. So I gotta
go and manually resize all rows and columns which is kinda
time consuming.

Got any other ideas?


"Don Guillett" wrote in message
...
Have you tried a right clickcopy

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Robert Crandal" wrote in message
...
I wanted to copy and paste one sheet to another sheet. The
problem is, I can't seem to copy EVERYTHING over,
including row and column heights, etc etc....

I used "Paste Special" during my paste, but it does not copy
over the row and column heights. What am I doing wrong??

thanx