#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,091
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel formulae Jimi Excel Worksheet Functions 7 August 2nd 07 10:48 PM
using formulae in excel conroy Excel Worksheet Functions 4 January 10th 07 08:04 PM
excel formulae zemarko Excel Discussion (Misc queries) 1 August 3rd 05 05:41 PM
Searching TEXT in formulae, rather than results of formulae AndyE Excel Worksheet Functions 1 July 15th 05 10:57 AM
Excel and CubeCell Formulae les Excel Discussion (Misc queries) 0 March 9th 05 11:28 AM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"