A SHARP COOKIE
  • Home
  • Contact
  • Cookie Crumbs
  • OCO Files
  • Home
  • The Adjunct Files

Efficient Excel: Easy Adding and AutoSum Tips

5/13/2017

0 Comments

 

If you are new to Excel or you want to work more efficiently, try these tips for using Autosum.

Let's start with some basics.

If you just want a quick view of a running total,  select the numbers and look in the bottom right corner of your screen.

Picture
For numbers that will stay in place, you can:
Use the Autosum key on the Home tab or the Formula tab (or add it to the Quick Access toolbar)
Press Alt+11
Use the Quick Analysis tools on the bottom right corner of a selected cell group (or press CTRL+Q)
Make a table (Ctrl+T) and click table rows on the Table Design tool.
Picture
0 Comments



Leave a Reply.

    Author

    These are tips and tricks from my Excel adventures.

    Archives

    March 2020
    June 2017
    May 2017

    Categories

    All
    Autosum
    Conditional Formatting
    Dropdown List
    Excel
    Excel Efficiency
    Excel Formulas And Functions
    Keyboard Shortcuts

    RSS Feed

Services

Tech Training
Content Writing
Editing
Formatting
Publishing

Company

A Sharp Cookie

Support

Contact
FAQ
Terms of Use
© COPYRIGHT 2015. ALL RIGHTS RESERVED.
  • Home
  • Contact
  • Cookie Crumbs
  • OCO Files
  • Home
  • The Adjunct Files