excel 2007 copy row heights

  • Thread starter Thread starter jannkatt
  • Start date Start date
J

jannkatt

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.
 
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
| 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.
 
Back
Top