| January 5, 2009 |  |
 |
 |
 |
 |
 |
 |
 |
 |
|
 |
Microsoft Excel Keyboard Shortcuts
Don't remember all of those Excel keyboard shortcuts you learned in your last class? No problem! Here are some of the most popular shortcuts for you to use.
While many of these shortcuts will work for all versions of Excel, these have been prepared using Excel 2003 so if you have an earlier version of the program some of the actions may or may not be applicable.
Excel 2003 Keyboard Shortcuts |
||
Action |
Shortcut Key |
|
| Edit cells | F2 | |
| Delete cells entirely | Ctrl + - | |
| Move between open workbooks | Ctrl + Tab | |
| Move to next sheet | Ctrl + PgDn | |
| Move to previous sheet | Ctrl + PgUp | |
| Insert a new worksheet | Shift + F11 | |
| Select the current sheet and the next sheet | Shift + Ctrl + PgDn | |
| Select the current sheet and the previous sheet | Shift + Ctrl + PgUp | |
| Select the entire column | Ctrl + Spacebar | |
| Select the entire row | Shift + Spacebar | |
| Display the format cells dialog box | Ctrl + 1 | |
| Select a range of cells | Ctrl + Shift + * | |
| Enter a line break within a cell | Alt + Enter | |
| Toggle between absolute and relative cell references | F4 | |
| Toggle between viewing values and formulas in cells | Ctrl + | |
| Delete the selected cells | Ctrl + - | |
| Insert blank cells | Ctrl + Shift + + | |
| Hide the selected rows | Ctrl + 9 | |
| Unhide any hidden rows in the selection | Ctrl + Shift + ( | |
| Hide the selected columns | Ctrl + 0 | |
| Unhide any hidden columns in the selection | Ctrl + Shift + ) | |
| Apply an outline border to the selected cells | Ctrl + Shift + & | |
| Remove the outline border | Ctrl + Shift + _ | |
| Open the Visula Basic editor | Alt + F11 | |
| Insert the current date | Ctrl + ; | |
| Insert the current time | Ctrl + Shift + ; | |
| Insert the current time and date | Ctrl + Spacebar then Ctrl + Shift + ; | |
| Create a chart | F11 | |
| Repeat the last action | F4 | |
| Define a range name | Ctrl + F3 | |
| Fill a range to the right | Ctrl + R | |
| Fill a range down | Ctrl + D | |
| Enter the cent character | Alt + 0162 | |
| Enter the pound sterling character | Alt + 0163 | |
| Enter the yen symbol | Alt + 0165 | |
| Enter the euro symbol | Alt + 0128 | |
| Display the insert function dialog box | Shift + F3 | |
| Copy the value from the cell above | Ctrl + Shift + " | |
| Copy the formula from the cell above | Ctrl + ' | |
| Edit a cell comment | Ctrl + F2 | |
| Apply the currency format | Ctrl + Shift + $ | |
| Apply the percentage format | Ctrl + Shift + % | |
| Aply the exponential number format | Ctrlj + Shift + ^ | |
| Apply the number format with two decimals | Ctrl + Shift + ! | |
| Apply the general number format | Ctrl + Shift + ~ | |
| Display the style dialog box | Alt + ' |