just need to display formulas nothing appears
 

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

just need to display formulas nothing appears
 

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.



"Sissy81" wrote:

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

just need to display formulas nothing appears
 

On 20 Feb, 07:27, Sissy81 wrote:
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.

just need to display formulas nothing appears
 

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


Gord Dibben MS Excel MVP


On Fri, 19 Feb 2010 21:27:01 -0800, Sissy81
wrote:

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