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
How to Insert Formulas Into the Excel Formula Bar
The formula bar in Excel shows the formula programmed into any cell within the spreadsheet. It is a field at the top...
How to Insert a Row In Excel With My Keyboard
When you are entering data into Microsoft Excel, it's often handy to insert a row while you enter data. However, clicking your...
How to Insert Page Numbers in Excel 2007
Excel is a spreadsheet program produced by Microsoft. This program has so many features that often a seemingly simple task cannot be...
How to Automatically Insert the Date Onto a Spreadsheet
Excel is a highly customizable spreadsheet application included in Microsoft Office. In addition to creating spreadsheets, users can create graphs, macros, pivot...