6 Excel keyboard shortcut pairs I didn’t know yet: select row/select column and insert current date/time(via: The Best Shortcut Keys in Microsoft Excel)
Posted by jpluimers on 2012/09/17
Learned a few Excel keyboard shortcut pairs today:
| Shortcut | Action |
|---|---|
| Ctrl+Spacebar | Select columns |
| Shift+Spacebar | Select rows |
| Ctrl+; | Current date |
| Ctrl+Shift+: | Current time |
| Ctrl+Shift+2 | Format current cell as default date |
| Ctrl+Shift+3 | Format current cell as default time |
–jeroen
via:
- The Best Shortcut Keys in Microsoft Excel.
- keyboard shortcut for dates and Time – ExcelBanter.
- Adding the Current Date – Excel Keyboard Shortcuts.
- Adding the Current Time – Excel Keyboard Shortcuts.
- Discussion on A few Excel formatting keyboard shortcuts | TechRepublic.
The Wiert Corner - irregular stream of stuff 
Leave a comment