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.
- Ctrl + C: Copy
- Ctrl + X: Cut
- Ctrl + V: Paste
- Ctrl + Z: Undo
- Ctrl + Y: Redo
- Ctrl + A: Select all
- Ctrl + B: Bold
- Ctrl + I: Italic
- Ctrl + U: Underline
- Ctrl + F: Find
- Ctrl + H: Replace
- Ctrl + Shift + L: Turn on/off filters
- Ctrl + Shift + $: Apply currency format
- Ctrl + Shift + %: Apply percentage format
- Ctrl + Shift + #: Apply date format
- Ctrl + Shift + &: Apply outline border
- Ctrl + Shift + _: Remove outline border
- Ctrl + Shift + !: Apply number format
- Ctrl + Shift + ^: Apply exponential format
- Ctrl + Shift + ~: Apply general format
- Ctrl + Shift + *: Select current region
- Ctrl + Space: Select entire column
- Shift + Space: Select entire row
- Ctrl + Shift + +: Insert new cells/rows/columns
- Ctrl + -: Delete cells/rows/columns
- Ctrl + Shift + Arrow keys: Extend selection to the edge of data region
- Ctrl + Arrow keys: Move to edge of data region
- Ctrl + Home: Move to cell A1
- Ctrl + End: Move to last cell with content
- Alt + E, S, V: Paste special
- Alt + E, S, T: Paste format
- Alt + E, S, F: Paste formulas
- Alt + H, H: Hide selected rows
- Alt + H, U, N: Unhide rows
- Alt + H, H: Hide selected columns
- Alt + H, U, C: Unhide columns
- Alt + D, L: Create data filter
- Alt + D, F, F: Autofilter
- Alt + D, L, L: Clear filter
- Alt + E, A, A: Clear all
- Alt + E, S, P: Paste as hyperlink
- Alt + N, V: Insert new worksheet
- Alt + O, C, A: Clear all formatting
- Alt + O, C, F: Clear formats
- Alt + O, C, E: Clear contents
- Alt + E, S, R: Insert row
- Alt + E, D, D: Delete row
- Alt + E, C, C: Copy worksheet
- Alt + E, C, V: Move worksheet
- 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.