Oct 8 2008
Excel Keyboard Shortcuts
- 1 Comment
Using these Microsoft Excel shortcuts will greatly decrease your time spent doing simple operations. This is not an exhaustive list of available shortcuts, only commands that I have found useful through my experiences. I’ve found that the best way to see if any of them will work for me, is to try a couple at a time and get used to using them. Over time, they can gradually increase your productivity if you give them a chance.
[ad#in-post-ad]
|
Shortcut Keys |
Action |
|
F1 |
Display the Assistant Balloon or Turns on Assistant
|
|
CTRL+P or CTRL+SHIFT+F12 |
Print
|
|
ALT+F then press V
|
Print Preview
|
|
SHIFT+F11 or ALT+SHIFT+F1
|
Move to the next Sheet
|
|
CTRL+PAGE UP
|
Move to the previous sheet
|
|
Arrow Keys
|
Move one cell in that direction
|
|
CTRL+arrow keys
|
Move to the edge of the 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 on the worksheet (inside data region)
|
|
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
|
Display the GO TO box.
|
|
CTRL F or SHIFT+F5
|
Display the FIND box.
|
|
SHIFT+F4
|
Repeat the last FIND action
|
|
End+arrow key
|
Move by one block of data within a row or column
|
|
END+HOME
|
Move to the last cell in the worksheet (inside data region)
|
|
END+ENTER
|
Move to the rightmost nonblank cells in the current row.
|
|
CTRL+SPACEBAR
|
Select the entire column
|
|
SHIRT+SPACEBAR
|
Select the entire row
|
|
CTRL+A
|
Select Entire Worksheet
|
|
CTRL+SHIFT+*
|
Select the entire PivotTable Report
|
|
CTRL+SHIRT+O
|
Select all cells that contain comments
|
|
CTRL+[
|
Select all cells directly references by formulas in the selection
|
|
CTRL+]
|
Select cells that contain formulas that directly reference the active cell
|
|
F8
|
Turn the Extend Mode on/off
|
|
SHIFT+arrow key
|
Extend the selection by one cell
|
|
CTRL+SHIRT+arrow key
|
Extend the selection to the last nonblank cell in the same column or row.
|
|
SHIFT+HOME
|
Extend the selection to the beginning of the row
|
|
CTRL+SHIFT+HOME
|
Extend the selection to the beginning of the worksheet
|
|
CTRL+SHIFT+END
|
Extend the selection to the last used cell on the worksheet
|
|
ENTER
|
Complete a cell entry and select the cell below.
|
|
ALT+ENTER
|
Start a new line in the same cell
|
|
TAB
|
Complete a cell entry and select the next cell to the right.
|
|
SHIFT+TAB
|
Complete a cell entry and select the previous cell to the left.
|
|
ESC
|
Cancel a cell entry
|
|
Arrow Key (within cell entry)
|
Move one character up, down, left, right
|
|
CTRL+D
|
Fill Down
|
|
CTRL+R
|
Fill Right
|
|
CTRL+K
|
Insert a Hyperlink
|
|
CTRL+;
|
Enter the Date
|
|
CTRL+SHIFT+:
|
Enter the time
|
|
CTRL+Z
|
Undo your last action
|
|
=
|
Start a formula
|
|
CTRL+SHIFT+ENTER
|
Enter a formula as an array formula
|
|
SHIFT+F3
|
In a formula, display the Insert Function
|
|
ALT+=
|
Insert an autosum formula
|
|
CTRL+’
|
Alternate between displaying cell values and displaying formulas
|
|
F9
|
Calculate all worksheets in all open workbooks
|
|
SHIFT+F9
|
Calculate the active worksheet
|
|
F7
|
Spellcheck
|
|
SHIFT+F2
|
Edit a cell comment
|
|
CTRL+C
|
Copy the selected cells
|
|
CTRL+X
|
Cut the Selected Cells
|
|
CTRL+V
|
Paste Copied Cells
|
|
DELETE
|
Clear the contents of the selected cells
|
|
CTRL+1
|
Display the Format Cells dialog box
|
|
CTRL+SHIFT+~
|
Apply the General Number format
|
|
CTRL+SHIFT+$
|
Apply the Currency format with 2 decimal places
|
|
CTRL+SHIFT+%
|
Apply the Percentage format
|
|
CTRL+SHIFT+^
|
Apply the Exponential number format
|
|
CTRL+SHIFT+#
|
Apply the Date format
|
|
CTRL+SHIFT+@
|
Apply the time format
|
|
CTRL+SHIFT+!
|
Apply the Number format with 2 decimal places
|
|
CTRL+B
|
Apply Bold formatting
|
|
CTRL+I
|
Apply Italic formatting
|
|
CTRL+U
|
Apply Underline formatting
|
|
CTRL+5
|
Apply strikethrough formatting
|
|
CTRL+9
|
Hide selected rows
|
|
CTRL+SHIFT+(
|
Unhide any hidden rows with selection
|
|
CTRL+9
|
Hide selected columns
|
|
CTRL+SHIFT+)
|
Unhide any hidden columns with selection
|
|
ALT+down arrow
|
Displays the auto-filter list in the current column
|
** Excel Hints provides Excel Tips and Excel Help for All Levels.
[...] Basic editor. A quick way to get to the VBA editor is to hit the Alt+F11 key sequence (Additional keyboard shortcuts). Once you get into the VBA editor, from the menu bar – select Insert–>Module. This is [...]