excel 2007 copy row heights

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

Ian W

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.
 
J

Jim Rech

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?
 
J

jannkatt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top