» Fast Summation
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
To sum the columns within the Current Region:
1. Select a cell in the Current Region/List and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A).
2. Press Alt+=.
OR
Click the AutoSum icon (sigma) on the Standard toolbar.
The SUM formula is added automatically at the bottom of each column.
To add the SUM function to a vertical and horizontal range:
1. Select the range of cells containing values, including an empty row and column surrounding the cells by selecting the first cell in data table, pressing Shift, and then selecting the empty cell in the first cross empty row and column (cell D8 in the screenshot below).
2. Press Alt+=.
OR
Click the AutoSum icon.
The SUM formula is added to the end of each row and the bottom of each column.
To quickly sum values in a range:
1. Select the range of cells along with an empty cell in a vertical or horizontal direction.
2. Press Alt+=.
OR
Click the AutoSum icon.
The SUM formula is added to the empty cell.
Book Store:
Recommended Books:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Microsoft Windows XP Inside Out
- The Fall of Advertising and the Rise of PR
- Excel 2002 For Dummies®
- Microsoft Windows XP Step by Step (With CD-ROM)
- Dictionary of Finance and Investment Terms
No comments have been submitted.
