view values instead of cell reference

[nickels]

Hi

I want to check my formulas by seeing the values instead of the cell references.

For example in cell a1 there is 5 and in cell b1 there is 6.
In cell c1 i have the fomula =a1+b1

I want to view that cell as = 5+6

Does anyone know a shortcut to do this?

Thanks
Nickels

 

[acw]

Hi

Go to cell C1, and in the formula bar highlight the A1, then press F9. Using your example, this will convert the A1 in the formula to 5. Do the same thing with the B1. If you want to keep the numbers, then press enter. If you want to retain the formula as it stands, then press esc.


Tony

 

[nickels]

cool

thanks, thats great Do you know if you convert all the references in the cell at one time or whether you can only do it one by one?

Thanks

Nickels

 

[acw]

Nickels

UP to you how much of the formula you grab and debug. If you had grabbed the entire formula, then you would have had 11 as the result.

If you mean can you highlight the entire formula and have each part of it converted separately, then no - it will evaluate the entire portion selected and give the final output for the selected part.


Tony

 

[nickels]

Thats alright, just thought i'd check.

Thanks for your help