Mastering Microsoft Excel with Handy Shortcuts
Excel, a quintessential tool in the world of data management and analysis, becomes even more powerful when you can navigate and manipulate it swiftly. Whether you’re a novice getting your feet wet, or an expert knee-deep in spreadsheets, knowing these shortcuts will undeniably amp up your Excel game. To help you become an Excel wizard, we’ve organized a comprehensive list of shortcuts that cover everything from basic navigation and editing to advanced number formats.
Microsoft Excel shortcuts A to Z:
CTRL + A ➡️ Select All
CTRL + B ➡️ Toggle BOLD (font)
CTRL + C ➡️ Copy
CTRL + D ➡️ Fill Down
CTRL + E ➡️ Flash Fill
CTRL + F ➡️ Find
CTRL + G ➡️ Go To
CTRL + H ➡️ Find and Replace
CTRL + I ➡️ Toggle Italic (font)
CTRL + J ➡️ Input line break (in Find and Replace)
CTRL + K ➡️ Insert Hyperlink
CTRL + L ➡️ Insert Excel Table
CTRL + M ➡️ Not Assigned
CTRL + N ➡️ New Workbook
CTRL + O ➡️ Open
CTRL + P ➡️ Print
CTRL + Q ➡️ Quick Analysis
CTRL + R ➡️ Fill Right
CTRL + S ➡️ Save
CTRL + T ➡️ Insert Excel Table
CTRL + U ➡️ Toggle underline (font)
CTRL + V ➡️ Paste (when something is cut/copied)
CTRL + W ➡️ Close the current workbook
CTRL + X ➡️ Cut
CTRL + Y ➡️ Redo (Repeat last action)
CTRL + Z ➡️ Undo
Microsoft Excel Shortcuts 0 to 9:
CTRL + 1 ➡️ Format Cells
CTRL + 2 ➡️ Bold font
CTRL +3➡️ Italic font
CTRL +4 ➡️ Underline
CTRL +5 ➡️ Strikethrough
CTRL +6 ➡️ Show/Hide an Object
CTRL +7 ➡️ Show/Hide the Toolbar
CTRL +8 ➡️ Toggle Outline Symbols
CTRL +9 ➡️ Hide Rows
CTRL +0 ➡️ Hide Columns
Microsoft Excel Shortcuts for symbols:
CTRL + ` ➡️ Toggle Formula
CTRL + ~ ➡️ General Format
CTRL + ! ➡️ Number Format
CTRL + @ ➡️ Time Format
CTRL + # ➡️ Date Format
CTRL + $ ➡️ Currency Format
CTRL + % ➡️ Percent Format
CTRL + ^ ➡️ Exponential Format
CTRL + & ➡️ Outside Borders
CTRL + * ➡️ Select Current Region
CTRL + ( ➡️ Unhide Rows
CTRL + ) ➡️ Unhide Columns
CTRL + – ➡️ Delete
CTRL + _ ➡️ Remove Border
CTRL + + ➡️ Insert
CTRL + = ➡️ Insert
CTRL + ; ➡️ Insert Current Date
CTRL + : ➡️ Insert Current Time
Microsoft Excel shortcuts for function keys:
CTRL + F1 ➡️ Collapse the Ribbon
CTRL + F2 ➡️ Print Preview
CTRL + F3 ➡️ Name Manager
CTRL + F4 ➡️ Close
CTRL + F5 ➡️ Restore Window Size
CTRL + F6 ➡️ Next Workbook
CTRL + F7 ➡️ Move Window
CTRL + F8 ➡️ Resize Window
CTRL + F9 ➡️ Minimize Workbook
CTRL + F10 ➡️ Maximize Workbook
CTRL + F11 ➡️ Insert a Macro Sheet
CTRL + F12 ➡️ Open a File
Microsoft Excel shortcuts for other keys:
CTRL + ’ ➡️ Copy a Formula from the Cell Above
CTRL + ” ➡️ Copy a Value from the Cell Above
CTRL + < ➡️ Copy a Formula from the Cell Above
CTRL + > ➡️ Copy a Formula from Cell to Left
CTRL + Tab ➡️ Next Workbook
CTRL + Backspace ➡️ Jump to the Active Cell
CTRL + Spacebar ➡️ Select an Entire Column
CTRL + Insert ➡️ Copy
CTRL + Home ➡️ Go to Beginning of Worksheet
CTRL + Page Up ➡️ Go to Previous Worksheet
CTRL + Page Down ➡️ Go to Next Worksheet
CTRL + Delete ➡️ Delete
CTRL + End ➡️ Go to the Intersection of the Last used Row and Column
+ There are no comments
Add yours