AutoSum, Quick Calculations & Keyboard Shortcuts

AutoSum, Quick Calculations & Keyboard Shortcuts

Excel includes built in calculation tools that let you add up numbers, find averages, and get quick results without typing formulas from scratch.

In this blog, we’ll look at AutoSum, Quick Calculations, and the keyboard shortcuts that make everyday tasks faster.

You may need more advanced formulas later, but AutoSum covers roughly 80% of everyday needs for most basic users.


AutoSum: The Fastest Way to Add Numbers

AutoSum automatically adds a column or row of numbers for you. Excel will select either the column above or the row to the left of the cell containing the total.

AutoSum is perfect for:

Budgets

Expenses

Sales totals


How to Use AutoSum

1. Click the empty cell below a column of numbers (or to the right of a row)

2. Select Home Ribbon

3. Click on AutoSum

4. Press Enter

Can't find exactly what you need?

Build your own course or let us design one around your systems and processes.

Contact us online

Why train with us

We use cookies to enhance your experience. Please let us know if you accept or reject optional cookies.
Accept Optional Cookies
Reject Optional Cookies
Privacy Policy
My favourites
Evaluate a course Read 8000+ Reviews
Courses Public Schedule About
This site requires JavaScript - JavaScript is currently disabled on your device, please be aware that certain functionality may not work until you enable JavaScript.