 |
|
|
|
|
|
AutoCalculate
There might be times when you wish to find out the sum of a range of numbers quickly without having to add a formula to the Worksheet. For these instances, we can simply use the AutoCalculate feature of Excel.
To do this, select a range of cells containing the numbers you want to sum and look in the Status bar. If the Status bar is not visible go to View>Status bar. If the range of cells you wish to sum are non-adjoining, hold down the Ctrl key while selecting the ranges.
We are not restricted to only displaying the sum of our selected range! If you right click on the Status bar a shortcut menu will pop-up allowing us to choose one of six basic formulas. Have a look at each of these in turn and if you are unsure of what they do, please ask.
Go To Free Excel Training Lesson 21 . Back to Previous Lesson
Go to Excel Basic/Level 1 Training Index
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS