Excel Shortcuts
Be Smart with Excel - Get2Excel Single place to get all excel shortcuts to go fast & easy with Excel!
All Microsoft Windows and Apple Mac Keyboard shortcuts for Excel...
Work With File
Excel Shortcut Details
Windows Shortcuts
MAC Shortcuts
To Create new workbook
Ctrl N
⌘ N
For Open workbook
Ctrl O
⌘ O
To Save workbook
Ctrl S
⌘ S
For Save as
F12
⌘ ⇑S
For Print file
ctrl P
⌘ P
For Open print preview window
ctrl F2
To Close current workbook
ctrl F4
⌘ W
Close Excel Application
Alt F4
⌘ Q
Play With Ribbon
Show or Hide ribbon
Ctrl F1
⌘ ⌥ R
To Activate access keys
Alt
Move to next ribbon control
Tab Key
Tab Key
Activate or open selected control
Space Key
Space Key
Confirm control change
Enter Key
Enter Key
For Get help on selected control
F1
⌘ /
General
Undo last action
Ctrl Z
⌘ Z
Redo last action
Ctrl Y
⌘ Y
Repeat last action
F4
⌘ Y
Copy selected cells
Ctrl C
⌘ C
Cut selected cells
Ctrl X
⌘ X
Paste content from clipboard
Ctrl V
⌘ V
Display the Paste Special dialog box
Ctrl Alt V
^ ⌘ V
Display find and replace
Ctrl F
⌘ F
Display find and replace, replace selected
Ctrl H
⌃ H
Find previous match
Ctrl Shift F4
⌘ ⇧ G
Find next match
Shift F4
⌘ G
Create embedded chart
Alt F1
Fn ⌥ F1
Create chart in new worksheet
F11
Fn F11
Toggle Autofilter
Ctrl Shift L
⌘ ⇧ F
Activate filter
Alt ↓
⌥ ↓
Insert table
Ctrl T
⌃ T
Select table row
Shift Space
⇧ Space
Select table column
Ctrl Space
⌃ Space
Select table
Ctrl A
⌘ A
Drag and Drop
Drag and cut
drag
drag
Drag and copy
Ctrl drag
⌥ drag
Drag and insert
Shift drag
⇧ drag
Drag and insert copy
Ctrl Shift drag
⌥ ⇧ drag
Drag to worksheet
Alt drag
⌘ drag
Drag to duplicate worksheet
Ctrl drag
⌥ drag
Navigation
Move one cell right
→
→
Move one cell left
←
←
Move one cell up
↑
↑
Move one cell down
↓
↓
Move one screen right
Alt PgDn
Fn ⌥ ↓
Move one screen left
Alt PgUp
Fn ⌥ ↑
Move one screen up
PgUp
Fn ↑
Move one screen down
PgDn
Fn ↓
Move to right edge of data region
Ctrl →
⌃ →
Move to left edge of data region
Ctrl ←
⌃ ←
Move to top edge of data region
Ctrl ↑
⌃ ↑
Move to bottom edge of data region
Ctrl ↓
⌃ ↓
Move to beginning of row
Home
Fn ←
Move to last cell in worksheet
Ctrl End
Fn ⌃ →
Move to first cell in worksheet
Ctrl Home
Fn ⌃ ←
Turn End mode on
End
Fn →
Selection
Select entire row
Shift Space
⇧ Space
Select entire column
Ctrl Space
⌃ Space
Select entire worksheet
Ctrl A
⌘ A
Add adjacent cells to selection
Shift Click
⇧ Click
Add non-adjacent cells to selection
Ctrl Click
⌘ Click
Same selection in next column
⌥ Tab
Same selection in previous column
⌥ ⇧ Tab
Move right between non-adjacent selections
Ctrl Alt →
⌃ ⌥ →
Move left between non-adjacent selections
Ctrl Alt ←
⌃ ⌥ ←
Toggle add to selection mode
Shift F8
Fn ⇧ F8
Cancel selection
Esc
Esc
Active Cell
Select active cell only
Shift Backspace
⇧ Delete
Show the active cell on worksheet
Ctrl Backspace
⌘ Delete
Move active cell clockwise in selection
Ctrl .
⌃ .
Move active cell down in selection
Enter
Return
Move active cell up in selection
Shift Enter
⇧ Return
Move active cell right in a selection
Tab
Tab
Move active cell left in a selection
Shift Tab
⇧ Tab
Extend Selection
Extend selection by one cell right
Shift →
⇧ →
Extend selection by one cell left
Shift ←
⇧ ←
Extend selection by one cell up
Shift ↑
⇧ ↑
Extend selection by one cell down
Shift ↓
⇧ ↓
Extend the selection to the last cell right
Ctrl Shift →
⌃ ⇧ →
Extend the selection to the last cell left
Ctrl Shift ←
⌃ ⇧ ←
Extend the selection to the last cell up
Ctrl Shift ↑
⌃ ⇧ ↑
Extend the selection to the last cell down
Ctrl Shift ↓
⌃ ⇧ ↓
Extend selection up one screen
Shift PgUp
Fn ⇧ ↑
Extend selection down one screen
Shift PgDn
Fn ⇧ ↓
Extend selection right one screen
Alt Shift PgDn
Fn ⇧ ⌘ ↓
Extend selection left one screen
Alt Shift PgUp
Fn ⇧ ⌘ ↑
Extend selection to start of row
Shift Home
Fn ⇧ ←
Extend selection to first cell in worksheet
Ctrl Shift Home
Fn ⌃ ⇧ ←
Extend selection to last cell in worksheet
Ctrl Shift End
Fn ⌃ ⇧ →
Toggle extend selection mode
F8
Fn F8
Select Special
Display 'Go To' dialog box
Ctrl G
⌃ G
Select cells with comments
Ctrl Shift O
Fn ⌃ ⇧ O
Select current region around active cell
Ctrl Shift *
⇧ ⌃ Space
Select current region
Ctrl A
⌘ A
Select current array
Ctrl /
⌃ /
Select row differences
Ctrl \
⌃ \
Select column differences
Ctrl Shift |
⌃ ⇧ |
Select direct precedents
Ctrl [
⌃ [
Select all precedents
Ctrl Shift {
⌃ ⇧ {
Select direct dependents
Ctrl ]
⌃ ]
Select all dependents
Ctrl Shift }
⌃ ⇧ }
Select visible cells only
Alt ;
⌘ ⇧ Z
Cell edit mode
Edit the active cell
F2
⌃ U
Insert or edit comment
Shift F2
Fn ⇧ F2
Cancel entry
Esc
Esc
Select one character right
Shift →
⇧ →
Select one character left
Shift ←
⇧ ←
Move one word right
Ctrl →
⌃ →
Move one word left
Ctrl ←
⌃ ←
Select one word right
Ctrl Shift →
⌃ ⇧ →
Select one word left
Ctrl Shift ←
⌃ ⇧ ←
Select to beginning of cell
Shift Home
Fn ⇧ ←
Select to end of cell
Shift End
Fn ⇧ →
Delete to end of line
Ctrl Delete
⌃ Delete
Delete character to the left of cursor
Backspace
Delete
Delete character to the right of cursor
Delete
Fn Delete
Start a new line in the same cell
Alt Enter
⌃ ⌥ Return
Entering data
Enter and move down
Enter
Return
Enter and move up
Shift Enter
⇧ Return
Enter and move right
Tab
Tab
Enter and move left
Shift Tab
⇧ Tab
Complete entry and stay in same cell
Ctrl Enter
⌃ Return
Enter same data in multiple cells
Ctrl Enter
⌃ Return
Insert current date
Ctrl ;
⌃ ;
Insert current time
Ctrl Shift :
⌃ ⇧ :
Fill down from cell above
Ctrl D
⌃ D
Fill right from cell left
Ctrl R
⌃ R
Copy formula from cell above
Ctrl '
⌃ '
Copy value from cell above
Ctrl Shift "
⌃ ⇧ "
Add hyperlink
Ctrl K
⌘ K
Display AutoComplete list
Alt ↓
⌥ ↓
Flash fill
Ctrl E
Formatting
Format (almost) anything
Ctrl 1
⌘ 1
Display Format Cells with Font tab selected
Ctrl Shift F
⌃ ⇧ F
Apply or remove bold formatting
Ctrl B
⌘ B
Apply or remove italic formatting
Ctrl I
⌘ I
Apply or remove underscoring
Ctrl U
⌘ U
Apply or remove strikethrough formatting
Ctrl 5
⌘ ⇧ X
Add or remove the shadow font style
⌘ ⇧ W
Add or remove the outline font style
⌘ ⇧ D
Align center
Alt H A C
⌘ E
Align left
Alt H A L
⌘ L
Align right
Alt H A R
⌘ R
Indent
Alt H 6
⌃ ⌥ Tab
Remove indent
Alt H 5
⌃ ⌥ ⇧ Tab
Increase font size one step
Alt H F G
⌘ ⇧ >
Decrease font size one step
Alt H F K
⌘ ⇧ <
Number Formatting
Apply general format
Ctrl Shift ~
⌃ ⇧ ~
Apply currency format
Ctrl Shift $
⌃ ⇧ $
Apply percentage format
Ctrl Shift %
⌃ ⇧ %
Apply scientific format
Ctrl Shift ^
⌃ ⇧ ^
Apply date format
Ctrl Shift #
⌃ ⇧ #
Apply number format
Ctrl Shift !
⌃ ⇧ !
Borders
Add border outline
Ctrl Shift &
⌘ ⌥ 0
Add or remove border right
Alt R
⌘ ⌥ →
Add or remove border left
Alt L
⌘ ⌥ ←
Add or remove border top
Alt T
⌘ ⌥ ↑
Add or remove border bottom
Alt B
⌘ ⌥ ↓
Add or remove border upward diagonal
Alt D
Add or remove border horizontal interior
Alt H
Add or remove border vertical interior
Alt V
Remove borders
Ctrl Shift _
⌘ ⌥ _
Formulas
Toggle absolute and relative references
F4
⌘ T
Open the Insert Function Dialog Box
Shift F3
Fn ⇧ F3
Autosum selected cells
Alt =
⌘ ⇧ T
Toggle formulas on and off
Ctrl `
⌃ `
Insert function arguments
Ctrl Shift A
⌃ ⇧ A
Enter array formula
Ctrl Shift Enter
⌃ ⇧ Return
Calculate worksheets
F9
Fn F9
Calculate active worksheet
Shift F9
Fn ⇧ F9
Force calculate all worksheets
Ctrl Alt F9
Evaluate part of a formula
F9
Fn F9
Expand or collapse the formula bar
Ctrl Shift U
⌃ ⇧ U
Display function arguments dialog box
Ctrl A
⌃ A
Define name
Ctrl F3
Fn ⌃ F3
Define name using row and column labels
Ctrl Shift F3
Fn ⌃ ⇧ F3
Paste name into formula
F3
Accept function with autocomplete
Tab
↓ Tab
Grid Operations
Display Insert Dialog box
Ctrl Shift +
⌃ I
Insert rows
Ctrl Shift +
⌃ I
Insert columns
Ctrl Shift +
⌃ I
Display Delete dialog box
Ctrl -
⌃ -
Delete rows
Ctrl -
⌃ -
Delete columns
Ctrl -
⌃ -
Delete cells
Ctrl -
⌃ -
Delete contents of selected cells
Delete
Fn Delete
Hide columns
Ctrl 0
⌃ 0
Hide rows
Ctrl 9
⌃ 9
Unhide rows
Ctrl Shift 9
⌃ ⇧ 9
Unhide columns
Ctrl Shift 0
⌃ ⇧ 0
Group rows or columns
Alt Shift →
⌘ ⇧ K
Ungroup rows or columns
Alt Shift ←
⌘ ⇧ J
Open Group Dialog Box
Alt Shift →
⌘ ⇧ K
Open Ungroup Dialog Box
Alt Shift ←
⌘ ⇧ J
Hide or show outline symbols
Ctrl 8
⌃ 8
Pivot Tables
Select entire pivot table
Ctrl A
⌘ A
Toggle pivot table field checkbox
Space
Space
Group pivot table items
Alt Shift →
⌘ ⇧ K
Ungroup pivot table items
Alt Shift ←
⌘ ⇧ J
Hide pivot table item
Ctrl -
Ctrl -
Create pivot chart on same worksheet
Alt F1
Create pivot chart on new worksheet
F11
Fn F11
Open pivot table wizard
Alt D P
⌘ ⌥ P
Workbook
Insert new worksheet
Shift F11
fn ⇧ F11
Go to next worksheet
Ctrl PgDn
Fn ⌃ ↓
Go to previous worksheet
Ctrl PgUp
Fn ⌃ ↑
Move to next pane
F6
Fn F6
Move to previous pane
Shift F6
Fn ⇧ F6
Go to next workbook
Ctrl Tab
⌃ Tab
Go to previous workbook
Ctrl Shift Tab
⌃ ⇧ Tab
Minimize current workbook window
Ctrl F9
⌘ M
Maximize current workbook window
Ctrl F10
fn ⌃ F10
Select adjacent worksheets
Shift Click
⇧ Click
Select non-adjacent worksheets
Ctrl Click
⌘ Click
Toggle scroll lock
ScrLk
Fn ⇧ F14
Dialog boxes
Move to next control
Tab
Tab
Move to previous control
Shift Tab
⇧ Tab
Move to next tab
Ctrl Tab
⌃ Tab
Move to previous tab
Ctrl Shift Tab
⌃ ⇧ Tab
Accept and apply
Enter
Return
Check and uncheck box
Space
Space
Cancel and close the dialog box
Esc
Esc
Others
Open Spelling dialog box
F7
Fn F7
Open Thesaurus dialog box
Shift F7
Fn ⇧ F7
Open Macro dialog box
Alt F8
Fn ⌥ F8
Open VBA Editor
Alt F11
Fn ⌥ F11
Duplicate object
Ctrl D
⌘ D
Snap to grid
Alt
⌘
Hide or show objects
Ctrl 6
⌃ 6
Display Modify Cell Style dialog box
Alt '
⌘ ⇧ L
Display right-click menu
Shift F10
Fn ⇧ F10
Delete comment
Shift F10 D
fn Shift F10
Display control menu
Alt Space
?