Select the data range that you want to auto fill formula and then click Insert Table see screenshot. B6C2 and press Enter Now select cell C6 and the other cells in the column where you want to apply the formula. How to Use Date Formula in Excel.
After applying the formula in the total column the values are used to sum the Grand total.
When in Excel pressing Enter in the cell or in the formula bar like how you would in Microsoft Word would only move the cursor to the next cell. The formula bar is located above the rows and columns of cells and beneath the menu bar or ribbon. You can also do this in the formula bar. In the Create Table dialog check the My table has headers if there are headers in your data see.