| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
| use CTRL key inside a macro IE CTRL + ; | Excel Worksheet Functions | |||
| Anyone having Ctrl+C / Ctrl+V problems in E2007? | Excel Discussion (Misc queries) | |||
| How to forbid ctrl+c and ctrl+X in sheet? | Setting up and Configuration of Excel | |||
| CARET or ^, as in CTRL but CTRL !!! ??? | Excel Worksheet Functions | |||
Hybrid Mode
