Do you want to increase productivity while working with Microsoft Excel? Excel shortcuts are one of the most powerful tools to help you master Excel and take your skills to the next level. This article will help you learn excel shortcuts to help you become an Excel pro in no time!
What are excel shortcuts?
Excel shortcuts are key combinations that allow you to perform tasks efficiently.
For example,
- The Excel keyboard shortcut to copy and paste is Ctrl + C, and Ctrl + V.
- CTRL+F is the Excel shortcut to find
- Learning these shortcuts are important to understand as they help you save a lot of time.
List of Excel Shortcuts:
If you want to become an Excel pro, you must learn the Excel shortcuts. To help you get started, here is a list of the most important Excel shortcuts by category.
List of Top 50 Must Know Excel Shortcuts:
| Shortcut | Description |
| Ctrl + C | Copy |
| Ctrl + X | Cut |
| Ctrl + V | Paste |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + A | Select All |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Ctrl + F | Find |
| Ctrl + H | Replace |
| Ctrl + N | New Workbook |
| Ctrl + O | Open |
| Ctrl + S | Save |
| Ctrl + P | |
| Ctrl + W | Close Workbook |
| Ctrl + T | New Worksheet |
| Ctrl + R | Fill Right |
| Ctrl + D | Fill Down |
| Ctrl + L | AutoFit Column Width |
| Ctrl + K | Insert Hyperlink |
| Ctrl + ; | Insert Date |
| Ctrl + Shift + ; | Insert Time |
| Ctrl + Enter | Fill Selected Cells with Same Data |
| Ctrl + Shift + Enter | Insert New Line in Cell |
| Ctrl + Space bar | Select Entire Column |
| Ctrl + Shift + Space bar | Select Entire Row |
| Ctrl + Tab | Move to Next Sheet |
| Ctrl + Shift + Tab | Move to Previous Sheet |
| Ctrl + [ | Go to cell that contains specific data |
| Ctrl + ] | Go to next cell that contains specific data |
| Ctrl + Page Up | Move to Previous Worksheet |
| Ctrl + Page Down | Move to Next Worksheet |
| Ctrl + Home | Move to First Cell of Worksheet |
| Ctrl + End | Move to Last Cell of Worksheet |
| Ctrl + Shift + Arrow Key | Select Multiple Cells |
| Ctrl + F1 | Show/Hide Ribbon |
| Ctrl + Shift + ! | Apply Number Format |
| Ctrl + Shift + $ | Apply Currency Format |
| Ctrl + Shift + # | Apply Date Format |
| Ctrl + Shift + % | Apply Percentage Format |
| Ctrl + Shift + ^ | Apply Scientific Notation |
| Ctrl + Shift + & | Apply Outline Border |
| Ctrl + Shift + @ | Apply Time Format |
| Ctrl + Alt + V | Paste Special |
| Ctrl + ; | Repeat Last Action |
| Ctrl + Alt + F1 | Create New Chart |
| Ctrl + Alt + I | Insert New Picture |
| Ctrl + Alt + D | Create Pivot Table |
| Ctrl + Alt + W | Apply Auto filter |
List of Excel Worksheet Related Shortcuts:
| Shortcut | Description |
| Ctrl + Home | Go to cell A1 |
| Ctrl + End | Go to the last cell in the worksheet |
| Ctrl + Shift + Home | Select all cells from the current cell to A1 |
| Ctrl + Shift + End | Select all cells from the current cell to the last cell in the worksheet |
| Ctrl + Tab | Move between worksheets in a workbook |
| Ctrl + Page Down | Move to the next worksheet |
| Ctrl + Page Up | Move to the previous worksheet |
| Ctrl + Page Up | Move to the previous worksheet in the workbook. |
| Ctrl + Page Down | Move to the next worksheet in the workbook. |
| Ctrl + Home | Move to the first cell in the worksheet (A1). |
| Ctrl + End | Move to the last cell in the worksheet with data. |
| Ctrl + Tab | Move between open workbooks. |
| Alt + Page Up | Move one screen to the left in the worksheet. |
| Alt + Page Down | Move one screen to the right in the worksheet. |
| Alt + Home | Move to the first cell in the row. |
| Alt + End | Move to the last cell in the row. |
| Ctrl + Arrow key | Move to the last non |
| Ctrl + Shift + Arrow key | Select all cells between the current cell and the last non |
| Ctrl + Space bar | Select the entire column. |
| Shift + Space bar | Select the entire row. |
| Ctrl + Shift + Home | Select all cells from the current cell to the first cell in the worksheet. |
| Ctrl + Shift + End | Select all cells from the current cell to the last cell with data in the worksheet. |
| Ctrl + Shift + Page Up | Select multiple worksheets. |
| Ctrl + Shift + Page Down | Select multiple worksheets. |
| Ctrl + A | Select all cells in the worksheet. |
| Ctrl + Shift + + | Select all cells with data in the adjacent columns and rows. |
| Ctrl + * | Select all cells with data in the current region. |
| Ctrl + / | Select all cells with data in the current row. |
| Ctrl + ‘ | Copy the value from the cell above. |
| F5 | Open the Go To dialog box. |
| Ctrl + G | Open the Go To dialog box. |
| Ctrl + F5 | Restore the window size of the workbook. |
| Ctrl + Shift + F5 | Maximize the window size of the workbook. |
| F6 | Switch between different parts of the Excel window. |
| F11 | Create a chart in a new sheet. |
| Alt + F11 | Open the Visual Basic Editor. |
| Ctrl + O | Open a workbook. |
| Ctrl + S | Save the current workbook. |
| Ctrl + Shift + S | Save the current workbook with a new name. |
| Ctrl + W | Close the current workbook. |
| Ctrl + P | Print the current workbook. |
| Ctrl + F | Open the Find and Replace dialogue box. |
| Ctrl + H | Open the Find and Replace dialogue box. |
| Ctrl + Shift + H | Replace values in a range of cells. |
| Ctrl + Shift + F | Open the Format Cells dialogue box. |
| Ctrl + Shift + C | Copy the selected cells. |
| Ctrl + Shift + V | Paste the copied cells. |
| Ctrl + Shift + X | Cut the selected cells |
| Ctrl + Shift + O | Select all cells with comments |
| Ctrl + Shift + T | Create or remove a table from selected data. |
| Ctrl + Shift + W | Wrap the text in selected cells |
List of Formatting Related Shortcuts:
| Shortcut | Description |
| Ctrl + 1 | Open format cells dialogue box |
| Ctrl + 1 | Open the Format Cells dialogue box |
| Ctrl + 5 | Strike through selected cells |
| Ctrl + A | Select the entire worksheet |
| Ctrl + Alt + V | Open paste special dialogue box |
| Ctrl + B | Bold selected cells |
| Ctrl + D | Fill down the contents of the active cell into selected cells below |
| Ctrl + E | Apply center alignment to selected cells |
| Ctrl + I | Italicize selected cells |
| Ctrl + J | Apply justified alignment to selected cells |
| Ctrl + L | Apply left alignment to selected cells |
| Ctrl + R | Apply right alignment to selected cells |
| Ctrl + R | Fill right the contents of the active cell into selected cells to the right |
| Ctrl + Shift + _ | Remove outline border from selected cells |
| Ctrl + Shift + ; | Apply date format to selected cells |
| Ctrl + Shift + ; | Apply date format with a semicolon (MM/DD/YYYY) to selected cells |
| Ctrl + Shift + : | Apply time format with a colon (HH:MM) to selected cells |
| Ctrl + Shift + ! | Apply number format to selected cells |
| Ctrl + Shift + { | Decrease indent of selected cells |
| Ctrl + Shift + } | Increase indent of selected cells |
| Ctrl + Shift + @ | Apply time format to selected cells |
| Ctrl + Shift + & | Apply outline border to selected cells |
| Ctrl + Shift + # | Apply date format to selected cells |
| Ctrl + Shift + % | Apply percentage format to selected cells |
| Ctrl + Shift + ^ | Apply exponential format to selected cells |
| Ctrl + Shift + + | Apply formula to selected cells |
| Ctrl + Shift + < | Decrease font size of selected cells |
| Ctrl + Shift + = | Apply formula to selected cells |
| Ctrl + Shift + > | Increase font size of selected cells |
| Ctrl + Shift + $ | Apply currency format to selected cells |
| Ctrl + Shift + 1 | Apply general format to selected cells |
| Ctrl + Shift + 2 | Apply number format to selected cells |
| Ctrl + Shift + 2 | Apply time format to selected cells |
| Ctrl + Shift + 3 | Apply currency format to selected cells |
| Ctrl + Shift + 3 | Apply date format to selected cells |
| Ctrl + Shift + 4 | Apply currency format to selected cells |
| Ctrl + Shift + 4 | Apply date format to selected cells |
| Ctrl + Shift + 5 | Apply percentage format to selected cells |
| Ctrl + Shift + 5 | Apply time format to selected cells |
| Ctrl + Shift + 6 | Apply percentage format to selected cells |
| Ctrl + Shift + 6 | Apply shading to selected cells |
| Ctrl + Shift + 7 | Apply border to selected cells |
| Ctrl + Shift + 7 | Apply or remove borders to selected cells |
| Ctrl + Shift + 7 | Apply scientific format to selected cells |
| Ctrl + Shift + 8 | Apply fraction |
| Ctrl + Shift + F | Apply or change cell formatting |
| Ctrl + Shift + Space | Select the entire row of the active cell |
| Ctrl + Shift + U | Apply or remove the underline format to selected cells |
| Ctrl + Shift + Y | Apply or remove the strike through format to selected cells |
| Ctrl + Space | Select the entire column of the active cell |
| Ctrl + U | Underline selected cells |
List of Alt Key Shortcuts:
| Shortcut | Description |
| Alt + Enter | Add a line break within a cell |
| Alt + H | Open the Home tab in the ribbon |
| Alt + W | Open the View tab in the ribbon |
| Alt + F | Open the File tab in the ribbon |
| Alt + R | Open the Review tab in the ribbon |
| Alt + P | Open the Page Layout tab in the ribbon |
| Alt + N | Open the Insert tab in the ribbon |
| Alt + T | Open the Formulas tab in the ribbon |
| Alt + D | Open the Data tab in the ribbon |
| Alt + X | Open the Developer tab in the ribbon |
| Alt + A | Apply or remove auto-filter to a table |
| Alt + H + O + I | Open the Format Cells dialogue |
| Alt + H + C | Clear the contents of selected cells |
| Alt + H + D | Clear the formatting of selected cells |
| Alt + H + F + G | Group rows or columns |
| Alt + H + F + U | Ungroup rows or columns |
| Alt + H + W | Apply or remove word wrap to selected cells |
| Alt + H + Q | Apply or remove cell text wrapping |
| Alt + H + A + A | Apply or remove autofit to column width |
| Alt + H + A + R | Apply or remove autofit to row height |
| Alt + W + F | Open the Freeze Panes dialogue box |
| Alt + W + U | Unfreeze panes |
| Alt + W + S | Split the screen horizontally or vertically |
| Alt + W + D | Remove screen split |
| Alt + F + S | Save the workbook |
| Alt + F + A | Save the workbook with a different name |
| Alt + F + C | Close the workbook |
| Alt + F + P | Print the workbook |
| Alt + F + I | Import data into the workbook |
| Alt + F + X | Export the workbook |
| Alt + F + Q | Quick analysis of selected data |
| Alt + F + T | Apply a pivot table to selected data |
| Alt + F + R | Refresh the pivot table data |
| Alt + F + W | Format the pivot table |
| Alt + R + C | Conditional formatting rules |
| Alt + R + T | Track changes in the workbook |
| Alt + R + H | Highlight changes in the workbook |
| Alt + R + A | Accept or reject changes in the workbook |
| Alt + P + M | Page margins |
| Alt + P + S | Page orientation |
| Alt + P + L | Page layout |
| Alt + P + H | Page header and footer |
| Alt + P + R | Page setup |
| Alt + P + B | Page background |
| Alt + N + T | Insert a table |
| Alt + N + C | Insert a chart |
| Alt + N + S | Insert a shape |
| Alt + N + P | Insert a picture |
| Alt + N + L | Insert a linked picture |
| Alt + N + I | Insert an image from the internet |
| Alt + N + H | Insert a hyperlink |
| Alt + N + O | Insert an object |
| Alt + N + A | Insert an audio clip |
| Alt + N + V | Insert a video clip |
| Alt + D + D | Data connection properties |
| Alt + D + T | Data table |
| Alt + D + P | Data pivot table |
| Alt + D + S | Data sort |
| Alt + D + F | Data filter |
| Alt + D + R | Data refresh |
| Alt + T + F | Formulas |
| Alt + T + A | AutoSum |
| Alt + T + S | Sum |
| Alt + T + M | Average |
| Alt + T + C | Count |
| Alt + T + X | Max |
| Alt + T + N | Min |
| Alt + T + V | Vlookup |
| Alt + T + H | Hlookup |
| Alt + T + I | If statement |
| Alt + T + R | Round |
| Alt + T + L | Logical functions |
| Alt + T + T | Text functions |
| Alt + T + D | Date and time functions |
| Alt + T + B | Basic arithmetic functions |
| Alt + T + P | Power functions |
| Alt + T + G | Financial functions |
| Alt + T + Q | Statistical functions |
| Alt + X | Open the Developer tab |
| Alt + X + V | View code |
| Alt + X + B | Debug code |
| Alt + X + R | Run code |
| Alt + X + T | Test code |
| Alt + X + C | Control code |
| Alt + V + F | Format cells |
| Alt + V + N | Custom number formatting |
| Alt + V + D | Custom date formatting |
| Alt + V + T | Custom time formatting |
| Alt + V + C | Custom currency formatting |
| Alt + V + A | Custom accounting formatting |
| Alt + V + P | Custom percentage formatting |
| Alt + V + X | Custom exponential formatting |
| Alt + V + B | Custom fraction formatting |
| Alt + V + L | Custom scientific notation formatting |
| Alt + V + S | Custom text formatting |
| Alt + O + M | Office theme |
| Alt + O + C | Color scheme |
| Alt + O + F | Font scheme |
| Alt + O + P | Paragraph spacing |
| Alt + O + L | Line spacing |
| Alt + O + T | Text direction |
| Alt + O + R | Text alignment |
| Alt + O + B | Text border |
| Alt + O + F | Text fill |
| Alt + O + I | Text indent |
| Alt + O + N | Text shading |
| Alt + O + G | Text glow |
| Alt + O + E | Text effects |
| Alt + O + U | Text underline |
| Alt + H + A | AutoFit |
| Alt + H + R | Row height |
| Alt + H + C | Column width |
| Alt + H + M | Merge cells |
| Alt + H + S | Split cells |
| Alt + H + T | Wrap text |
| Alt + H + B | Bold text |
| Alt + H + I | Italic text |
| Alt + H + U | Underline text |
| Alt + H + L | Strikethrough text |
| Alt + H + X | Superscript text |
| Alt + H + Y | Subscript text |
| Alt + H + F | Font size |
| Alt + H + N | Font color |
| Alt + H + P | Text protection |
| Alt + H + G | Gridlines |
| Alt + H + T | Table styles |
| Alt + H + C | Cell styles |
| Alt + H + Z | Zoom |
| Alt + H + Q | Quick analysis |
| Alt + H + W | Word wrap |
| Alt + H + O | Overflow text |
| Alt + H + R | Repeat header row |
| Alt + H + D | Data validation |
| Alt + H + K | Custom data validation |
| Alt + W + R | Repeat columns |
| Alt + W + D | Freeze panes |
| Alt + W + T | Table filter |
| Alt + W + S | Table sort |
| Alt + W + G | Table group |
| Alt + W + P | Table pivot |
| Alt + W + C | Table chart |
| Alt + W + F | Table formula |
| Alt + W + M | Table map |
| Alt + W + H | Table hierarchy |
| Alt + W + L | Table layout |
| Alt + W + B | Table banded rows |
| Alt + W + N | Table banded columns |
| Alt + W + X | Table total row |
| Alt + W + Y | Table calculated column |
| Alt + W + Z | Table calculated field |
| Alt + D + C | Conditional formatting |
| Alt + D + R | Remove formatting |
| Alt + D + A | Clear all formatting |
| Alt + D + T | Text to columns |
| Alt + D + E | Flash fill |
| Alt + D + P | PowerPivot |
| Alt + D + F | PowerQuery |
| Alt + D + Q | Quick insights |
| Alt + D + W | Data model |
| Alt + A + B | Add |
| Alt + A + C | Charts |
| Alt + A + G | Graphs |
| Alt + A + I | Shapes |
| Alt + A + L | Labels |
| Alt + A + T | Tables |
| Alt + A + M | Maps |
| Alt + A + S | Scenarios |
| Alt + A + D | Solver |
| Alt + A + P | PowerView |
| Alt + A + O | PowerMap |
| Alt + A + R | PowerApps |
| Alt + A + N | PowerBI |
| Alt + A + U | PowerUpdate |
| Alt + A + Z | PowerZoom |
| Alt + A + X | PowerExplore |
| Alt + A + Q | PowerQ&A |
| Alt + A + W | PowerWiki |
| Alt + A + K | PowerKPI |
| Alt + A + J | PowerBI Jaggery. |
| Alt + F + A | File actions |
| Alt + F + N | New workbook |
| Alt + F + O | Open workbook |
| Alt + F + S | Save workbook |
| Alt + F + X | Save as workbook |
| Alt + F + W | Close workbook |
| Alt + F + E | Excel options |
| Alt + F + T | Excel themes |
| Alt + F + R | Excel records |
| Alt + F + I | Excel Info |
| Alt + F + P | Excel print |
| Alt + F + U | Excel undo |
| Alt + F + Z | Excel redo |
| Alt + F + C | Excel copy |
| Alt + F + V | Excel paste |
| Alt + F + D | Excel cut |
| Alt + F + B | Excel bold |
| Alt + F + I | Excel italic |
| Alt + F + U | Excel underline |
| Alt + F + L | Excel strikethrough |
| Alt + F + X | Excel superscript |
| Alt + F + Y | Excel subscript |
| Alt + F + K | Excel hyperlink |
| Alt + F + G | Excel autocomplete |
| Alt + F + H | Excel autofill |
| Alt + F + M | Excel merge cells |
| Alt + F + W | Excel wrap text |
| Alt + F + Q | Excel cell formatting |
| Alt + F + R | Excel row height |
| Alt + F + C | Excel column width |
| Alt + F + A | Excel align left |
| Alt + F + E | Excel align center |
| Alt + F + I | Excel align right |
| Alt + F + O | Excel justify |
| Alt + F + Z | Excel top align |
| Alt + F + X | Excel middle align |
| Alt + F + C | Excel bottom align |
| Alt + F + V | Excel increase font size |
| Alt + F + B | Excel decrease font size |
| Alt + F + N | Excel font color |
| Alt + F + M | Excel fill color |
| Alt + F + W | Excel cell border |
| Alt + F + E | Excel conditional formatting |
| Alt + F + R | Excel data validation |
| Alt + F + T | Excel text to columns |
| Alt + H + H | Home tab |
| Alt + H + F | Font group |
| Alt + H + A | Alignment group |
| Alt + H + N | Number group |
| Alt + H + W | Cells group |
| Alt + H + E | Styles group |
| Alt + H + C | Clipboard group |
| Alt + H + F | Find & Select group |
| Alt + H + T | Editing group |
| Alt + H + S | Formulas group |
| Alt + H + D | Data group |
| Alt + H + P | Protection group |
| Alt + H + A | Arrange group |
| Alt + H + R | Review group |
| Alt + H + V | View group |
| Alt + H + G | Show/Hide group |
| Alt + H + Q | Quick Analysis group |
| Alt + H + W | Flash Fill group |
| Alt + H + E | Formula AutoComplete group |
| Alt + H + R | Formula Auditing group |
Benefits of Excel Shortcuts:
Excel shortcuts are essential to learn for any Excel user. They can make your work faster, easier and more efficient.
Here are some of the benefits of learning Excel shortcuts:
- Learning Excel shortcuts can make you much more productive. Shortcuts help in entering and formatting the cells quickly and easily. This in turn would reduce the amount of time to complete tasks.
- Excel shortcuts can help in formatting the Excel spreadsheets consistently and accurately. This would avoid careless errors and improve the accuracy of data.
- Excel Key shortcuts would help in faster movement around the spreadsheet.