In previous versions of Excel when I copied an entire sheet to a new sheet,
the column widths and row heights were also copied. However, that does not
work in Excel 2007. I was able to get the column widths using paste
special-column widths. But I cannot get the row heights. I even tried
copying the formatting but that did not work. I copy sheets a lot and have a
lot of different row heights which would take forever to have to fix
individually again. If this is an "upgrade" with this version, it is
terrible. Any suggestions?

I don't know what I'm doing differently but I select the entire worksheet
using the little button top left (to the left of Column A and above Row 1)
then Copy, and then paste that into the new worksheet and it copies
everything, row heights and column widths included.
--
Ian W
South Africa


"jannkatt" wrote:

In previous versions of Excel when I copied an entire sheet to a new sheet,
the column widths and row heights were also copied. However, that does not
work in Excel 2007. I was able to get the column widths using paste
special-column widths. But I cannot get the row heights. I even tried
copying the formatting but that did not work. I copy sheets a lot and have a
lot of different row heights which would take forever to have to fix
individually again. If this is an "upgrade" with this version, it is
terrible. Any suggestions?

I find Excel 2007 is the same as before. If you copy a sheet you get the
row heights and column widths. If you copy all the cells on a sheet you get
the row heights and column widths. If you copy entire rows you get their
row heights...

--
Jim
"jannkatt" wrote in message
...
| In previous versions of Excel when I copied an entire sheet to a new
sheet,
| the column widths and row heights were also copied. However, that does
not
| work in Excel 2007. I was able to get the column widths using paste
| special-column widths. But I cannot get the row heights. I even tried
| copying the formatting but that did not work. I copy sheets a lot and
have a
| lot of different row heights which would take forever to have to fix
| individually again. If this is an "upgrade" with this version, it is
| terrible. Any suggestions?

When I create a new workbook based on the Blank template, copying as you said
does not work. However, when I use the template I created and copy the
worksheet, everything works. I don't know what is different about the Blank
template but I won't be using that again. Thanks, J.

"Ian W" wrote:

I don't know what I'm doing differently but I select the entire worksheet
using the little button top left (to the left of Column A and above Row 1)
then Copy, and then paste that into the new worksheet and it copies
everything, row heights and column widths included.
--
Ian W
South Africa


"jannkatt" wrote:

In previous versions of Excel when I copied an entire sheet to a new sheet,
the column widths and row heights were also copied. However, that does not
work in Excel 2007. I was able to get the column widths using paste
special-column widths. But I cannot get the row heights. I even tried
copying the formatting but that did not work. I copy sheets a lot and have a
lot of different row heights which would take forever to have to fix
individually again. If this is an "upgrade" with this version, it is
terrible. Any suggestions?