View formula values instead of cell references

[Antony S]

Hi

Is it possible when copying and pasting a formula, to see the values from each cell rather than the cell reference?

[Fotis1991]

Copy>>Paste Special> values>OK

[AliGW]

Copy>>Paste Special> values>OK

I am not sure this is what the OP is after. The only way I know of seeing the values of the cells referenced in a formula is to use the Evaluate Formula option on the Formulas ribbon.

[Antony S]

Hi Fotis, I tried that but it doesn't give me what I was looking for so I must have termed the question wrongly. If in cell B5 I added the values from the 2 cells above, when I go into B5 I can see the formula, but I want to see the values from the 2 cells above not the formula.

[Antony S]

Hi AliGW, what is the Evaluate Formula option?

[XOR LX]

Hi,

An alternative to using Evaluate Formula is to go into the formula bar and highlight the portion which you would like to see evaluated and press F9.

For example, with the formula:

=SUM(A1:A4)

going into the formula bar, highlighting A1:A4 only and pressing F9 will give you what you want.

Regards

[AliGW]

Select a cell with a formula in it and click on it on the Formulas ribbon - you'll see what it does. Easier to look yourself than for me to try to explain it to you!

Edit: in your version, it will be a menu option.

[Antony S]

This shows the values on the sheet rather than the values in the formula ribbon, so maybe a better question is, is it possible to see the values in the formula ribbon rather than the cell references?

[AliGW]

I've just tried this, and it appears to change the contents of the formula - it's not a toggle. Am I missing something?

[Fotis1991]

Hi Fotis, I tried that but it doesn't give me what I was looking for so I must have termed the question wrongly. ....

Or i understoond the question wrongly!!

[XOR LX]

This shows the values on the sheet rather than the values in the formula ribbon, so maybe a better question is, is it possible to see the values in the formula ribbon rather than the cell references?

You need to clarify to whom you're replying as you have solutions offered by more than one person.

Regards

[Antony S]

Hi XOR LX, Sorry, first time on here, none of the solutions are giving me exactly what I am looking for so I will reply when I think of a clearer way of asking the question. Thanks for all of the replies.

[XOR LX]

Could you give me some feedback as to the solution I proposed first?

Regards