Show all formulae

[karrie]

I just had a query on the show formula shortcut on excel. I'm trying to show
all the formulae for a sheet, but using the Ctrl + ` only seems to show me
the formula for whatever cell is highlighted not the whole sheet. I've tried
selecting the whole sheet but no luck.

 

[Jacob Skaria]

No need to select whole sheet.
The short cut is Ctrl + ~ (Tilde) which is just below the Esc Key...

If this post helps click Yes

 

[karrie]

brill, thanks a lot for taking the time, much appreciated. K

 

[Gord Dibben]

Which is exactly same as CTRL + `(backquote)


Gord Dibben MS Excel MVP