Quick Tip – #Excel AutoSum

Excel Tip - AutoSum

While SUMMING data is probably the most common task in Excel, I am surprised that many people are not aware of this Excel feature – AutoSum.  It is super handy especially when you know the shortcut of it, which is ALT+=.

Let’s watch it in action:

Excel Tip - AutoSum

Tip: When you make the selection, make sure you have selected an “extra” row and/or column to reside the total(s).

As simple as this! 🙂

Advertisement

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.