We mentioned before an easy way to highlight cells in Excel to quickly get average, count, and sum of those cells. But if you need a formula in-place for future use, there’s a quick and easy way to insert the SUM formula for the column you’re looking at. Here’s how you do it.

First off, built out your spreadsheet with the data you want to add up:

Click on the cell directly below the column you want the total of:

Press the ALT key and the = key at the same time and then press Enter. It will first create a SUM formula of the column above and then hitting Enter accepts the formula creation.

Have any other Excel or other Office tips you’d like us to share? Email our loudmouth webmaster to submit your ideas or comment below.