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.
How to Expand Rows in Excel
- Open your file.
- Select all the rows.
- Click Home.
- Click Format.
- 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
- Open your spreadsheet in Excel 2013.
- Click the button above the row 1 heading and to the left of the column A heading to select your entire sheet.
- Right-click on one of the row numbers, then left-click the Row Height option.
- 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.
How to Automatically Adjust Row Height in Excel 2013
- Open your spreadsheet in Excel 2013.
- Click the button above the row 1 heading and to the left of the column A heading to select the entire sheet.
- Click the Home tab at the top of the window.
- Click the Format button in the Cells section of the ribbon, then click the AutoFit Row Height option.
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.
Step 2: Hold down the Shift key, then click the last row number to include in the group.
Step 3: Click the Data tab at the top of the window.
Step 4: Click the Group button in the Outline section of the ribbon, then click the Group button.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.