You can use a keyboard shortcut to insert the formula for the entire column of your worksheet. If you follow these steps youll note that the Formula Bar now contains Budget. Now take a look at the formula reference SUM in Excel Sheet1.
You can use a keyboard shortcut to insert the formula for the entire column of your worksheet.
The equal sign tells Excel that the string of characters youre entering into a cell is a mathematical formula. Start the formula with an sign select a cell enter an operator like or then select another cell. Now we need to do the calculation to get the sale value. For example just type 2 2 in a cell of your choice and Excel will perform the requested calculation.