Blogs

Tip of the Week - Excel- AutoSum

By ILTA Tips posted 07-22-2019 08:17

  

AutoSum Keyboard Shortcut

 

Everyone uses Excel's AutoSum button  for quickly SUMming values. But did you know there is a keyboard shortcut that performs this same function and very few Excel users know about? This is great for times when you'd prefer to use your keyboard rather than your mouse.

 

Select a cell or range of cells below, or to the right of, the cells you want to apply the SUM function to and simply press theAlt key plus the equal sign (Alt + =).

 

Once you get used to using this shortcut, you can avoid reaching for the mouse when you already have your hands on the keyboard.

 

 

 

From TheExcelAddict.com


#TipOfTheWeek
0 comments
9 views

Permalink