MacOSShortcutsWindows

252 Excel Shortcut keys for Windows & Mac

List of Excel Shortcut keys

Learn Excel Shortcut keys for Windows & Mac

Most used Excel Shortcut keys

Action Excel Shortcuts Windows Excel Shortcuts Mac
Copy selected cells Ctrl + C Command + C
Paste content from the clipboard Ctrl + V Command + V
Cut selected cells Ctrl + X Command + X
Undo the last action Ctrl + Z Command + Z
Redo the last action Ctrl + Y Command + Y
Repeat the last action F4 F4
Paste Special dialog box Ctrl + Alt + V Command + Option + V
Find and Replace Ctrl + F Command + F
Replace selected Ctrl + H Command + H
Find the previous match Ctrl + Shift + F4 Command + Shift + F4
Find next match Shift + F4 Shift + F4
Create embedded chart Alt + F1 Option + F1
Create a chart in the new worksheet F11 F11
Open Options Alt, F, T Option, F, T
Open help F1 F1
Expand or collapse the ribbon Ctrl + F1 Command + F1
Activate access keys Alt Option
Move to the next ribbon control Tab Tab
Activate or open selected control Spacebar Spacebar
Confirm control change Enter Return
Get help on selected control F1 F1
Open spelling dialog box F7 F7
Open Thesaurus dialog box Shift + F7 Shift + F7
Open Macro dialog box Alt + F8 Option + F8
Open VBA Editor Alt + F11 Option + F11
Duplicate object Ctrl + D Command + D
Snap to grid Alt Option
Hide or show objects Ctrl + F6 Command + F6
Display modify cell style dialog box Alt + ‘ Option + ‘
Display right-click menu Shift + F10 Shift + F10
Delete comment Shift + F10, D Shift + F10, D
Display control menu Alt + Spacebar Option + Spacebar

File Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Create New Workbook Ctrl + N Command + N
Open workbook Ctrl + O Command + O
Save workbook Ctrl + S Command + S
Save as F12 F12
Print file Ctrl + P Command + P
Open print preview window Ctrl + F2 Command + F2
Close current workbook Ctrl + F4 Command + F4
Close Excel Alt + F4 Option + F4

Text Formatting Shortcuts

Action Excel Shortcut keys Windows Excel Shortcut keys Mac
Apply or remove bold formatting Ctrl + B Command + B
Apply or remove italic formatting Ctrl + I Command + I
Apply or Remove underscoring Ctrl + U Command + U
Apply or remove strikethrough formatting Ctrl + 5 Command + 5
Align center Alt, H, A, C Option, H, A, C
Align left Alt, H, A, L Option, H, A, L
Align right Alt, H, A, R Option, H, A, R
Indent Alt, H, 6 Option, H, 6
Remove indent Alt, H, 5 Option, H, 5
Increase font size one step Alt, F, FG Option, F, FG
Decrease font size one step Alt, H, FK Option, H, FK
Format Cells Ctrl + 1 Command + 1
Display Format cells with font tab selected Ctrl + Shift + F Command + Shift + F

Number Formatting Shortcuts

Action Windows Shortcuts Mac Shortcuts
Apply general format Ctrl + Shift + ~ Command + Shift + ~
Apply currency format Ctrl + Shift + $ Command + Shift + $
Apply percentage format Ctrl + Shift + % Command + Shift + %
Apply scientific format Ctrl + Shift + ^ Command + Shift + ^
Apply date format Ctrl + Shift + # Command + Shift + #
Apply time format Ctrl + Shift + @ Command + Shift + @
Apply number format Ctrl + Shift + ! Command + Shift + !

Filter Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Activate filter Alt + Down Arrow key Option + Down Arrow key
Toggle Autofilter Ctrl + Shift + L Command + Shift + L
Clear slicer filter Alt + C Option + C
Select the next item in the AutoFilter list Down Arrow key Down Arrow key
Select the previous item in the AutoFilter list Up Arrow key Up Arrow key
Close the AutoFilter list for the current column Alt + Up Arrow key Option + Up Arrow key
Select the first item in the AutoFilter list Home key Home key
Select the last item in the AutoFilter list End key End key

Active Cell Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Select active cell only Shift + Backspace Shift + Backspace
Show the active cell on the worksheet Ctrl + Backspace Command + Backspace
Move active cell clockwise in selection Ctrl + . Command + .
Move active cell down in the selection Enter Return
Move active cell up in the 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

Drag and Drop Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Drag and cut Drag Drag
Drag and Copy Ctrl + Drag Command + Drag
Drag and insert Shift + Drag Shift + Drag
Drag and insert copy Ctrl + Shift + Drag Command + Shift + Drag
Drag to worksheet Alt + Drag Option + Drag
Drag to duplicate worksheet Ctrl + Drag Command + Drag

Cell Borders Shortcuts

Action Windows Shortcuts Mac Shortcuts
Add or remove border-right Alt, H, B, R Option, H, B, R
Add or remove border-left Alt, H, B, L Option, H, B, L
Add or remove border top Alt, H, B, T Option, H, B, T
Add or remove border-bottom Alt, H, B, B Option, H, B, B
Add or remove border upward diagonal Alt, H, B, D Option, H, B, D
Add or remove border horizontal interior Alt, H, B, H Option, H, B, H
Add or remove border vertical interior Alt, H, B, V Option, H, B, V
Add border outline Ctrl + Shift + & Command + Shift + &
Remove borders Ctrl + Shift + _ Command + Shift + _

Data Entering Shortcuts

Action Windows Shortcuts Mac Shortcuts
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 the same cell Ctrl + Enter Command + Return
Enter same data in multiple cells Ctrl + Enter Command + Return
Insert current date Ctrl + ; Command + ;
Insert current time Ctrl + Shift + : Command + Shift + :
Fill down from cell above Ctrl + D Command + D
Fill right from cell left Ctrl + R Command + R
Copy formula from the cell above Ctrl + ` Command + `
Copy value from the cell above Ctrl + Shift + “ Command + Shift + “
Add hyperlink Ctrl + K Command + K
Display AutoComplete list Alt + Down Arrow key Option + Down Arrow key
Flash Fill Ctrl + E Command + E

Cell Edit Mode Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Edit the active cell F2 F2
Insert or edit comment Shift + F2 Shift + F2
Cancel entry Esc Esc
Select one character right Shift + Right Arrow key Shift + Right Arrow key
Select one character left Shift + Left Arrow key Shift + Left Arrow key
Move one word right Ctrl + Right Arrow key Command + Right Arrow key
Move one word left Ctrl + Left Arrow key Command + Left Arrow key
Select one word right Ctrl + Shift + Right Arrow key Command + Shift + Right Arrow key
Select one word left Ctrl + Shift + Left Arrow key Command + Shift + Left Arrow key
Select to the beginning of the cell Shift + Home Shift + Home
Select to end of the cell Shift + End Shift + End
Delete to end of line Ctrl + Delete Command + Delete
Delete the character to the left of the cursor Backspace Backspace
Delete the character to the right of the cursor Delete Delete
Start a new line in the same cell Alt + Enter Option + Return

Dialog boxes Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Move to the next control Tab Tab
Move to the previous control Shift + Tab Shift + Tab
Move to the next tab Ctrl + Tab Command + Tab
Move to the previous tab Ctrl + Shift + Tab Command + Shift + Tab
Accept and apply Enter Return
Check and uncheck the box Spacebar Spacebar
Cancel and close the dialogue box Esc Esc

Navigation Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Move one cell right Right Arrow key Right Arrow key
Move one cell left Left Arrow key Left Arrow key
Move one cell up Up Arrow key Up Arrow key
Move one cell down Down Arrow key Down Arrow key
Move one screen right Alt + Page Down key Option + Page Down key
Move one screen left Alt + Page Up key Option + Page Up key
Move one screen up Page Up key Page Up key
Move one screen down Page Down key Page Down key
Move to the right edge of the data region Ctrl + Right Arrow key Command + Right Arrow key
Move to the left edge of the data region Ctrl + Left Arrow key Command + Left Arrow key
Move to the top edge of the data region Ctrl + Up Arrow key Command + Up Arrow key
Move to the bottom edge of the data region Ctrl + Down Arrow key Command + Down Arrow key
Move to begin of row Home key Home key
Move to the last cell in the worksheet Ctrl + End key Command + End key
Move to the first cell in the worksheet Ctrl + Home key Command + Home key
Turn End Mode on End key End key

Selection Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Select entire row Shift + Spacebar Shift + Spacebar
Select entire column Ctrl + Spacebar Command + Spacebar
Select entire worksheet Ctrl + A Command + A
Add adjacent cells to selection Shift + Click Shift + Click
Add non-adjacent cells to selection Ctrl + Click Command + Click
Move right between non-adjacent selections Ctrl + Alt + Right Arrow key Command + Option + Right Arrow key
Move left between non-adjacent selections Ctrl + Alt + Left Arrow key Command + Option + Left Arrow key
Toggle add to selection mode Shift + F8 Shift + F8
Cancel selection Esc Esc

Extend Selection Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Extend selection by one cell right Shift + Right Arrow key Shift + Right Arrow key
Extend selection by one cell left Shift + Left Arrow key Shift + Left Arrow key
Extend selection by one cell up Shift + Up Arrow key Shift + Up Arrow key
Extend selection by one cell down Shift + Down Arrow key Shift + Down Arrow key
Extend the selection to the last cell right Ctrl + Shift + Right Arrow key Command + Shift + Right Arrow key
Extend the selection to the last cell left Ctrl + Shift + Left Arrow key Command + Shift + Left Arrow key
Extend the selection to the last cell up Ctrl + Shift + Up Arrow key Command + Shift + Up Arrow key
Extend the selection to the last cell down Ctrl + Shift + Down Arrow key Command + Shift + Down Arrow key
Extend selection up one screen Shift + Page Up key Shift + Page Up key
Extend selection down one screen Shift + Page Down key Shift + Page Down key
Extend selection right one screen Alt + Shift + Page Down key Option + Shift + Page Down key
Extend selection left one screen Alt + Shift + Page Up key Option + Shift + Page Up key
Extend selection to start of the row Shift + Home Shift + Home
Extend selection to End of row Shift + End Shift + End
Extend selection to the first cell in the worksheet Ctrl + Shift + Home Command + Shift + Home
Extend selection to last cell in the worksheet Ctrl + Shift + End Command + Shift + End
Toggle extend selection mode F8 F8

Grid Operations Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Insert rows Ctrl + + Command + +
Delete rows Ctrl + – Command + –
Insert columns Ctrl + + Command + +
Delete columns Ctrl + – Command + –
Display Insert dialogue box Ctrl + Shift + + Command + Shift + +
Display Delete dialogue box Ctrl + – Command + –
Hide columns Ctrl + 0 Command + 0
Unhide columns Ctrl + Shift + 0 Command + Shift + 0
Hide rows Ctrl + 9 Command + 9
Unhide rows Ctrl + Shift + 9 Command + Shift + 9
Group rows or columns Alt + Shift + Right Arrow key Option + Shift + Right Arrow key
Ungroup rows or columns Alt + Shift + Left Arrow key Option + Shift + Left Arrow key
Zoom in Ctrl + Alt + + Command + Option + +
Zoom out Ctrl + Alt + – Command + Option + –
Open group dialogue box Alt + Shift + Right Arrow key Option + Shift + Right Arrow key
Open Ungroup dialogue box Alt + Shift + Left Arrow key Option + Shift + Left Arrow key
Hide or show outline symbols Ctrl + 8 Command + 8
Delete cells Ctrl + – Command + –
Delete contents of selected cells Delete Delete

Workbook Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Insert new worksheet Shift + F11 Shift + F11
Go to the next worksheet Ctrl + Page Down key Command + Page Down key
Go to the previous worksheet Ctrl + Page Up key Command + Page Up key
Move to the next pane F6 F6
Move to the previous pane Shift + F6 Shift + F6
Go to the next workbook Ctrl + Tab Command + Tab
Go to the previous workbook Ctrl + Shift + Tab Command + Shift + Tab
Minimize current workbook window Ctrl + F9 Command + F9
Maximize current workbook window Ctrl + F10 Command + F10
Select adjacent worksheets Shift + Click Shift + Click
Select non-adjacent worksheets Ctrl + Click Command + Click
Toggle scroll lock Scr Lk Scr Lk
Toggle fullscreen Ctrl + Shift + F1 Command + Shift + F1

Pivot Table Shortcuts

Action Excel Shortcut keys Windows Excel Shortcut keys Mac
Select entire pivot tables Ctrl + A Command + A
Toggle pivot table field checkbox Spacebar Spacebar
Group pivot table items Alt + Shift + Right Arrow key Option + Shift + Right Arrow key
Ungroup pivot table items Alt + Shift + Left Arrow key Option + Shift + Left Arrow key
Hide pivot table item Ctrl + – Command + –
Create pivot chart on the same worksheet Alt + F1 Option + F1
Create pivot chart on the new worksheet F11 F11
Open pivot table wizard Alt, D, P Option, D, P

Excel Formulas Shortcuts

Action Excel Shortcut keys Windows Excel Shortcut keys Mac
Autosum selected cells Alt + = Option + =
Toggle formulas on and off Ctrl + ` Command + `
Insert function arguments Ctrl + Shift + A Command + Shift + A
Enter array formula Ctrl + Shift + Enter Command + Shift + Return
Calculate worksheets F9 F9
Calculate active worksheet Shift + F9 Shift + F9
Force calculate all worksheets Ctrl + Alt + F9 Command + Option + F9
Evaluate part of a formula F9 F9
Expand or collapse the formula bar Ctrl + Shift + U Command + Shift + U
Display function arguments dialogue box Ctrl + A Command + A
Define name Ctrl + F3 Command + F3
Define name using row and column labels Ctrl + Shift + F3 Command + Shift + F3
Paste name into a formula F3 F3
Accept function with autocomplete Tab Tab
Toggle absolute and relative references F4 F4
Open the Insert function dialogue box Shift + F3 Shift + F3

Excel Select Special Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Display Go To dialog box Ctrl + G Command + G
Select cells with comments Ctrl + Shift + O Command + Shift + O
Select current region around active cell Ctrl + Shift + * Command + Shift + *
Select current region Ctrl + A Command + A
Select current array Ctrl + / Command + /
Select row differences Ctrl + \ Command + \
Select column difference Ctrl + Shift + | Command + Shift + |
Select direct precedents Ctrl + [ Command + [
Select direct dependents Ctrl + ] Command + ]
Select all precedents Ctrl + Shift + { Command + Shift + {
Select all dependents Ctrl + Shift + } Command + Shift + }
Select visible cells only Alt + ; Option + ;

Table Shortcuts

Action Excel Shortcuts Windows Excel Shortcuts Mac
Insert table Ctrl + T Command + T
Select table row Shift + Spacebar Shift + Spacebar
Select table column Ctrl + Spacebar Command + Spacebar
Select table Ctrl + A Command + A
Toggle table total row Ctrl + Shift + T Command + Shift + T
Move to the next field which can be edited Tab Tab
Move to the previous field which can be edited Shift + Tab Shift + Tab
Move to the first field in the next record Enter Return
Move to the first field in the previous record Shift + Enter Shift + Return
Move to the same field 10 records forward Page Down key Page Down key
Move to the same field 10 records back Page Up key Page Up key
Move to a new record Ctrl + Page Down key Command + Page Down key
Move to a first record Ctrl + Page Up key Command + Page Up key
Move to the beginning of a field Home key Home key
Move to the end of a field End key End key

Download Excel Shortcut keys PDF for Windows & Mac

Download Excel Shortcut keys PDF

READ NEXT:

Related Articles

Leave a Reply

Your email address will not be published.

Back to top button