CTRL + `
 

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?

--
Lindsay Graham
Canberra, Australia
---------------------------------------------
Please reply only to the list/newsgroup so that all may benefit.

CTRL + `
 

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



"Lindsay Graham" wrote in message
...
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?

--
Lindsay Graham
Canberra, Australia
---------------------------------------------
Please reply only to the list/newsgroup so that all may benefit.

CTRL + `
 

hi
if you would like a list of keyboard shortcut, see these sites...
2003
http://www.cpearson.com/excel/KeyboardShortcuts.htm
2007
http://www.keyxl.com/aaa33ef/136/Mic...-shortcuts.htm
yeah. some changes.
surprised????

regards
FSt1


"Lindsay Graham" wrote:

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?

--
Lindsay Graham
Canberra, Australia
---------------------------------------------
Please reply only to the list/newsgroup so that all may benefit.