» 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:
- Excel 2002 For Dummies®
- Special Edition Using Microsoft Excel 2002
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
No comments have been submitted.
