How to Expand One Row in Excel 2013

If you’ve increased the size of your font, or if you have placed an object like an image in one of your cells, then you might not be seeing all of your content.

Luckily the rows and columns in Exel are adjustable, and you are able to learn how to expand one row in Excel so that all of the content in that row is able to be seen by anyone that is viewing the worksheet.

How to Make a Row Bigger in Excel 2013

  1. Open the spreadsheet.
  2. Click the row number to select it.
  3. Click and drag the bottom column border to increase its size.

Our guide continues below with additional information on how to expand one row in Excel, including pictures of these steps.

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.

You might also want to know how to expand all rows in Excel if you have more than one under-sized row and you don’t want to have to manually adjust the size of every row in your spreadsheet.

How to Expand Row Height in Excel 2013 (Guide with Pictures)

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

Now that you know how to expand one row in Exccel you will be able to make rows larger (or even smaller) if you need to make that sort of change to a future spreadsheet.

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.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy