excel formulae
 

This is going to sound like a really basic question, but how do you display
all formulae on a sheet in Excel XP or 2003. I can do it no problem in 2007,
but just have total mental block in earlier versions.

Any ideas??
Thanks

excel formulae
 

Press Ctrl+` (Accent Grave, leftmost key on the top row below the function
keys) Repeat to return to normal display. Just as in Excel 2007.

Tyro

"jester181" wrote in message
...
This is going to sound like a really basic question, but how do you
display
all formulae on a sheet in Excel XP or 2003. I can do it no problem in
2007,
but just have total mental block in earlier versions.

Any ideas??
Thanks

excel formulae
 

Thanks - did it a different way in 2007, but it all came back to me just
after I posted the message!
Thanks anyway!!


"Tyro" wrote:

Press Ctrl+` (Accent Grave, leftmost key on the top row below the function
keys) Repeat to return to normal display. Just as in Excel 2007.

Tyro

"jester181" wrote in message
...
This is going to sound like a really basic question, but how do you
display
all formulae on a sheet in Excel XP or 2003. I can do it no problem in
2007,
but just have total mental block in earlier versions.

Any ideas??
Thanks

excel formulae
 

Ooh, I didn't know that one. I love keyboard shortcuts! Thanks!

"Tyro" wrote:

Press Ctrl+` (Accent Grave, leftmost key on the top row below the function
keys) Repeat to return to normal display. Just as in Excel 2007.

Tyro

"jester181" wrote in message
...
This is going to sound like a really basic question, but how do you
display
all formulae on a sheet in Excel XP or 2003. I can do it no problem in
2007,
but just have total mental block in earlier versions.

Any ideas??
Thanks