Step 2: Click the row below where you want your new row to be added.įor example, I want to add a row between what is currently row 4 and row 5, so I am selecting row 5. Step 1: Open your worksheet in Excel 2013. 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.
Insert new row in excel keyboard shortcut how to#
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. Adding a New Row Between Existing Rows in Excel 2013 (Guide with Pictures) Our article continues below with additional information on inserting new rows in Excel, including pictures of these steps. Click the Insert arrow, then Insert Sheet Rows.Select the row number below where you want the new row.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.Ħ Additional Sources How to Add a New Row in Excel 2013 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. The rows and columns in your spreadsheet also have labels to identify them, which are indicated by row numbers and column letters. 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. One of the most useful features of Microsoft Excel 2013 is how easy it is to manipulate and sort data. But there are some options for adding rows in Excel that can make it much easier to include data within an existing dataset. Have you ever meticulously entered a lot of data into a spreadsheet, only to find that you need to add something between two existing rows? You may have solved this issue by cutting all of your data and pasting it one row lower, or you might have even deleted a bunch of data to make room for the new row.