Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to show formula
okay- I have tried for over an hour!
How does one "show formula" on excel in Office '07? I googled it and found the shortcut CNTRL ~ But there simply MUST be a way to format the spreadsheet to "show formulas" without a shortcut. Can someone please tell me where that would be? Thanks a bunch! Don |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to show formula
Click the window button in the top left and go into Excel options, advanced,
scroll down to the display options and toggle on the "show formulas instead of their calculation result" Cheers Robbie "Don" wrote: okay- I have tried for over an hour! How does one "show formula" on excel in Office '07? I googled it and found the shortcut CNTRL ~ But there simply MUST be a way to format the spreadsheet to "show formulas" without a shortcut. Can someone please tell me where that would be? Thanks a bunch! Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show and copy values in formula bar containing a formula | Excel Discussion (Misc queries) | |||
Dont show formula in formula bar | Excel Discussion (Misc queries) | |||
formula to show a formula in a different cell | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |