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 ➡️ UndoMicrosoft 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