The cells in an Excel spreadsheet are a certain size by default. While this can be useful in some situations, you may find that you need to make a cell bigger in order to fit all of the data contained in that cell. You accomplish this by increasing the width of a column, or by expanding the height of a row.
The method that we describe below can also be used to contract the size of a row, but this tutorial will be focused on expanding a row in Excel. If you decide that you want to contract the size of a row in your spreadsheet, then you can do so by dragging the row border in the opposite direction to make it smaller.
How to Expand Row Height in Excel 2013
This tutorial focuses specifically on expanding rows in Microsoft Excel 2013, and the images are from that version of the program. However, this is a feature that is applicable to all versions of Excel so, for example, if you have an earlier version of the program on your computer or at work (such as Excel 2003, 2007 or 2010) then you can follow the same steps below to expand a single row in Excel 2013.
Step 1: Open your spreadsheet in Excel 2013.
Step 2: Locate and select the row that you want to expand by clicking the number of the row at the left side of the spreadsheet. In the example image below, we want to expand row 3.
Step 3: Click the bottom border of the row heading, then drag it down until the row is at the desired size. Note that the size of the row is displayed as you are expanding the size of the row.
You can also numerically specify the size of a row by right-clicking the row number, then clicking the Row Height option.
Type the desired row height into the Row height field, then click the OK button.
Do you want to make your spreadsheet easier to read? Learn how to change the color of your cells to help distinguish different rows or columns from the data in neighboring cells.
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.