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 How to Add All of the Values in a Row in Excel.You can either click on one of the shortcut links below to jump to the appropriate section, or you can continue reading.

We will address both of the possible ways that you can add rows in Excel in the various sections of our article below. 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.

How enable adding columns in excel 2016