Using the Calculate Command

Home Tutorials My MVP FAQs Useful Links

 

Better than an Easter egg: Using ToolsCalculate

This article was written for Word 2003 and earlier; for its application to Word 2007 and above, see the final section.

Among Word’s many undocumented features are some legacies from previous versions. One of these is the ToolsCalculate command. In Word 2.x for Windows and 5.1 for Mac, the Tools menu included a Calculate item that permitted users to perform calculations on selected numbers. The result was displayed in the status bar and also copied to the Clipboard, whence it could be pasted into the document.

Word 6.0 introduced the “formula field” (an expansion of the “expression field” that had already existed in Word 2.0), which greatly extended Word’s ability to perform calculations. Not limited to simple arithmetic operators, formula fields can use a variety of other functions. But formula fields are sometimes overkill, and they have their limitations. Although they are not entirely confined to tables, that is where they are easiest to use. And one of the most commonly used formula fields, { = SUM(ABOVE) }, not only is confined to tables but has some serious limitations even there: it stops adding at the first empty cell, and in Word 97 it can’t sum more than 85 rows accurately.

These limitations (and unfamiliarity with formula fields) were enough to send Word 6.0 users looking for the handy Calculate command, only to find it gone from the Tools menu. A Microsoft Knowledge Base article, “WD6X: Calculate Command Does Not Appear on the Tools Menu [Q120093]” (now retired), acknowledged its absence and advised users that “This change in the menu structure is by design in Word 6.0. To perform a calculation in Word 6.0, use the Formula command on the Table menu or run the ToolsCalculate macro from the Tools Macro dialog box.” Alas, the ToolsCalculate macro itself had disappeared by Word 95.

But all is not lost! ToolsCalculate is still available (in Word 2003 and earlier) through Tools | Customize. On the Commands tab, select All Commands in the Category list, then scroll down the Commands list until you find ToolsCalculate. Drag it to the menu bar and hover the mouse over “Tools” until the Tools menu drops down. Drop Calculate somewhere on the menu and begin to discover its usefulness:

  1. You can use it anywhere. If you have constructed a simple table using tabs, you can select one column of numbers by holding down the Alt key while you drag. Then use the Calculate command. The status bar briefly displays the text “The result of the calculation is x,” and if you press Ctrl+V, the result will be inserted in your document. You can even sum a series of numbers in running text, such as 1, 2, 3, 4 or 1 2 3 4; just select them and run Calculate.

  2. If you use Calculate in a table, you can sum a column (any number of rows, including empty cells—unlike SUM(ABOVE)), a row, or the entire table!

  3. Calculate is not limited to sums, either. By using simple arithmetic operators, you can perform the following operations: addition, subtraction, multiplication, division, calculating a power, calculating a root, and calculating a percentage.

Following are excerpts from the instructions contained in the Microsoft Word User's Guide for Word 2.0.

Adding with the Calculate Command

The math feature is especially useful if you want to add numbers in table columns, in table rows, or in columns created with tabs. Just select the row or column, and then choose Calculate from the Tools menu. Word calculates the result for you, and you can insert the result in a document.

Word ignores text and reads only numbers when calculating a selection. You don’t need to type a plus sign (+), because Word automatically adds selected numbers separated by spaces unless you specify another mathematical operation.

Other Operations with the Calculate Command

You can also use the Calculate command to subtract, divide, or multiply numbers or to calculate percentages, powers, and roots. When you perform calculations other than addition, you need to include mathematical operators. For example, if you want to multiply two numbers, type the first number, an asterisk (*), and the second number. Select the numbers and the asterisk, and then choose Calculate from the Tools menu. Word performs the calculation and displays the result for a few seconds in the status bar. The result is also automatically copied to the Clipboard.

The following table shows the operators to use for various calculations.

Use

To

Example

Expression

Result

- or ( )

Subtract