From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Calculate faster with the AutoSum button and AutoSum keystroke shortcut

Calculate faster with the AutoSum button and AutoSum keystroke shortcut - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Calculate faster with the AutoSum button and AutoSum keystroke shortcut

- [Instructor] When you work with formulas in Excel, 2 one of the most efficient tools you can use 3 is the auto sum button, and it also has 4 a keystroke shortcut alt equal. 5 I want a total here, in cell L two. 6 Let me zoom in a little bit on this. 7 I'm holding down the control key using the mouse wheel. 8 The auto sum button is found in two locations 9 in the ribbon menu system, far right 10 on the home tab, out here in the editing group, 11 you'll see auto sum right here. 12 It's got a little drop arrow associated with it as well. 13 Notice the keystroke shortcut is alt equal. 14 You will also find this button 15 somewhat larger on the formulas tab. 16 Here it's on the left side, and there too 17 there's a drop arrow, and also 18 the reminder that it's alt equal. 19 So we want a total here in cell L two. 20 What do we do? 21 We can click the auto sum button. 22 Auto sum tells us what it's about to do. 23 Many…

Contents