Shortcut Key for Excel – 200+ Shortcuts for Beginner to Pro

Excel shortcuts are keyboard combinations that allow you to perform various actions in Microsoft Excel quickly and efficiently. Some commonly used shortcut key for Excel are Ctrl+C, Ctrl+V etc. Using the shortcut key for Excel we can save time and increase productivity when working with Excel. There are many more shortcut key for excel available depending on the version and edition of Excel, and you can usually find a list of available shortcuts in Excel’s Help menu or by doing a quick online search.

Examples:

Excel can be used for a variety of purposes, including personal finance management, budgeting, inventory management, project management, data analysis, and reporting.

What is MS Excel

Microsoft Excel is a popular spreadsheet software developed by Microsoft Corporation. It is widely used for a variety of tasks, including creating, organizing, and analyzing numerical data, generating charts and graphs, and performing complex calculations. Almost all the operations can be performed using the shortcut key for Excel as well as GUI mode.

9.6

200+ MS Excel ShortcutS PDF Download

Excel offers a variety of tools and features, such as formulas and functions, conditional formatting, pivot tables, macros, and add-ins.

Free$5 Download

Download Free PDF Files

Excel offers a variety of tools and features, such as formulas and functions, conditional formatting, pivot tables, macros, and add-ins. These tools make it easier to analyze data, identify trends and patterns, and make informed decisions based on the information.

Excel has been around since the mid-1980s and has gone through many changes and improvements since its initial release. It is available as standalone software or as part of the Microsoft Office suite. Excel is used by millions of people around the world and is considered a valuable tool for businesses, academics, and individuals alike.

What is Shortcut Key for Excel

The shortcut key for Excel or keyboard shortcuts are the combinations of keys that can be used to perform various tasks in Microsoft Excel quickly and efficiently. They can be used to perform common actions such as saving, copying, pasting, formatting, navigating, and more.

The general shortcut key for Excel is the Ribbon keyboard shortcut. Pressing the “Alt” key displays a letter or number for each tab on the Ribbon. Pressing the corresponding letter or number key opens that tab, and then displays additional letters or numbers for each command on the tab. Pressing the corresponding letter or number key for a command selects that command.

For example, to select the “Home” tab, you would press the “Alt” key and then the letter “H”. This displays additional letters or numbers for each command on the “Home” tab. To select the “Copy” command, you would press the letter “C”.

1. Ctrl + C: Copy
2. Ctrl + X: Cut
3. Ctrl + V: Paste
4. Ctrl + Z: Undo
5. Ctrl + Y: Redo
6. Ctrl + A: Select all
7. Ctrl + F: Find
8. Ctrl + H: Replace
9. Ctrl + S: Save
10. Ctrl + N: Create a new workbook
11. Ctrl + O: Open an existing workbook
12. Ctrl + W: Close the active workbook
13. Ctrl + F1: Collapse or expand the ribbon
14. Ctrl + F4: Close the active workbook
15. Ctrl + F6: Switch to the next workbook window
16. Alt + F4: Exit Excel

Cell formatting in Excel refers to changing the appearance of cells, including the font style, size, colour, alignment, and other formatting options. Here is some common shortcut key for Excel related to cell formatting.

1. Ctrl + 1: Open the Format Cells dialogue box
2. Ctrl + B: Bold text
3. Ctrl + I: Italicize text
4. Ctrl + U: Underline the text
5. Ctrl + Shift + F: Apply the font formatting
6. Ctrl + Shift + P: Apply the font size formatting
7. Ctrl + Shift + F3: Paste the cell format
8. Ctrl + Shift + F: Apply the font formatting
9. Ctrl + Shift + P: Apply the font size formatting
10. Ctrl + 1 + Alt + E: Open the Format Cells dialogue box with the Font tab selected
11. Ctrl + 1 + Alt + P: Open the Format Cells dialogue box with the Number tab selected
12. Ctrl + 1 + Alt + B: Open the Format Cells dialogue box with the Border tab selected

Navigation and selection shortcuts in Excel are designed to help you move quickly through your worksheets and select cells, ranges, rows, or columns efficiently. Here are some commonly used shortcut key for Excel navigation and selection.

1. Ctrl + G: Go to a specific cell or range
2. Ctrl + Space: Select the entire column
3. Shift + Space: Select the entire row
4. Ctrl + Shift + *: Select the current region around the active cell
5. Ctrl + Shift + Arrow keys: Extend the selection to the last non-blank cell in the same column or row
6. Ctrl + F3: Open the Define Name dialogue box
7. Ctrl + Shift + F3: Open the Create Names dialogue box
8. Ctrl + Shift + O: Select all cells with comments
9. Ctrl + Shift + T: Select the current table
10. Ctrl + Shift + F8: Add a non-contiguous range to the selection
11. Ctrl + Shift + Home: Select all cells from the current cell to the beginning of the worksheet
12. Ctrl + Shift + End: Select all cells from the current cell to the last cell of the worksheet
13. Ctrl + Shift + F6: Switch to the previous workbook window
14. Ctrl + Page Up: Move to the previous sheet in the workbook
15. Ctrl + Page Down: Move to the next sheet in the workbook
16. Ctrl + Shift + F12: Save as
17. Ctrl + Shift + F3: Open the Define Name dialogue box
18. Ctrl + Shift + F7: Find the next matching cell
19. Ctrl + Shift + F11: Insert a new worksheet

Worksheet shortcuts in Excel are designed to help you work efficiently within a worksheet. Here are some commonly used shortcut key for Excel worksheets.

1. Ctrl + Page Up: Switch to the previous worksheet
2. Ctrl + Page Down: Switch to the next worksheet
3. Alt + =: AutoSum selected cells
4. Ctrl + Home: Move to the beginning of the worksheet
5. Ctrl + End: Move to the last cell of the worksheet
6. Ctrl + Shift + Page Up: Select the current and previous sheet
7. Ctrl + Shift + Page Down: Select the current and next sheet
8. Alt + H + O + I: Insert a new worksheet
9. Ctrl + Shift + F11: Insert a new worksheet
10. Alt + F8: Open the Macro dialogue box to create, run, or edit a macro
11. Alt + F11: Open the Visual Basic Editor
12. F5: Display the Go To dialogue box
13. Ctrl + F6: Switch to the previous workbook window
14. Ctrl + Shift + F12: Save the current workbook
15. Ctrl + F1: Toggle the ribbon display
16. Ctrl + F2: Display the Print Preview window
17. Ctrl + F5: Restore the window size of the workbook
18. Ctrl + F9: Minimize the workbook window
19. Ctrl + Shift + P: Insert a new page break
20. Ctrl + Shift + F6: Switch to the previous workbook window
21. Ctrl + Shift + F9: Hide rows
22. Ctrl + Shift + F10: Open the right-click context menu
23. Ctrl + Shift + F12: Print

The formula shortcut key for Excel is designed to help you work more efficiently when creating, editing, and copying formulas. Here are some generally used shortcut key for Excel formulas.

1. F2: Edit the active cell
2. F4: Repeat the last action
3. F9: Calculate all worksheets in all open workbooks
4. Ctrl + Shift + A: Insert argument names into a formula
5. Ctrl + Shift + L: Create a table
6. Alt + =: AutoSum selected cells
7. F3: Insert a function
8. Shift + F3: Insert a defined name
9. F9: Calculate all worksheets in all open workbooks
10. Ctrl + Shift + U: Show or hide the formula bar
11. Ctrl + 9: Hide selected rows
12. Ctrl + 0: Hide selected columns
13. Ctrl + Shift + 6: Apply or remove the outline border
14. Ctrl + `: Toggle between showing formulas and their results
15. Ctrl + K: Insert a hyperlink
16. F7: Open the Spelling dialogue box
17. F11: Create a chart from selected cells
18. Shift + F11: Insert a new worksheet with a chart
19. Ctrl + 1 + Alt + F: Open the Format Cells dialogue box with the Fill tab selected
20. Ctrl + Shift + ~: Apply the general number format
21. Ctrl + Shift + Enter: Enter an array formula
22. Ctrl + Shift + A: Insert function arguments
23. Ctrl + Shift + B: Toggle bold
24. Ctrl + Shift + C: Copy cell formatting
25. Ctrl + Shift + F3: Create a name by using the names of the row and column labels
26. Ctrl + Shift + F3: Define a name
27. Ctrl + Shift + F6: Switch to the previous workbook window
28. Ctrl + Shift + F12: Save as
29. Ctrl + Shift + F7: Find the previous matching cell
30. Ctrl + Shift + F9: Unhide rows

9.6

200+ MS Excel ShortcutS PDF Download

Excel offers a variety of tools and features, such as formulas and functions, conditional formatting, pivot tables, macros, and add-ins.

Free$5 Download

Download Free PDF Files

The chart shortcut key for Excel is designed to help you work more efficiently when creating, editing, and formatting charts. Here are some commonly used Excel chart shortcuts.

1. Alt + F1: Create a chart with the data in the current range
2. F11: Create a chart on a new sheet
3. F4: Repeat the last action on a chart element
4. F6: Move to the next pane in a chart
5. F7: Open the Spelling dialogue box to check the spelling of chart text
6. Ctrl + 1: Open the Format Chart Area dialogue box
7. Ctrl + 2: Open the Format Plot Area dialogue box
8. Ctrl + 3: Open the Format Data Series dialogue box
9. Ctrl + 4: Open the Format Data Point dialogue box
10. Ctrl + 5: Open the Format Data Labels dialogue box
11. Ctrl + 6: Open the Format Axis dialogue box
12. Ctrl + 7: Open the Format Legend dialogue box
13. Ctrl + 8: Open the Format Chart Title dialogue box
14. Ctrl + 9: Hide or show the selected chart object
15. Ctrl + 0: Hide or show the data table in a chart
16. Ctrl + Shift + F1: Insert a new worksheet with a chart that uses the default chart type
17. Ctrl + Shift + F3: Create names from the labels in the selected range
18. Ctrl + Shift + F6: Switch to the previous workbook window
19. Ctrl + Shift + F11: Insert a new chart sheet
20. Alt + F3: Create a new chart style based on the current chart

The PivotTable shortcut key for Excel is designed to help you work more efficiently when creating, analyzing, and formatting PivotTables.

1. Alt + D + P: Create a PivotTable
2. Alt + D + S: Sort the PivotTable data in ascending or descending order
3. Alt + D + L: Refresh the PivotTable data
4. Alt + D + E: Expand or collapse the selected field in the PivotTable
5. Alt + D + F + F: Show or hide the Field List pane
6. Alt + D + F + T: Show or hide the PivotTable toolbar
7. Alt + D + P + F: Open the PivotTable and PivotChart Wizard
8. Alt + D + P + S: Open the PivotTable Options dialog box
9. Alt + D + P + T: Open the PivotTable toolbar
10. Alt + Shift + Left/Right Arrow: Group or ungroup PivotTable items
11. Alt + Shift + Up/Down Arrow: Move PivotTable fields up or down
12. Alt + Shift + F1: Insert a new worksheet with a PivotTable report
13. Ctrl + Shift + L: Toggle the PivotTable field list pane on and off
14. Ctrl + Shift + Space: Select the entire PivotTable report
15. Ctrl + A: Select all cells in the current PivotTable report
16. Ctrl + Shift + F3: Create names from the labels in the selected range (useful for PivotTable fields)
17. Ctrl + Shift + F6: Switch to the previous workbook window
18. Ctrl + Shift + F11: Insert a new chart sheet based on the current PivotTable report
19. Tab: Move to the next cell in the PivotTable
20. Shift + Tab: Move to the previous cell in the PivotTable.

The editing shortcut key for Excel is designed to help you work more efficiently when editing cells, text, and formulas. Here is some commonly used shortcut key for Excel editing.

1. Ctrl + D: Fill down from the cell above
2. Ctrl + R: Fill right from the cell to the left
3. Ctrl + Shift + +: Insert cells, rows, or columns
4. Ctrl + -: Delete cells, rows, or columns
5. Ctrl + Shift + =: Insert a new column or row
6. Ctrl + Shift + L: Turn on or off the filter
7. Alt + Enter: Insert a new line in a cell
8. Ctrl + 1 + Alt + G: Open the Format Cells dialogue box with the Alignment tab selected
9. Ctrl + ;: Insert the current date
10. Ctrl + Shift + ;: Insert the current time
11. F2: Edit the active cell
12. Shift + F2: Add or edit a cell comment
13. Ctrl + T: Create a table from selected data
14. Shift + F3: Open the Insert Function dialogue box
15. Ctrl + Shift + U: Change the case of the selected text
16. Ctrl + Shift + O: Select all cells with comments
17. Alt + F10: Turn on/off the End mode (which allows navigation with arrow keys to the last cell in a row or column)
18. Ctrl + Shift + F3: Create names from the labels in the selected range

The data shortcut key for Excel is designed to help you work more efficiently when managing and manipulating data.

1. Ctrl + Shift + L: Create a table
2. Ctrl + T: Convert a range of cells into a table
3. Ctrl + Shift + $: Apply currency formatting to selected cells
4. Ctrl + Shift + %: Apply percentage formatting to selected cells
5. Alt + D + L: Filter data by column
6. Alt + A + M: Merge and Center cells
7. Alt + A + H + L: Remove duplicates from a range of cells
8. Alt + D + P: PivotTable and PivotChart Wizard
9. Alt + D + S: Sort a range of cells
10. Alt + D + F + F: Filter data by column
11. Ctrl + Alt + V + V: Paste values
12. Alt + D + G: Create a sparkline
13. Alt + D + Q: Quick Analysis tool
14. Alt + H + R: Remove a hyperlink
15. Alt + H + B: Add a border to cells
16. Alt + F1: Create a chart with the data in the current range
17. Ctrl + Shift + F1: Hide or show the ribbon
18. Ctrl + Shift + F5: Show or hide the formula bar
19. Ctrl + Shift + F9: Unhide rows
20. Ctrl + Shift + F11: Insert a chart sheet

Another miscellaneous shortcut key for Excel is designed to help you work more efficiently when managing and manipulating Excel data. Here is some important shortcut key for Excel.

1. Ctrl + Shift + F12: Open the Save As dialogue box
2. Ctrl + Shift + S: Save a copy of the current workbook
3. Ctrl + Shift + E: Create a new email with the current workbook attached
4. Ctrl + F9: Minimize the current workbook window
5. Ctrl + Shift + F6: Switch to the previous workbook window
6. Ctrl + Alt + F9: Force a recalculation of all formulas in all open workbooks
7. Ctrl + Alt + V: Paste special
8. Ctrl + Shift + F12: Print the current workbook
9. Ctrl + Shift + F9: Minimize the ribbon
10. Alt + F10: Toggle the display of the Selection Pane.
11. Ctrl + F1: Toggle the display of the ribbon
12. Ctrl + F4: Close the current workbook window
13. Ctrl + F11: Insert a chart sheet for the selected chart
14. Ctrl + F12: Open the Save As dialogue box
15. Ctrl + Shift + F12: Print the current workbook without opening the Print dialogue box.
16. F3: Paste a defined name into a formula
17. F9: Calculate all worksheets in all open workbooks
18. Ctrl + Shift + F12: Print the active sheet
19. Ctrl + Shift + F6: Switch to the next workbook window
20. Ctrl + Shift + F10: Display the shortcut menu.

9.6

200+ MS Excel ShortcutS PDF Download

Excel offers a variety of tools and features, such as formulas and functions, conditional formatting, pivot tables, macros, and add-ins.

Free$5 Download

Download Free PDF Files

Frequency Asked Questions

Hope you enjoy this information. Please tell us your thoughts and suggestions about this article. Keep reading more SEO tips & how-to guides and do follow and subscribe to our social media platforms for more latest updates.