How to Make All Rows the Same Height in Excel 2010

You may already know that you can change the height of a row in Microsoft Excel 2010, but it can be tedious when you need to change the height of every row in your spreadsheet. Fortunately if you are making each row the same height, there is a much faster way to do it.

Our guide below will show you how to select your entire spreadsheet, then simultaneously change the height of each row so that they are the same height. This will work regardless of whether the rows are already the same height, or if each row has a different height.


Set All Rows to One Height in Excel 2010

Another option for automatically changing the height of each row is to use the Autofit Row Height option. This article was written for Excel 2013, but the instructions are the same for Excel 2010. Using the Autofit Row Height option will automatically resize your rows based upon the data that is contained within them. This is a more preferable option when you have rows that contain varying heights of data.


Step 1: Open your spreadsheet in Excel 2010.


Step 2: Click the button at the top-left corner of the spreadsheet, between the 1 and the A, to select all of the rows and columns in the spreadsheet. It is the button pointed out in the image below. If you only want to change the height for some of your rows, then you will instead need to select those row numbers at the left side of the spreadsheet.

select all the cells



Step 3: Right-click one of the selected rows, then click the Row Height option.

select the row height option on the right-click menu



Step 4: Enter the desired row height value into the field, then click the OK button. Note that the unit of measurement for the row height is in points, an unfamiliar unit of measurement for many people, so you may need to try a few different sizes until you find one that is appropriate for your needs.

enter a new row height, then click OK



Does your spreadsheet contain a lot of unwanted format, and you would rather just start with a clean slate? This guide will show you how to clear cell formatting in Excel 2010.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides