Display Cell Formula

[sarahrosenberg]

How do I make a sheet (or a cell) display formulas rather than values? (I am sure this question has been posted before, but I can't find it!)

Thanks!

Sarah

 

[gaynard_nelson]

How do I make a sheet (or a cell) display formulas rather than values? (I am sure this question has been posted before, but I can't find it!)

Thanks!

Sarah

Two ways I know of. If you want all cells to display the formula instead of the results do Tools, Options and on the View tab Check Formulas under Windows options. If you want to display a single formula Hit F2 and insert an ' to change it to text display. Just remove the apostrophe when you want the formula back.

 

[sarahrosenberg]

I thought there was a keystroke-combo that would change the sheet back and forth from value to formula view. Am I making this up?

 

[scwyj]

To view formulae, keystroke is CTRL-tilde (above the tab key)