DEV Community

Cover image for {230+} Excel SHORTCUTS List for Windows & MAC
Vigneshwaran Vijayakumar for Excel24x7

Posted on • Originally published at excel24x7.com

{230+} Excel SHORTCUTS List for Windows & MAC

In this tutorial, you’ll find a complete and updated list of Excel shortcuts to help you work more efficiently. From basic navigation to advanced data operations, this tutorial covers everything you need. It includes shortcuts for both Windows and Mac users. You can bookmark the page for quick access or download the PDF version of the shortcuts list.

File Options Shortcuts:

Options Windows Mac
How to Create a new workbook ctrl n ⌘ N
How to open a workbook ctrl o ⌘ o
How to save a workbook ctrl s ⌘ S
Save as Workbook F12 ⌘ ⇧S
How to print a file in Excel ctrl p ⌘ P
How to open a print preview window in Excel ctrl F12 Not Available
How to Close the current workbook ctrl F4 ⌘W
How to Close Excel ALT F4 ⌘ Q

Ribbon Options Shortcuts:

Options Windows Mac
How to Expand or collapse the ribbon ctrl F1 ⌘ ⌥ R
How to Activate access keys ALT Not Available
How to Move to next ribbon control Tab Tab
How to Activate or open selected control Space Space
How to Confirm control change Enter Return
How to Get help on the selected control F1 Not Available

General Options Shortcuts:

Options Windows Mac
How to open options in Excel ALT F T ⌘ ,
How to undo the last action in Excel ctrl z ⌘ Z
How to redo the last action in Excel ctrl y ⌘ Y
How to copy selected cells in Excel ctrl c ⌘ C
How to repeat the last action in Excel f4 ⌘ Y
How to cut selected cells in Excel ctrl X ⌘ X
How to paste content from clipboard in Excel ctrl v ⌘ V
How to display the paste special dialog box in Excel ctrl ALT V ⌘ ⌃ V
How to display find and replace in Excel ctrl f ⌘ F
How to display find and replace, replace selected in Excel ctrl h ⌃ H
How to Find the previous match in Excel ctrl shift f4 ⌘ ⇧ G
How to Find the next match in Excel Shift f4 ⌘ G
How to Create an embedded chart in Excel Alt f1 Fn ⌥ F1
How to Create a chart in a new worksheet in Excel f11 Fn F11

Table & Filters Options Shortcuts:

Options Windows Mac
How to insert a table in Excel ctrl t ⌃ T
How to toggle auto filter in Excel ctrl shift l ⌘ ⇧ F
How to activate filter in Excel Alt ↓ ⌥ ↓
How to select a table row in Excel shift space ⇧ Space
How to select the table column in Excel ctrl Space ⌃ Space
How to select a table in Excel ctrl a ⌘ A
How to clear the slicer filter in Excel alt c ⌥ C
How to toggle table total row in Excel ctrl shift t ⌘ ⇧ T

Drag & Drop Options Shortcuts:

Options Windows Mac
How to Drag and cut in Excel drag Drag
How to Drag and copy in Excel ctrl drag ⌥ Drag
How to Drag & Insert in Excel shift drag ⇧ Drag
How to Drag and insert copy in Excel ctrl shift drag ⌥ ⇧ Drag
How to Drag to a worksheet in Excel ctrl drag ⌥ Drag
How to Drag to duplicate worksheet in Excel alt drag ⌘ Drag

Navigation Options Shortcuts:

Options Windows Mac
How to Move one cell right in Excel
How to Move one cell left in Excel
How to Move one cell up in Excel
How to Move one cell down in Excel
How to Move one screen right in Excel alt Pg.Dn Fn ⌥↓
How to Move one screen left in Excel alt Pg.up Fn ⌥↑
How to Move one screen up in Excel PG.Up Fn ↑
How to Move one screen down in Excel PG.Dn Fn ↓
How to Move to the right edge of the data region in Excel Ctrl → ⌃ →
How to Move to the left edge of the data region in Excel Ctrl ← ⌃ ←
How to Move to the top edge of the data region in Excel Ctrl↑ ⌃ ↑
How to Move to the bottom edge of the data region in Excel Ctrl ↓ ⌃ ↓
How to Move to the beginning of a row in Excel Home Fn ←
How to Move to the last cell in a worksheet in Excel ctrlend Fn ⌃→
How to Move to the first cell in a worksheet in Excel ctrlHome Fn ⌃←
How to Turn End mode on in Excel End Fn →
How to Go back to hyperlink in Excel ctrlGEnter ⌃ GReturn

Selection Options Shortcuts:

Options Windows Mac
How to Select an entire row in Excel shiftspace ⇧Space
How to Select an entire column in Excel ctrlspace ⌃Space
How to Select entire worksheet in Excel ctrla ⌘A
How to Add adjacent cells to selection in Excel ShiftClick ⇧Click
How to Add non-adjacent cells to selection in Excel ctrlClick ⌘Click
How to Same selection in next column in Excel Nil ⌥Tab
How to Same selection in the previous column in Excel Nil ⌥⇧Tab
How to Move right between non-adjacent selections in Excel ctrlalt→ ⌃⌥→
How to Move left between non-adjacent selections in Excel ctrlalt← ⌃⌥←
How to Toggle add to selection mode in Excel shiftf8 Fn⇧F8
How to Cancel selection in Excel Esc Esc

Active Cell Options Shortcuts:

Options Windows Mac
How to Select an active cell only in Excel shiftBackspace ⇧Delete
How to Show the active cell on a worksheet in Excel ctrlBackspace ⌘Delete
How to Move active cell clockwise in selection in Excel ctrl. ⌃.
How to Move active cell down in selection in Excel Enter Return
How to Move active cell up in selection in Excel shiftenter ⇧Return
How to Move active cell right in a selection in Excel tab Tab
How to Move active cell left in a selection in Excel shifttab ⇧Tab

Extend Selection Options Shortcuts:

Options Windows Mac
How to Extend selection by one cell right in Excel shift→ ⇧→
How to Extend selection by one cell left in Excel shift← ⇧←
How to Extend selection by one cell up in Excel shift↑ ⇧↑
How to Extend selection by one cell down in Excel shift↓ ⇧↓
How to Extend the selection to the last cell right in Excel ctrlshift→ ⌃⇧→
How to Extend the selection to the last cell left in Excel ctrlshift← ⌃⇧←
How to Extend the selection to the last cell up in Excel ctrlshift↑ ⌃⇧↑
How to Extend the selection to the last cell down in Excel ctrlshift↓ ⌃⇧↓
How to Extend selection up one screen in Excel shiftpg.up Fn⇧↑
How to Extend selection down one screen in Excel shiftpg.dn Fn⇧↓
How to Extend selection right one screen in Excel altshiftpg.dn Fn⇧⌥↓
How to Extend selection left one screen in Excel altshiftpg.up Fn⇧⌥↑
How to Extend selection to start of the row in Excel shifthome Fn⇧←
How to Extend selection to the first cell in a worksheet in Excel ctrlshifthome Fn⌃⇧←
How to Extend selection to last cell in the worksheet in Excel ctrlshiftend Fn⌃⇧→
How to Toggle extend selection mode in Excel f8 FnF8

Select Special Options Shortcuts:

Options Windows Mac
How to Display ‘Go-To’ dialog box in Excel ctrlg ⌃G
How to Select cells with comments in Excel ctrlshifto Fn⌃⇧O
How to Select the current region around the active cell in Excel ctrlshift* ⇧⌃Space
How to Select the current region in Excel ctrla ⌘A
How to Select the current array in Excel ctrl/ ⌃/
How to Select row differences in Excel ctrl\ ⌃\
How to Select column differences in Excel ctrlshift\
How to Select direct precedents in Excel ctrl[ ⌃[
How to Select all precedents in Excel ctrlshift{ ⌃⇧{
How to Select direct dependents in Excel ctrl] ⌃]
How to Select all dependents in Excel ctrlshift} ⌃⇧}
How to Select visible cells only in Excel alt; ⌘⇧Z

Cell Edit Mode Options Shortcuts:

Options Windows Mac
How to Edit the active cell in Excel f2 ⌃U
How to Insert or edit the comment in Excel shiftf2 Fn⇧F2
How to Cancel entry in Excel Esc Esc
How to Select one character right in Excel shift→ ⇧→
How to Select one character left in Excel shift← ⇧←
How to Move one word right in Excel ctrl→ ⌃→
How to Move one word left in Excel ctrl← ⌃←
How to Select one word right in Excel ctrlshift→ ⌃⇧→
How to Select one word left in Excel ctrlshift← ⌃⇧←
How to Select to the beginning of a cell in Excel shiftHome Fn⇧←
How to Select to end of the cell in Excel shiftend Fn⇧→
How to Delete to end of a line in Excel ctrldelete ⌃Delete
How to Delete the character to the left of the cursor in Excel backspace Delete
How to Delete the character to the right of the cursor in Excel delete FnDelete
How to Start a new line in the same cell in Excel altenter ⌃⌥Return

Entering data Options Shortcuts:

Options Windows Mac
How to Enter and move down in Excel Enter Return
How to Enter and move right in Excel tab Tab
How to Enter and move left in Excel shifttab ⇧Tab
How to Complete entry and stay in the same cell in Excel ctrlEnter ⌃Return
How to Enter the same data in multiple cells in Excel ctrlEnter ⌃Return
How to Insert a current date in Excel ctrl; ⌃;
How to Insert current time in Excel ctrlshift: ⌘:
How to Fill down from cell above in Excel ctrlD ⌃D
How to Fill right from cell left in Excel ctrlr ⌃R
How to Copy a formula from the cell above in Excel ctrl‘ ⌃‘
How to Copy value from the cell above in Excel ctrlshift“ ⌃⇧“
How to Add hyperlink in Excel ctrlk ⌘K
How to Display AutoComplete list in Excel alt↓ ⌥↓
How to Flash fill in Excel ctrle Not Available

Formatting Options Shortcuts:

Options Windows Mac
How to Format anything in Excel ctrl1 ⌘1
How to Display Format Cells with Font tab selected in Excel ctrlshiftF ⌃⇧F
How to Apply or remove bold formatting in Excel ctrlb ⌘B
How to Apply or remove italic formatting in Excel ctrlI ⌘I
How to Apply or remove underscoring in Excel ctrlu ⌘U
How to Apply or remove strikethrough formatting in Excel ctrl5 ⌘⇧X
How to Add or remove the shadow font style in Excel Nil ⌘⇧W
How to Add or remove the outline font style in Excel Nil ⌘⇧D
How to Align center in Excel althac ⌘E
How to Align left in Excel althal ⌘L
How to Align right in Excel althar ⌘R
How to Indent in Excel alth6 ⌃⌥Tab
How to Remove indent in Excel alth5 ⌃⌥⇧Tab
How to Increase font size one step in Excel althFG ⌘⇧>
How to Decrease font size one step in Excel althFk ⌘⇧<

Number Formatting Options Shortcuts:

Options Windows Mac
How to Apply general format in Excel CTRLSHIFT~ ⌃⇧~
How to Apply currency format in Excel CTRLSHIFT$ ⌃⇧$
How to Apply percentage format in Excel CTRLSHIFT% ⌃⇧%
How to Apply scientific format in Excel CTRLSHIFT^ ⌃⇧^
How to Apply date format in Excel CTRLSHIFT# ⌃⇧#
How to Apply time format in Excel CTRLSHIFT@ ⌃⇧@
How to Apply number format in Excel CTRLSHIFT! ⌃⇧!
How to Show the active cell on a worksheet in Excel CTRLBACKSPACE ⌘DELETE
How to Move active cell clockwise in selection in Excel CTRL. ⌃.
How to Move active cell down in selection in Excel ENTER RETURN
How to Move active cell up in selection in Excel SHIFTENTER ⇧RETURN
How to Move active cell right in a selection in Excel TAB TAB
How to Move active cell left in a selection in Excel SHIFTTAB ⇧TAB

Border Options Shortcuts:

Options Windows Mac
How to Add border outline in Excel ctrlshift& ⌘⌥0
How to Add or remove border right in Excel altr ⌘⌥→
How to Add or remove border-left in Excel altl ⌘⌥←
How to Add or remove border-top in Excel altt ⌘⌥↑
How to Add or remove border-bottom in Excel altb ⌘⌥↓
How to Add or remove border upward diagonal in Excel altd Not Available
How to Add or remove border horizontal interior in Excel alth Not Available
How to Add or remove border vertical interior in Excel altv Not Available
How to Remove borders in Excel ctrlshift_ ⌘⌥_

Formula Options Shortcuts:

Options Windows Mac
How to Toggle absolute and relative references in Excel f4 ⌘ T
How to Open the Insert Function Dialog Box in Excel shift f3 Fn ⇧F3
How to Autosum selected cells in Excel alt = ⌘ ⇧T
How to Toggle formulas on and off in Excel ctrl ` ⌃ `
How to Insert function arguments in Excel ctrl
shift
a
⌃ ⇧A
How to Enter array formula in Excel ctrl
shift
Enter
⌃ ⇧Return
How to Calculate worksheets in Excel f9 Fn F9
How to Calculate active worksheet in Excel shift
f9
Fn ⇧F9
How to Force calculate all worksheets in Excel ctrl
alt
f9
Not Available
How to Evaluate part of a formula in Excel f9 Fn F9
How to Expand or collapse the formula bar in Excel ctrl
shift
u
⌃ ⇧U
How to Display function arguments dialog box in Excel ctrl
a
⌃ A
How to Define a name in Excel ctrl
f3
Fn ⌃F3
How to Define name using row and column labels in Excel ctrl
shift
f3
Fn⌃⇧F3
How to Paste name into a formula in Excel f3 Not Available
How to Accept function with autocomplete in Excel tab ↓ Tab

Grid Options Shortcuts:

Options Windows Mac
How to Display Insert Dialog box in Excel ctrlshift+ ⌘ ⇧+
How to Insert rows in Excel ctrlshift+ ⌘ ⇧+
How to Insert columns in Excel ctrlshift+ ⌘ ⇧+
How to Display Delete dialog box in Excel ctrl – ⌘ –
How to Delete rows in Excel ctrl – ⌘ –
How to Delete columns in Excel ctrl – ⌘ –
How to Delete cells in Excel ctrl – ⌘ –
How to Delete the contents of selected cells in Excel Delete Fn Delete
How to Hide columns in Excel ctrl 0 ⌃ 0
How to Hide rows in Excel ctrl 9 ⌃ 9
How to Unhide rows in Excel ctrl shift 9 ⌃ ⇧9
How to Unhide Columns in Excel ctrl shift 0 ⌃ ⇧0
How to Group rows or columns in Excel alt shift → ⌘ ⇧K
How to Ungroup rows or columns in Excel alt shift ← ⌘ ⇧J
How to Open Group Dialog Box in Excel alt shift → ⌘ ⇧K
How to Open Ungroup Dialog Box in Excel alt shift ← ⌘ ⇧J
How to Hide or Show outline symbols in Excel ctrl 8 ⌃ 8
How to Zoom in in Excel ctrl alt + ⌥ ⌘+
How to Zoom out in Excel ctrl alt – ⌥ ⌘–

Pivot Tables Options Shortcuts:

Options Windows Mac
How to Select the entire pivot table in Excel ctrl a ⌘ A
How to Toggle pivot table field checkbox in Excel space Space
How to Group pivot table items in Excel alt shift → ⌘ ⇧K
How to Ungroup pivot table items in Excel alt shift ← ⌘ ⇧J
How to Hide pivot table item in Excel ctrl – Ctrl –
How to Create a pivot chart on the same worksheet in Excel alt f1 Not Available
How to Create a pivot chart on a new worksheet in Excel f11 Fn F11
How to Create a pivot chart on a new worksheet in Excel alt d p ⌘ ⌥P

Workbook Options Shortcuts:

How to Insert new worksheet in Excel Shiftf11 Fn ⇧F11
How to Go to next worksheet in Excel ctrl pg.dn Fn ⌃↓
How to Go to the previous worksheet in Excel ctrl pg.up Fn ⌃↑
How to Move to next pane in Excel shiftf6 Fn ⇧F6
How to Go to next workbook in Excel ctrl tab ⌃ Tab
How to Go to the previous workbook in Excel ctrl shift tab ⌃ ⇧Tab
How to Minimize the current workbook window in Excel ctrl f9 ⌘M
How to Maximize the current workbook window in Excel ctrl f10 Fn ⌃F10
How to Select adjacent worksheets in Excel shift Click ⇧ Click
How to Select non-adjacent worksheets in Excel ctrl Click ⌘ Click
How to Toggle scroll lock in Excel Scrlk Fn ⇧F14
How to Toggle full screen in Excel ctrl shift f1 ⌃ ⌘F

Dialog Boxes Options Shortcuts:

Options Windows Mac
How to Move to the next control in Excel tab Tab
How to Move to the previous control in Excel shift tab ⇧ Tab
How to Move to the next tab in Excel ctrl tab ⇧ Tab
How to Move to the previous tab in Excel ctrl shift tab ⌃ ⇧Tab
How to Accept and apply in Excel Enter Retrn
How to Check and uncheck the box in Excel space Space
How to Cancel and close the dialog box in Excel Esc Esc

Other Options Shortcuts:

Options Windows Mac
How to Open Spelling dialog box in Excel f7 Fn F7
How to Open Thesaurus dialog box in Excel shift f7 Fn ⇧F7
How to Open Macro dialog box in Excel alt f8 Fn ⌥F8
How to Open VBA Editor in Excel alt f11 Fn ⌥F11
How to Duplicate object in Excel ctrl D ⌘ D
How to Snap to the grid in Excel alt
How to Hide or show objects in Excel ctrl 6 ⌃ 6
How to Display Modify Cell Style dialog box in Excel alt ‘ ⌘ ⇧L
How to Display the right-click menu in Excel Shift f10 Fn ⇧F10
How to Delete a comment in Excel Shift f10D Fn ShiftF10
How to Display control menu in Excel alt space ?
How to Move to the previous tab in Excel ctrl shift tab ⌃ ⇧Tab
How to Accept and apply in Excel Enter Return
How to Check and uncheck the box in Excel space Space
How to Cancel and close the dialog box in Excel Esc Esc

That’s it.

Narendhiran Vijayakumar.

Feel free to comment us below, if you have any queries about the above topic and find more interesting excel tutorials on our homepage: Excel24x7.com.

Warp.dev image

The best coding agent. Backed by benchmarks.

Warp outperforms every other coding agent on the market, and gives you full control over which model you use. Get started now for free, or upgrade and unlock 2.5x AI credits on Warp's paid plans.

Download Warp

Top comments (0)

👋 Kindness is contagious

Dive into this thoughtful piece, beloved in the supportive DEV Community. Coders of every background are invited to share and elevate our collective know-how.

A sincere "thank you" can brighten someone's day—leave your appreciation below!

On DEV, sharing knowledge smooths our journey and tightens our community bonds. Enjoyed this? A quick thank you to the author is hugely appreciated.

Okay