id="info"

Software

Compute your entire Excel worksheet with a click of the mouse

You already know how to use Excel's AutoSum feature -- now use it to enter all the formulas with just one click and sum it up. Here's how.

Most users know how to take advantage of Excel's AutoSum feature to quickly total spreadsheet data across a row or a column. For example, in the spreadsheet below, most users would use AutoSum to calculate the totals for each state by clicking in B7, double-clicking the AutoSum button, and then copying the formula across the range C7:E7. Likewise, to obtain the total sales for each software category, they would click in cell F4, double-click the AutoSum button, and then copy the formula down the range F5:F7.

Even though using AutoSum this way can save users quite a bit of time over entering each formula separately, they can save even more time by following these steps:

  1. Select the range A2:F7.
  2. Click the AutoSum button.

AutoSum lets you enter all the formulas with just one click! What's more, you can do this for all the auto functions. For example, if we change the labels in F3 and A7 to Average, we can then complete the worksheet by following these steps:

  1. Select the range A2:F7.
  2. Click the AutoSum button drop-down arrow and select Average.
Miss an Excel tip?

Check out the Microsoft Excel archive, and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks