just need to display formulas nothing appears

  • Thread starter Thread starter Sissy81
  • Start date Start date
S

Sissy81

I am a student and it says to display the cell formulas in the worksheet. I
have tried EVERYTHING and can't figure it out??? Please help
 
EXCEL 2007

Take the following actions:-

1. Click in one cell in the Worksheet where you wish to display the formulas.

2. Hit the F5 key.

3. Hit Special . . .

- in lower left hand corner

4. Formulas.

5. OK.

All of the formulas in your Worksheet should now be displayed (it is not
very clear they are just highlighted in a light grey colour so be careful you
don't miss it).

If my comments have helped please hit Yes.

Thanks.
 
I am a student and it says to display the cell formulas in the worksheet. I
have tried EVERYTHING and can't figure it out??? Please help
Click to expand...

You want to display the formulas in the cells?

Pressing Ctrl + ` (grave accent) seems to work in Excel 2003 and 2007.

Some older web pages seem to suggest Ctrl + ~ (tilde). I wonder if
this is for versions older than 2003.

In 2007, there is also a 'Show Formulas' click button in the Formulas
tab.
 
CTRL + `(backquote above Tab key) to toggle view formulas on/off.


Gord Dibben MS Excel MVP
 
Back
Top