Display formula in worksheet

[Julie]

Good day everybody

I hope someone can help me with this

I have a worksheet with formulas. I need to check the all the formulas.
Instead of selecting each cell and look at the formula bar, is there a way that I can display the formula in the worksheet for easy and quick checking

We have setting for Comments display in TOOLS>OPTIONS....>VIEW>Comment&indicator to show Comment
Does Excel has a similiar setting for Formula

Thank you in advance and hope to hear from you

Have a nice day

Best regards
Julie

 

[Vasant Nanavati]

Ctrl `

(the key to the left of the 1)

will toggle the formula view on and off.

--

Vasant

Good day everybody,

I hope someone can help me with this.

I have a worksheet with formulas. I need to check the all the formulas.
Instead of selecting each cell and look at the formula bar, is there a way

that I can display the formula in the worksheet for easy and quick checking?

We have setting for Comments display in

TOOLS>OPTIONS....>VIEW>Comment&indicator to show Comment.

 

[Domenic]

Hi Julie,

Try,

CTRL+` (that's Control plus the back-tick)

Hope this helps!

 

[Julie]

Thank you very much, Vasant.
You has 'saved' me again
Have a wonderful day.

 

[Gord Dibben]

Julie

Tools>Options>View. Just below the "comments" section is Window Options.

Show Formulas can be checked on and off here as well as using the CRTL + `

Gord Dibben Excel MVP

 

[David McRitchie]

Hi Julie,
I see you got the solution you sought [ctrl+`] , but my interpretation from the
subject alone and one that you might find extremely useful is to
display the formula in one cell that is in actual live use in another cell.
See GetFormula macro (and GetFormulaD) macro in
Show FORMULA or FORMAT of another cell
http://www.mvps.org/dmcritchie/excel/formula.htm

In fact I use it so often that I've added creating the formula to my
right-click menu.
Right Click Menus (Context Menus) in Excel
http://www.mvps.org/dmcritchie/excel/rightclick.htm