Take the formula such as =Q6+R6+S6+T6+U6

In the formula bar, double-click on say Q6 to select that single reference:

2022-07-20_231308.png
then press the key

**F9 **on the keyboard. Excel will replace the reference with its value. If you select more than one reference in the formula it will try and calculate the bit of formula that you've selected.

Here I've done it with Q6:

2022-07-20_231348.png
and here I've double clicked on all but one reference, one at a time and pressed

**F9 **each time and got:

2022-07-20_231441.png
Any use?