| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show all formula's
Is it possible to highligt all formulas so that any ommissions or error's can be seen? -- MichaelJDrake ------------------------------------------------------------------------ MichaelJDrake's Profile: http://www.excelforum.com/member.php...o&userid=31892 View this thread: http://www.excelforum.com/showthread...hreadid=516181 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to show all formula's
Ctrl + ` (grave accent) same key as the tilde ~ will toggle formulas back
and forth or you can select all formulas using F5 (or Ctrl + G), then special and formulas -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "MichaelJDrake" wrote in message news:MichaelJDrake.23qmwb_1140791704.1894@excelfor um-nospam.com... Is it possible to highligt all formulas so that any ommissions or error's can be seen? -- MichaelJDrake ------------------------------------------------------------------------ MichaelJDrake's Profile: http://www.excelforum.com/member.php...o&userid=31892 View this thread: http://www.excelforum.com/showthread...hreadid=516181 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to show all formula's
F5 Special Formulas ok
Vaya con Dios, Chuck, CABGx3 "MichaelJDrake" wrote: Is it possible to highligt all formulas so that any ommissions or error's can be seen? -- MichaelJDrake ------------------------------------------------------------------------ MichaelJDrake's Profile: http://www.excelforum.com/member.php...o&userid=31892 View this thread: http://www.excelforum.com/showthread...hreadid=516181 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to show all formula's
If you mean showing the formulas themselves:
ToolsOptionsView, check Formulas If you mean highlighting the cells: EditGo ToSpecial, check Formulas -- Kind regards, Niek Otten "MichaelJDrake" wrote in message news:MichaelJDrake.23qmwb_1140791704.1894@excelfor um-nospam.com... Is it possible to highligt all formulas so that any ommissions or error's can be seen? -- MichaelJDrake ------------------------------------------------------------------------ MichaelJDrake's Profile: http://www.excelforum.com/member.php...o&userid=31892 View this thread: http://www.excelforum.com/showthread...hreadid=516181 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to show all formula's
To highlight all formulas: Edit Go To Special select Formulas OK This selects all cells containing formulas To show all formulas: Tools Options View tab in Window options select Formulas OK This displays all the formulas instead of their values -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=516181 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Printing formulas | Excel Discussion (Misc queries) | |||
| show text after formulas | Excel Discussion (Misc queries) | |||
| UDF and Calculation tree | Links and Linking in Excel | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
