XL7: CTRL+Click Selected Cell Changes AutoCalculate Value

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
autoc
and then double-click the selected text to go to the "Easier Calculation
And Number Formatting" topic.
Lastnosti

ID članka: 133050 – Zadnji pregled: 14. feb. 2017 – Revizija: 1

Microsoft Excel 95 Standard Edition

Povratne informacije