100 Microsoft Excel Shortcuts

General Shortcuts

  1. Ctrl + N: Create a new workbook.
  2. Ctrl + O: Open an existing workbook.
  3. Ctrl + S: Save the current workbook.
  4. Ctrl + W: Close the current workbook.
  5. Ctrl + P: Open the Print dialog box.
  6. Alt + F4: Exit Excel.
  7. Ctrl + Z: Undo the last action.
  8. Ctrl + Y: Redo the last action.
  9. Ctrl + C: Copy selected cells.
  10. Ctrl + X: Cut selected cells.
  11. Ctrl + V: Paste copied or cut cells.
  12. Ctrl + A: Select all cells in the worksheet.
  13. Ctrl + F: Open the Find dialog box.
  14. Ctrl + H: Open the Replace dialog box.
  15. Ctrl + G: Open the Go To dialog box.
  16. F2: Edit the active cell.
  17. F4: Repeat the last action (or toggle absolute/relative references).
  18. Shift + F11: Insert a new worksheet.
  19. Ctrl + Tab: Switch between open workbooks.
  20. Ctrl + Page Up/Page Down: Move between worksheets in a workbook.

Navigation Shortcuts

  1. Arrow Keys: Move one cell up, down, left, or right.
  2. Ctrl + Arrow Keys: Move to the edge of the data region.
  3. Home: Move to the beginning of the row.
  4. Ctrl + Home: Move to cell A1.
  5. Ctrl + End: Move to the last used cell.
  6. Page Up/Page Down: Move one screen up or down.
  7. Alt + Page Up/Page Down: Move one screen left or right.
  8. Ctrl + Backspace: Scroll to make the active cell visible.
  9. Tab: Move to the next cell to the right.
  10. Shift + Tab: Move to the previous cell to the left.

Formatting Shortcuts

  1. Ctrl + B: Apply or remove bold formatting.
  2. Ctrl + I: Apply or remove italic formatting.
  3. Ctrl + U: Apply or remove underline.
  4. Ctrl + 1: Open the Format Cells dialog box.
  5. Ctrl + Shift + $: Apply currency format.
  6. Ctrl + Shift + %: Apply percentage format.
  7. Ctrl + Shift + !: Apply number format with two decimal places.
  8. Ctrl + Shift + ~: Apply general number format.
  9. Ctrl + Shift + #: Apply date format.
  10. Ctrl + Shift + @: Apply time format.
  11. Ctrl + Shift + &: Add a border around selected cells.
  12. Ctrl + Shift + _: Remove borders from selected cells.
  13. Ctrl + T: Insert a table.
  14. Ctrl + Shift + L: Toggle filter on/off.
  15. Alt + H + O + A: AutoFit column width.
  16. Alt + H + O + I: AutoFit row height.

Formula and Function Shortcuts

  1. =: Start a formula.
  2. F9: Calculate all sheets in all open workbooks.
  3. Shift + F9: Calculate the active sheet.
  4. Ctrl + ` (grave accent): Toggle between showing formulas and their results.
  5. Ctrl + Shift + Enter: Enter an array formula.
  6. Alt + =: Insert the SUM function.
  7. Ctrl + ;: Insert the current date.
  8. Ctrl + Shift + ;: Insert the current time.
  9. Ctrl + D: Fill down (copy content from the cell above).
  10. Ctrl + R: Fill right (copy content from the cell to the left).
  11. Ctrl + [: Select cells referenced by formulas in the active cell.
  12. Ctrl + ]: Select cells that reference the active cell.

Selection and Editing Shortcuts

  1. Ctrl + Space: Select the entire column.
  2. Shift + Space: Select the entire row.
  3. Ctrl + Shift + Space: Select the entire worksheet.
  4. Ctrl + – (minus): Delete selected cells, rows, or columns.
  5. Ctrl + Shift + + (plus): Insert cells, rows, or columns.
  6. Ctrl + Shift + ~: Clear formatting from selected cells.
  7. Ctrl + K: Insert a hyperlink.
  8. Alt + Enter: Insert a line break within a cell.
  9. Ctrl + Shift + U: Expand or collapse the formula bar.
  10. Ctrl + Shift + F3: Create names from row and column labels.
  11. Ctrl + / (slash): Select the array containing the active cell.
  12. Ctrl + \ (backslash): Select cells with differences in rows.

Data Analysis Shortcuts

  1. Alt + D + S: Sort data.
  2. Alt + D + F: Insert a Data Form.
  3. Alt + D + P: Open PivotTable Wizard.
  4. Alt + D + E: Remove duplicates.
  5. Ctrl + Q: Open Quick Analysis tools.
  6. Alt + A + T: Insert a table.
  7. Alt + A + V: Insert a chart.
  8. Alt + A + S: Insert a slicer.
  9. Alt + A + M: Insert a timeline.
  10. Alt + A + F: Flash fill.

View and Window Shortcuts

  1. Ctrl + F1: Show or hide the Ribbon.
  2. Ctrl + F9: Minimize the workbook window.
  3. Ctrl + F10: Maximize or restore the workbook window.
  4. Ctrl + F11: Insert a macro sheet.
  5. Ctrl + F12: Open the File Open dialog box.
  6. Alt + F11: Open the Visual Basic for Applications (VBA) editor.
  7. Alt + Shift + F1: Insert a new worksheet.
  8. Alt + F8: Open the Macro dialog box.
  9. Alt + F11: Open the VBA editor.
  10. Ctrl + F6: Switch between open workbooks.

Miscellaneous Shortcuts

  1. Ctrl + Shift + Esc: Open Task Manager (to close unresponsive Excel).
  2. Ctrl + Alt + V: Open the Paste Special dialog box.
  3. Ctrl + Shift + F: Change the font.
  4. Ctrl + Shift + P: Change the font size.
  5. Ctrl + Shift + >: Increase font size.
  6. Ctrl + Shift + <: Decrease font size.
  7. Ctrl + Shift + &: Add a border to selected cells.
  8. Ctrl + Shift + _: Remove borders from selected cells.
  9. Ctrl + Shift + ~: Apply general number format.
  10. Ctrl + Shift + #: Apply date format.

Tips for Using Shortcuts Effectively

  • Practice regularly to memorize the most frequently used shortcuts.
  • Combine shortcuts with mouse actions for maximum efficiency.
  • Customize your keyboard shortcuts if needed via Excel Options.

By mastering these shortcuts, you can significantly speed up your workflow in Excel and become a power user.