Copy and Paste MS Excel Row Height « Carol’s Corner Office Blog

Copy and Paste MS Excel Row Height

I have had many inquiries regarding this tip and it is such an easy thing to do!

To learn how to copy and paste row height in MS Excel, follow the steps below:

Select the row you would like to copy.
Click on the Format Painter icon on your Standard toolbar (or on the Home tab is you are using version 2007).
You will now see a small paint brush.
Simply drag it where you would like to copy the row height.

That’s all there is to it! You have now copied the format to your new row.

If you are not a subscriber of Carol’s Word Bytes Newsletter, you should be! Visit http://www.carolscorneroffice.com to subscribe.

This entry was posted on Tuesday, February 24th, 2009 at 3:39 pm and is filed under Excel 2003, Excel 2007, Microsoft Office, Microsoft Office Excel, Office Productivity. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Manuel says:

March 7, 2009 at 9:56 am

I need to be able to copy and past to another sheet the axcact copy including row hight .. the solution u provided dos not work.. do you have a nother method i could try?

Thank you
Vince says:

July 14, 2011 at 6:39 pm

Carol,

Fantastic solution. If only I had known this years ago it would have said a lot of fiddly changes!!! Thankyou!
Brad says:

December 2, 2011 at 3:27 pm

Thanks Carol for that tip – that definitely saves some time. Works for columns too. To copy both row and column heights (plus other formating) all at once to a new sheet select the whole sheet then format painter.