Top 100+ Excel Shortcut Keys List (A to Z) (original) (raw)
Last Updated : 20 Mar, 2026
Ms Excel offers hundreds of keyboard shortcuts that help users work faster and more efficiently. Instead of navigating through menus with a mouse, Excel shortcut keys allow you to quickly perform tasks like formatting cells, managing worksheets, entering data, and creating charts or PivotTables.
List of All Excel Shortcut Keys
Here below we have provided all the Excel shortcut keys that will make your work fast and efficient:
Basic Shortcuts in Excel
These are the Shortcuts that are used to perform some basic tasks such as opening help, undoing, redoing the last action, and many more.
| Shortcuts | Descriptions |
|---|---|
| F1 | To open Help |
| Ctrl + Z | To Undo the last action |
| Ctrl + Y | To redo the last action |
| Ctrl + C | To copy the Selected data |
| F4 | To Repeat the last action |
| Ctrl +X | To cut the selected data |
| Ctrl + V | To paste the Content from the clipboard |
| Ctrl + Alt + V | To display the paste special dialog box |
| Ctrl+ F | To display the find and replace with the find tab selected |
| Ctrl + H | To display the find and replace with the Replace tab selected |
| Ctrl+ Shift + F4 | Find the previous match |
| Shift +F4 | Find the next match |
| Alt + F1 | Insert Embedded chart |
| F11 | Insert a chart in a new sheet |
| Ctrl + Shift + L | Toggle Auto filter |
| Alt + (Arrow down button) | Activate Filter |
| Ctrl + T or Ctrl + L | Create Table |
| Shift + Space | Select Table row |
| Ctrl + Space | Select Table column |
| Ctrl + A | Select the table when the active cell is in the table |
| Clear Slicer Filter | Atl + C |
| Run Spellcheck | F7 |
| Open the Macro Dialog box | Alt + F8 |
| Open VBA Editor | Alt + F11 |
| Duplicate object, Formula, Text | Ctrl + D |
| Snap to grid | Alt |
| Hide or show objects | Ctrl + 6 |
| Open modify cell style dialog box | Alt + ' |
| Show right-click menu | Shift + F10 |
| Display control menu | Alt Space |
Excel Worksheet Shortcut keys
The worksheet is a collection of cells, where you can store and manipulate data. By default, every workbook contains at least one worksheet in it. It is easier to organize and locate information in your workbook by using multiple worksheets when working with huge data. Excel key commands will help you to work with large data in less amount of time. For exiting the worksheet, Renaming the worksheet, and many more.
Below are some shortcuts for worksheet:
| Shortcuts | Description |
|---|---|
| Shift + F11 | Insert a new worksheet |
| Ctrl +PgDn | Go to the next Worksheet |
| Ctrl + PgUp | Go to the previous worksheet |
| Alt +O, H, R | Rename current worksheet |
| Alt + E, L | Delete current worksheet |
| Alt + E, M | Move Current Worksheet |
| F6 or Shift + F6 | Move between the worksheet, Ribbon, Task pane, and zoom controls in a worksheet that has been split |
| Ctrl + Shift + PgUp/PgDn | Select adjacent worksheet |
| Ctrl + Click | Select non-adjacent worksheets |
| Scrlk | Toggle Scroll Lock |
| Ctrl +Shift + F1 | Toggle fullscreen |
| Ctrl + P | |
| Ctrl + F2 | Open print preview window |
| Alt + P, R, S | Set Print area |
| Alt + P + R,C | Clear Print area |
| Ctrl + Mouse Wheel up | Zoom in |
| Ctrl + Mouse Wheel Down | Zoom in |
| Alt + R, P, S | Zoom in |
These shortcuts make navigation easier and speed up your data entry. For example, using **Ctrl + S frequently ensures your data is saved without the need to manually click the save button.
Excel Workbook Shortcut Keys
Learning how to manage your workbooks efficiently can be a game-changer. Here are some key Excel shortcut commands to save, create, and navigate through your workbooks:
The term workbook refers to the entire Excel file.
| Shortcuts | Descriptions |
|---|---|
| Ctrl + N | This will create a new workbook |
| Ctrl + O | This will open an existing workbook |
| Ctrl + S | This will save a workbook |
| Ctrl + W | This will Close the current workbook |
| Ctrl + F4 | This will Close Excel |
| Ctrl + PageDown | This will move to the next sheet |
| Ctrl + PageUp | To move to the previous sheet |
| Ctrl + A | To go to the Data tab |
| Ctrl + W | To go to the View tab |
| Alt + M | To go to the Formula tab |
| Ctrl + Z | This will undo your most recent action. |
| Ctrl + Y | This will Redo your most recent action. |
| Ctrl + Shift + F1 | Toggle full screen |
Shortcuts keys for Ribbon in Excel
The ribbon in Excel is the row of tabs and icons at the top of the Excel window that allows us to quickly find, understand and use commands for completing a certain task.
| Shortcut | Description |
|---|---|
| Ctrl +F1 | Expand and collapse Ribbon |
| Alt | Activate access keys |
| Space or Enter | Activate or open selected Control |
| Enter | Confirm control change |
| F1 | Get help with selected control |
Drag and Drop Shortcuts in Excel
Here are the Drag and Drop Shortcut keys in Excel:
| Shortcuts | Description |
|---|---|
| Drag | Drag and cut |
| Ctrl + Drag | Drag and copy |
| Shift + Drag | Drag and insert |
| Ctrl + Shift + Drag | Drag and insert copy |
| Alt + Drag | Drag to Worksheet |
| Ctrl + Drag | Drag to duplicate Worksheet |
Shortcuts Keys for Navigation in Excel
The navigation pane in Excel is an easy way to understand a workbook's layout, see what elements are there in the workbook, and navigate directly to those elements.
| Shortcuts | Description |
|---|---|
| Right side arrow | Move one cell Right |
| Left side arrow | Move one cell Left |
| Upward arrow | Move one cell up |
| Downward arrow | Move one cell down |
| Alt + PgDn | Move one screen Right |
| Alt + PgUp | Move one screen Left |
| PgUp | Move one screen up |
| PgDn | Move one screen down |
| Ctrl + Right Arrow | Move to the right edge of the data region |
| Ctrl + Left Arrow | Move to the left edge of the data region |
| Ctrl + Upward arrow | Move to the top edge of the data region |
| Ctrl + Downward arrow | Move to the bottom edge of the data region |
| Home | Move to the beginning of Row |
| Ctrl + End | Move to the last cell in the Worksheet that contains the data |
| Ctrl + Home | Move to the first cell in the Worksheet |
| End | Turn end mode on |
Excel Shortcut keys for Active Cell
The active cell is the cell in the worksheet on which the task is being performed. There are various functions that can be performed on Active cell for which below are the shortcut keys:
| Shortcuts | Descriptions |
|---|---|
| Shift + Backspace | Select the active cell( when multiple cells already selected0 |
| Ctrl + Backspace | Show the active cell on the worksheet |
| Ctrl +. | Move active cell clockwise to corners of the selection |
| Enter | Move the active cell down in the selection- wrap to the next column |
| Shift + Enter | Move active cells up in selection - wrap to the previous column |
| Tab | Move active cell right in a selection - Wrap to next row |
| Shift + Tab | Move active cell left in a selection - Wrap to the previous row |
Excel Shortcut keys for Selection
There is various operation that takes a lot of time, We can do them with a simple click using shortcuts as mentioned below:
| Shortcuts | Descriptions |
|---|---|
| Shift + Space | Select the entire row |
| Ctrl + Space | Select entire column |
| Ctrl + A | Select the current region if the worksheet contains data. Press again to select the current region and summary rows. Press again to select the entire worksheet. |
| Shift + Click | Expand Selection |
| Ctrl + Click | Add nonadjacent cells to the selection |
| Ctrl + Alt + Right Side arrow | Move right between non- Adjacent selections |
| Ctrl + Alt + Left side arrow | Move left between non-adjacent selections |
| Shift +F8 | Toggle the 'Add to selection' mode |
| Esc | Exit the 'Add to selection ' mode |
Shortcut Keys for Cell Edit Mode in Excel
Excel Shortcut Keys for Cell Edit Mode are mentioned below:
| Shortcuts | Descriptions |
|---|---|
| F2 | Edit active cell |
| Shift +F2 | Insert or edit the comment |
| Shift + F10 ,M | Delete comment |
| Esc | Cancel Editing |
| Shift + Right Side Arrow | Select one character right |
| Shift + Left Side arrow | Select one character Left |
| Ctrl + Right side Arrow | Move one word right |
| Ctrl + Left side Arrow | Move one word left |
| Ctrl + Shift +Right arrow | Select one word right |
| Ctrl + Shift + Left arrow | Select one word left |
| Shift +Home | Select the beginning of the cell |
| Shift + End | Select to end of the cell |
| Ctrl + Delete | Delete to end of line |
| Backspace | Delete the character to the left of the cursor |
| Delete | Delete the character to the right of the cursor |
| Alt +Enter | Start a new line in the same cell |
Excel Shortcut Keys to Enter data
You may need to reenter the data again and again whenever you need to perform the Calculations to make your work easy and fast below are some shortcut keys that can be used to enter the data.
| Shortcuts | Description |
|---|---|
| Enter | Enter data and move down |
| Shift + Enter | Enter data and move up |
| Tab | Enter data and move right |
| Shift +Tab | Enter data and move left |
| Ctrl + Enter | Enter data and stay in the same cell |
| Enter | Enter the same data in multiple cells |
| Ctrl + ; | Insert current date |
| Ctrl + Shift + : | Insert current Time |
| Ctrl + D | Fill down from the cell Above |
| Ctrl + R | Fill right from the cell on the left |
| Ctrl + ' | Copy the formula from the cell above(the formula is an exact copy) |
| Ctrl +Shift + " | Copy value from the cell above |
| Ctrl + K | Insert hyperlink |
| Alt + Arrow down | Display AutoComplete list |
Cell Formatting Shortcut Keys
Excel shortcut keys for Cell Formatting are listed below:
| Shortcuts | Description |
|---|---|
| Ctrl + 1 | Format cells |
| Ctrl + Shift + F | Display format cells with font tab selected |
| Ctrl + B | Apply or remove bold |
| Ctrl + I | Apply or remove italics |
| Ctrl + U | Apply or remove the underscore |
| Ctrl + 5 | Apply or remove the strikethrough |
| Alt + H, A, C | Align center |
| Alt + H, A, L | Align left |
| Alt+ H, A, R | Align right |
| Alt + H, 6 | Indent |
| Alt+ H, 5 | Remove Indent |
| Alt + H, W | Wrap text |
| Alt + H, A, T | Align top |
| Alt + H, A, M | Align Middle |
| Alt + H, A, B | Align bottom |
| Alt + H, F, G | Increase font size by one step |
| Alt + H, F, K | Decrease font size by one step |
Row and Column Formatting Shortcut Keys
We will explore how to delete rows and columns, hide and unhide selected rows and columns, as well as how to group and ungroup them.
| Shortcuts | Description |
|---|---|
| Ctrl + Shift + + | Insert new row or column |
| Ctrl + - | Delete the selected row or column |
| Alt + H, O, H | Hide the selected row or column |
| Alt + H, O, U | Unhide the selected row or column |
| Ctrl + Space | Select the entire column |
| Shift + Space | Select the entire row |
**Shortcut Keys for Insert & Layout in Excel
| Shortcuts | Description |
|---|---|
| Alt +N+T | To insert table |
| Alt +N+P | To insert picture |
| Alt +N+S+H | To insert shape |
| Alt +N+S+C | To insert Chart |
| Alt +N+I | To insert hyperlink |
| Alt +N+X | To insert a text box |
| Alt +N+U | To insert Symbol |
| Alt +N+H | To insert header and footer |
| Alt +W+F+C | To Create a custom View |
Apply Borders in Excel Using Shortcut
Excel Shortcut Keys to apply borders are listed below:
| Shortcuts | Descriptions |
|---|---|
| Alt + H + B | To open a list of borders styles from ribbon |
| Ctrl + Shift + & | Add a border around selected cells |
| Alt + H +B,R | Add or remove the right border |
| Alt + H, B, L | Add or remove the left border |
| Alt +H, B, P | Add or remove the top border |
| Alt + H, B, O | Add or remove the bottom border |
| Alt + H, B, A | Add all borders to all cells in the selection |
| Ctrl + Shift + - | Remove borders |
Excel Shortcut Keys for Pivot Tables
Here are some of the Excel Shortcut keys for Pivot Tables:
| Shortcuts | Descriptions |
|---|---|
| Alt + N+ V | Create pivot table |
| Ctrl + A | Select entire pivot table |
| Alt + Shift + Right arrow | Group pivot table |
| Alt + Shift + Left arrow | Ungroup Pivot table items |
| Ctrl + - | Hide (Filter out) pivot table item |
| Alt + H,S,C | Unhide (clear filter on) pivot table item |
| Alt +N,S,Z,C | Insert pivot chart. |