Shortcut for Excel

Shortcut of Excel

1. Ctrl + N
   • Create a new workbook.
2. Ctrl + O
   • Open an existing workbook.
3. Ctrl + S
   • Save the current workbook.
4. Ctrl + P
   • Open the Print dialog to print the current worksheet.
5. Ctrl + C
   • Copy the selected cells.
6. Ctrl + X
   • Cut the selected cells.
7. Ctrl + V
   • Paste the copied or cut cells.
8. Ctrl + Z
   • Undo the last action.
9. Ctrl + Y
   • Redo the last undone action.
10. Ctrl + A
    • Select all cells in the worksheet.
11. Ctrl + F
    • Open the Find dialog to search within the worksheet.
12. Ctrl + H
    • Open the Replace dialog to find and replace text or data.
13. Ctrl + B
    • Apply bold formatting to the selected cells.
14. Ctrl + I
    • Apply italic formatting to the selected cells.
15. Ctrl + U
    • Apply underline formatting to the selected cells.
16. Ctrl + L
    • Open the Create Table dialog box.
17. Ctrl + T
    • Create a table from the selected range.
18. Ctrl + K
    • Insert a hyperlink.
19. Ctrl + Home
    • Move the cursor to the beginning of the worksheet.
20. Ctrl + End
    • Move the cursor to the last cell with data in the worksheet.
21. Ctrl + Arrow Keys
    • Move to the edge of the data region in the direction of the arrow.
22. Ctrl + Shift + Arrow Keys
    • Extend the selection to the edge of the data region in the direction of the arrow.
23. Ctrl + Spacebar
    • Select the entire column.
24. Shift + Spacebar
    • Select the entire row.
25. Ctrl + Shift + Plus (+)
    • Insert new cells, rows, or columns.
26. Ctrl + Minus (-)
    • Delete the selected cells, rows, or columns.
27. Ctrl + 1
    • Open the Format Cells dialog box.
28. Ctrl + 5
    • Apply or remove strikethrough formatting.
29. Ctrl + 9
    • Hide the selected rows.
30. Ctrl + 0
    • Hide the selected columns.
31. Ctrl + Shift + 9
    • Unhide hidden rows within the selection.
32. Ctrl + Shift + 0
    • Unhide hidden columns within the selection.
33. Ctrl + Shift + L
    • Toggle the AutoFilter on and off.
34. Ctrl + Shift + U
    • Expand or collapse the formula bar.
35. Ctrl + ` (Grave Accent)
    • Toggle the display of formulas.
36. F2
    • Edit the active cell.
37. F4
    • Repeat the last action or toggle absolute and relative references in a formula.
38. F7
    • Open the Spelling dialog box to check spelling in the worksheet.
39. Shift + F2
    • Add or edit a cell comment.
40. Alt + Enter
    • Start a new line within a cell.
41. Ctrl + Enter
    • Fill the selected cells with the current entry.
42. Ctrl + Shift + Enter
    • Enter an array formula.
43. Ctrl + Alt + V
    • Open the Paste Special dialog box.
44. Ctrl + Alt + F9
    • Calculate all worksheets in all open workbooks.
45. Ctrl + F9
    • Minimize the workbook window.
46. Ctrl + F10
    • Maximize or restore the workbook window.
47. Ctrl + Page Up
    • Move to the previous worksheet.
48. Ctrl + Page Down
    • Move to the next worksheet.
49. Alt + F1
    • Create a chart of the data in the current range.
50. Alt + F11
    • Open the Microsoft Visual Basic for Applications (VBA) editor.

These shortcuts can help you work more efficiently in Microsoft Excel by allowing you to perform common tasks quickly and easily.