How to Expand a Row in Excel 2013

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.

select the row to expand



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.

how to expand a row in excel 2013



You can also numerically specify the size of a row by right-clicking the row number, then clicking the Row Height option.

click the row height option



Type the desired row height into the Row height field, then click the OK button.

enter the desired size of the row



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. newsletter

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