Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to have the actual formulas show up on my spreadsheet, instead of
the results. I think I have done it before, but I can't remember now. Thank you |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
ToolsOptionsView, check Formulas
-- Kind regards, Niek Otten "Hippopotamus" wrote in message ... I am trying to have the actual formulas show up on my spreadsheet, instead of the results. I think I have done it before, but I can't remember now. Thank you |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
goto tools and options, select formulas
|
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ctrl + ` (grave accent same key as tilde) toggles it off and on, or
toolsoptionsviewformulas -- Regards, Peo Sjoblom Portland, Oregon "Hippopotamus" wrote in message ... I am trying to have the actual formulas show up on my spreadsheet, instead of the results. I think I have done it before, but I can't remember now. Thank you |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Press CTRL and ` (the grave accent key to the left of the number 1 at the top
of the keyboard). This shortcut will toggle between the formulas and values. Andrea Jones www.allaboutoffice.co.uk www.stratatraining.co.uk www.allaboutclait.com "Hippopotamus" wrote: I am trying to have the actual formulas show up on my spreadsheet, instead of the results. I think I have done it before, but I can't remember now. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get the filter results to show up in the status bar? | Excel Discussion (Misc queries) | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Excel Solver Results do not show up | Excel Worksheet Functions | |||
displaying results and not formulas | Excel Worksheet Functions | |||
Formulas with If/ and results | Excel Worksheet Functions |