• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: Appendixes > Excel Shortcut Keys

Appendix A. Excel Shortcut Keys

In this Appendix

  • Excel Shortcut Keys

ToPress
General Commands 
Get helpF1
Activate menu barF10
Find an entryShift+F5
Repeat most recent find operationShift+F4
Check spellingF7
Workbook File Commands 
Create new fileCtrl+N
Open fileCtrl+O
Print fileCtrl+P
Save fileCtrl+S
Save copy of file under another nameF12
Navigate Worksheets 
Move one cell up, down, left, or rightArrow Keys
Go to active cellCtrl+Backspace
Move to next unlocked cell on a protected worksheetTab
Move down one screenPage Down
Move up one screenPage Up
Move one screen to the rightAlt+Page Down
Move one screen to the leftAlt+Page Up
Switch to next split paneF6
Switch to previous split paneShift+F6
Find text or formatCtrl+F
Flip to next worksheet pageCtrl+Page Down
Flip to previous worksheet pageCtrl+Page Up
Go to a specific cell or named rangeF5 or Ctrl+G
Move to edge of current data regionCtrl+Arrow Key
Move to beginning of rowHome
Move to beginning of worksheetCtrl+Home
Move to last cell on worksheetCtrl+End
Navigate in Selected Range 
Move from top to bottom of rangeEnter
Move from bottom to top of rangeShift+Enter
Move from left to right of rangeTab
Move from right to left of rangeShift+Tab
Move clockwise to next corner of rangeCtrl+Period
Switch to selected range to the rightCtrl+Alt+Right Arrow
Switch to selected range to the leftCtrl+Alt+Left Arrow
Navigate in End Mode 
Toggle End mode on or offEnd
Move to next data block in row or columnEnd+Arrow Key
Move down and to the right to the last used worksheet cellEnd+Home
Move to rightmost used cell in current rowEnd+Enter
Navigate with Scroll Lock 
Toggle Scroll Lock on or offScroll Lock
Select cell in upper-left corner of windowHome
Select cell in lower-right corner of windowEnd
Scroll one row upUp Arrow
Scroll one row downDown Arrow
Scroll one column to leftLeft Arrow
Scroll one column to rightRight Arrow
Data Entry 
End cell entry and move down one cellEnter
End cell entry and move up one cellShift+Enter
End cell entry and move one cell to rightTab
End cell entry and move one cell to leftShift+Tab
Cancel an entry you typedEsc
Move one character or line left, right, up, or down when entering or editing cell entryArrow Key
Move to beginning of entryHome
Fill a cell entry into cells belowCtrl+D
Fill a cell entry into cells to rightCtrl+R
Fill range with current entryCtrl+Enter
Paste a function into a formulaShift+F3
Insert AutoSum formulaAlt+= (equal sign)
Start new line in cell entryAlt+Enter (when typing or editing entry)
Insert page breakAlt+Enter (when cell, row, or column is selected)
Insert dateCtrl+; (semicolon)
Insert timeCtrl+: (colon)
Insert new worksheetShift+F11
Select entry from a drop-down list of entries already typed in a row or columnAlt+Down Arrow
Insert hyperlink (for Web-based worksheets)Ctrl+K
Formula/Function Entry 
Start formula entry= (equal sign)
Enter a formula as an array formulaCtrl+Shift+Enter
Display Insert Function dialog box when typing or editing a formulaShift+F3
Display Function Arguments dialog box when insertion point is to right of function name in formulaCtrl+A
Insert argument names and parentheses when insertion point is to right of function name in formulaCtrl+Shift+A
Paste range name into formulaF3
Insert AutoSum formula with SUM functionAlt+= (equal sign)
Copy value from cell above active cell into active cellCtrl+Shift+” (quotation mark)
Copy formula from cell above active cell into active cellCtrl+’ (apostrophe)
Toggle display of cell values and formulasCtrl+` (single left quotation mark)
Recalculate all formulas or selected portion of current formulaF9
Calculate only the active worksheetShift+F9
Recalculate all formulas whether or not they have changed since the last calculationCtrl+Alt+F9
Check all dependent formulas and recalculate all formulas, including those not marked for recalculationCtrl+Alt+Shift+F9
Selection Keystrokes 
Select cellArrow Keys
Name selected range of cellsCtrl+F3
Name range using an entry from a cell in the rangeCtrl+Shift+F3
Select entire columnCtrl+Spacebar
Select entire rowShift+Spacebar
Select entire worksheetCtrl+A
Deselect all but the active cellShift+Backspace
Select all objects on worksheet when an object is selectedCtrl+Shift+Spacebar
Toggle between hiding or displaying objects or displaying placeholders for objectsCtrl+6
Select current and next worksheetCtrl+Shift+Page Down
Select current and previous worksheetCtrl+Shift+Page Up
Deselect multiple worksheetsCtrl+Page Down
Extend Selection 
Toggle Extend mode on or offF8
Extend selection in Extend modeArrow Key
Select another rangeShift+F8
Extend selection with Extend mode offShift+Arrow Key
Extend selection to last used cellCtrl+Shift+Arrow Key
Extend selection to beginning of rowShift+Home
Extend selection to beginning of worksheetCtrl+Shift+Home
Extend selection to last used cellCtrl+Shift+End
Extend selection down one screenShift+Page Down
Extend selection up one screenShift+Page Up
Extend selection to last used cell in same column or rowEnd+Shift+Arrow Key
Extend selection to last used cellEnd+Shift+Home
Extend selection to last cell in current rowEnd+Shift+Enter
Extend selection to cell in upper-left corner of windowScroll Lock+Shift+Home
Extend selection to cell in lower-right corner of windowScroll Lock+Shift+End
Editing Shortcuts 
Copy selectionCtrl+C
Display Office ClipboardCtrl+C, Ctrl+C
Replace textCtrl+H
Paste selectionCtrl+V
Cut selectionCtrl+X
Repeat last actionCtrl+Y or F4
Undo last actionCtrl+Z
Delete entries in selected cellsDelete
Delete character to the right of the insertion point when in Edit modeDelete
Delete from the insertion point to the end of the lineCtrl+Delete
Delete character to the left of the insertion point when in Edit modeBackspace
Delete cellsCtrl+- (hyphen)
Insert blank cellsCtrl+Shift++ (plus sign)
Edit a cell entryF2
Edit a cell commentShift+F2
Rename current worksheetALT+O H R
Move or copy current worksheetALT+E M
Delete current worksheetALT+E L
Formatting Shortcuts 
Copy format of selectionCtrl+Shift+C
Paste formatCtrl+Shift+V
Display Style dialog boxAlt+’ (apostrophe)
Display Format Cells dialog boxCtrl+1
Apply General Number formatCtrl+Shift+~
Apply Currency formatCtrl+Shift+$
Apply Percentage formatCtrl+Shift+%
Apply Exponential Number formatCtrl+Shift+^
Apply Date formatCtrl+Shift+#
Apply Time formatCtrl+Shift+@
Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative valuesCtrl+Shift+!
Add or remove boldfacingCtrl+B
Add or remove italicsCtrl+I
Add or remove underliningCtrl+U
Add or remove strikethroughCtrl+5
Hide selected rowsCtrl+9
Unhide any hidden rows in selectionCtrl+Shift+( (opening parenthesis)
Hide selected columnsCtrl+0 (zero)
Unhide any hidden columns in selectionCtrl+Shift+) (closing parenthesis)
Apply outline border around selected cellsCtrl+Shift+&
Remove outline border from around selected cellsCtrl+Shift+_



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint