How to Make All Excel Rows the Same Height

Techwalla may earn compensation through affiliate links in this story.

New Excel spreadsheets begin with all the rows the same height. However, during the course of creating an Excel spreadsheet, you may find the row heights begin to differ. This can be inadvertently caused by dragging the line between row numbers or entering a larger font size, which automatically causes the row height to increase. To make all Excel rows the same height, you can manually specify their size, which prevents them from automatically changing.


Step 1

Open Microsoft Excel.

Video of the Day

Step 2

Hold the "Ctrl" key and press "A" to select all cells.

Step 3

Right-click any row number and select "Row Height..." from the pop-up menu.


Step 4

Enter a point size for the cell in the "Row Height" window and click "OK" to set all rows to that size. Alternatively, you can click and drag the line between row numbers to change them visually. When you release your mouse button, all rows will appear at the selected height.