Inserting rows with the methods above will add blank rows full of blank cells.You would also need to select the Insert Sheet Columns option from the Home > Insert menu instead o the Insert Sheet Rows option. You will simply be dealing with the column letters at the top of the window instead of the row numbers at the left side of the window. All of the procedures outlined in the article above can be used to add new columns, or add the values found within columns of your spreadsheet.

More Information on How to Add Rows in Excel Instead of manually entering the cell locations, you could also click on the first cell after entering the =SUM( part of the formula, then drag to select the rest of the cell values that you wish to add.

Step 2: Click on the row number at the left side of the window that’s below where you wish to add this new row. Step 1: Open the spreadsheet containing the existing data. This will shift cells down in your Excel spreadsheet, allowing you to add new data into the blank cells that should have appeared.

However, situations may arise where you have already entered a lot of data, only to find that you need to place a new row in between two of the rows that you have already created. When you need to add a new row to a spreadsheet, the easiest way is to simply start typing in the first empty cell after your existing data. How to Insert Single Rows in Microsoft Excel Our guide on how to add columns in Excel can show you a way to add all of the values in a column with just a single, simple formula. In the second scenario you are likely trying to figure out how to add all of the values that exist within the cells in a row. In the first scenario you are trying to insert additional rows into an existing set of data in a spreadsheet. When you are trying to figure out how to add rows in Excel, you may be looking for two different things. Our guide continues below with additional information on how to insert a row in Excel 2016, including pictures of these steps. Select the row number below where you want the new one.6 Additional Sources How to Insert a Row in Excel 2016

How to add multiple rows in excel 2016