Easy Microsoft Office 2003

2017-07-07 02:10:07

Click the cell in which you want the AutoSum function to appear.

Click the AutoSum button on the Standard toolbar and select the preferred function from the drop-down list (in this example, Sum).

If Excel automatically selected the correct range (the selected range is surrounded with a flashing dotted line), press the Enter key. If not, see the tip at the bottom of the page.

Click the cell containing the function. Notice that the formula is displayed in the Formula bar.

INTRODUCTION

Excel can use formulas and functions to perform calculations for you. Because a formula refers to the cells themselves rather than to the values they contain, Excel updates the sum whenever you change the values in the cells. You'll probably use the AutoSum formula frequently it adds numbers in a range of cells.

TIP

Selecting Specific AutoSum Cells

If you don't want to use the range of cells AutoSum selects for you, click the first cell you want, hold down the Ctrl key, and click each additional cell you want to include in the calculation. When you finish selecting the cells you want to calculate, press Enter. For more information on selecting cells, see "Selecting Cells" and "Selecting a Range of Cells" in Part 7, "Getting Started with Excel."

INTRODUCTION

TIP

Категории