How to Insert a Row in Excel 2013

One of the most useful features of Microsoft Excel 2013 is how easy it is to manipulate and sort data. This is due largely to the grid-like structure of the worksheet, which consists of columns that run vertically throughout the sheet and rows that run horizontally.

This structure also makes it easy to add new rows or columns when you discover that you need to add more data in a location within your currently existing data. So check out our guide below to find out how you can insert a row into your Excel 2013 worksheet with just a few short steps.


Adding a New Row Between Existing Rows in Excel 2013

The tutorial below will show you how to insert a new row in the exact location of your worksheet where you want that row to appear. Any rows below the inserted row will simply be shifted down, and any formulas referencing a cell in those moved rows will automatically update to the new cell location.


Step 1: Open your worksheet in Excel 2013.


Step 2: Click the row below where you want your new row to be added. For example, I want to add a row between what is currently row 4 and row 5, so I am selecting row 5.

how to insert a new row in Excel 2013



Step 3: Click the Home tab at the top of the window.

click the Home tab at the top of the window



Step 4: Click the arrow under Insert in the Cells section of the navigational ribbon, then click Insert Sheet Rows.

click insert, then click insert sheet rows



You should now have an empty row above the row that you had selected in Step 2, as in the image below.

worksheet after row has been inserted



You can also insert a new row by right-clicking on the row number, then clicking the Insert option on the shortcut menu.

right-click the row number, then click the Insert option



Do you have a row in your spreadsheet that you no longer need, or did you insert the new row in the wrong location? Learn how to delete a row in Excel 2013 when you have data that you want to remove. newsletter

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