If you need to find a quick total, but you don’t want or
need to include that total in the worksheet, you can use the AutoCalculate
feature. For example, you may want to sum a list and then use that sum in a
formula. You could grab a calculator and add up the figures using the
calculator, or you can use Excel’s AutoCalculate feature!
Try This
1.
Select the range you want to perform addition
on. The AutoCalculate button in the status bar automatically displays the sum
of the selected range.
2. Right-click on the status bar area where the sum is
displayed and you will be given other AutoCalculate choices.
3. The result of
the function you selected appears in the status bar. If you select additional
ranges, Excel uses the most recent function you selected on the AutoCalculate
button.
AutoSum
The SUM function totals the numeric value of all cells in
the range(s) it references. The AutoSum button appears on the Standard toolbar.
You can use it to sum adjacent columns or rows automatically. In addition to
entering the SUM function automatically, the AutoSum button selects the cells
in the column above or in the row to the left of the current cell.
Try This Example
1. Select a cell below or to the right of the values you want to sum.
2. Click the AutoSum button on the Standard toolbar.
3. To accept the formula that AutoSum supplies, press Enter. Or, if the formula is incorrect, select a different range to sum and then press Enter.
Fill Data within a Row or Column
1. Select the cells you want to copy.
2. Drag the fill handle across the cells you want to fill, and then release the mouse button. (The fill handle is the small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.)
3. To fill in the active cell with the contents of the cell above it (fill downward), press CTRL+D. To fill in with contents of the cell to the left (fill to the right), press CTRL+R
No comments:
Post a Comment