252 Microsoft Excel Shortcut keys

for Windows & MacOS

0 515 14 minutes read

Instead of accessing the toolbar with a mouse, you can perform significant functions using the Excel Shortcut keys. Excel Shortcut keys will be used by big companies, small firms, school and college students, etc. Excel Shortcut keys will help you to record and analyze the data, perform mathematical operations, visualize charts and graphs, etc.

Download Excel Shortcut keys PDF

There is no denying that the list of Excel Shortcut keys is pretty too long and by no means will you be able to remember them. However, in order to become an Excel master you must know each and every bit of Excel and its shortcuts. Hence a PDF format of Excel Shortcut keys is available for download.

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 a 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 the spelling dialog box	F7	F7
Open the Thesaurus dialog box	Shift + F7	Shift + F7
Open the 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

Read More: 46 CATIA V5 Shortcuts for Windows

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

These shortcuts allow you to format cells and data within your worksheets, such as bolding, italicizing, or underlining text, or opening the Format Cells dialog box. Examples include Ctrl + B (bold), Ctrl + I (italicize), Ctrl + U (underline), and Ctrl + 1 (Format Cells).

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	Excel Shortcuts Windows	Excel Shortcuts Mac
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 cells down in the selection	Enter	Return
Move active cells up in the selection	Shift + Enter	Shift + Return
Move active cells right in a selection	Tab	Tab
Move active cells 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	Excel Shortcuts Windows	Excel Shortcuts Mac
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 the 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 the border upward diagonal	Alt, H, B, D	Option, H, B, D
Add or remove the 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 + _

Read More: 80 Apple Numbers Shortcuts for Mac

Data Entering Shortcuts

Action	Excel Shortcuts Windows	Excel Shortcuts Mac
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 the same data in multiple cells	Ctrl + Enter	Command + Return
Insert current date	Ctrl + ;	Command + ;
Insert current time	Ctrl + Shift + :	Command + Shift + :
Fill down from the cell above	Ctrl + D	Command + D
Fill right from cell left	Ctrl + R	Command + R
Copy the 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 the 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 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

These shortcuts allow you to move around the Excel interface and within and between worksheets, such as moving to the next sheet or returning to the previous sheet. Examples include the arrow keys, Page Up and Page Down, and the Ctrl + G (go to) shortcut.

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 beginning of the 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 the selection	Shift + Click	Shift + Click
Add non-adjacent cells to the 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 the 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 the 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 the 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 a pivot chart on the same worksheet	Alt + F1	Option + F1
Create a pivot chart on the new worksheet	F11	F11
Open pivot table wizard	Alt, D, P	Option, D, P

Excel Formulas Shortcuts

These shortcuts allow you to enter and manipulate data within your worksheets, such as entering the same data in multiple cells at once, inserting the SUM function, or entering the current date or time. Examples include Ctrl + Enter (enter same data in multiple cells), Ctrl + Shift + = (insert SUM function), and Ctrl + ; (enter current date).

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 calculates 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 the 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 the current region around the 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

Microsoft Excel is one of the many data analytical tools available in the market. Despite the various data analytical tools in the market, excel still is the go-to product when it comes to working with data. If you don’t have that kind of money to spend on a subscription, then you can look for a free alternative i.e. Google Sheets. Consider taking a look at the Google Sheet Shortcuts list.

FAQs

How do I view a list of all Excel shortcut keys?

In Excel, you can view a list of all shortcut keys by going to File > Options > Customize ribbon and then selecting the Keyboard shortcuts button at the bottom of the window.

Can I create my own custom shortcut keys in Excel?

Yes, you can create your own custom shortcut keys in Excel by going to File > Options > Customize ribbon and then selecting the Keyboard shortcuts button at the bottom of the window. From there, you can choose a command from the Categories list and then assign a shortcut key to it.

Can I use the same shortcut keys in both Windows and Mac versions of Excel?

Some shortcut keys are the same in both Windows and Mac versions of Excel, such as Ctrl + C (copy) and Ctrl + V (paste). However, some shortcuts are specific to either the Windows or Mac version, so it's a good idea to familiarize yourself with the shortcuts for both platforms.

READ NEXT: