How to Expand All Rows in Excel 2013

Last updated: July 2, 2019

If you have multiple lines of text in a cell in your spreadsheet, then you may have noticed that Excel 2013 may not be displaying all of it. You might already know how to change row height in Excel 2013, but it can be tedious to do that for every row that needs adjustment.

Fortunately you can expand the row height of every row in your spreadsheet, and there are a couple of different ways to do so. You can manually set the height for every row, or you can elect to have Excel automatically fit your row height to your data.

If you would like to group your rows so that you can selectively expand and collapse groups of them, click here to jump to that section of this article.

Make All Rows Bigger in Excel 2013

The steps in this article will show you how to manually adjust the row height of every row in your Excel 2013 spreadsheet, as well as show you how to automatically adjust your row heights to display the content in the cells. Note that these steps are meant to change row height, but you can follow very similar steps to adjust column width in Excel 2013.

Manually Adjust All Row Heights in Excel 2013

  1. Open your spreadsheet in Excel 2013.
  2. Click the button above the row 1 heading and to the left of the column A heading to select your entire sheet.
  3. Right-click on one of the row numbers, then left-click the Row Height option.
  4. Enter the desired height for your rows, then click the OK button. Note that the default row height is 15, so you can use that as a base for choosing your row heights. You may need to try a couple of different row heights before you find the right one.
manually set row height in excel 2013

Automatically Adjust Row Height in Excel 2013

  1. Open your spreadsheet in Excel 2013.
  2. Click the button above the row 1 heading and to the left of the column A heading to select the entire sheet.
  3. Click the Home tab at the top of the window.
  4. Click the Format button in the Cells section of the ribbon, then click the AutoFit Row Height option.
how to expand all rows in excel 2013

How to Group Rows in Excel

This method provides you with another way to expand or collapse certain parts of your spreadsheet. Note that the rows in a group must all be consecutive.

Step 1: Click on the first row number that you wish to include in your group.

select the first row to include in the group

Step 2: Hold down the Shift key, then click the last row number to include in the group.

hold the shift key, then choose the last row for the group

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

select the data tab

Step 4: Click the Group button in the Outline section of the ribbon, then click the Group button.

how to do groupings in excel

Step 5: Click the button to the left of the row numbers to collapse a grouped row, then click the + symbol to expand them.

Note that there is a small number 1 and 2 above the section with the + and – symbols. Clicking on the 1 will collapse every group, while clicking on the 2 will expand every group.

collapse or expand all groupings in excel

Do the row numbers at the left side of your sheet skip a few numbers? Learn how to unhide rows in Excel 2013 to see everything that is part of your spreadsheet.

solveyourtech.com newsletter
vintage t rex t-shirt

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