Popular MS Excel Shortcuts

  • 155
  • 1
Deal Newbie

Microsoft Excel is a powerful spreadsheet program that offers numerous keyboard shortcuts to help users work more efficiently. Here are some popular Excel keyboard shortcuts:

  1. Ctrl + C: Copy selected cells or text.
  2. Ctrl + X: Cut selected cells or text.
  3. Ctrl + V: Paste copied or cut cells or text.
  4. Ctrl + Z: Undo the last action.
  5. Ctrl + Y: Redo the last undone action.
  6. Ctrl + S: Save the current workbook.
  7. Ctrl + N: Open a new workbook.
  8. Ctrl + O: Open an existing workbook.
  9. Ctrl + P: Print the current worksheet or workbook.
  10. Ctrl + F: Find and replace text or values.
  11. Ctrl + H: Find and replace text or values with the replace dialog box.
  12. Ctrl + A: Select all cells in the current worksheet.
  13. Ctrl + Arrow Keys: Navigate to the edge of data regions in the current worksheet.
  14. Ctrl + Space: Select the entire column of the active cell.
  15. Shift + Space: Select the entire row of the active cell.
  16. Ctrl + Shift + "+" or "-": Insert or delete rows or columns.
  17. Alt + Enter: Start a new line within a cell.
  18. Ctrl + Tab: Switch between open workbooks.
  19. Ctrl + Page Up/Page Down: Move between worksheet tabs.
  20. F2: Edit the active cell.
  21. Ctrl + 1: Format cells dialog box.
  22. Ctrl + 5: Strikethrough text within a cell.
  23. Ctrl + Shift + L: Add or remove filters.
  24. Ctrl + ;: Enter the current date.
  25. Ctrl + Shift + ;: Enter the current time.
  26. Alt + E, S, V: Paste special.
  27. Alt + E, S, T: Transpose data (switch rows with columns and vice versa).
  28. F4: Repeat the last action.
  29. Alt + Enter (in the formula bar): Start a new line within a formula.
  30. Alt + F4: Close Excel.

Remember that these shortcuts may vary slightly depending on your Excel version and operating system. You can also customize keyboard shortcuts in Excel to suit your preferences. To see a full list of keyboard shortcuts specific to your version of Excel, you can usually find them within the Excel Help documentation

Click here to reply