excel formulae

[jester181]

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

 

[Tyro]

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]

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

 

[Sue in AZ]

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