Excel Keyboard Shortcuts

Keyboard shortcuts listed in this topic refer to the U.S. keyboard layout. Keys on other keyboard layouts might not correspond to the keys on a U.S. keyboard. Keyboard shortcuts for laptop computers might also differ.

Some function key shortcuts conflict with default key assignments in Mac OS X version 10.3 or later. To use them, you must change the settings for your function keys. On the Apple menu, go to System Preferences. Under Hardware, click Keyboard > Keyboard and then check Use all F1, F2, etc. as standard function keys.

Custom Keyboard Shortcuts: In the Mac versions of Excel, you have to go to the Tools menu (it may be under File and then Options depending on the Excel version) and then select Customize Keyboard there to create these shortcuts. These shortcuts work the same way mechanically as on Windows, but the dialog box to create them looks different and you have to access that dialog box differently.

Tip: To quickly find your search term on this page, press Ctrl F or F (Mac) and use the find bar.

Action Windows Mac
General
Open help F1 /
Undo last action Ctrl Z Z
Redo last action Ctrl Y 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 Control V
Display find and replace Ctrl F F
Display find and replace, replace selected Ctrl H Control H
Find next match Shift F4 G
Find previous match Ctrl Shift F4 Shift G
Create embedded chart Alt F1 Fn Option F1
Create chart in new worksheet F11 Fn F11
Toggle Autofilter Ctrl Shift L Shift F
Activate filter Alt Option
Insert table Ctrl T Control T
Select table row Shift Space Bar Shift Space Bar
Select table column Ctrl Space Bar Control Space Bar
Select table Ctrl A A
File
Create new workbook Ctrl N N
Open workbook Ctrl O O
Save workbook Ctrl S S
Save as F12 Shift S
Print file Ctrl P P
Open print preview window Ctrl F2
Close current workbook Ctrl F4 W
Close Excel Alt F4 Q
Ribbon
Expand or collapse ribbon Ctrl F1 Option R
Activate access keys Alt
Move to next ribbon control Tab Tab
Activate or open selected control Space Bar Space Bar
Confirm control change Enter Return
Get help on selected control F1
Drag and Drop
Drag and cut drag drag
Drag and copy Ctrl drag Option drag
Drag and insert Shift drag Shift drag
Drag and insert copy Ctrl Shift drag Option Shift drag
Drag to worksheet Alt drag drag
Drag to duplicate worksheet Ctrl drag Option drag
Move one cell right
Move one cell left
Move one cell up
Move one cell down
Move one screen right Alt PgDn Fn Option
Move one screen left Alt PgUp Fn Option
Move one screen up PgUp Fn
Move one screen down PgDn Fn
Move to right edge of data region Ctrl Control
Move to left edge of data region Ctrl Control
Move to top edge of data region Ctrl Control
Move to bottom edge of data region Ctrl Control
Move to beginning of row Home Fn
Move to last cell in worksheet Ctrl End Fn Control
Move to first cell in worksheet Ctrl Home Fn Control
Turn End mode on End Fn
Selection
Select entire row Shift Space Bar Shift Space Bar
Select entire column Ctrl Space Bar Control Space Bar
Select entire worksheet Ctrl A A
Add non-adjacent cells to selection Ctrl Click Control Click
Move right between non-adjacent selections Ctrl Alt Control Option
Move left between non-adjacent selections Ctrl Alt Control Option
Toggle add to selection mode Shift F8 Fn Shift F8
Cancel selection Esc Esc
Extend Selection
Extend selection by one cell right Shift Shift
Extend selection by one cell left Shift Shift
Extend selection by one cell up Shift Shift
Extend selection by one cell down Shift Shift
Extend the selection to the last cell right Ctrl Shift Control Shift
Extend the selection to the last cell left Ctrl Shift Control Shift
Extend the selection to the last cell up Ctrl Shift Control Shift
Extend the selection to the last cell down Ctrl Shift Control Shift
Extend selection up one screen Shift PgUp Fn Shift
Extend selection down one screen Shift PgDn Fn Shift
Extend selection to start of row Shift Home Fn Shift
Extend selection to first cell in worksheet Ctrl Shift Home Fn Control Shift
Extend selection to last cell in worksheet Ctrl Shift End Fn Control Shift
Toggle extend selection mode F8 Fn F8
Active Cell
Select active cell only Shift Backspace Shift Delete
Show the active cell on worksheet Ctrl Backspace Delete
Move active cell clockwise in selection Ctrl . Control .
Move active cell down in selection Enter Return
Move active cell up in selection Shift Enter Shift Return
Move active cell right in a selection Tab Tab
Move active cell left in a selection Shift Tab Shift Tab
Select Special
Display ‘Go To’ dialog box Ctrl G Control G
Select cells with comments Ctrl Shift O Fn Control Shift O
Select current region around active cell Ctrl Shift * Control Shift Space Bar
Select current region Ctrl A A
Select current array Ctrl / Control /
Select row differences Ctrl \ Control \
Select column differences Ctrl Shift | Control Shift |
Select direct precedents Ctrl [ Control [
Select all precedents Ctrl Shift { Control Shift {
Select direct dependents Ctrl ] Control ]
Select all dependents Ctrl Shift } Control Shift }
Select visible cells only Alt ; Shift Z
Cell Edit Mode
Edit the active cell F2 Control U
Insert or edit comment Shift F2 Shift F2
Cancel entry Esc Esc
Select one character right Shift Shift
Select one character left Shift Shift
Move one word right Ctrl Control
Move one word left Ctrl Control
Select one word right Ctrl Shift Control Shift
Select one word left Ctrl Shift Control Shift
Select to beginning of cell Shift Home Fn Shift
Select to end of cell Shift End Fn Shift
Delete to end of line Ctrl Delete Control 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 Control Option Return
Entering Data
Enter and move down Enter Return
Enter and move up Shift Enter Shift Return
Enter and move right Tab Tab
Enter and move left Shift Tab Shift Tab
Complete entry and stay in same cell Ctrl Enter Control Return
Enter same data in multiple cells Ctrl Enter Control Return
Insert current date Ctrl ; Control ;
Insert current time Ctrl Shift : Control Shift :
Fill down from cell above Ctrl D Control D
Fill right from cell left Ctrl R Control R
Copy formula from cell above Ctrl ` Control `
Copy value from cell above Ctrl Shift " Control Shift "
Add hyperlink Ctrl K K
Display AutoComplete list Alt Option
Formatting
Format (almost) anything Ctrl 1 1
Display Format Cells with Font tab selected Ctrl Shift F
Apply format again F4 Control Y
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 Shift X
Add or remove the shadow font style Shift W
Add or remove the outline font style Shift D
Align center Alt H A C E
Align left Alt H A L L
Align right Alt H A R R
Indent M
Remove indent Shift M
Increase font size one step Shift >
Decrease font size one step Shift <
Number Formatting
Apply general format Ctrl Shift ~ Control Shift ~
Apply currency format Ctrl Shift $ Control Shift $
Apply percentage format Ctrl Shift % Control Shift %
Apply scientific format Ctrl Shift ^ Control Shift ^
Apply date format Ctrl Shift # Control Shift #
Apply time format Ctrl Shift @ Control Shift @
Apply number format Ctrl Shift ! Control Shift !
Borders
Add border outline Ctrl Shift & Option 0
Add or remove border right Alt R Option
Add or remove border left Alt L Option
Add or remove border top Alt T Option
Add or remove border bottom Alt B Option
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 _ Option _
Formulas
Toggle absolute and relative references F4 T
Open the Insert Function Dialog Box Shift F3 Fn Shift F3
Autosum selected cells Alt = Shift T
Toggle formulas on and off Ctrl ` Control `
Insert function arguments Ctrl Shift A Control Shift A
Enter array formula Ctrl Shift Enter Control Shift Return
Calculate worksheets F9 F9
Calculate active worksheet Shift F9 Fn Shift 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 Control Shift U
Display function arguments dialog box Ctrl A Control A
Name Manager Ctrl F3 Control L
Define name using row and column labels Ctrl Shift F3 Control Shift F3
Paste name into formula F3
Accept function with autocomplete Tab Tab
Pivot Tables
Select entire pivot table Ctrl A A
Toggle pivot table field checkbox Space Bar Space Bar
Group pivot table items Alt Shift Shift K
Ungroup pivot table items Alt Shift 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
Workbook
Insert new worksheet Shift F11 Shift F11
Go to next worksheet Ctrl PgDn Fn Control
Go to previous worksheet Ctrl PgUp Fn Control
Move to next pane F6 F6
Move to previous pane Shift F6 Shift F6
Go to next workbook Ctrl Tab Control Tab
Go to previous workbook Ctrl Shift Tab Control Shift Tab
Display control menu Alt Space Bar
Minimize current workbook window Ctrl F9 M
Maximize current workbook window Ctrl F10
Dialog Boxes
Move to next control Tab Tab
Move to previous control Shift Tab Shift Tab
Move to next tab Ctrl Tab Control Tab
Move to previous tab Ctrl Shift Tab Control Shift Tab
Accept and apply Enter Return
Check and uncheck box Space Bar Space Bar
Cancel and close the dialog box Esc Esc
Grid Operations
Display Insert Dialog box Ctrl Shift + Control I
Insert rows Ctrl Shift + Control I
Insert columns Ctrl Shift + Control I
Display Delete dialog box Ctrl - Control -
Delete rows Ctrl - Control -
Delete columns Ctrl - Control -
Delete cells Ctrl - Control -
Delete contents of selected cells Delete Fn Delete
Hide columns Ctrl 0 Control 0
Hide rows Ctrl 9 Control 9
Unhide rows Ctrl Shift 9 Control Shift 9
Unhide columns Ctrl Shift 0 Control Shift 0
Group rows or columns Alt Shift Shift K
Ungroup rows or columns Alt Shift Shift J
Open Group Dialog Box Alt Shift Shift K
Open Ungroup Dialog Box Alt Shift Shift J
Hide or show outline symbols Ctrl 8 Control 8
VBA Editor
Help F1
Object Browser F2
Find F3
Properies Window F4
Run F5
Switch Split Windows F6
Goto Window Of Object F7
Step F8
Breakpoint F9
Activate Menu Bar F10
Toggle Insert Mode Insert
Delete Delete
Beginning Of Line Home
End Of Line End
Page Up PgUp
Page Down PgDn
Left
Right
Up
Down
Indent Tab
New Line Enter
Delete Prev Char BackSpace
Procedure Definition Shift F2
Find Prev Shift F3
Find Next Shift F4
Procedure Step Shift F8
Quick Watch Shift F9
Show Right Click Menu Shift F10
Paste Shift Insert
Select To Start Of Line Shift Home
Select To End Of Line Shift End
Select To Top Of Module Shift PgUp
Select To End Of Module Shift PgDn
Extend Selection Left 1 Char Shift
Extend Selection Right 1 Char Shift
Extend Selection Up Shift
Extend Selection Down Shift
Un-indent Shift Tab
Focus To Object Box Ctrl F2
Close Window Ctrl F4
Run To Cursor Ctrl F8
Activate Menu Bar Ctrl F10
Select All Text Ctrl B
Copy Ctrl C
Export Module Ctrl E
Find Ctrl F
Immediate Window Ctrl G
Replace Ctrl H
Turn On Quick Info Ctrl I
List Members Ctrl J
Show Call Stack Ctrl L
Import File Ctrl M
New Line Ctrl N
Print Ctrl P
Project Window Ctrl R
Save Ctrl S
Show Available Components Ctrl T
Paste Ctrl V
Cut Ctrl X
Cut Entire Line Ctrl Y
Undo Ctrl Z
Copy Ctrl Insert
Delete To End Of Word Ctrl Delete
Top Of Module Ctrl Home
End Of Module Ctrl End
Top Of Current Procedure Ctrl Page Up
End Of Current Procedure Ctrl Page Down
Left Word Ctrl Left Arrow
Right Word Ctrl Right Arrow
Previous Procedure Ctrl Up Arrow
Next Procedure Ctrl Down Arrow
Turn On Complete Word Ctrl Space Bar
Cycle Windows Ctrl Tab
Delete To Start Of Word Ctrl BackSpace
Close VBE Alt F4
Run Error Handler Alt F5
Switch Between Last 2 Windows Alt F6
Step Error Handler Alt F7
Return To Application Alt F11
Add-Ins Menu Alt A
Debug Menu Alt D
Edit Menu Alt E
File Menu Alt F
Help Menu Alt H
Insert Menu Alt J
Format Menu Alt O
Close & Return Alt Q
Run Menu Alt R
Tools Menu Alt T
View Menu Alt V
Window Menu Alt W
System Menu Alt Space Bar
Cycle Applications Alt Tab
Undo Alt BackSpace
Previous Position Ctrl Shift F2
Clear All Breakpoints Ctrl Shift F9
Turn On Param Info Ctrl Shift I
Turn On List Properties Ctrl Shift J
Other
Open Spelling dialog box F7 F7
Open Thesaurus dialog box Shift F7 Shift F7
Open Macro dialog box Alt F8 Fn Option F8
Open VBA Editor Alt F11 Fn Option F11
Duplicate object Ctrl D D
Snap to grid Alt
Hide or show objects Ctrl 6 Control 6
Display Modify Cell Style dialog box Alt ' Shift L