50 MS Excel Shortcut with How to Use.

50 Excel shortcuts along with instructions on how to use them:



1. Ctrl+C: Copy the selected cell(s) or range.

2. Ctrl+V: Paste the copied cell(s) or range.

3. Ctrl+X: Cut the selected cell(s) or range.

4. Ctrl+Z: Undo the last action.

5. Ctrl+Y: Redo the last action.

6. Ctrl+A: Select the entire worksheet.

7. Ctrl+S: Save the current workbook.

8. Ctrl+P: Print the current workbook.

9. Ctrl+B: Apply bold formatting to the selected cell(s) or range.

10. Ctrl+I: Apply italic formatting to the selected cell(s) or range.

11. Ctrl+U: Apply underline formatting to the selected cell(s) or range.

12. Ctrl+F: Open the Find and Replace dialog box.

13. Ctrl+H: Open the Find and Replace dialog box with the Replace tab selected.

14. Ctrl+G: Go to a specific cell or range.

15. Ctrl+K: Insert a hyperlink.

16. Ctrl+N: Create a new workbook.

17. Ctrl+O: Open an existing workbook.

18. Ctrl+W: Close the current workbook.

19. Ctrl+Tab: Switch between open workbooks or tabs.

20. Ctrl+Shift+: (colon): Insert the current time.

21. Ctrl+; (semicolon): Insert the current date.

22. Ctrl+Shift+~: Apply the general number format.

23. Ctrl+Shift+$: Apply the currency format.

24. Ctrl+Shift+%: Apply the percentage format.

25. Ctrl+Shift+#: Apply the date format.

26. Ctrl+Shift+!: Apply the number format with two decimal places.

27. Ctrl+Shift+^: Apply the scientific number format.

28. Ctrl+Shift+@: Apply the time format.

29. Ctrl+Shift+*: Select the current region around the active cell.

30. Ctrl+Shift+Arrow Keys: Select a range of cells.

31. Ctrl+Spacebar: Select the entire column.

32. Shift+Spacebar: Select the entire row.

33. Ctrl+Shift+L: Apply filters to the selected range.

34. Ctrl+Shift+F: Open the Format Cells dialog box.

35. Ctrl+Shift+P: Insert a new page break.

36. Ctrl+Shift+V: Paste special.

37. Ctrl+1: Open the Format Cells dialog box.

38. Ctrl+2: Apply bold formatting.

39. Ctrl+3: Apply italic formatting.

40. Ctrl+4: Apply underline formatting.

41. Ctrl+5: Apply strikethrough formatting.

42. Ctrl+6: Show/hide objects.

43. Ctrl+7: Show/hide gridlines.

44. Ctrl+8: Show/hide outline symbols.

45. Ctrl+9: Hide rows.

46. Ctrl+0: Hide columns.

47. Ctrl+Shift+O: Select all cells with comments.

48. F2: Edit the selected cell.

49. F4: Repeat the last action.

50. F11: Create a new chart in a separate chart sheet.


These shortcuts can help you work more efficiently and save time while using Microsoft Excel.

Post a Comment

0 Comments
* Please Don't Spam Here. All the Comments are Reviewed by Admin.