From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use AutoSum shortcuts

Use AutoSum shortcuts

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Use AutoSum shortcuts

“

- [Voiceover] Excel's AutoSum feature can be a real time saver. Anytime you need to add data from above or from the left, you can potentially use it. I want a total in cell G 2, their numbers off to the left. First of all there's an auto sum button found in two different locations in the ribbon menu system. If you're on the home tab, it's far right. There's AutoSum. Notice it's keystrokes shortcut, alt equal. That can be even faster. On the formulas tab, you'll see it on the left side somewhat larger. In both cases there's a drop arrow below this, that also alerts you to other functions as well. If you want a total in cell G 2, you could press that keystroke shortcut or the icon. I'll simply click AutoSum. In either case here's what happens. Looks good, we'll press enter. But it could be faster. Once you get used to it, and perhaps a lot of you are already. Why not just double click AutoSum. That's a lot faster. Or press alt equal and enter. Alt equal, enter. That's pretty fast too…

Contents