PSS ID Number: 133050
Article Last Modified on 10/22/2000
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0
This article was previously published under Q133050
SYMPTOMS
In Microsoft Excel, when you click a selected cell while holding down the
CTRL key, the value in the cell is added to the AutoCalculate value
displayed on the status bar.
CAUSE
The AutoCalculate feature behaves like the =SUM() function: when you click
a cell while holding down the CTRL key, the value in the cell is added to
the AutoCalculate result, even if the cell was already selected.
The AutoCalculate feature in Microsoft Excel displays the sum (or average,
count, count nums, max, or min) of the selected cells. However, when you
hold down the CTRL key and click a cell on your worksheet, the value in the
cell is added to the AutoCalculate result, even if the cell is already
selected. For example, if you select cells A1:A2, the AutoCalculate feature
displays the sum (by default) of the values in cells A1:A2 on the status
bar. If you then hold down the CTRL key, and click cell A1, the value in
cell A1 is added to the result displayed on the status bar, although the
cell selection has not changed.
REFERENCES
For more information about the AutoCalculate feature in Microsoft Excel,
click the Index tab in Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "Easier Calculation
And Number Formatting" topic.
Keywords: KB133050
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch