view values instead of cell reference

nickels

New Member
Joined
Jul 15, 2004
Messages
26
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
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
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

New Member
Joined
Jul 15, 2004
Messages
26
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

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
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
 

Forum statistics

Threads
1,137,366
Messages
5,681,074
Members
419,950
Latest member
BeckiJae

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top