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
|