A recent update to Excel has made a slight change to the AutoCalculate feature. You can copy a value by simply clicking on it.

When you select more than one cell, Excel will show you a number of different calculation results based on the range selected.

The results are displayed in the bottom right corner of the screen – see image below.

The change to this feature is that you can now point to one of the results with the mouse and click a value to copy the value – see image below.

You can then use Ctrl + v to paste the value into a cell.

Capturing a value is handy if you are making changes and need a quick and easy way to capture different results for different changes.