How to Insert a Row & Have Formulas Automatically Included in the Row in Excel

Save

One of the advantages of Microsoft Excel is the large number of formulas the program contains. Microsoft Excel users can create formulas that add a range of cells, compute the average or simply count the number of records in the spreadsheet. When those formulas are properly constructed, adding a new row to the range will cause the spreadsheet totals to update automatically.

  • Open Microsoft Excel and click on the "File" menu. Choose "New" to start a new spreadsheet.

  • Type your data into the cells in the spreadsheet. Position your cursor under the last cell that contains data. For instance, if your data is located in cells A1 through A10, position the cursor in cell A11.

  • Enter the formula "=SUM(A1:A10)" to add the values in those cells. Position your cursor between rows 1 and 10. Click on the "Insert" menu and choose "Rows" from the list. Type a value into the new row and watch as the formula automatically updates.

  • Photo Credit computer image by blaine stiger from Fotolia.com
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!