Calculating Results

You can verify or check your work without inserting a formula into your worksheet by using the AutoCalculate feature. Because AutoCalculate is not a formula that you've inserted, the results do not appear on the worksheet when you print it. AutoCalculate can give you quick answers while you work. You can easily total a range of cells by using the AutoSum button on the Standard toolbar. AutoSum suggests a range to sum, but you can modify this range if you want a different range. You can calculate subtotals for data ranges using the Tools menu and the Subtotals dialog box. You can select where Excel performs the subtotals and the function type.

Calculate a Range Automatically

Select the range (contiguous or noncontiguous). The sum of the selected cells appears in the status bar.

To change the type of calculation, right-click the AutoCalculate button in the status bar.

Click the type of calculation you want.

Calculate Totals with AutoSum

Click the cell where you want to display the calculation.

Click the AutoSum button.

Click the Enter button on the formula bar, or press Enter.

Calculate with Extended AutoSum

Click the cell where you want to display the calculation.

Click the AutoSum button list arrow.

Click the function you want to use.

Did You Know?

Select additional AutoFill commands . Click the Edit menu, and then click Fill to select additional commands such as Up, Down, Left, Right, Series, or Justify.