What are Excel keyboard shortcuts?

Excel keyboard shortcuts are key combinations that allow you to perform tasks faster in Microsoft Excel without using a mouse.

Why should I use Excel keyboard shortcuts?

Using Excel keyboard shortcuts improves speed, productivity, and accuracy while working with spreadsheets.

Are Excel keyboard shortcuts different for Windows and Mac?

Yes, Excel keyboard shortcuts differ slightly. Windows mainly uses the Ctrl key, while Mac uses the Command (⌘) key.

Is there a complete Excel keyboard shortcuts list?

Yes, Excellyes provides a complete, category-wise Excel keyboard shortcuts list for both Windows and Mac.

What are the most commonly used Excel shortcuts?

Some commonly used Excel shortcuts include Ctrl+C (Copy), Ctrl+V (Paste), Ctrl+S (Save), and Ctrl+Z (Undo).

What are Excel file management shortcuts?

Excel file shortcuts help you create, open, save, print, and manage workbooks efficiently using the keyboard.

What are Excel navigation keyboard shortcuts?

Excel navigation shortcuts help you move quickly between cells, rows, columns, worksheets, and workbooks.

What are Excel selection shortcuts?

Excel selection shortcuts allow you to select cells, rows, columns, or ranges quickly using the keyboard.

What are Excel formatting shortcuts?

Excel formatting shortcuts help you apply bold, italics, borders, colors, number formats, and alignment faster.

What are Excel formula shortcuts?

Excel formula shortcuts assist in inserting formulas, editing cells, and recalculating worksheets efficiently.

What are Excel data entry shortcuts?

Excel data entry shortcuts help you enter, edit, and fill data quickly without switching to the mouse.

What are Excel worksheet shortcuts?

Excel worksheet shortcuts allow you to add, delete, rename, move, and switch between worksheets easily.

What are Excel row and column shortcuts?

Row and column shortcuts help insert, delete, hide, unhide, and resize rows and columns in Excel.

What are Excel copy and paste shortcuts?

Excel copy and paste shortcuts allow you to duplicate content quickly, including values, formulas, and formats.

What are Excel find and replace shortcuts?

Find and replace shortcuts help you search and modify data quickly across worksheets or workbooks.

What are Excel undo and redo shortcuts?

Undo and redo shortcuts help reverse or reapply recent actions while working in Excel.

What are Excel filter shortcuts?

Excel filter shortcuts allow you to apply, clear, and navigate filters quickly in data tables.

What are Excel table shortcuts?

Table shortcuts help you create, format, and manage Excel tables efficiently.

What are Excel chart shortcuts?

Excel chart shortcuts assist in creating and editing charts faster using keyboard commands.

What are Excel pivot table shortcuts?

Pivot table shortcuts help you create, refresh, and navigate pivot tables more efficiently.

Are Excel keyboard shortcuts useful for beginners?

Yes, Excel keyboard shortcuts are very useful for beginners as they help build good habits and improve speed early.

Are Excel shortcuts useful for advanced users?

Advanced Excel users rely heavily on keyboard shortcuts to handle complex tasks faster and more accurately.

Do Excel shortcuts work in all Excel versions?

Most Excel keyboard shortcuts work across versions, though some may vary slightly depending on Excel edition.

Can Excel shortcuts increase productivity?

Yes, using Excel keyboard shortcuts significantly increases productivity by reducing repetitive mouse actions.

Are Excel keyboard shortcuts worth learning?

Yes, learning Excel keyboard shortcuts saves time and improves efficiency for all Excel users.

Excel Keyboard Shortcuts (Windows & Mac) – Complete List 2026

File Shortcuts

Excel File shortcuts for Windows and Mac
Action	Windows	Mac
Create a New Excel Workbook	`Ctrl` + `N`	`Cmd` + `N`
Open an Existing Excel Workbook	`Ctrl` + `O`	`Cmd` + `O`
Save the Current Excel Workbook	`Ctrl` + `S`	`Cmd` + `S`
Save Workbook As a New File	`F12`	`Cmd` + `Shift` + `S`
Print the Excel Workbook File	`Ctrl` + `P`	`Cmd` + `P`
View Print Preview of the Workbook	`Ctrl` + `F2`	—
Close the Current Workbook	`Ctrl` + `W`	`Cmd` + `W`
Close Microsoft Excel Application	`Alt` + `F4`	`Cmd` + `Q`

Ribbon Shortcuts

Keyboard shortcuts related to the Excel Ribbon.

Excel Ribbon shortcuts for Windows and Mac
Action	Windows	Mac
Expand or Collapse the Excel Ribbon Interface	`Ctrl` + `F1`	`Cmd` + `Option` + `R`
Activate Ribbon Access Keys for Keyboard Navigation	`Alt`	—
Move to the Next Control on the Ribbon	`Tab`	`Tab`
Activate or Open the Currently Selected Ribbon Control	`Space`	`Space`
Confirm or Apply the Selected Ribbon Control Action	`Enter`	`Return`
Open Help for the Selected Ribbon Control	`F1`	`F1`

General Shortcuts

Excel general shortcuts for Windows and Mac
Action	Windows	Mac
Open Excel Options and Application Settings	`Alt` + `F` + `T`	`Cmd` + `,`
Open Excel Help and Support Window	`F1`	`Cmd` + `/`
Undo the Last Action or Change	`Ctrl` + `Z`	`Cmd` + `Z`
Redo the Previously Undone Action	`Ctrl` + `Y`	`Cmd` + `Y`
Copy the Selected Cells to the Clipboard	`Ctrl` + `C`	`Cmd` + `C`
Repeat the Last Action Performed in Excel	`F4`	`Cmd` + `Y`
Cut the Selected Cells to the Clipboard	`Ctrl` + `X`	`Cmd` + `X`
Paste Content from the Clipboard	`Ctrl` + `V`	`Cmd` + `V`
Paste Values Only Without Formatting or Formulas	`Ctrl` + `Shift` + `V`	`Cmd` + `Shift` + `V`
Open the Paste Special Options Dialog	`Ctrl` + `Alt` + `V`	`Cmd` + `Ctrl` + `V`
Find Text, Values, or Cells in the Worksheet	`Ctrl` + `F`	`Cmd` + `F`
Open Find and Replace Dialog (Replace Tab)	`Ctrl` + `H`	`Ctrl` + `H`
Find the Next Matching Result in the Worksheet	`Shift` + `F4`	`Cmd` + `G`
Find the Previous Matching Result in the Worksheet	`Ctrl` + `Shift` + `F4`	`Cmd` + `Shift` + `G`
Create an Embedded Chart in the Current Worksheet	`Alt` + `F1`	`Fn` + `Option` + `F1`
Create a Chart in a New Chart Worksheet	`F11`	`Fn` + `F11`

Tables & Filters

Excel Tables and Filters shortcuts for Windows and Mac
Action	Windows	Mac
Convert the Selected Range into an Excel Table	`Ctrl` + `T`	`Cmd` + `T`
Turn Autofilter On or Off for the Selected Range	`Ctrl` + `Shift` + `L`	`Cmd` + `Shift` + `F`
Open the Filter Dropdown for the Active Column	`Alt` + `↓`	`Option` + `↓`
Select the Entire Row in an Excel Table	`Shift` + `Space`	`Shift` + `Space`
Select the Entire Column in an Excel Table	`Ctrl` + `Space`	`Ctrl` + `Space`
Select the Entire Excel Table	`Ctrl` + `A`	`Cmd` + `A`
Clear All Filters Applied Using a Slicer	`Alt` + `C`	`Option` + `C`
Show or Hide the Total Row in an Excel Table	`Ctrl` + `Shift` + `T`	`Ctrl` + `Shift` + `T`

Drag & Drop

Excel Drag and Drop shortcuts for Windows and Mac
Action	Windows	Mac
Drag Selected Cells to Move Them (Cut & Paste)	`Drag`	`Drag`
Drag Selected Cells to Duplicate Content (Copy)	`Ctrl` + `Drag`	`Option` + `Drag`
Drag to Insert Cells and Shift Existing Data	`Shift` + `Drag`	`Shift` + `Drag`
Drag to Insert a Copy and Shift Existing Cells	`Ctrl` + `Shift` + `Drag`	`Option` + `Shift` + `Drag`
Drag Selected Cells to Another Worksheet	`Alt` + `Drag`	`Cmd` + `Drag`
Duplicate the Entire Worksheet by Dragging	`Ctrl` + `Drag`	`Option` + `Drag`

Navigation Shortcuts

Excel navigation shortcuts for Windows and Mac
Action	Windows	Mac
Move One Cell to the Right	`→`	`→`
Move One Cell to the Left	`←`	`←`
Move One Cell Upwards	`↑`	`↑`
Move One Cell Downwards	`↓`	`↓`
Move One Screen to the Right	`Alt` + `PgDn`	`Fn` + `Option` + `↓`
Move One Screen to the Left	`Alt` + `PgUp`	`Fn` + `Option` + `↑`
Move One Screen Upwards	`PgUp`	`Fn` + `↑`
Move One Screen Downwards	`PgDn`	`Fn` + `↓`
Jump to the Right Edge of the Data Region	`Ctrl` + `→`	`Cmd` + `→`
Jump to the Left Edge of the Data Region	`Ctrl` + `←`	`Cmd` + `←`
Jump to the Top Edge of the Data Region	`Ctrl` + `↑`	`Cmd` + `↑`
Jump to the Bottom Edge of the Data Region	`Ctrl` + `↓`	`Cmd` + `↓`
Move to the Beginning of the Current Row	`Home`	`Fn` + `←`
Jump to the Last Cell in the Worksheet	`Ctrl` + `End`	`Fn` + `Ctrl` + `→`
Jump to the First Cell in the Worksheet	`Ctrl` + `Home`	`Fn` + `Ctrl` + `←`
Activate End Mode to Extend Navigation	`End`	`Fn` + `→`
Go Back to the Previous Hyperlink Location	`Ctrl` + `G` → `Enter`	`Ctrl` + `G` → `Return`

Selection Shortcuts

Excel selection shortcuts for Windows and Mac
Action	Windows	Mac
Select the Entire Row of the Active Cell	`Shift` + `Space`	`Shift` + `Space`
Select the Entire Column of the Active Cell	`Ctrl` + `Space`	`Ctrl` + `Space`
Select All Cells in the Worksheet	`Ctrl` + `A`	`Cmd` + `A`
Add Adjacent Cells to Current Selection	`Shift` + Click	`Shift` + Click
Add Non-Adjacent Cells to Selection	`Ctrl` + Click	`Cmd` + Click
Extend Same Selection to the Next Column	—	`Option` + `Tab`
Extend Same Selection to the Previous Column	—	`Option` + `Shift` + `Tab`
Move to the Next Non-Adjacent Selection on the Right	`Ctrl` + `Alt` + `→`	`Ctrl` + `Option` + `→`
Move to the Previous Non-Adjacent Selection on the Left	`Ctrl` + `Alt` + `←`	`Ctrl` + `Option` + `←`
Enable Add-to-Selection Mode to Extend Selection Without Losing Previous Selection	`Shift` + `F8`	`Fn` + `Shift` + `F8`
Cancel the Current Selection and Deselect Cells	`Esc`	`Esc`

Active Cell Shortcuts

Excel active cell shortcuts for Windows and Mac
Action	Windows	Mac
Select Only the Currently Active Cell	`Shift` + `Backspace`	`Shift` + `Delete`
Locate and Highlight the Active Cell on the Worksheet	`Ctrl` + `Backspace`	`Ctrl` + `Delete`
Move the Active Cell Clockwise Around the Selection	`Ctrl` + `.`	`Ctrl` + `.`
Move the Active Cell Down Within the Selection	`Enter`	`Return`
Move the Active Cell Up Within the Selection	`Shift` + `Enter`	`Shift` + `Return`
Move the Active Cell Right Within the Selection	`Tab`	`Tab`
Move the Active Cell Left Within the Selection	`Shift` + `Tab`	`Shift` + `Tab`

Extend Selection Shortcuts

Excel extend selection shortcuts for Windows and Mac
Action	Windows	Mac
Extend the Selection One Cell to the Right	`Shift` + `→`	`⇧` + `→`
Extend the Selection One Cell to the Left	`Shift` + `←`	`⇧` + `←`
Extend the Selection One Cell Upwards	`Shift` + `↑`	`⇧` + `↑`
Extend the Selection One Cell Downwards	`Shift` + `↓`	`⇧` + `↓`
Extend Selection to the Last Cell on the Right	`Ctrl` + `Shift` + `→`	`⌘` + `⇧` + `→`
Extend Selection to the Last Cell on the Left	`Ctrl` + `Shift` + `←`	`⌘` + `⇧` + `←`
Extend Selection to the Last Cell Upwards	`Ctrl` + `Shift` + `↑`	`⌘` + `⇧` + `↑`
Extend Selection to the Last Cell Downwards	`Ctrl` + `Shift` + `↓`	`⌘` + `⇧` + `↓`
Extend Selection Up by One Screen	`Shift` + `Page Up`	`Fn` + `⇧` + `↑`
Extend Selection Down by One Screen	`Shift` + `Page Down`	`Fn` + `⇧` + `↓`
Extend Selection Right by One Screen	`Alt` + `Shift` + `Page Down`	`Fn` + `⇧` + `⌥` + `↓`
Extend Selection Left by One Screen	`Alt` + `Shift` + `Page Up`	`Fn` + `⇧` + `⌥` + `↑`
Extend Selection to the Beginning of the Current Row	`Shift` + `Home`	`Fn` + `⇧` + `←`
Extend Selection to the First Cell in Worksheet (A1)	`Ctrl` + `Shift` + `Home`	`Fn` + `⌃` + `⇧` + `←`
Extend Selection to the Last Used Cell in Worksheet	`Ctrl` + `Shift` + `End`	`Fn` + `⌃` + `⇧` + `→`
Turn On or Off Extend Selection Mode	`F8`	`Fn` + `F8`

Select Special Shortcuts

Excel select special shortcuts for Windows and Mac
Action	Windows	Mac
Open the “Go To” Dialog to Jump to a Specific Cell	`Ctrl` + `G`	`⌃` + `G`
Select All Cells that Contain Comments in the Worksheet	`Ctrl` + `Shift` + `O`	`Fn` + `⌃` + `⇧` + `O`
Select the Current Data Region Around the Active Cell	`Ctrl` + `Shift` + `*`	`⌃` + `⇧` + `Space`
Select the Entire Region or Worksheet	`Ctrl` + `A`	`⌘` + `A`
Select the Entire Current Array Formula	`Ctrl` + `/`	`⌃` + `/`
Select Differences in the Current Row Compared to the Active Cell	`Ctrl` + `\`	`⌃` + `\`
Select Differences in the Current Column Compared to the Active Cell	`Ctrl` + `Shift` + `\|`	`⌃` + `⇧` + `\|`
Select Direct Precedent Cells Referenced by the Active Cell	`Ctrl` + `[`	`⌃` + `[`
Select All Precedent Cells Referenced by the Active Cell	`Ctrl` + `Shift` + `{`	`⌃` + `⇧` + `{`
Select Direct Dependent Cells that Rely on the Active Cell	`Ctrl` + `]`	`⌃` + `]`
Select All Dependent Cells that Rely on the Active Cell	`Ctrl` + `Shift` + `}`	`⌃` + `⇧` + `}`
Select Only Visible Cells in the Current Selection	`Alt` + `;`	`⌘` + `⇧` + `Z`

Cell Edit Mode Shortcuts

Excel cell edit mode shortcuts for Windows and Mac
Action	Windows	Mac
Enter Edit Mode for the Active Cell	`F2`	`⌃` + `U`
Cancel Cell Entry or Edit	`Esc`	`Esc`
Select One Character to the Right	`Shift` + `→`	`⇧` + `→`
Select One Character to the Left	`Shift` + `←`	`⇧` + `←`
Move Cursor One Word to the Right	`Ctrl` + `→`	`⌃` + `→`
Move Cursor One Word to the Left	`Ctrl` + `←`	`⌃` + `←`
Select One Word to the Right	`Ctrl` + `Shift` + `→`	`⌃` + `⇧` + `→`
Select One Word to the Left	`Ctrl` + `Shift` + `←`	`⌃` + `⇧` + `←`
Select from Cursor to Beginning of Cell	`Shift` + `Home`	`Fn` + `⇧` + `←`
Select from Cursor to End of Cell	`Shift` + `End`	`Fn` + `⇧` + `→`
Delete Text from Cursor to End of Cell	`Ctrl` + `Delete`	`Fn` + `⌃` + `Delete`
Delete Character to the Left	`Backspace`	`Delete`
Delete Character to the Right	`Delete`	`Fn` + `Delete`
Insert a Line Break Within the Cell	`Alt` + `Enter`	`⌃` + `⌥` + `Return`

Entering Data Shortcuts

Excel entering data shortcuts for Windows and Mac
Action	Windows	Mac
Enter Data and Move Down	`Enter`	`Return`
Enter Data and Move Up	`Shift` + `Enter`	`⇧` + `Return`
Enter Data and Move Right	`Tab`	`Tab`
Enter Data and Move Left	`Shift` + `Tab`	`⇧` + `Tab`
Complete Entry and Stay in the Same Cell	`Ctrl` + `Enter`	`⌃` + `Return`
Enter Same Data in Multiple Selected Cells	`Ctrl` + `Enter`	`⌃` + `Return`
Insert Current Date	`Ctrl` + `;`	`⌃` + `;`
Insert Current Time	`Ctrl` + `Shift` + `:`	`⌘` + `;`
Fill Down	`Ctrl` + `D`	`⌘` + `D`
Fill Right	`Ctrl` + `R`	`⌘` + `R`
Copy Formula from the Cell Above	`Ctrl` + `'`	`⌘` + `'`
Copy Value from the Cell Above	`Ctrl` + `Shift` + `"`	`⌃` + `⇧` + `"`
Add Hyperlink	`Ctrl` + `K`	`⌘` + `K`
Display AutoComplete List	`Alt` + `↓`	`⌥` + `↓`
Flash Fill	`Ctrl` + `E`	`⌃` + `E`

Formatting Shortcuts

Excel formatting shortcuts for Windows and Mac
Action	Windows	Mac
Open the Format Cells Dialog to Apply Formatting	`Ctrl` + `1`	`⌘` + `1`
Open the Font Tab in the Format Cells Dialog	`Ctrl` + `Shift` + `F`	`⌃` + `⇧` + `F`
Apply Bold Formatting to Selected Cells	`Ctrl` + `B`	`⌘` + `B`
Apply Italic Formatting to Selected Cells	`Ctrl` + `I`	`⌘` + `I`
Underline the Text in Selected Cells	`Ctrl` + `U`	`⌘` + `U`
Apply Strikethrough Formatting to Selected Cells	`Ctrl` + `5`	`⌘` + `⇧` + `X`
Center Align the Contents of Selected Cells	`Alt` + `H` + `A` + `C`	`⌘` + `E`
Align the Contents of Selected Cells to the Left	`Alt` + `H` + `A` + `L`	`⌘` + `L`
Align the Contents of Selected Cells to the Right	`Alt` + `H` + `A` + `R`	`⌘` + `R`
Increase the Indentation Level of Selected Cells	`Alt` + `H` + `6`	`⌃` + `⌥` + `Tab`
Decrease the Indentation Level of Selected Cells	`Alt` + `H` + `5`	`⌃` + `⌥` + `⇧` + `Tab`
Increase the Font Size of the Selected Cells Step by Step	`Alt` + `H` + `F` + `G`	`⌘` + `⇧` + `>`

Grid Operations Shortcuts

Excel grid operations shortcuts for Windows and Mac
Action	Windows	Mac
Insert New Rows or Columns into the Worksheet	`Ctrl` + `Shift` + `+`	`⌘` + `⇧` + `+`
Delete Selected Rows, Columns, or Cells from the Worksheet	`Ctrl` + `-`	`⌘` + `-`
Delete the Contents of Selected Cells Without Removing the Cells	`Delete`	`Fn` + `Delete`
Hide the Selected Columns in the Worksheet	`Ctrl` + `0`	`⌃` + `0`
Hide the Selected Rows in the Worksheet	`Ctrl` + `9`	`⌃` + `9`
Unhide Previously Hidden Rows in the Worksheet	`Ctrl` + `Shift` + `9`	`⌃` + `⇧` + `9`
Unhide Previously Hidden Columns in the Worksheet	`Ctrl` + `Shift` + `0`	`⌃` + `⇧` + `0`
Group Selected Rows or Columns for Outline and Collapse/Expand	`Alt` + `Shift` + `→`	`⌘` + `⇧` + `K`
Ungroup Previously Grouped Rows or Columns	`Alt` + `Shift` + `←`	`⌘` + `⇧` + `J`
Show or Hide Outline Symbols for Grouped Data	`Ctrl` + `8`	`⌃` + `8`
Zoom In to Magnify the Worksheet View	`Ctrl` + `Alt` + `+`	`⌥` + `⌘` + `+`
Zoom Out to Reduce the Worksheet View	`Ctrl` + `Alt` + `-`	`⌥` + `⌘` + `-`
Zoom the Worksheet Using the Mouse Scroll Wheel	`Ctrl` + `Mouse Scroll`	`⌃` + `Scroll`

Pivot Tables Shortcuts

Excel pivot tables shortcuts for Windows and Mac
Action	Windows	Mac
Select the Entire Pivot Table in the Worksheet	`Ctrl` + `A`	`⌘` + `A`
Toggle the Checkbox for a Selected Pivot Field	`Space`	`Space`
Group Selected Items in a Pivot Table Field	`Alt` + `Shift` + `→`	`⌘` + `⇧` + `K`
Ungroup Previously Grouped Items in a Pivot Table Field	`Alt` + `Shift` + `←`	`⌘` + `⇧` + `J`
Hide the Selected Pivot Item from the Pivot Table	`Ctrl` + `-`	`Ctrl` + `-`
Create a Pivot Chart on the Same Worksheet as the Pivot Table	`Alt` + `F1`	—
Create a Pivot Chart on a New Worksheet	`F11`	`Fn` + `F11`
Open the PivotTable Wizard to Create or Modify Pivot Tables	`Alt` + `D` + `P`	`⌘` + `⌥` + `P`

Workbook Shortcuts

Excel workbook shortcuts for Windows and Mac
Action	Windows	Mac
Insert a New Worksheet into the Current Workbook	`Shift` + `F11`	`Fn` + `⇧F11`
Move to the Next Worksheet in the Workbook	`Ctrl` + `PgDn`	`Fn` + `⌃↓`
Move to the Previous Worksheet in the Workbook	`Ctrl` + `PgUp`	`Fn` + `⌃↑`
Switch to the Next Pane in a Split Worksheet	`F6`	`FnF6`
Switch to the Previous Pane in a Split Worksheet	`Shift` + `F6`	`Fn⇧F6`
Switch to the Next Open Workbook Window	`Ctrl` + `Tab`	⌘`
Switch to the Previous Open Workbook Window	`Ctrl` + `Shift` + `Tab`	⌘⇧`
Minimize the Current Workbook Window	`Ctrl` + `F9`	`⌘M`
Maximize the Current Workbook Window	`Ctrl` + `F10`	`Fn` + `⌃F10`
Select Adjacent Worksheets by Clicking While Holding Shift	`Shift` + `Click`	`⇧Click`
Select Non-Adjacent Worksheets by Clicking While Holding Ctrl / Command	`Ctrl` + `Click`	`⌘Click`
Toggle the Scroll Lock Function On or Off	`ScrLk`	`Fn⇧F14`
Toggle Full Screen Mode for the Current Workbook Window	`Ctrl` + `Shift` + `F1`	`⌃⌘F`

Dialog Boxes Shortcuts

Excel dialog box shortcuts for Windows and Mac
Action	Windows	Mac
Move to the Next Control or Field in a Dialog Box	`Tab`	`Tab`
Move to the Previous Control or Field in a Dialog Box	`Shift` + `Tab`	`⇧Tab`
Switch to the Next Tab within a Dialog Box	`Ctrl` + `Tab`	`⌃Tab`
Switch to the Previous Tab within a Dialog Box	`Ctrl` + `Shift` + `Tab`	`⌃⇧Tab`
Accept the Changes and Apply Them in the Dialog Box	`Enter`	`Return`
Check or Uncheck the Selected Checkbox in a Dialog Box	`Space`	`Space`
Cancel the Operation and Close the Dialog Box	`Esc`	`Esc`

Other Useful Excel Shortcuts

Other useful Excel shortcuts for Windows and Mac
Action	Windows	Mac
Check the Spelling of the Selected Cells or Entire Worksheet	`F7`	`FnF7`
Open Thesaurus to Look Up Synonyms for Selected Text	`Shift` + `F7`	`Fn⇧F7`
Open the Macro Dialog to Run or Manage Macros	`Alt` + `F8`	`Fn⌥F8`
Open the VBA Editor to Write or Edit Macros	`Alt` + `F11`	`Fn⌥F11`
Open the Power Query Editor for Data Transformation	`Alt` + `F12`	`Fn⌥F12`
Duplicate the Selected Object or Shape in the Worksheet	`Ctrl` + `D`	`⌘D`
Enable or Disable Snap to Grid for Objects	`Alt`	`⌘`
Hide or Show All Objects in the Worksheet	`Ctrl` + `6`	`⌃6`
Modify the Style of the Selected Cell or Range	`Alt` + `'`	`⌘⇧L`
Open the Context Menu for the Selected Cell or Object	`Shift` + `F10`	`Fn⇧F10`
Insert a New Note or Edit an Existing Note in a Cell	`Shift` + `F2`	`Fn⇧F2`
Insert a Threaded Comment in the Selected Cell	`Ctrl` + `Shift` + `F2`	`Fn⌘⇧F2`
Delete an Existing Comment or Threaded Comment from the Cell	`Shift` + `F10` then `D`	`Fn⇧F10` then `D`
Open the Control Menu for the Current Workbook Window	`Alt` + `Space`	—

Number Formatting Keyboard Shortcuts

Number formatting shortcuts for Windows and Mac
Action	Windows	Mac
Apply General Number Format to Selected Cells	`Ctrl` + `Shift` + `~`	`⌃⇧~`
Apply Currency Formatting with Dollar Sign to Selected Cells	`Ctrl` + `Shift` + `$`	`⌃⇧$`
Apply Percentage Formatting to Selected Cells	`Ctrl` + `Shift` + `%`	`⌃⇧%`
Apply Scientific Notation Format to Selected Cells	`Ctrl` + `Shift` + `^`	`⌃⇧^`
Apply Standard Date Format to Selected Cells	`Ctrl` + `Shift` + `#`	`⌃⇧#`
Apply Standard Time Format to Selected Cells	`Ctrl` + `Shift` + `@`	`⌃⇧@`
Apply Number Formatting with Thousand Separator to Selected Cells	`Ctrl` + `Shift` + `!`	`⌃⇧!`

Borders Keyboard Shortcuts

Borders shortcuts for Windows and Mac
Action	Windows	Mac
Add a Complete Border Outline Around Selected Cells	`Ctrl` + `Shift` + `&`	`⌘⌥0`
Add or Remove Right Border for Selected Cells	`Alt` + `R`	`⌘⌥→`
Add or Remove Left Border for Selected Cells	`Alt` + `L`	`⌘⌥←`
Add or Remove Top Border for Selected Cells	`Alt` + `T`	`⌘⌥↑`
Add or Remove Bottom Border for Selected Cells	`Alt` + `B`	`⌘⌥↓`
Add or Remove Upward Diagonal Border Across Selected Cells	`Alt` + `D`	—
Add or Remove Horizontal Interior Borders Between Selected Cells	`Alt` + `H`	—
Add or Remove Vertical Interior Borders Between Selected Cells	`Alt` + `V`	—
Remove All Borders from the Selected Cells	`Ctrl` + `Shift` + `_`	`⌘⌥_`

Formulas Keyboard Shortcuts

Formulas shortcuts for Windows and Mac
Action	Windows	Mac
Toggle Between Absolute and Relative Cell References in a Formula	`F4`	`⌘T`
Open the Insert Function Dialog Box to Insert a New Function	`Shift` + `F3`	`Fn⇧F3`
Automatically Sum the Selected Range of Cells Using AutoSum	`Alt` + `=`	`⌘⇧T`
Toggle Displaying Formulas On or Off in the Worksheet	`Ctrl` + `	⌃`
Insert or Edit Function Arguments Directly into a Formula	`Ctrl` + `Shift` + `A`	`⌃⇧A`
Enter an Array Formula Across Multiple Cells at Once	`Ctrl` + `Shift` + `Enter`	`⌃⇧Return`
Calculate All Formulas in All Worksheets of the Workbook	`F9`	`FnF9`
Calculate Formulas Only in the Active Worksheet	`Shift` + `F9`	`Fn⇧F9`
Force a Full Recalculation of All Formulas in the Entire Workbook	`Ctrl` + `Alt` + `F9`	—
Evaluate a Specific Part of a Formula Step by Step	`F9`	`FnF9`
Toggle the Visibility of the Formula Bar in Excel	`Ctrl` + `Shift` + `U`	`⌃⇧U`
Open the Function Arguments Dialog to Edit Formula Arguments	`Ctrl` + `A`	`⌃A`
Open the Name Manager to View and Edit Named Ranges	`Ctrl` + `F3`	`Fn⌃F3`
Define Named Ranges Automatically from Selected Row or Column Labels	`Ctrl` + `Shift` + `F3`	`Fn⌃⇧F3`
Select the Name Box to Quickly Jump to a Named Cell or Range	`Alt` + `F3`	—
Paste a Named Range or Cell Name Directly into a Formula	`F3`	`F3`
Accept the Autocomplete Suggestion for a Function While Typing	`Tab`	`Tab`