how to show formula

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

okay- I have tried for over an hour!
How does one "show formula" on excel in Office '07?
I googled it and found the shortcut CNTRL ~
But there simply MUST be a way to format the spreadsheet to "show formulas"
without a shortcut.
Can someone please tell me where that would be?
Thanks a bunch!
Don
 
Click the window button in the top left and go into Excel options, advanced,
scroll down to the display options and toggle on the "show formulas instead
of their calculation result"

Cheers

Robbie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 07 always showing formulas? 6
Excel Formula Bar Time Display Format 2
Hide a Formula 3
How to fix my spreadsheet from showing formula to showing answer 3
How do I change the following formula to allow for leap year 3
Copying Formulas 1
Copying cell formulas 1
Formulas using time and dates 3

Back
Top