Tech Dynasty Services

Blog Details

  • Home
  • Excel
  • 50 Must-Know Excel Keyboard Shortcuts

50 Must-Know Excel Keyboard Shortcuts

Keyboard shortcuts are often overlooked but can significantly speed up your workflow in Excel. From basic navigation to complex formulas, mastering keyboard shortcuts can shave precious seconds off your tasks and improve your overall efficiency. Familiarize yourself with these 50 common shortcuts and watch your productivity soar.

  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 + B: Bold
  8. Ctrl + I: Italic
  9. Ctrl + U: Underline
  10. Ctrl + F: Find
  11. Ctrl + H: Replace
  12. Ctrl + Shift + L: Turn on/off filters
  13. Ctrl + Shift + $: Apply currency format
  14. Ctrl + Shift + %: Apply percentage format
  15. Ctrl + Shift + #: Apply date format
  16. Ctrl + Shift + &: Apply outline border
  17. Ctrl + Shift + _: Remove outline border
  18. Ctrl + Shift + !: Apply number format
  19. Ctrl + Shift + ^: Apply exponential format
  20. Ctrl + Shift + ~: Apply general format
  21. Ctrl + Shift + *: Select current region
  22. Ctrl + Space: Select entire column
  23. Shift + Space: Select entire row
  24. Ctrl + Shift + +: Insert new cells/rows/columns
  25. Ctrl + -: Delete cells/rows/columns
  26. Ctrl + Shift + Arrow keys: Extend selection to the edge of data region
  27. Ctrl + Arrow keys: Move to edge of data region
  28. Ctrl + Home: Move to cell A1
  29. Ctrl + End: Move to last cell with content
  30. Alt + E, S, V: Paste special
  31. Alt + E, S, T: Paste format
  32. Alt + E, S, F: Paste formulas
  33. Alt + H, H: Hide selected rows
  34. Alt + H, U, N: Unhide rows
  35. Alt + H, H: Hide selected columns
  36. Alt + H, U, C: Unhide columns
  37. Alt + D, L: Create data filter
  38. Alt + D, F, F: Autofilter
  39. Alt + D, L, L: Clear filter
  40. Alt + E, A, A: Clear all
  41. Alt + E, S, P: Paste as hyperlink
  42. Alt + N, V: Insert new worksheet
  43. Alt + O, C, A: Clear all formatting
  44. Alt + O, C, F: Clear formats
  45. Alt + O, C, E: Clear contents
  46. Alt + E, S, R: Insert row
  47. Alt + E, D, D: Delete row
  48. Alt + E, C, C: Copy worksheet
  49. Alt + E, C, V: Move worksheet
  50. Alt + E, D, L: Delete worksheet

Excel is packed with hidden features that can help you work smarter, not harder. By harnessing the power of these keyboard shortcuts, you can streamline your workflow, and take your productivity to new heights. 

Learn more about other relevant features on excel by enrolling in our excel training at Tech Dynasty Services (TDS)

Tech Dynasty Services (TDS) stands out as the premier destination for superior training. Our comprehensive training programs, led by seasoned industry experts, offer a hands-on approach to mastering Excel, Focusing on practical skills and real-world applications, our courses empower tech talents to excel in their roles and advance their careers. 

Enroll at Tech Dynasty Services and start your tech journey today. 

 

Leave A Comment

Cart
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar
Compare