Excel Keyboard Shortcuts
February 26th, 2007A lot of people I know like to use the mouse when using the computer. One hand is almost always holding the mouse. But me, I prefer to use the keyboard and use the mouse only when I have to (like drag-and-drop operations, clicking a button, etc). But as long as there’s an easy-to-remember way that I can do the operation without using the mouse, chances are, I’d do it that way. I just feel that there are many things that can be done a lot faster with the use of the keyboard than using the mouse. So, if you’re like me, you’d be interested about keyboard shortcuts in Excel.
I found a nicely formatted reference in Chip Pearson’s website. You can even download it as an Excel workbook. The complete list can be found in Excel help by doing a search for ‘keyboard shortcuts’. It is also available online from Microsoft’s Office website.
Personnaly, I have found these to be ones that I regularly use and very useful to me:
Shortcut Key |
What it does |
| F1 | Help |
| F2 | Edit the active cell and position the cursor at the end of the cell contents |
| Shift+F11 | Insert a new worksheet |
| Ctrl+Page Down | Move to the next sheet |
| Ctrl+Page Up | move to the previous sheet |
| Shift+Ctrl+Page Down | Select the current sheet and the next sheet |
| Shift+Ctrl+Page Up | Select the current and previous sheets |
| Alt + O H H | Hide the current sheet |
| Arrow Keys | Move one cell at a time within the worksheet in the direction of the arrow key |
| Ctrl+Arrow Key | Move to the edge of the current data region |
| HOME | Move to the beginning of the row |
| Ctrl+HOME | Move to the beginning of the worksheet |
| Ctrl+END | Move to the last cell of the worksheet. Bottom-right of the used range |
| Page Down | Move down one screen |
| Page Up | Move up one screen |
| Alt+Page Down | Move one screen to the right |
| Alt-Page Up | Move one screen to the left |
| F5 | Go to |
| Ctrl+Space Bar | Select the entire column |
| Shift+Space Bar | Select the entire row |
| Ctrl+A | Select the entire worksheet |
| Ctrl+Shift+Space Bar | Select the current data region |
| Alt+Enter | Start a new line in the same cell |
| Ctrl+D | Fill Down |
| Ctrl+R | Fill Right |
| Ctrl+;(semi-colon) | Enter the date |
| Ctrl+Shift+; (colon) | Enter the time |
| Ctrl+Z | Undo |
| Ctrl+C | Copy |
| Ctrl+X | Cut |
| Ctrl+V | Paste |
| Ctrl+1 | Format Cells Dialog Box |
| Ctrl+B | Apply Bold formatting to the font |
| Ctrl+I | Apply Italic formatting to the font |
No Comments yet »
RSS feed for comments on this post. TrackBack URI
Leave a comment
(C) by Virgilio Adriano. All rights reserved. Powered by WordPress.
Entries and comments feeds.
It took 0.493 seconds to load this page.