Excel Shortcuts
{230+} Excel SHORTCUTS List for Windows & MAC- 2025 Edition!
Essential Excel Shortcuts List for Windows and Mac Users!
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.
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.
Recently Published Tutorials:
- Excel File Options Shortcuts List & It’s Explanations!
- How to Use Excel YEAR Function?
- How to Use Excel WEEKNUM Function?
- How to Use Excel NETWORKDAYS.INTL Function?
- How to Use Excel NOW Function?
Follow Us
