Display Cell Formula

KevinYC

New Member
Joined
Mar 27, 2011
Messages
12
Hello Everyone,

I would like to see the formula in each cell in my worksheet. I was able to see the formula when I clicked on the cells earlier. But now when I click the cells I see only the values, not the fomula anymore.

Do I need to be in certain mode to view the worksheet? What am I missing?

Thank you in advance for any input!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Matty

Well-known Member
Joined
Feb 17, 2007
Messages
3,710
A couple of things (that I can think of) could have happened:

1) You copied and hit Paste Special > Paste Values, overwriting the formulas with the values the formulas were returning, or;

2) The Worksheet has become protected and Format Cells > Protection > Hidden is ticked.

Is it one of these?

Matty
 

KevinYC

New Member
Joined
Mar 27, 2011
Messages
12
Hi Matty,

Thank you for your reply. I don't think it's any of the scenario you listed. Because I didn't update the worksheet. I was only browsing it.


Any other suggestions? anyone?

Thanks again!
 

Matty

Well-known Member
Joined
Feb 17, 2007
Messages
3,710
Did you check whether the Worksheet is unprotected or not?
 

Matty

Well-known Member
Joined
Feb 17, 2007
Messages
3,710
I was able to see the formula when I clicked on the cells earlier. But now when I click the cells I see only the values, not the fomula anymore.

Referring to the above-mentioned quote, are you saying you were seeing the formulas in the formula bar and you are not now?

Matty
 

Matty

Well-known Member
Joined
Feb 17, 2007
Messages
3,710
I'm afraid I don't know what else it could be. Sorry.

Matty
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,303
Messages
5,836,520
Members
430,437
Latest member
Emilycr

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