98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » The Easiest and Quickest Way to use Autosum in Excel 2010

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

Added by Yolande on 15th September 2011

More Excel hints and tips, like:

• Apply currency format quickly in Excel
• Convert a column into row quickly in Excel 2010
• Adding up time greater than 24 hours