Open Data Tab Shortcut in Microsoft Excel Office 365!!
Tags: excelshortcuts, shortcutkeystoopenda
Published: 2020-08-27 12:34:57

---
title: Open Data Tab Shortcut in Microsoft Excel Office 365!!
published: true
date: 2020-08-27 09:54:48 UTC
tags: Excelshortcuts,shortcutkeystoOpenDa
canonical_url: https://geekexcel.com/open-data-tab-shortcut-in-microsoft-excel-office-365/
---

## Shortcut to Open Data Tab:

In this article, we are going to see the **Shortcut Keys to Open Data Tab in Excel Office 365**.



## Shortcut Keys:

Here, we come up with the shortcut keys to open the data tab in Excel for both the Windows and MAC devices.

| Windows Shortcut |
| AltA |

| MAC Shortcut |
| Not Available |

## Shortcut Description:

- This shortcut will open the data tab in the Excel spreadsheet.
- To do this, you need to press ( **ALT + A** ) Keys and then it will give the result like below.

!["<yoastmark](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/EXCEL_FcN97KTE17.png)

## Verdict:

In the above article, you will learn the **shortcut keys to Open Data Tab in Excel Office 365** for both the Windows and MAC Systems. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

Find more Excel shortcuts on the following Article!

# {222+} EXCEL SHORTCUTS For Windows/Mac OS Updated 2020 Version!

Posted: June 9, 2020 | [0 comments](https://geekexcel.com/excel-shortcuts-windows-2020/#respond)

[Excel](https://geekexcel.com/) is one of the most famous software used by many peoples, users & many corporate all around the world. Knowing Excel shortcuts will help you to use [**Excel software**](https://www.microsoft.com/en-us/microsoft-365/excel) more efficiently. In this article, we list the **222+ Keyboard shortcuts** of Excel software on the **Windows system**.

## Download 220+ Excel Shortcuts PDF:

[Excel Shortcut PDF Download](https://geekexcel.com/geekexcel-com-excel-shortcuts-windows-2020-2/)

## File Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Create a new workbook](https://geekexcel.com/simple-shortcut-to-create-a-new-workbook-in-excel-365/) | ctrl n | ⌘ N |
| [How to open a workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) | ctrl o | ⌘ o |
| [How to save a workbook](https://geekexcel.com/shortcut-to-save-workbook-in-excel-365/) | ctrl s | ⌘ S |
| [Save as Workbook](https://geekexcel.com/save-as-shortcut-in-microsoft-excel-365/) | F12 | ⌘ ⇧S |
| [How to print a file in Excel](https://geekexcel.com/print-file-shortcut-in-microsoft-excel-365/) | ctrl p | ⌘ P |
| [How to open a print preview window in Excel](https://geekexcel.com/shortcut-to-open-print-preview-window-in-excel-365/) | ctrl F12 | Not Available |
| [How to Close the current workbook](https://geekexcel.com/shortcut-to-close-current-workbook-in-microsoft-excel-365/) | ctrl F4 | ⌘W |
| [How to Close Excel](https://geekexcel.com/quick-shortcut-to-close-excel-file-microsoft-excel-365/) | ALT F4 | ⌘ Q |

## Ribbon Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Expand or collapse the ribbon](https://geekexcel.com/shortcut-keys-to-expand-or-collapse-ribbon-in-excel-365/) | ctrl F1 | ⌘⌥R |
| [How to Activate access keys](https://geekexcel.com/shortcut-to-activate-access-keys-in-microsoft-excel-365/) | ALT | Not Available |
| [How to Move to next ribbon control](https://geekexcel.com/shortcut-to-move-to-the-next-ribbon-control-in-microsoft-excel-365/) | Tab | Tab |
| [How to Activate or open selected control](https://geekexcel.com/shortcut-to-activate-or-open-selected-control-in-excel-365/) | Space | Space |
| [How to Confirm control change](https://geekexcel.com/shortcut-to-confirm-control-change-in-excel-365/) | Enter | Return |
| [How to Get help on the selected control](https://geekexcel.com/shortcut-to-get-help-on-selected-control-in-excel-365/) | F1 | Not Available |

## General Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to open options in Excel](https://geekexcel.com/quick-shortcut-to-open-options-in-microsoft-excel-365/) | ALTFT | ⌘ , |
| [How to undo the last action in Excel](https://geekexcel.com/shortcuts-to-undo-last-action-in-microsoft-excel-365/) | ctrl z | ⌘ Z |
| [How to redo the last action in Excel](https://geekexcel.com/shortcuts-to-redo-last-action-in-microsoft-excel-365/) | ctrl y | ⌘Y |
| [How to copy selected cells in Excel](https://geekexcel.com/shortcut-to-copy-the-selected-cells-quickly-in-excel-365/) | ctrl c | ⌘ C |
| [How to repeat the last action in Excel](https://geekexcel.com/shortcut-keys-to-repeat-last-action-in-microsoft-excel-365/) | f4 | ⌘ Y |
| [How to cut selected cells in Excel](https://geekexcel.com/a-quick-shortcut-to-cut-selected-cells-in-excel-365/) | ctrl X | ⌘ X |
| [How to paste content from clipboard in Excel](https://geekexcel.com/a-simple-shortcut-to-paste-content-from-clipboard-in-excel-365/) | ctrl v | ⌘ V |
| [How to display the paste special dialog box in Excel](https://geekexcel.com/shortcut-to-display-the-paste-special-dialog-box-in-microsoft-excel-365/) | ctrl ALTV | ⌘ ⌃V |
| [How to display find and replace in Excel](https://geekexcel.com/easy-shortcut-to-display-find-and-replace-in-excel-365/) | ctrlf | ⌘ F |
| [How to display find and replace, replace selected in Excel](https://geekexcel.com/shortcut-to-find-and-replace-replace-selected-in-microsoft-excel-365/) | ctrlh | ⌃ H |
| [How to Find the previous match in Excel](https://geekexcel.com/quick-shortcut-to-find-previous-match-in-microsoft-excel-365/) | ctrlshiftf4 | ⌘ ⇧G |
| [How to Find the next match in Excel](https://geekexcel.com/simple-shortcut-to-find-next-match-in-microsoft-excel-365/) | Shiftf4 | ⌘ G |
| [How to Create an embedded chart in Excel](https://geekexcel.com/shortcut-to-create-embedded-chart-in-excel-365/) | Alt f1 | Fn ⌥F1 |
| [How to Create a chart in a new worksheet in Excel](https://geekexcel.com/what-is-the-shortcut-to-create-chart-in-new-worksheet-in-excel-365/) | f11 | Fn F11 |

## Table & Filters Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to insert a table in Excel](https://geekexcel.com/ms-excel-shortcut-to-insert-table-in-the-worksheet/) | ctrl t | ⌃ T |
| [How to toggle auto filter in Excel](https://geekexcel.com/easy-shortcut-to-toggle-autofilter-in-ms-excel-365/) | ctrlshiftl | ⌘ ⇧F |
| [How to activate filter in Excel](https://geekexcel.com/quick-keyboard-shortcut-to-activate-filter-in-excel-365/) | Alt↓ | ⌥ ↓ |
| [How to select a table row in Excel](https://geekexcel.com/shortcut-keys-to-select-table-row-in-microsoft-excel-365/) | shiftspace | ⇧Space |
| [How to select the table column in Excel](https://geekexcel.com/easy-shortcuts-to-select-table-column-in-ms-excel-365/) | ctrlSpace | ⌃ Space |
| [How to select a table in Excel](https://geekexcel.com/keyboard-shortcut-to-select-table-in-microsoft-excel-365/) | ctrl a | ⌘ A |
| [How to clear the slicer filter in Excel](https://geekexcel.com/excel-shortcut-to-clear-slicer-filter-in-worksheet/) | altc | ⌥ C |
| [How to toggle table total row in Excel](https://geekexcel.com/a-simple-shortcut-to-toggle-table-total-row-in-excel-365/) | ctrlshiftt | ⌘ ⇧T |

## Drag & Drop Options Excel Shortcut:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Drag and cut in Excel](https://geekexcel.com/shortcut-keys-to-drag-and-cut-in-microsoft-excel-365/) | drag | Drag |
| [How to Drag and copy in Excel](https://geekexcel.com/quick-shortcut-to-drag-and-copy-in-ms-excel-365/) | ctrldrag | ⌥ Drag |
| [How to Drag & Insert in Excel](https://geekexcel.com/ms-excel-keyboard-shortcuts-to-drag-and-insert-in-the-worksheet/) | shiftdrag | ⇧ Drag |
| [How to Drag and insert copy in Excel](https://geekexcel.com/a-simple-keyboard-shortcut-to-drag-and-insert-copy-in-excel-365/) | ctrlshiftdrag | ⌥ ⇧Drag |
| [How to Drag to a worksheet in Excel](https://geekexcel.com/shortcuts-for-drag-to-a-worksheet-in-microsoft-excel-365/) | ctrldrag | ⌥Drag |
| [How to Drag to duplicate worksheet in Excel](https://geekexcel.com/shortcut-keys-to-drag-to-the-duplicate-worksheet-in-ms-excel-365/) | altdrag | ⌘ Drag |

## Navigation Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Move one cell right in Excel](https://geekexcel.com/simple-shortcut-to-move-one-cell-right-in-microsoft-excel-365/) | → | → |
| [How to Move one cell left in Excel](https://geekexcel.com/quick-shortcut-to-move-one-cell-left-in-ms-excel-365/) | ← | ← |
| [How to Move one cell up in Excel](https://geekexcel.com/a-simple-keyboard-shortcuts-to-move-one-cell-up-in-excel-365/) | ↑ | ↑ |
| [How to Move one cell down in Excel](https://geekexcel.com/quick-shortcut-to-move-one-cell-down-in-microsoft-excel-365/) | ↓ | ↓ |
| [How to Move one screen right in Excel](https://geekexcel.com/shortcut-to-move-one-screen-right-in-ms-excel-365/) | alt Pg.Dn | Fn ⌥↓ |
| [How to Move one screen left in Excel](https://geekexcel.com/easy-shortcut-to-move-one-screen-left-in-microsoft-excel-365/) | alt Pg.up | Fn ⌥↑ |
| [How to Move one screen up in Excel](https://geekexcel.com/simple-shortcut-to-move-one-screen-up-in-excel-365/) | PG.Up | Fn ↑ |
| [How to Move one screen down in Excel](https://geekexcel.com/excel-keyboard-shortcut-to-move-one-screen-down-in-spreadsheet/) | PG.Dn | Fn ↓ |
| [How to Move to the right edge of the data region in Excel](https://geekexcel.com/shortcut-to-move-to-right-edge-of-data-region-in-excel-365/) | Ctrl → | ⌃ → |
| [How to Move to the left edge of the data region in Excel](https://geekexcel.com/shortcut-to-move-to-left-edge-of-data-region-in-ms-excel-365/) | Ctrl ← | ⌃ ← |
| [How to Move to the top edge of the data region in Excel](https://geekexcel.com/quick-shortcut-to-move-to-the-top-edge-of-data-region-in-excel/) | Ctrl↑ | ⌃ ↑ |
| [How to Move to the bottom edge of the data region in Excel](https://geekexcel.com/simple-shortcut-for-move-to-bottom-edge-of-data-region-in-excel-365/) | Ctrl ↓ | ⌃ ↓ |
| [How to Move to the beginning of a row in Excel](https://geekexcel.com/quick-keyboard-shortcuts-for-move-to-beginning-of-row-in-ms-excel-365/) | Home | Fn ← |
| [How to Move to the last cell in a worksheet in Excel](https://geekexcel.com/how-to-move-to-the-last-cell-in-worksheet-using-shortcut-in-ms-excel-365/) | ctrlend | Fn ⌃→ |
| [How to Move to the first cell in a worksheet in Excel](https://geekexcel.com/simple-keyboard-shortcut-to-move-to-the-first-cell-in-excel-worksheet/) | ctrlHome | Fn ⌃← |
| [How to Turn End mode on in Excel](https://geekexcel.com/quick-shortcut-to-turn-end-mode-on-in-microsoft-excel-365/) | End | Fn → |
| [How to Go back to hyperlink in Excel](https://geekexcel.com/simple-shortcut-for-go-back-to-hyperlink-in-ms-excel-365/) | ctrlGEnter | ⌃ GReturn |

## Selection Options Excel Shortcut:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Select an entire row in Excel](https://geekexcel.com/easy-ms-excel-shortcut-to-select-entire-row-in-the-worksheet/) | shift space | ⇧ Space |
| [How to Select an entire column in Excel](https://geekexcel.com/quick-shortcut-to-select-entire-column-in-ms-excel-365/) | ctrlspace | ⌃ Space |
| [How to Select entire worksheet in Excel](https://geekexcel.com/excel-keyboard-shortcut-to-select-entire-worksheet/) | ctrla | ⌘ A |
| [How to Add adjacent cells to selection in Excel](https://geekexcel.com/shortcut-to-add-adjacent-cells-to-selection-in-ms-excel-365/) | ShiftClick | ⇧ Click |
| [How to Add non-adjacent cells to selection in Excel](https://geekexcel.com/quick-shortcut-keys-to-add-non-adjacent-cells-to-selection-in-excel-365/) | ctrlClick | ⌘ Click |
| [How to Same selection in next column in Excel](https://geekexcel.com/a-quick-keyboard-shortcut-for-same-selection-in-next-column/) | Nil | ⌥ Tab |
| [How to Same selection in the previous column in Excel](https://geekexcel.com/simple-shortcuts-for-same-selection-in-previous-column-in-excel-365/) | Nil | ⌥ ⇧Tab |
| [How to Move right between non-adjacent selections in Excel](https://geekexcel.com/shortcut-to-move-right-between-non-adjacent-selections-in-excel/) | ctrlalt→ | ⌃ ⌥→ |
| [How to Move left between non-adjacent selections in Excel](https://geekexcel.com/simple-shortcuts-to-move-left-between-non-adjacent-selection-cells/) | ctrlalt← | ⌃ ⌥← |
| [How to Toggle add to selection mode in Excel](https://geekexcel.com/shortcuts-for-toggle-add-to-selection-mode-in-ms-excel-365/) | shiftf8 | Fn ⇧F8 |
| [How to Cancel selection in Excel](https://geekexcel.com/simple-shortcut-to-cancel-selection-in-microsoft-excel-365/) | Esc | Esc |

## Active Cell Options Excel Shortcuts:

| [How to Select an active cell only in Excel](https://geekexcel.com/shortcut-keys-to-select-active-cell-only-in-excel-365/) | shift Backspace |   
⇧Delete |
| [How to Show the active cell on a worksheet in Excel](https://geekexcel.com/easy-shortcut-to-show-the-active-cell-on-worksheet-in-excel-365/) | ctrlBackspace | ⌘ Delete |
| [How to Move active cell clockwise in selection in Excel](https://geekexcel.com/shortcut-to-move-active-cell-clockwise-in-selection-in-excel-365/) | ctrl. | ⌃ . |
| [How to Move active cell down in selection in Excel](https://geekexcel.com/shortcut-to-move-active-cell-down-in-selection-in-ms-excel-365/) | Enter | Return |
| [How to Move active cell up in selection in Excel](https://geekexcel.com/simple-shortcut-to-move-active-cell-up-in-selection-in-excel-365/) | shiftenter | ⇧ Return |
| [How to Move active cell right in a selection in Excel](https://geekexcel.com/quick-shortcut-to-move-active-cell-right-in-a-selection-in-ms-excel-365/) | tab | Tab |
| [How to Move active cell left in a selection in Excel](https://geekexcel.com/keyboard-shortcut-to-move-the-active-cell-left-in-a-selection-in-excel-365/) | shifttab | ⇧ Tab |

## Extend Selection Options Excel Shortcut:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Extend selection by one cell right in Excel](https://geekexcel.com/quick-shortcut-to-extend-selection-by-one-cell-right-in-ms-excel-365/) | shift → | ⇧ → |
| [How to Extend selection by one cell left in Excel](https://geekexcel.com/shortcut-keys-to-extend-selection-by-one-cell-left-in-excel-365/) | shift ← | ⇧ ← |
| [How to Extend selection by one cell up in Excel](https://geekexcel.com/excel-shortcut-to-extend-selection-by-one-cell-up-in-worksheet/) | shift ↑ | ⇧ ↑ |
| [How to Extend selection by one cell down in Excel](https://geekexcel.com/a-simple-shortcut-to-extend-selection-by-one-cell-down-in-excel/) | shift ↓ | ⇧ ↓ |
| [How to Extend the selection to the last cell right in Excel](https://geekexcel.com/shortcut-to-extend-the-selection-to-the-last-cell-right-in-ms-excel-365/) | ctrlshift→ | ⌃ ⇧→ |
| [How to Extend the selection to the last cell left in Excel](https://geekexcel.com/simple-shortcut-to-extend-the-selection-to-the-last-cell-left-in-excel-365/) | ctrlshift← | ⌃ ⇧← |
| [How to Extend the selection to the last cell up in Excel](https://geekexcel.com/shortcut-to-extend-the-selection-to-the-last-cell-up-in-ms-excel-365/) | ctrlshift↑ | ⌃ ⇧↑ |
| [How to Extend the selection to the last cell down in Excel](https://geekexcel.com/shortcut-to-extend-the-selection-to-the-last-cell-down-in-microsoft-excel/) | ctrlshift↓ | ⌃ ⇧↓ |
| [How to Extend selection up one screen in Excel](https://geekexcel.com/shortcut-to-extend-selection-up-one-screen-in-excel-worksheet/) | shiftpg.up | Fn⇧↑ |
| [How to Extend selection down one screen in Excel](https://geekexcel.com/shortcut-to-extend-selection-down-one-screen-in-excel-365/) | shiftpg.dn | Fn⇧↓ |
| [How to Extend selection right one screen in Excel](https://geekexcel.com/shortcut-to-extend-selection-right-one-screen-in-excel-365/) | altshiftpg.dn | Fn⇧⌥↓ |
| [How to Extend selection left one screen in Excel](https://geekexcel.com/easy-shortcut-to-extend-selection-left-one-screen-in-ms-excel-365/) | altshiftpg.up | Fn⇧⌥↑ |
| [How to Extend selection to start of the row in Excel](https://geekexcel.com/quick-shortcut-to-extend-selection-to-start-of-row-in-ms-excel-365/) | shifthome | Fn ⇧← |
| [How to Extend selection to the first cell in a worksheet in Excel](https://geekexcel.com/ms-excel-shortcut-to-extend-selection-to-first-cell-in-worksheet/) | ctrlshifthome | Fn⌃⇧← |
| [How to Extend selection to last cell in the worksheet in Excel](https://geekexcel.com/shortcut-to-extend-selection-to-last-cell-in-excel-worksheet/) | ctrlshiftend | Fn⌃⇧→ |
| [How to Toggle extend selection mode in Excel](https://geekexcel.com/simple-shortcut-to-toggle-extend-selection-mode-in-excel-365/) | f8 | Fn F8 |

## Select Special Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Display ‘ **Go-To** ‘ dialog box in Excel](https://geekexcel.com/simple-shortcut-keys-to-display-go-to-dialog-box-in-ms-excel-365/) | ctrl g | ⌃ G |
| [How to Select cells with comments in Excel](https://geekexcel.com/shortcut-to-select-cells-with-comments-in-microsoft-excel-365/) | ctrlshift o | Fn⌃⇧O |
| [How to Select the current region around the active cell in Excel](https://geekexcel.com/shortcut-to-select-current-region-around-active-cell-in-excel-365/) | ctrlshift \* | ⇧ ⌃Space |
| [How to Select the current region in Excel](https://geekexcel.com/quick-shortcut-to-select-current-region-in-ms-excel-365/) | ctrla | ⌘ A |
| [How to Select the current array in Excel](https://geekexcel.com/easy-keyboard-shortcuts-to-select-current-array-in-excel-365/) | ctrl / | ⌃ / |
| [How to Select row differences in Excel](https://geekexcel.com/shortcut-to-select-row-differences-in-microsoft-excel-365/) | ctrl \ | ⌃ \ |
| [How to Select column differences in Excel](https://geekexcel.com/simple-shortcut-to-select-column-differences-in-microsoft-excel-365/) | ctrlshift | | ⌃ ⇧| |
| [How to Select direct precedents in Excel](https://geekexcel.com/shortcut-to-select-direct-precedents-in-ms-excel-365/) | ctrl [ | ⌃ [ |
| [How to Select all precedents in Excel](https://geekexcel.com/simple-shortcut-to-select-all-precedents-in-ms-excel-365/) | ctrl shift { | ⌃ ⇧{ |
| [How to Select direct dependents in Excel](https://geekexcel.com/quick-shortcut-to-select-direct-dependents-in-excel-365/) | ctrl ] | ⌃ ] |
| [How to Select all dependents in Excel](https://geekexcel.com/shortcut-to-select-all-dependents-in-microsoft-excel-365/) | ctrlshift } | ⌃ ⇧} |
| [How to Select visible cells only in Excel](https://geekexcel.com/shortcut-to-select-visible-cells-only-in-microsoft-excel-365/) | alt ; | ⌘ ⇧Z |

## Cell Edit Mode Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Edit the active cell in Excel](https://geekexcel.com/simple-keyboard-shortcuts-to-edit-the-active-cell-in-ms-excel-365/) | f2 | ⌃ U |
| [How to Insert or edit the comment in Excel](https://geekexcel.com/simple-shortcut-to-insert-or-edit-comment-in-excel-365/) | shift f2 | Fn ⇧F2 |
| [How to Cancel entry in Excel](https://geekexcel.com/quick-shortcut-to-cancel-entry-in-microsoft-excel-365/) | Esc | Esc |
| [How to Select one character right in Excel](https://geekexcel.com/shortcut-to-select-one-character-right-in-ms-excel-365/) | shift → | ⇧ → |
| [How to Select one character left in Excel](https://geekexcel.com/easy-shortcut-to-select-one-character-left-in-excel-365/) | shift ← | ⇧ ← |
| [How to Move one word right in Excel](https://geekexcel.com/simple-shortcut-to-move-one-word-right-in-excel-365/) | ctrl → | ⌃ → |
| [How to Move one word left in Excel](https://geekexcel.com/quick-shortcut-to-move-one-word-left-in-microsoft-excel-365/) | ctrl ← | ⌃ ← |
| [How to Select one word right in Excel](https://geekexcel.com/shortcut-to-select-one-word-right-in-microsoft-excel-365/) | ctrl shift → | ⌃ ⇧→ |
| [How to Select one word left in Excel](https://geekexcel.com/easy-keyboard-shortcuts-to-select-one-word-left-in-ms-excel-365/) | ctrl shift ← | ⌃ ⇧← |
| [How to Select to the beginning of a cell in Excel](https://geekexcel.com/simple-shortcut-for-select-to-the-beginning-of-cell-in-ms-excel-365/) | shift Home | Fn ⇧← |
| [How to Select to end of the cell in Excel](https://geekexcel.com/quick-excel-shortcut-for-select-to-end-of-cell-in-a-worksheet/) | shift end | Fn ⇧→ |
| [How to Delete to end of a line in Excel](https://geekexcel.com/shortcuts-for-delete-to-the-end-of-line-in-ms-excel-365/) | ctrl delete | ⌃ Delete |
| [How to Delete the character to the left of the cursor in Excel](https://geekexcel.com/shortcut-to-delete-character-to-the-left-of-cursor-in-excel-365/) | backspace | Delete |
| [How to Delete the character to the right of the cursor in Excel](https://geekexcel.com/easy-shortcut-to-delete-the-character-to-the-right-of-cursor-in-excel-365/) | delete | Fn Delete |
| [How to Start a new line in the same cell in Excel](https://geekexcel.com/simple-shortcut-to-start-a-new-line-in-the-same-cell-in-ms-excel-365/) | alt enter | ⌃ ⌥Return |

## Entering data Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Enter and move down in Excel](https://geekexcel.com/quick-shortcut-to-enter-and-move-down-in-microsoft-excel-365/) | Enter | Return |
| [How to Enter and move right in Excel](https://geekexcel.com/simple-shortcut-to-enter-and-move-right-in-ms-excel-365/) | tab | Tab |
| [How to Enter and move left in Excel](https://geekexcel.com/simple-keyboard-shortcut-to-enter-and-move-left-in-ms-excel-365/) | shift tab | ⇧ Tab |
| [How to Complete entry and stay in the same cell in Excel](https://geekexcel.com/shortcut-to-complete-entry-and-stay-in-the-same-cell-in-excel-365/) | ctrlEnter | ⌃ Return |
| [How to Enter the same data in multiple cells in Excel](https://geekexcel.com/shortcut-to-enter-same-data-in-multiple-cells-in-excel-365/) | ctrl Enter | ⌃ Return |
| [How to Insert a current date in Excel](https://geekexcel.com/simple-shortcut-to-insert-current-date-in-microsoft-excel-365/) | ctrl ; | ⌃ ; |
| [How to Insert current time in Excel](https://geekexcel.com/easy-keyboard-shortcut-to-insert-current-time-in-excel-365/) | ctrl shift : | ⌘ : |
| [How to Fill down from cell above in Excel](https://geekexcel.com/simple-shortcut-to-fill-down-from-cell-above-in-ms-excel-365/) | ctrl D | ⌃ D |
| [How to Fill right from cell left in Excel](https://geekexcel.com/shortcut-to-fill-down-from-the-cell-left-in-excel-365/) | ctrl r | ⌃ R |
| [How to Copy a formula from the cell above in Excel](https://geekexcel.com/shortcuts-to-copy-formula-from-cell-above-in-ms-excel-365/) | ctrl ‘ | ⌃ ‘ |
| [How to Copy value from the cell above in Excel](https://geekexcel.com/easy-shortcut-to-copy-value-from-the-cell-above-in-microsoft-excel-365/) | ctrlshift “ | ⌃ ⇧“ |
| [How to Add hyperlink in Excel](https://geekexcel.com/quick-keyboard-shortcut-to-add-hyperlink-in-ms-excel-365/) | ctrl k | ⌘K |
| [How to Display AutoComplete list in Excel](https://geekexcel.com/simple-shortcut-to-display-auto-complete-list-in-ms-excel-365/) | alt ↓ | ⌥ ↓ |
| [How to Flash fill in Excel](https://geekexcel.com/easy-keyboard-shortcut-to-flash-fill-in-microsoft-excel-365/) | ctrl e | Not Available |

## Formatting Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Format anything in Excel](https://geekexcel.com/shortcut-to-format-almost-anything-in-microsoft-excel-365/) | ctrl 1 | ⌘ 1 |
| [How to Display Format Cells with Font tab selected in Excel](https://geekexcel.com/shortcut-to-display-format-cells-with-font-tab-selected-in-ms-excel-365/) | ctrl shift F | ⌃ ⇧F |
| [How to Apply or remove bold formatting in Excel](https://geekexcel.com/simple-shortcut-to-apply-or-remove-bold-formatting-in-excel-365/) | ctrlb | ⌘ B |
| [How to Apply or remove italic formatting in Excel](https://geekexcel.com/easy-shortcut-to-apply-or-remove-italic-formatting-in-excel-365/) | ctrl I | ⌘ I |
| [How to Apply or remove underscoring in Excel](https://geekexcel.com/quick-shortcut-to-apply-or-remove-underscore-in-ms-excel-365/) | ctrl u | ⌘ U |
| [How to Apply or remove strikethrough formatting in Excel](https://geekexcel.com/shortcut-to-apply-or-remove-strike-through-formatting-in-excel-365/) | ctrl 5 | ⌘ ⇧X |
| [How to Add or remove the shadow font style in Excel](https://geekexcel.com/shortcut-to-add-or-remove-the-shadow-font-style-in-excel-365/) | Nil | ⌘ ⇧W |
| [How to Add or remove the outline font style in Excel](https://geekexcel.com/easy-shortcut-to-add-or-remove-the-outline-font-style-in-excel-365/) | Nil | ⌘ ⇧D |
| [How to Align center in Excel](https://geekexcel.com/quick-shortcut-to-align-center-in-microsoft-excel-365/) |   
alt  
h  
a  
c  
 | ⌘ E |
| [How to Align left in Excel](https://geekexcel.com/easy-keyboard-shortcut-to-align-left-in-ms-excel-365/) |   
alt  
h  
a  
l  
 | ⌘ L |
| [How to Align right in Excel](https://geekexcel.com/simple-keyboard-shortcut-to-align-right-in-ms-excel-365/) |   
alt  
h  
a  
r  
 | ⌘ R |
| [How to Indent in Excel](https://geekexcel.com/shortcut-keys-for-indent-option-in-microsoft-excel-365/) |   
alt  
h  
6  
 | ⌃ ⌥Tab |
| [How to Remove indent in Excel](https://geekexcel.com/shortcut-key-to-remove-indent-in-microsoft-excel-365/) |   
alt  
h  
5  
 | ⌃⌥⇧Tab |
| [How to Increase font size one step in Excel](https://geekexcel.com/shortcut-to-increase-font-size-one-step-in-ms-excel-365/) |   
alt  
h  
FG  
 | ⌘ ⇧> |
| [How to Decrease font size one step in Excel](https://geekexcel.com/easy-shortcut-to-decrease-font-size-one-step-in-microsoft-excel/) |   
alt  
h  
Fk  
 | ⌘ ⇧< |

## Number Formatting Options Excel Shortcuts:

| [How to Apply general format in Excel](https://geekexcel.com/shortcut-to-apply-general-format-in-ms-excel-365/) | ctrl shift ~ | ⌃ ⇧~ |
| [How to Apply currency format in Excel](https://geekexcel.com/simple-shortcut-to-apply-currency-format-in-ms-excel-365/) | ctrl shift $ | ⌃ ⇧$ |
| [How to Apply percentage format in Excel](https://geekexcel.com/simple-shortcut-keys-to-apply-percentage-format-in-ms-excel-365/) | ctrl shift % | ⌃ ⇧% |
| [How to Apply scientific format in Excel](https://geekexcel.com/shortcut-to-apply-scientific-format-in-microsoft-excel-365/) | ctrl shift ^ | ⌃ ⇧^ |
| [How to Apply date format in Excel](https://geekexcel.com/easy-keyboard-shortcuts-to-apply-date-format-in-excel-365/) | ctrl shift # | ⌃ ⇧# |
| [How to Apply time format in Excel](https://geekexcel.com/quick-shortcut-to-apply-time-format-in-microsoft-excel-365/) | ctrl shift @ | ⌃ ⇧@ |
| [How to Apply number format in Excel](https://geekexcel.com/keyboard-shortcut-to-apply-number-format-in-excel-365/) | ctrl shift ! | ⌃ ⇧! |
| [How to Show the active cell on a worksheet in Excel](https://geekexcel.com/easy-shortcut-to-show-the-active-cell-on-worksheet-in-excel-365/) | ctrl Backspace | ⌘ Delete |
| [How to Move active cell clockwise in selection in Excel](https://geekexcel.com/shortcut-to-move-active-cell-clockwise-in-selection-in-excel-365/) | ctrl . | ⌃ . |
| [How to Move active cell down in selection in Excel](https://geekexcel.com/shortcut-to-move-active-cell-down-in-selection-in-ms-excel-365/) | Enter | Return |
| [How to Move active cell up in selection in Excel](https://geekexcel.com/simple-shortcut-to-move-active-cell-up-in-selection-in-excel-365/) | shift enter | ⇧ Return |
| [How to Move active cell right in a selection in Excel](https://geekexcel.com/quick-shortcut-to-move-active-cell-right-in-a-selection-in-ms-excel-365/) | tab | Tab |
| [How to Move active cell left in a selection in Excel](https://geekexcel.com/keyboard-shortcut-to-move-the-active-cell-left-in-a-selection-in-excel-365/) | shift tab | ⇧ Tab |

## Border Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Add border outline in Excel](https://geekexcel.com/shortcut-to-add-border-outline-in-microsoft-excel-365/) | ctrl shift & | ⌘ ⌥0 |
| [How to Add or remove border right in Excel](https://geekexcel.com/simple-shortcut-to-add-or-remove-border-right-in-excel-365/) | alt r | ⌘ ⌥→ |
| [How to Add or remove border-left in Excel](https://geekexcel.com/easy-shortcut-to-add-or-remove-border-left-in-excel-365/) | alt l | ⌘ ⌥← |
| [How to Add or remove border-top in Excel](https://geekexcel.com/quick-shortcut-to-add-or-remove-border-top-in-excel-365/) | alt t | ⌘ ⌥↑ |
| [How to Add or remove border-bottom in Excel](https://geekexcel.com/shortcut-to-add-or-remove-border-bottom-in-ms-excel-365/) | alt b | ⌘⌥↓ |
| [How to Add or remove border upward diagonal in Excel](https://geekexcel.com/easy-shortcut-to-add-or-remove-border-upward-diagonal-in-excel-365/) | altd | Not Available |
| [How to Add or remove border horizontal interior in Excel](https://geekexcel.com/simple-shortcut-to-add-or-remove-border-horizontal-interior-in-excel-365/) | alt h | Not Available |
| [How to Add or remove border vertical interior in Excel](https://geekexcel.com/easy-shortcut-to-add-or-remove-border-vertical-interior-in-excel-365/) | alt v | Not Available |
| [How to Remove borders in Excel](https://geekexcel.com/easy-keyboard-shortcut-to-remove-borders-in-microsoft-excel-365/) | ctrl shift \_ | ⌘⌥\_ |

## Formula Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Toggle absolute and relative references in Excel](https://geekexcel.com/simple-shortcut-to-toggle-absolute-and-relative-references-in-excel-365/) | f4 | ⌘ T |
| [How to Open the Insert Function Dialog Box in Excel](https://geekexcel.com/shortcut-to-open-the-insert-function-dialog-box-in-ms-excel-365/) | shift f3 | Fn ⇧F3 |
| [How to Autosum selected cells in Excel](https://geekexcel.com/shortcut-to-auto-sum-selected-cells-in-microsoft-excel-365/) | alt = | ⌘ ⇧T |
| [How to Toggle formulas on and off in Excel](https://geekexcel.com/quick-shortcut-to-toggle-formulas-on-and-off-in-ms-excel-365/) | ctrl ` | ⌃ ` |
| [How to Insert function arguments in Excel](https://geekexcel.com/simple-shortcut-to-insert-function-arguments-in-excel-365/) |   
ctrl  
shift  
a  
 | ⌃ ⇧A |
| [How to Enter array formula in Excel](https://geekexcel.com/simple-shortcut-to-enter-array-formula-in-microsoft-excel-365/) |   
ctrl  
shift  
Enter  
 | ⌃ ⇧Return |
| [How to Calculate worksheets in Excel](https://geekexcel.com/quick-shortcuts-to-calculate-worksheets-in-microsoft-excel-365/) |   
f9 | Fn F9 |
| [How to Calculate active worksheet in Excel](https://geekexcel.com/simple-shortcut-to-calculate-active-worksheet-in-ms-excel-365/) |   
shift  
f9  
 | Fn ⇧F9 |
| [How to Force calculate all worksheets in Excel](https://geekexcel.com/easy-shortcut-to-force-calculate-all-worksheets-in-excel-365/) |   
ctrl  
alt  
f9  
 | Not Available |
| [How to Evaluate part of a formula in Excel](https://geekexcel.com/shortcut-to-evaluate-part-of-a-formula-in-excel-365/) |   
f9  
 | Fn F9 |
| [How to Expand or collapse the formula bar in Excel](https://geekexcel.com/shortcut-to-expand-or-collapse-the-formula-bar-in-ms-excel-365/) |   
ctrl  
shift  
u  
 | ⌃ ⇧U |
| [How to Display function arguments dialog box in Excel](https://geekexcel.com/simple-shortcut-to-display-function-arguments-dialog-box-in-excel-365/) |   
ctrl  
a  
 | ⌃ A |
| [How to Define a name in Excel](https://geekexcel.com/a-simple-shortcut-to-define-name-in-microsoft-excel-365/) |   
ctrl  
f3  
 | Fn ⌃F3 |
| [How to Define name using row and column labels in Excel](https://geekexcel.com/shortcut-to-define-name-using-row-and-column-labels-in-excel-365/) |   
ctrl  
shift  
f3  
 | Fn⌃⇧F3 |
| [How to Paste name into a formula in Excel](https://geekexcel.com/a-simple-shortcut-to-paste-name-into-formula-in-ms-excel-365/) |   
f3  
 | Not Available |
| [How to Accept function with autocomplete in Excel](https://geekexcel.com/shortcut-to-accept-function-with-autocomplete-in-excel-365/) |   
tab  
 | ↓ Tab |

## Grid Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Display Insert Dialog box in Excel](https://geekexcel.com/quick-shortcut-to-display-insert-dialog-box-in-microsoft-excel-365/) | ctrlshift+ | ⌘ ⇧+ |
| [How to Insert rows in Excel](https://geekexcel.com/easy-shortcut-to-insert-rows-in-microsoft-excel-365/) | ctrlshift+ | ⌘ ⇧+ |
| [How to Insert columns in Excel](https://geekexcel.com/simple-shortcut-to-insert-columns-in-ms-excel-365/) | ctrlshift+ | ⌘ ⇧+ |
| [How to Display Delete dialog box in Excel](https://geekexcel.com/easy-keyboard-shortcut-to-display-delete-dialog-box-in-excel-365/) | ctrl – | ⌘ – |
| [How to Delete rows in Excel](https://geekexcel.com/simple-shortcut-to-delete-rows-in-microsoft-excel-365/) | ctrl – | ⌘ – |
| [How to Delete columns in Excel](https://geekexcel.com/simple-shortcut-to-delete-columns-in-microsoft-excel-365/) | ctrl – | ⌘ – |
| [How to Delete cells in Excel](https://geekexcel.com/quick-shortcut-to-delete-cells-in-microsoft-excel-365/) | ctrl – | ⌘ – |
| [How to Delete the contents of selected cells in Excel](https://geekexcel.com/shortcut-to-delete-contents-of-selected-cells-in-excel-365/) | Delete | Fn Delete |
| [How to Hide columns in Excel](https://geekexcel.com/simple-shortcut-to-hide-columns-in-microsoft-excel-365/) | ctrl 0 | ⌃ 0 |
| [How to Hide rows in Excel](https://geekexcel.com/quick-keyboard-shortcut-to-hide-rows-in-ms-excel-365/) | ctrl 9 | ⌃ 9 |
| [How to Unhide rows in Excel](https://geekexcel.com/simple-shortcut-to-unhide-rows-in-microsoft-excel-365/) | ctrl shift 9 | ⌃ ⇧9 |
| [How to Unhide Columns in Excel](https://geekexcel.com/easy-keyboard-shortcuts-to-unhide-columns-in-excel-365/) | ctrl shift 0 | ⌃ ⇧0 |
| [How to Group rows or columns in Excel](https://geekexcel.com/shortcut-to-group-rows-or-columns-in-ms-excel-365/) | alt shift → | ⌘ ⇧K |
| [How to Ungroup rows or columns in Excel](https://geekexcel.com/quick-shortcut-to-ungroup-rows-or-columns-in-ms-excel-365/) | alt shift ← | ⌘ ⇧J |
| [How to Open Group Dialog Box in Excel](https://geekexcel.com/shortcut-to-open-group-dialog-box-in-microsoft-excel-365/) | alt shift → | ⌘ ⇧K |
| [How to Open Ungroup Dialog Box in Excel](https://geekexcel.com/excel-keyboard-shortcuts-to-open-ungroup-dialog-box/) | alt shift ← | ⌘ ⇧J |
| [How to Hide or Show outline symbols in Excel](https://geekexcel.com/simple-shortcut-to-hide-or-show-outline-symbols-in-ms-excel-365/) | ctrl 8 | ⌃ 8 |
| [How to Zoom in in Excel](https://geekexcel.com/a-simple-keyboard-shortcut-keys-to-zoom-in-the-worksheet-in-excel-365/) | ctrl alt + | ⌥ ⌘+ |
| [How to Zoom out in Excel](https://geekexcel.com/shortcut-to-zoom-out-the-worksheet-in-microsoft-excel-365/) | ctrl alt – | ⌥ ⌘– |

## Pivot Tables Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Select the entire pivot table in Excel](https://geekexcel.com/simple-keyboard-shortcut-to-select-entire-pivot-table-in-excel-365/) | ctrl a | ⌘ A |
| [How to Toggle pivot table field checkbox in Excel](https://geekexcel.com/shortcut-to-toggle-pivot-table-field-checkbox-in-ms-excel-365/) | space | Space |
| [How to Group pivot table items in Excel](https://geekexcel.com/quick-shortcut-to-group-pivot-table-items-in-excel-365/) | alt shift → | ⌘ ⇧K |
| [How to Ungroup pivot table items in Excel](https://geekexcel.com/shortcut-to-ungroup-pivot-table-items-in-microsoft-excel-365/) | alt shift ← | ⌘ ⇧J |
| [How to Hide pivot table item in Excel](https://geekexcel.com/shortcut-to-hide-pivot-table-items-in-microsoft-excel-365/) | ctrl – | Ctrl – |
| [How to Create a pivot chart on the same worksheet in Excel](https://geekexcel.com/easy-shortcut-to-create-pivot-chart-on-same-worksheet-in-excel-365/) | alt f1 | Not Available |
| [How to Create a pivot chart on a new worksheet in Excel](https://geekexcel.com/shortcut-to-create-pivot-chart-on-new-worksheet-in-ms-excel-365/) | f11 | Fn F11 |
| [How to Create a pivot chart on a new worksheet in Excel](https://geekexcel.com/simple-shortcut-to-open-pivot-table-wizard-in-excel-365/) | alt d p | ⌘ ⌥P |

## Workbook Options Excel Shortcuts:

| [How to Insert new worksheet in Excel](https://geekexcel.com/easy-and-quick-shortcut-to-insert-new-worksheet-in-ms-excel-365/) | Shiftf11 | Fn ⇧F11 |
| [How to Go to next worksheet in Excel](https://geekexcel.com/a-simple-shortcut-for-go-to-the-next-worksheet-in-ms-excel-365/) | ctrl pg.dn | Fn ⌃↓ |
| [How to Go to the previous worksheet in Excel](https://geekexcel.com/simple-shortcut-for-go-to-the-previous-worksheet-in-excel-365/) | ctrl pg.up | Fn ⌃↑ |
| [How to Move to next pane in Excel](https://geekexcel.com/easy-keyboard-shortcut-keys-to-move-to-the-next-pane-in-excel-365/) | shiftf6 | Fn ⇧F6 |
| [How to Go to next workbook in Excel](https://geekexcel.com/shortcut-to-go-to-the-next-workbook-in-ms-excel-365/) | ctrl tab | ⌃ Tab |
| [How to Go to the previous workbook in Excel](https://geekexcel.com/shortcut-to-go-to-the-previous-workbook-in-ms-excel-365/) | ctrl shift tab | ⌃ ⇧Tab |
| [How to Minimize the current workbook window in Excel](https://geekexcel.com/quick-shortcut-to-minimize-current-workbook-window-in-excel-365/) | ctrl f9 | ⌘M |
| [How to Maximize the current workbook window in Excel](https://geekexcel.com/shortcut-to-maximize-current-workbook-window-in-microsoft-excel-365/) | ctrl f10 | Fn ⌃F10 |
| [How to Select adjacent worksheets in Excel](https://geekexcel.com/simple-shortcut-to-select-adjacent-worksheets-in-ms-excel-365/) | shift Click | ⇧ Click |
| [How to Select non-adjacent worksheets in Excel](https://geekexcel.com/easy-shortcut-to-select-non-adjacent-worksheets-in-excel-365/) | ctrl Click | ⌘ Click |
| [How to Toggle scroll lock in Excel](https://geekexcel.com/easy-keyboard-shortcut-to-toggle-scroll-lock-in-ms-excel-365/) | Scrlk | Fn ⇧F14 |
| [How to Toggle full screen in Excel](https://geekexcel.com/simple-shortcut-to-toggle-full-screen-in-excel-365/) | ctrl shift f1 | ⌃ ⌘F |

## Dialog Boxes Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Move to the next control in Excel](https://geekexcel.com/simple-shortcut-to-move-to-the-next-control-in-ms-excel-365/) | tab | Tab |
| [How to Move to the previous control in Excel](https://geekexcel.com/easy-shortcut-to-move-to-the-previous-control-in-excel-365/) | shift tab | ⇧ Tab |
| [How to Move to the next tab in Excel](https://geekexcel.com/shortcut-to-move-to-the-next-tab-in-microsoft-excel-365/) | ctrl tab | ⇧ Tab |
| [How to Move to the previous tab in Excel](https://geekexcel.com/quick-shortcut-to-move-to-the-previous-tab-in-ms-excel-365/) | ctrl shift tab | ⌃ ⇧Tab |
| [How to Accept and apply in Excel](https://geekexcel.com/shortcut-to-accept-and-apply-in-the-dialog-box-in-excel-365/) | Enter | Retrn |
| [How to Check and uncheck the box in Excel](https://geekexcel.com/shortcut-to-check-and-uncheck-the-box-in-microsoft-excel-365/) | space | Space |
| [How to Cancel and close the dialog box in Excel](https://geekexcel.com/shortcut-to-cancel-and-close-the-dialog-box-in-excel-365/) | Esc | Esc |

## Other Options Excel Shortcuts:

| Options | Windows | Mac |
| --- | --- | --- |
| [How to Open Spelling dialog box in Excel](https://geekexcel.com/simple-shortcut-to-open-spelling-dialog-box-in-ms-excel-365/) | f7 | Fn F7 |
| [How to Open Thesaurus dialog box in Excel](https://geekexcel.com/shortcut-to-open-thesaurus-dialog-box-in-ms-excel-365/) | shift f7 | Fn ⇧F7 |
| [How to Open Macro dialog box in Excel](https://geekexcel.com/shortcut-to-open-macro-dialog-box-in-microsoft-excel-365/) | alt f8 | Fn ⌥F8 |
| [How to Open VBA Editor in Excel](https://geekexcel.com/shortcut-to-open-vba-editor-in-microsoft-excel-365/) | alt f11 | Fn ⌥F11 |
| [How to Duplicate object in Excel](https://geekexcel.com/easy-keyboard-shortcut-to-duplicate-object-in-ms-excel-365/) | ctrl D | ⌘ D |
| [How to Snap to the grid in Excel](https://geekexcel.com/a-simple-shortcut-for-snap-to-grid-in-microsoft-excel-365/) | alt | ⌘ |
| [How to Hide or show objects in Excel](https://geekexcel.com/easy-shortcuts-to-hide-or-show-objects-in-ms-excel-365/) | ctrl 6 | ⌃ 6 |
| [How to Display Modify Cell Style dialog box in Excel](https://geekexcel.com/shortcut-keys-to-display-modify-cell-style-dialog-box-in-excel-365/) | alt ‘ | ⌘ ⇧L |
| [How to Display the right-click menu in Excel](https://geekexcel.com/quick-shortcut-to-display-right-click-menu-in-excel-365/) | Shift f10 | Fn ⇧F10 |
| [How to Delete a comment in Excel](https://geekexcel.com/shortcut-to-delete-comment-in-microsoft-excel-365/) | Shift f10D | Fn ShiftF10 |
| [How to Display control menu in Excel](https://geekexcel.com/easy-shortcut-to-display-control-menu-in-ms-excel-365/) | alt space | ? |
| [How to Move to the previous tab in Excel](https://geekexcel.com/quick-shortcut-to-move-to-the-previous-tab-in-ms-excel-365/) | ctrl shift tab | ⌃ ⇧Tab |
| [How to Accept and apply in Excel](https://geekexcel.com/shortcut-to-accept-and-apply-in-the-dialog-box-in-excel-365/) | Enter | Return |
| [How to Check and uncheck the box in Excel](https://geekexcel.com/shortcut-to-check-and-uncheck-the-box-in-microsoft-excel-365/) | space | Space |
| [How to Cancel and close the dialog box in Excel](https://geekexcel.com/shortcut-to-cancel-and-close-the-dialog-box-in-excel-365/) | Esc | Esc |