CTRL + `

L

Lindsay Graham

JE McGimpsey mentioned this keyboard shortcut in a post back in June 2008.

It appears to change all cells in a spreadsheet from dates to date serial
numbers and vice versa. But I can't find any mention of the shortcut in
Excel 2003 Help. Can someone tell me where it is in Help or explain what it
is supposed to do? For example, is it supposed to operate on the whole
spreadsheet? Can it be applied to selected cells only?
 
P

Peo Sjoblom

It toggles formulas/view formulas on and off and apparently toggle date and
their serial numbers on/off as well. Put a formula in a cell, for instance

=12*A1

in any cell but A1, the press ctrl + ` over and over again




--


Regards,


Peo Sjoblom
 
Top