Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel formulae | Excel Worksheet Functions | |||
using formulae in excel | Excel Worksheet Functions | |||
excel formulae | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Excel and CubeCell Formulae | Excel Discussion (Misc queries) |