Show all formulae
 

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.

Show all formulae
 

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
---------------
Jacob Skaria


"karrie" wrote:

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.

Show all formulae
 

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

"karrie" wrote:

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.

Show all formulae
 

Which is exactly same as CTRL + `(backquote)


Gord Dibben MS Excel MVP

On Wed, 7 Oct 2009 03:55:01 -0700, Jacob Skaria
wrote:

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
---------------
Jacob Skaria


"karrie" wrote:

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.