Total an Excel Column Faster with This Keyboard Shortcut

When you are working with Excel, who has time to use the mouse to select a column and create a formula to total?

You don't have to.

A quick and easy shortcut will let you do it mouse-free.

To quickly sum a column, go to the first empty column at the bottom and then press and hold the ALT and then = keys.

The formula =SUM will be entered with the column range.  Press the Enter key to confirm.

That's it.  A quick and easy way to total a column in Excel.


READ MORE

• Tell Outlook Where to Search
• Select an Excel Data Set Faster with this Shortcut
• This Power Point Tip Will Make You the Focus
• Show or Hide Microsoft Word Format Marks
• Microsoft Words Magical Lorem Ipsum Generator

Listen to the One Cool Tech Tip Show

Podomatic | Tunein | Stitcher | iTunes

One Cool Tip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#Microsoft #Excel #SUM #formula #ALT #= #keyboard #shortcut