Microsoft Excel is one of the most powerful tools for data entry, analysis, and reporting. Whether you’re a student, accountant, engineer, or business analyst, learning Excel shortcuts can drastically improve your speed and productivity. Instead of navigating menus and ribbons, these shortcuts let you perform tasks in seconds.
In this blog, we’ll explore the top 100 Excel keyboard shortcuts that every user should know — organized by category for easy reference.
1. Basic Excel Shortcuts
These shortcuts are the foundation for working efficiently in Excel.
-
Ctrl + N – Create a new workbook
-
Ctrl + O – Open an existing workbook
-
Ctrl + S – Save the workbook
-
F12 – Save As
-
Ctrl + P – Print
-
Ctrl + Z – Undo
-
Ctrl + Y – Redo
-
Ctrl + C – Copy
-
Ctrl + X – Cut
-
Ctrl + V – Paste
-
Ctrl + A – Select all cells
-
Ctrl + F – Find
-
Ctrl + H – Replace
2. Navigation Shortcuts
Move around large spreadsheets quickly using these keys.
-
Arrow Keys – Move one cell up, down, left, or right
-
Ctrl + Arrow Key – Jump to the end of data region
-
Home – Go to the beginning of the row
-
Ctrl + Home – Move to cell A1
-
Ctrl + End – Move to the last used cell
-
Page Up / Page Down – Move one screen up or down
-
Alt + Page Up / Down – Move one screen left or right
3. Formatting Shortcuts
Make your data more readable and professional.
-
Ctrl + 1 – Format cells dialog box
-
Ctrl + B – Bold
-
Ctrl + I – Italic
-
Ctrl + U – Underline
-
Ctrl + Shift + $ – Apply currency format
-
Ctrl + Shift + % – Apply percentage format
-
Ctrl + Shift + # – Apply date format
-
Alt + E + S + V – Paste Special (Values)
-
Alt + H + H – Change cell color
4. Row and Column Management
Insert, delete, or hide rows and columns quickly.
-
Ctrl + Space – Select entire column
-
Shift + Space – Select entire row
-
Ctrl + Shift + "+" – Insert new row or column
-
Ctrl + "-" – Delete selected row or column
-
Ctrl + 9 – Hide rows
-
Ctrl + Shift + 9 – Unhide rows
-
Ctrl + 0 – Hide columns
-
Ctrl + Shift + 0 – Unhide columns
5. Data Entry and Editing
Speed up data manipulation and entry.
-
F2 – Edit active cell
-
Ctrl + Enter – Fill selected cells with current entry
-
Alt + Enter – Start a new line in the same cell
-
Ctrl + D – Fill down
-
Ctrl + R – Fill right
-
Ctrl + ‘ – Copy formula from above
-
Ctrl + ; – Insert current date
-
Ctrl + Shift + : – Insert current time
6. Working with Formulas
Formulas are the heart of Excel. Use these shortcuts for quick calculations.
-
Alt + = – Insert AutoSum
-
Ctrl + Shift + Enter – Enter array formula
-
F4 – Toggle absolute and relative references
-
Shift + F9 – Calculate active worksheet
-
F9 – Calculate all worksheets
-
Ctrl + ` – Show or hide formulas
7. Workbook and Worksheet Management
Handle multiple sheets and files efficiently.
-
Ctrl + Page Up / Page Down – Switch between worksheets
-
Shift + F11 – Insert new worksheet
-
Alt + E + L – Delete worksheet
-
Ctrl + Tab – Switch between open workbooks
-
Ctrl + F4 – Close the workbook
-
Alt + F4 – Exit Excel
Conclusion
Mastering these Excel keyboard shortcuts can transform the way you work. You’ll not only save time but also become more confident navigating through complex datasets and performing repetitive tasks with ease.
Whether you’re a beginner or an advanced user, keep practicing these shortcuts until they become second nature. Excel power users rely on them daily — and with consistent use, you will too!
கருத்துகள்
கருத்துரையிடுக