Excel 2007 shortcuts
Posted by dvanarsd on May 16, 2008
PC Magazine (June 200
has a list of “11 Killer Excel 2007 Shortcuts”:
| Ctrl-Shift-& | Apply the outline border to the selected cells |
| Ctrl-Shift-# | Apply the Date format with day, month and year |
| Ctrl-Shift-@ | Apply the Time format: hour, minute, AM or PM |
| Ctrl-Shift-: | (colon) Enter current time |
| Ctrl-; | (semi-colon) Enter date |
| Ctrl-O | Hide selected columns |
| Ctrl-’ | (single quote) alternate: cell values/formulas |
| Ctrl-H | Find and replace |
| Ctrl-F2 | Print Preview |
| Ctrl-F6 | next workbook |
| Alt-F8 | macro dialog box |