Would like to show some best and most commonly used shortcut keys in Microsoft Excel that can be used in 2003-2010 version. To find all the shortcut key, searching in the “Help” by using the keywords -> Keyboard shortcuts.
Move around the Worksheets
Home | Move to the beginning of the row |
Ctrl+Home | Move to the beginning of the workaheet |
Ctrl+End | Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column |
Ctrl+Arrow | Move to edge of region |
Ctrl+Page Up
Ctrl+Page Down |
Move to the pervious sheet
Move to the next sheet |
Ctrl+Tab | Move to next open workbook |
Quick Data Selection
Ctrl+* | Select current region |
Ctrl+A | Select all cells |
Ctrl+Shift+End | Select from active cell to last call in used range |
Ctrl+Shift+Home | Select from active cell to A1 |
Ctrl+Spacebar
Shift+Spacebar |
Select columns
Select rows |
Shift+arrow key | Extend the selection by one cell |
Ctrl+Shift+arrow key | Extend the selection to the last nonblank cell in the same column or row as the active cell |
Instant Cell Formatting
Ctrl+1 | Format Cells |
Ctrl+B | Bold |
Ctrl+U | Underline |
Efficient Windows Operation
Alt+Tab | Switch to the next program |
Ctrl+Esc | Display the Windows Start menu |
PrtScr | Copy a picture of the screen to the Clipboard |
Ctrl+Print Screen | Copy a picture of the selected windows to the of a dialog box |
Tab | Move to the next option or option group of a dialog box |
Shift+Tab | Move to the previous option or option group of a dialog box |