Microsoft Excel Shortcuts

Cell editing shortcuts

Shortcut	Windows	Mac
Cancel entry	Esc	Esc
Delete character to the left of the cursor	Backspace	Delete
Delete character to the right of the cursor	Delete	Fn Delete
Delete to end of line	Ctrl Delete	Fn Control Delete
Edit the active cell	F2	Control U
Move one word to the left	Ctrl ←	Control ←
Move one word to the right	Ctrl →	Control →
Select one character to the left	Shift ←	⇧ ←
Select one character to the right	Shift →	⇧ →
Select one word to the left	Ctrl Shift ←	Control ⇧ ←
Select one word to the right	Ctrl Shift →	Control ⇧ →
Select to beginning of the cell	Shift Home	Fn ⇧ ←
Select to the end of cell	Shift End	Fn ⇧ →
Start new line in cell	Alt Enter	Control ⌥ Return

Cell formatting shortcuts

Shortcut	Windows	Mac
Align to the center	Alt HAC	⌘ E
Align to the left	Alt HAL	⌘ L
Align to the right	Alt HAR	⌘ R
Bold formatting	Ctrl B	⌘ B
Decrease font size	Alt HFK	⌘ ⇧ <
Display format cells with font the tab selected	Ctrl Shift F	Control ⇧ F
Format options	Ctrl 1	⌘ 1
Increase font size	Alt HFG	⌘ ⇧ >
Indent	Alt H6	Control ⌥ Tab
Italic formatting	Ctrl I	⌘ I
Remove indent	Alt H5	Control ⌥ ⇧ Tab
Strikethrough formatting	Ctrl 5	⌘ ⇧ X
Underline formatting	Ctrl U	⌘ U

Data entry shortcuts

Shortcut	Windows	Mac
Add a hyperlink	Ctrl K	⌘ K
Complete entry and stay in the same cell	Ctrl Enter	Control Return
Copy formula from the cell above	Ctrl ‘	⌘ ‘
Copy value from the cell above	Ctrl Shift “	Control ⇧ “
Display AutoComplete list	Alt ↓	⌥ ↓
Enter and move down	Enter	Return
Enter and move to the left	Shift Tab	⇧ Tab
Enter and move to the right	Tab	Tab
Enter and move up	Shift Enter	⇧ Return
Enter same data in multiple cells	Ctrl Enter	Control Return
Fill down from the cell above	Ctrl D	⌘ D
Fill right from the cell left	Ctrl R	⌘ R
Flash Fill	Ctrl E	Control E
Insert current date	Ctrl ;	Control ;
Insert current time	Ctrl Shift :	⌘ ;

Dragging shortcuts

Shortcut	Windows	Mac
Drag and copy	Ctrl drag	⌥ drag
Drag and cut	Drag	Drag
Drag and insert	Shift drag	⇧ drag
Drag and insert copy	Ctrl Shift drag	⌥ ⇧ drag
Drag to duplicate the worksheet	Ctrl drag	⌥ drag
Drag to the worksheet	Alt drag	⌘ drag

Extend selected cells

Shortcut	Windows	Mac
Extend selection down one screen	Shift PgDn	Fn ⇧ ↓
Extend selection left one screen	Alt Shift PgUp	Fn ⇧ ⌥ ↑
Extend selection mode	F8	Fn F8
Extend selection one cell down	Shift ↓	⇧ ↓
Extend selection one cell left	Shift ←	⇧ ←
Extend selection one cell right	Shift →	⇧ →
Extend selection one cell up	Shift ↑	⇧ ↑
Extend selection right by one screen	Alt Shift PgDn	Fn ⇧ ⌥ ↓
Extend selection to first cell in the worksheet	Ctrl Shift Home	Fn Control ⇧ ←
Extend selection to last cell in the worksheet	Ctrl Shift End	Fn Control ⇧ →
Extend selection to start of row	Shift Home	Fn ⇧ ←
Extend selection to the last cell down	Ctrl Shift ↓	⌘ ⇧ ↓
Extend selection to the last cell left	Ctrl Shift ←	⌘ ⇧ ←
Extend selection to the last cell right	Ctrl Shift →	⌘ ⇧ →
Extend selection to the last cell up	Ctrl Shift ↑	⌘ ⇧ ↑
Extend selection up one screen	Shift PgUp	Fn ⇧ ↑

Formula shortcuts

Shortcut	Windows	Mac
Absolute and relative references	F4	⌘ T
Accept function with autocomplete	Tab	Tab
AutoSum the selected cells	Alt =	⌘ ⇧ T
Calculate active the worksheet	Shift F9	Fn ⇧ F9
Calculate the worksheets	F9	Fn F9
Define name using row and column labels	Ctrl Shift F3	Fn Control ⇧ F3
Display function arguments options box	Ctrl A	Control A
Enter array formula	Ctrl Shift Enter	Control ⇧ Return
Evaluate part of a formula	F9	Fn F9
Expand or collapse the formula bar	Ctrl Shift U	Control ⇧ U
Force calculate all the worksheets	Ctrl Alt F9	NONE
Formulas on and off	Ctrl `	Control `
Insert function arguments	Ctrl Shift A	Control ⇧ A
Open the Insert Function options Box	Shift F3	Fn ⇧ F3
Open the Name Manager	Ctrl F3	Fn Control F3
Paste name into formula	F3	F3
Select name box	Alt F3	NONE

General shortcuts

Shortcut	Windows	Mac
Check spelling	F7	Fn F7
Copy the selected cells	Ctrl C	⌘ C
Create chart in new the worksheet	F11	Fn F11
Cut the selected cells	Ctrl X	⌘ X
Delete comment	Shift F10 D	Fn ⇧ F10
Display control menu	Alt Space	NONE
Display find and replace	Ctrl F	⌘ F
Display find and replace, replace selected	Ctrl H	Control H
Display Modify Cell Style dialog box	Alt ‘	⌘ ⇧ L
Display the Paste Special options	Ctrl Alt V	⌘ Control V
Duplicate object	Ctrl D	⌘ D
Expand or collapse the ribbon	Ctrl F1	⌘ ⌥ R
Find next match	Shift F4	⌘ G
Find previous match	Ctrl Shift F4	⌘ ⇧ G
Hide or show objects	Ctrl 6	Control 6
Insert embedded chart	Alt F1	Fn ⌥ F1
Insert or edit note	Shift F2	Fn ⇧ F2
Insert threaded comment	Ctrl Shift F2	Fn ⌘ ⇧ F2
Move active cell clockwise in selection	Ctrl .	Control .
Move active cell down in the selection	Enter	Return
Move active cell to the right in a selection	Tab	Tab
Move the active cell left in a selection	Shift Tab	⇧ Tab
Move the active cell up in selection	Shift Enter	⇧ Return
Open help	F1	⌘ /
Open Macro dialog box	Alt F8	Fn ⌥ F8
Open options	Alt FT	⌘ ,
Open Thesaurus dialog box	Shift F7	Fn ⇧ F7
Open VBA Editor	Alt F11	Fn ⌥ F11
Paste content from the clipboard	Ctrl V	⌘ V
Redo last action	Ctrl Y	⌘ Y
Repeat last action	F4	⌘ Y
Select the active cell only	Shift Backspace	⇧ Delete
Show the active cell on the worksheet	Ctrl Backspace	Control Delete
Show the right-click menu	Shift F10	Fn ⇧ F10
Snap to grid	Alt	⌘
Undo last action	Ctrl Z	⌘ Z

Gridline shortcuts

Shortcut	Windows	Mac
Delete cells	Ctrl –	⌘ –
Delete columns	Ctrl –	⌘ –
Delete contents of the selected cells	Delete	Fn Delete
Delete rows	Ctrl –	⌘ –
Display delete options box	Ctrl –	⌘ –
Display Insert options box	Ctrl Shift +	⌘ ⇧ +
Group rows or columns	Alt Shift →	⌘ ⇧ K
Hide columns	Ctrl 0	Control 0
Hide or show outline symbols	Ctrl 8	Control 8
Hide rows	Ctrl 9	Control 9
Insert columns	Ctrl Shift +	⌘ ⇧ +
Insert rows	Ctrl Shift +	⌘ ⇧ +
Open group options Box	Alt Shift →	⌘ ⇧ K
Open Ungroup options Box	Alt Shift ←	⌘ ⇧ J
Ungroup rows or columns	Alt Shift ←	⌘ ⇧ J
Unhide columns	Ctrl Shift 0	Control ⇧ 0
Unhide rows	Ctrl Shift 9	Control ⇧ 9
Zoom in	Ctrl Alt +	⌥ ⌘ +
Zoom out	Ctrl Alt –	⌥ ⌘ –
Zoom scroll	Ctrl scroll	Control Scroll

Navigation and selection shortcuts

Shortcut	Windows	Mac
Add adjacent cells to selection	Shift Click	⇧ Click
Add non-adjacent cells to selection	Ctrl Click	⌘ Click
Add to selection mode	Shift F8	Fn ⇧ F8
Cancel selection	Esc	Esc
Go back to hyperlink	Ctrl G Enter	Control G Return
Move left between non-adjacent selections	Ctrl Alt ←	Control ⌥ ←
Move one cell down	↓	↓
Move one cell left	←	←
Move one cell up	↑	↑
Move one screen down	PgDn	Fn ↓
Move one screen to the left	Alt PgUp	Fn ⌥ ↑
Move one screen to the right	Alt PgDn	Fn ⌥ ↓
Move one screen up	PgUp	Fn ↑
Move right between non-adjacent selections	Ctrl Alt →	Control ⌥ →
Move to beginning of row	Home	Fn ←
Move to bottom edge of data region	Ctrl ↓	⌘ ↓
Move to first cell in the worksheet	Ctrl Home	Fn Control ←
Move to last cell in the worksheet	Ctrl End	Fn Control →
Move to left edge of data	Ctrl ←	⌘ ←
Move to top edge of data region	Ctrl ↑	⌘ ↑
Navigate one cell to the right	→	→
Navigate to right edge of the data	Ctrl →	⌘ →
Select entire column	Ctrl Space	Control Space
Select entire row	Shift Space	⇧ Space
Select entire the worksheet	Ctrl A	⌘ A
Turn End mode on	End	Fn →

Number shortcuts

Shortcut	Windows	Mac
Apply the currency format	Ctrl Shift $	Control ⇧ $
Apply the date format	Ctrl Shift #	Control ⇧ #
Apply the general format	Ctrl Shift ~	Control ⇧ ~
Apply the number format	Ctrl Shift !	Control ⇧ !
Apply the percentage format	Ctrl Shift %	Control ⇧ %
Apply the scientific format	Ctrl Shift ^	Control ⇧ ^
Apply the time format	Ctrl Shift @	Control ⇧ @

PivotTable shortcuts

Shortcut	Windows	Mac
Create PivotChart on new the worksheet	F11	Fn F11
Group the PivotTable items	Alt Shift →	⌘ ⇧ K
Hide the PivotTable item	Ctrl –	Control –
Insert PivotChart on same worksheet	Alt F1	NONE
Open the PivotTable wizard	Alt DP	⌘ ⌥ P
PivotTable field checkbox	Space	Space
Select entire the PivotTable	Ctrl A	⌘ A
Ungroup the PivotTable items	Alt Shift ←	⌘ ⇧ J

Select special shortcuts

Shortcut	Windows	Mac
Display the ‘Go To’ box	Ctrl G	Control G
Select current array	Ctrl /	Control /
Select current region	Ctrl A	⌘ A
Select current region around active cell	Ctrl Shift *	Control ⇧ Space
Select direct dependents	Ctrl ]	Control ]
Select direct precedents	Ctrl [	Control [
Select row differences	Ctrl \	Control \
Select the visible cells only	Alt ;	⌘ ⇧ Z

Tables and filter shortcuts

Shortcut	Windows	Mac
Activate filter	Alt ↓	⌥ ↓
Filter	Ctrl Shift L	⌘ ⇧ F
Insert a table	Ctrl T	⌘ T
Table total row	Ctrl Shift T	Control ⇧ T

Workbook shortcuts

Shortcut	Windows	Mac
Close Excel	Alt F4	⌘ Q
Close the workbook	Ctrl W	⌘ W
Create a new workbook	Ctrl N	⌘ N
Full screen	Ctrl Shift F1	Control ⌘ F
Go to a previous workbook	Ctrl Shift Tab	⌘ ⇧ `
Go to next a workbook	Ctrl Tab	⌘ `
Go to the next worksheet	Ctrl PgDn	Fn Control ↓
Go to the previous worksheet	Ctrl PgUp	Fn Control ↑
Insert a new worksheet	Shift F11	Fn ⇧ F11
Maximize a current workbook window	Ctrl F10	Fn Control F10
Minimize a current workbook window	Ctrl F9	⌘ M
Move to previous pane	Shift F6	Fn ⇧ F6
Move to the next pane	F6	Fn F6
Open a workbook	Ctrl O	⌘ O
Print	Ctrl P	⌘ P
Print preview	Ctrl F2	NONE
Save a workbook	Ctrl S	⌘ S
Save as	F12	⌘ ⇧ S
Scroll lock	ScrLk	Fn ⇧ F14
Select non-adjacent the worksheets	Ctrl Click	⌘ Click
Select the adjacent worksheets	Shift Click	⇧ Click