How to Expand All Rows in Excel 2013

Many of the formatting changes that you can use in Excel are visible on one of the tabs in the navigational ribbon. Occasionally there tools with have options that specifically apply to an entire worksheet, but many only apply to the current selection. So if you need to know how to expand all of oyur rows in Excel, you may be looking for a way to do so.

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.

Table of Contents

How to Expand Rows in Excel

  1. Open your file.
  2. Select all the rows.
  3. Click Home.
  4. Click Format.
  5. Choose AutoFit Row Height.

Our article continues below with additional information on expanding rows in Excel including pictures of these steps and additional ways to expand them.

How to Make All Rows Bigger in Excel 2013 (Guide with Pictures)

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.

How to 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

How to 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.

How to Expand or Collapse All Groups in Excel

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.

Read More :   How To Set End Date On Google Ads

Additional Sources

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button