Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Toggle formulae display ON/OFF on worksheet
I've created a macro to do this, but I was sure that there was a shortcut key
already in Excel 2003 to do this. Here's how my macro looks: Sub ToggleFormulaOnOff() FormulaStatus = ActiveWindow.DisplayFormulas ActiveWindow.DisplayFormulas = Not FormulaStatus End Sub Does anyone know the existing shortcut? Thanks in advance! Cheers Training Goddess |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Toggle formulae display ON/OFF on worksheet
On my USA keyboard, the shortcut key is:
ctrl-` (Control-backquote, the key to the left of the 1/! on the top row) Training Goddess wrote: I've created a macro to do this, but I was sure that there was a shortcut key already in Excel 2003 to do this. Here's how my macro looks: Sub ToggleFormulaOnOff() FormulaStatus = ActiveWindow.DisplayFormulas ActiveWindow.DisplayFormulas = Not FormulaStatus End Sub Does anyone know the existing shortcut? Thanks in advance! Cheers Training Goddess -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Toggle formulae display ON/OFF on worksheet
Try:-
Ctrl+` Its to the left of the 1 key. Mike "Training Goddess" wrote: I've created a macro to do this, but I was sure that there was a shortcut key already in Excel 2003 to do this. Here's how my macro looks: Sub ToggleFormulaOnOff() FormulaStatus = ActiveWindow.DisplayFormulas ActiveWindow.DisplayFormulas = Not FormulaStatus End Sub Does anyone know the existing shortcut? Thanks in advance! Cheers Training Goddess |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Toggle formulae display ON/OFF on worksheet
same on UK
"Dave Peterson" wrote: On my USA keyboard, the shortcut key is: ctrl-` (Control-backquote, the key to the left of the 1/! on the top row) Training Goddess wrote: I've created a macro to do this, but I was sure that there was a shortcut key already in Excel 2003 to do this. Here's how my macro looks: Sub ToggleFormulaOnOff() FormulaStatus = ActiveWindow.DisplayFormulas ActiveWindow.DisplayFormulas = Not FormulaStatus End Sub Does anyone know the existing shortcut? Thanks in advance! Cheers Training Goddess -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Toggle formulae display ON/OFF on worksheet
On my USA keyboard, the shortcut key is:
ctrl-` (Control-backquote, the key to the left of the 1/! on the top row) You can also add a button to the toolbar to toggle this with a mouse click... Right-click a blank area of the toolbar and select Customize from the popup menu. Select the Command tab on the dialog box that appears. Select Tools in the Categories list and then scroll down in the Commands list until you find Formula Auditing Mode Click and drag the Formula Auditing Mode icon to some place on one of the tool bars and release the mouse button. The Formula Auditing Mode icon should now appear on the tool bar. Close the Customize dialog box. Whenever you click this icon, the formula display mode should toggle. Rick |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Toggle formulae display ON/OFF on worksheet
Thank you all for your help and for the extra tip about the toolbar button.
How cool is that?!? and so fast! Cheers! Kimberly "Training Goddess" wrote: I've created a macro to do this, but I was sure that there was a shortcut key already in Excel 2003 to do this. Here's how my macro looks: Sub ToggleFormulaOnOff() FormulaStatus = ActiveWindow.DisplayFormulas ActiveWindow.DisplayFormulas = Not FormulaStatus End Sub Does anyone know the existing shortcut? Thanks in advance! Cheers Training Goddess |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't toggle (or display) formula bar | Excel Discussion (Misc queries) | |||
"Toggle total row" button not enabled in Excel 2003 | Excel Discussion (Misc queries) | |||
Can't toggle function results display. | Excel Discussion (Misc queries) | |||
EXCEL 2003 formulae | Excel Discussion (Misc queries) | |||
Is there a way to toggle cells between display of referenced data. | Excel Discussion (Misc queries) |