Microsoft Excel is one of the most powerful tools used globally — from students in India, the US, and the UK to financial analysts on Wall Street. But most users barely scratch the surface of its potential because they rely entirely on the mouse.
Learning Excel keyboard shortcut keys is the single biggest productivity upgrade you can make. Whether you're working in Windows or Mac, shortcuts help you navigate spreadsheets, format cells, manage data, and run complex formulas at lightning speed.
This blog covers 100+ essential Excel shortcut keys, organized from A to Z across 10 key categories. Bookmark this page — you'll come back to it often.
Move through your spreadsheet instantly without lifting your hands from the keyboard.
Shortcut | Action |
|---|---|
Ctrl+Home | Go to cell A1 (beginning of sheet) |
Ctrl+End | Go to the last used cell |
Ctrl+→ | Jump to the last filled cell in a row |
Ctrl+↓ | Jump to the last filled cell in a column |
Ctrl+G | Open Go To dialog (navigate to a cell) |
Ctrl+F5 | Open Go To dialog box |
Page Down | Move one screen down |
Page Up | Move one screen up |
Alt+Page Down | Move one screen to the right |
Alt+Page Up | Move one screen to the left |
Select ranges, rows, columns, and entire sheets without a mouse.
Shortcut | Action |
|---|---|
Ctrl+A | Select all cells in the sheet |
Ctrl+Shift+End | Extend selection to last used cell |
Ctrl+Shift+Home | Extend selection to A1 |
Shift+Space | Select entire row |
Ctrl+Space | Select entire column |
Ctrl+Shift+→ | Extend selection to last filled cell in row |
Ctrl+Shift+↓ | Extend selection to last filled cell in column |
F8 | Toggle Extend Selection mode |
Apply bold, italics, borders, number formats, and more — without opening any ribbon menu.
Shortcut | Action |
|---|---|
Ctrl+B | Bold selected text/cell |
Ctrl+I | Italicize selected text/cell |
Ctrl+U | Underline selected text/cell |
Ctrl+1 | Open Format Cells dialog box |
Ctrl+Shift+$ | Apply Currency format |
Ctrl+Shift+% | Apply Percentage format |
Ctrl+Shift+# | Apply Date format (dd-mmm-yy) |
Ctrl+Shift+! | Apply Number format (2 decimal places) |
Ctrl+Shift+~ | Apply General number format |
Alt+H+B | Apply border to selected cells |
Alt+H+H | Apply cell fill/highlight color |
4. Editing & Data Entry Shortcuts
Enter, edit, and manage data faster with these essential shortcuts.
Shortcut | Action |
|---|---|
F2 | Edit the active cell |
Esc | Cancel the current entry or edit |
Enter | Confirm entry and move down |
Tab | Confirm entry and move right |
Ctrl+D | Fill Down (copy cell above) |
Ctrl+R | Fill Right (copy cell to the left) |
Ctrl+; | Insert current date |
Ctrl+Shift+: | Insert current time |
Delete | Delete cell content (without formatting) |
Ctrl+Delete | Delete text from cursor to end of line |
Alt+Enter | Start a new line within a cell |
Use Ctrl + Enter to fill all selected cells with the same value simultaneously — a massive time-saver when populating a range with identical data.
Speed up formula creation, auditing, and calculation in Excel.
Shortcut | Action |
|---|---|
Alt+= | AutoSum selected range |
F4 | Toggle absolute/relative cell reference ($A$1 ↔ A1) |
Ctrl+` | Show/hide all formulas in cells |
Ctrl+Shift+Enter | Enter an array formula |
Shift+F3 | Insert Function dialog (browse all functions) |
Ctrl+F3 | Open Name Manager |
F9 | Recalculate all formulas |
Shift+F9 | Recalculate active worksheet only |
Ctrl+[ | Select direct precedent cells |
Ctrl+] | Select direct dependent cells |
Manage files and worksheet tabs efficiently.
Shortcut | Action |
|---|---|
Ctrl+N | Create a new workbook |
Ctrl+O | Open an existing workbook |
Ctrl+S | Save current workbook |
Ctrl+W | Close the current workbook |
Ctrl+F4 | Close the active workbook window |
F12 | Save As dialog box |
Ctrl+Page Down | Move to the next sheet tab |
Ctrl+Page Up | Move to the previous sheet tab |
Alt+Shift+F1 | Insert a new worksheet |
Ctrl+P | Print dialog |
Copy, cut, paste, and use Paste Special like a pro.
Shortcut | Action |
|---|---|
Ctrl+C | Copy selected cells |
Ctrl+X | Cut selected cells |
Ctrl+V | Paste |
Ctrl+Alt+V | Paste Special dialog box |
Ctrl+Z | Undo last action |
Ctrl+Y | Redo last undone action |
Power Move: Use Paste Special → Values Only (Alt + E, S, V, Enter) to strip formulas and paste only raw data — critical when sharing spreadsheets with external stakeholders.
Locate and update data across large spreadsheets instantly.
Shortcut | Action |
|---|---|
Ctrl+F | Find (open search dialog) |
Ctrl+H | Find and Replace dialog |
Ctrl+Shift+L | Toggle AutoFilter on/off |
Alt+↓ | Open drop-down list in a filtered cell |
F5 | Go To dialog (jump to any cell) |
Ctrl+Shift+F3 | Create names from row/column labels |
Insert, delete, hide, and resize rows and columns without menus.
Shortcut | Action |
|---|---|
Ctrl++ | Insert new row or column |
Ctrl+- | Delete selected row or column |
Ctrl+9 | Hide selected rows |
Ctrl+Shift+9 | Unhide rows |
Ctrl+0 | Hide selected columns |
Ctrl+Shift+0 | Unhide columns |
Alt+O+C+A | AutoFit column width |
Alt+O+R+A | AutoFit row height |
Excel's function keys are powerhouse shortcuts that many users overlook.
Shortcut | Action |
|---|---|
F1 | Open Excel Help |
F2 | Edit the selected cell |
F3 | Paste a defined name into a formula |
F4 | Repeat last action / toggle cell reference type |
F5 | Open Go To dialog |
F6 | Move to the next pane in a split worksheet |
F7 | Open Spell Check |
F8 | Toggle Extend Selection mode |
F9 | Calculate all worksheets in all open workbooks |
F10 | Turn Key Tips on/off (access ribbon with keyboard) |
F11 | Create a chart from selected data (new sheet) |
F12 | Open Save As dialog |
Quick Win: Press F4 immediately after performing an action to repeat it on any other selection. This is one of Excel's most underrated hidden gems and can save you dozens of repetitive clicks.
You don't need to memorize all 100+ shortcuts overnight. Start with five from each category that match your daily workflow — navigation, formatting, and formula shortcuts will deliver the most immediate gains. Within a week, your fingers will begin moving on instinct.
Shortcuts work across Excel for Windows, Excel for Mac (with minor modifications), Excel Online, and Microsoft 365. Bookmark this page and revisit it as you advance.
Excel shortcut keys are keyboard combinations that help you perform tasks quickly without using a mouse, improving speed and efficiency.
Still have questions?
Talk to our academic mentors — we're happy to help.
© 2026 SkillSnap Learning Pvt. Ltd. All rights reserved.