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?