» 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:
- Special Edition Using Microsoft Office XP
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Analysis of Financial Statements
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Microsoft Office XP Introductory Concepts and Techniques
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
No comments have been submitted.
