Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show formulas instead of results
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
|
|||
|
|||
Show formulas instead of results
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
|
|||
|
|||
Show formulas instead of results
goto tools and options, select formulas
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show formulas instead of results
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
|
|||
|
|||
Show formulas instead of results
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 | |
|
|
Similar Threads | ||||
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 |