Shortcut to Display Quick Analysis Options in Excel:
In this guide, you will learn the shortcut to Display Quick Analysis Options in Excel Office 365.
Shortcut Keys:
The below-given shortcut keys are used to display quick analysis options in Excel for both the Windows and MAC devices.
| Windows Shortcut |
| CTRLQ |
| MAC Shortcut |
| Not Available |
Shortcut Description:
- This shortcut key is used to display the quick analysis options in Excel.
- To do this, you need to press ( CTRL + Q ) keys, and then it will display the quick analysis options as below example image.
Closure:
In this guide, you can clearly understand the shortcut to Display Quick Analysis Options in Excel Office 365 for both the Windows and MAC Operating systems. Kindly, leave your feedback in the comment section. Thanks for visiting Geek Excel. 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
Excel 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 more efficiently. In this article, we list the 222+ Keyboard shortcuts of Excel software on the Windows system.
Download 220+ Excel Shortcuts PDF:
File Options Excel 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 Excel 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 Excel Shortcuts:
| Options | Windows | Mac |
|---|---|---|
| How to open options in Excel | ALTFT | ⌘ , |
| 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 ALTV | ⌘ ⌃V |
| How to display find and replace in Excel | ctrlf | ⌘ F |
| How to display find and replace, replace selected in Excel | ctrlh | ⌃ H |
| How to Find the previous match in Excel | ctrlshiftf4 | ⌘ ⇧G |
| How to Find the next match in Excel | Shiftf4 | ⌘ 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 Excel Shortcuts:
| Options | Windows | Mac |
|---|---|---|
| How to insert a table in Excel | ctrl t | ⌃ T |
| How to toggle auto filter in Excel | ctrlshiftl | ⌘ ⇧F |
| How to activate filter in Excel | Alt↓ | ⌥ ↓ |
| How to select a table row in Excel | shiftspace | ⇧Space |
| How to select the table column in Excel | ctrlSpace | ⌃ Space |
| How to select a table in Excel | ctrl a | ⌘ A |
| How to clear the slicer filter in Excel | altc | ⌥ C |
| How to toggle table total row in Excel | ctrlshiftt | ⌘ ⇧T |
Drag & Drop Options Excel Shortcut:
| Options | Windows | Mac |
|---|---|---|
| How to Drag and cut in Excel | drag | Drag |
| How to Drag and copy in Excel | ctrldrag | ⌥ Drag |
| How to Drag & Insert in Excel | shiftdrag | ⇧ Drag |
| How to Drag and insert copy in Excel | ctrlshiftdrag | ⌥ ⇧Drag |
| How to Drag to a worksheet in Excel | ctrldrag | ⌥Drag |
| How to Drag to duplicate worksheet in Excel | altdrag | ⌘ Drag |
Navigation Options Excel 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 Excel Shortcut:
| Options | Windows | Mac |
|---|---|---|
| How to Select an entire row in Excel | shift space | ⇧ 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 Excel Shortcuts:
| How to Select an active cell only in Excel | shift Backspace |
⇧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 Excel Shortcut:
Select Special Options Excel Shortcuts:
| Options | Windows | Mac |
|---|---|---|
| How to Display ‘ Go-To ‘ dialog box in Excel | ctrl g | ⌃ G |
| How to Select cells with comments in Excel | ctrlshift o | 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 | ctrl shift { | ⌃ ⇧{ |
| 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 Excel Shortcuts:
| Options | Windows | Mac |
|---|---|---|
| How to Edit the active cell in Excel | f2 | ⌃ U |
| How to Insert or edit the comment in Excel | shift f2 | 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 | ctrl shift → | ⌃ ⇧→ |
| How to Select one word left in Excel | ctrl shift ← | ⌃ ⇧← |
| How to Select to the beginning of a cell in Excel | shift Home | Fn ⇧← |
| How to Select to end of the cell in Excel | shift end | Fn ⇧→ |
| How to Delete to end of a line in Excel | ctrl delete | ⌃ 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 | Fn Delete |
| How to Start a new line in the same cell in Excel | alt enter | ⌃ ⌥Return |
Entering data Options Excel 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 | shift tab | ⇧ 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 | ctrl Enter | ⌃ Return |
| How to Insert a current date in Excel | ctrl ; | ⌃ ; |
| How to Insert current time in Excel | ctrl shift : | ⌘ : |
| How to Fill down from cell above in Excel | ctrl D | ⌃ D |
| How to Fill right from cell left in Excel | ctrl r | ⌃ 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 | ctrl k | ⌘K |
| How to Display AutoComplete list in Excel | alt ↓ | ⌥ ↓ |
| How to Flash fill in Excel | ctrl e | Not Available |
Formatting Options Excel Shortcuts:
| Options | Windows | Mac |
|---|---|---|
| How to Format anything in Excel | ctrl 1 | ⌘ 1 |
| How to Display Format Cells with Font tab selected in Excel | ctrl shift F | ⌃ ⇧F |
| How to Apply or remove bold formatting in Excel | ctrlb | ⌘ B |
| How to Apply or remove italic formatting in Excel | ctrl I | ⌘ I |
| How to Apply or remove underscoring in Excel | ctrl u | ⌘ U |
| How to Apply or remove strikethrough formatting in Excel | ctrl 5 | ⌘ ⇧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 |
alt
h
a
c
| ⌘ E |
| How to Align left in Excel |
alt
h
a
l
| ⌘ L |
| How to Align right in Excel |
alt
h
a
r
| ⌘ R |
| How to Indent in Excel |
alt
h
6
| ⌃ ⌥Tab |
| How to Remove indent in Excel |
alt
h
5
| ⌃⌥⇧Tab |
| How to Increase font size one step in Excel |
alt
h
FG
| ⌘ ⇧> |
| How to Decrease font size one step in Excel |
alt
h
Fk
| ⌘ ⇧< |
Number Formatting Options Excel Shortcuts:
| How to Apply general format in Excel | ctrl shift ~ | ⌃ ⇧~ |
| How to Apply currency format in Excel | ctrl shift $ | ⌃ ⇧$ |
| How to Apply percentage format in Excel | ctrl shift % | ⌃ ⇧% |
| How to Apply scientific format in Excel | ctrl shift ^ | ⌃ ⇧^ |
| How to Apply date format in Excel | ctrl shift # | ⌃ ⇧# |
| How to Apply time format in Excel | ctrl shift @ | ⌃ ⇧@ |
| How to Apply number format in Excel | ctrl shift ! | ⌃ ⇧! |
| How to Show the active cell on a worksheet in Excel | ctrl Backspace | ⌘ 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 | shift enter | ⇧ 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 | shift tab | ⇧ Tab |
Border Options Excel Shortcuts:
| Options | Windows | Mac |
|---|---|---|
| How to Add border outline in Excel | ctrl shift & | ⌘ ⌥0 |
| How to Add or remove border right in Excel | alt r | ⌘ ⌥→ |
| How to Add or remove border-left in Excel | alt l | ⌘ ⌥← |
| How to Add or remove border-top in Excel | alt t | ⌘ ⌥↑ |
| How to Add or remove border-bottom in Excel | alt b | ⌘⌥↓ |
| How to Add or remove border upward diagonal in Excel | altd | Not Available |
| How to Add or remove border horizontal interior in Excel | alt h | Not Available |
| How to Add or remove border vertical interior in Excel | alt v | Not Available |
| How to Remove borders in Excel | ctrl shift _ | ⌘⌥_ |
Formula Options Excel 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 Excel 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 Excel 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 Excel 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 Excel 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 Excel 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 |
Top comments (0)