---

EXCEL AUTO CALCULATE

Lesson 20 - Excel Auto Calculate.  Calculate Without Formulas

EXCEL AUTO CALCULATE

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 click AutoSum.

.

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 back to:

Lesson 1 - Excel Fundamentals

Lesson 2 - Starting Excel and Excel Workbooks

Lesson 3 - Excel Toolbars and Task Panes

Lesson 4 - Excel Worksheets

Lesson 5 - Excel Cells and Navigating a Worksheet

Lesson 6 - Excel Cut/Copying and Pasting Data

Lesson 7 - Excel Copying with the Fill Handle

Lesson 8 - Excel Paste Special

Lesson 9 - Excel Insert Command

Lesson 10 - Excel's default options

Lesson 11 - Excel's Undo and Redo

Lesson 12 - Excel's Format Painter

Lesson 13 - Excel's Dates and Times

Lesson 14 - Excel's Custom Formats

Lesson 15 - Excel Formulas

Lesson 16 - Excel Cell References

Lesson 17 - Excel: Avoid Typing

Lesson 18 - Excel Formulae Arguments & Syntax

Lesson 19 - Excel Autosum Formula

See also:

Lesson 21 - Excel's Insert Function

Lesson 22 - Excel's Useful Functions

Lesson 23 - Excel's Named Ranges

Lesson 24 - Excel's Constants and the Paste Name Dialog

Lesson 25 - Excel's Calculations

Lesson 26 - Excel Comments Cell

Lesson 27 - Excel Find and Replace

Lesson - 28 - Clear Excel Cell Contents

Lesson 29 - Effective Excel Printing 1

Lesson 30 - Effective Excel Printing 2

Lesson 31 - Sorting in Excel

Lesson 32 - Hide/Show Row/Columns in Excel

Lesson 33 - Auto-Formats in Excel

Lesson 34 - Creating a Basic Excel Spreadsheet

Lesson 35 - Excel Charting Lesson: The Basic Excel Spreadsheet

Lesson 36 - Excel Worksheet Protection

Lesson 37 - Excel IF Formula Nesting

Lesson 38 - Excel Function Now/Today Formulas

See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

 

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.

Gallery

---

• 
• 
• 
• 
• 
•