just need to display formulas nothing appears

[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

 

[trip_to_tokyo]

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.

 

[Pekka Numminen]

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

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.

 

[Gord Dibben]

CTRL + `(backquote above Tab key) to toggle view formulas on/off.


Gord Dibben MS Excel MVP