How to Automatically Resize Row Height in Excel 2013


Occasionally you may be working with a spreadsheet in Microsoft Excel 2013 that contains a lot of data that does not fit within the height of the row. One way to resolve this is to manually adjust the height of your rows, but that may not be ideal if you have rows that need to have varying heights.

Fortunately Excel 2013 contains a feature that will automatically adjust the height of your selected rows so that the data contained within them is visible. This option is called AutoFit, and it can be a real time-saver if you need to adjust the row height for a large number of rows in your spreadsheet.

 

Resize Excel 2013 Row Heights Automatically

The steps below will cause Excel to automatically resize all of your selected rows to fit the height of the data contained within them. Note that you can also automatically resize column width with the steps in this article.

 

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Select the rows that you would like to automatically resize. You will need to select the rows with the row numbers at the left side of the spreadsheet.

select the rows to resize

 

 

Step 3: Click the Home tab at the top of the window.

click the Home tab

 

 

Step 4: Click the Format button in the Cells section of the navigational ribbon, then click the AutoFit Row Height option.

click format, then autofit row height

 

 

If you are formatting a spreadsheet so that it is easier for people to read, then one helpful change you can make is to center all of the data in your cells. Read here to learn how to do this for your entire spreadsheet at the same time.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.