BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns (this blog)
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months
Posted by Andrew Gould on 02 December 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Excel Quick Tip #3 - Adding Totals to Columns
Nearly everyone who's ever used Excel will have encountered the SUM function, usually at the bottom of a table to add up columns of figures. Did you know there was a keyboard shortcut that automatically sums columns?
- Select the cells at the bottom of a table where you would like your totals to appear.

Here we've selected the next blank cell in each column that contains numbers.
- Press ALT + = on the keyboard.

Totals will be added to each of the selected cells.
You can watch a short video of this technique in action on Wise Owl's YouTube channel.
- Excel Quick Tip #1 - Copying a Formula
- Excel Quick Tip #2 - Putting Dollar Signs in a Formula
- Excel Quick Tip #3 - Adding Totals to Columns (this blog)
- Excel Quick Tip #4 - Selecting a Table
- Excel Quick Tip #5 - Sorting a List
- Excel Quick Tip #6 - Creating Range Names
- Excel Quick Tip #7 - Creating a Chart
- Excel Quick Tip #8 - Copying a Worksheet
- Excel Quick Tip #9 - Entering Today's Date
- Excel Quick Tip #10 - Copying Days and Months