The sound of rapid keyboard taps echoing in an office is more than just background noise; it’s the rhythm of a person working in a state of flow. For years, I was the one who relied heavily on my mouse, clicking through menus, visually searching for “Bold” or “Format Cells.” I thought I was efficient enough, until I sat next to a colleague who rarely touched her mouse. She was like a ghost in the machine, data dancing across the screen at her command. That’s when I realized the power of keyboard shortcuts. What I saw wasn’t just speed; it was a deeper level of proficiency and concentration, which requires in depth knowledge of shortcuts used by professionals in daily workflow. For this purpose I have researched for months and created this list of Top 100 Excel Shortcuts that will drastically increase the workflow speed that you have.
Top 100 Excel Shortcuts
Here is my curated list of the MS-Excel – Top 100 shortcuts, designed and categorized to help you master the art of spreadsheet speed.
1. Workbook & File Management
These are your first steps. Moving seamlessly between workbooks, quickly saving, and opening files is the backbone of a structured and safe workflow. The difference between Ctrl + S and manually navigating to File > Save is a small choice that adds up in a major way by preventing work loss.
| Shortcut | Action |
| Ctrl + N | Create a new workbook |
| Ctrl + O | Open an existing workbook |
| Ctrl + S | Save the current workbook |
| F12 | Save As (new name or location) |
| Ctrl + W | Close the current workbook |
| Ctrl + F4 | Close Excel |
| Ctrl + P | Open Print menu |
| Ctrl + F1 | Show or hide the Ribbon |
| Ctrl + Tab | Switch between open Excel workbooks |
| Ctrl + Page Down | Move to the next worksheet in the workbook |
| Ctrl + Page Up | Move to the previous worksheet in the workbook |
| Alt + I, W | Insert a new worksheet |
| Alt + H, O, R | Rename the current worksheet |
2. Navigation & View
Large datasets can feel overwhelming. Stop scrolling! These are the tools that let you jump to the end of your data in a microsecond, helping you understand your spreadsheet’s structure almost instantly. Learning the Ctrl + Period (.) shortcut was a game-changer for me, allowing me to instantly orient myself within a large, selected region without scrolling.
| Shortcut | Action |
| Arrow Keys | Move one cell in any direction |
| Ctrl + Arrow Keys | Jump to the edge of the current data region |
| Ctrl + Home | Jump to cell A1 |
| Ctrl + End | Jump to the last used cell in the worksheet |
| Home | Move to the beginning of the current row |
| Ctrl + G or F5 | Open the Go To dialog box |
| Page Up / Down | Move one screen up or down |
| Alt + Page Up / Down | Move one screen left or right |
| Ctrl + F | Open the Find dialog box |
| Ctrl + H | Open the Replace dialog box |
| Shift + F4 | Repeat the last Find action |
| Ctrl + Mouse Wheel | Zoom in or out of the worksheet |
| Alt + W, F, F | Freeze Panes (locks top rows/columns) |
| Alt + W, Q | Open the Zoom dialog box |
3. Selection
Selection is often the step right before a format change or a delete operation. Precise selection, especially with Alt + ; for visible cells only, is a power move that prevents accidental edits. This simple key combination is invaluable for those times you have hidden or filtered data you want to ignore.
| Shortcut | Action |
| Shift + Arrow Keys | Extend the selection by one cell |
| Ctrl + Shift + Arrow | Extend selection to the edge of the data region |
| Ctrl + A | Select the current region (press twice for the whole sheet) |
| Shift + Space | Select the entire row |
| Ctrl + Space | Select the entire column |
| Ctrl + Shift + Space | Select the entire current data region |
| Shift + Backspace | Collapse selection to the active cell only |
| Ctrl + Period (.) | Jump to the four corners of a selected region |
| Alt + ; | Select visible cells only (ignores hidden/filtered data) |
| Shift + Home | Extend selection to the start of the row |
| Ctrl + Shift + Home | Extend selection to cell A1 |
| Ctrl + Shift + End | Extend selection to the last used cell |
4. Cell Formatting
Data is just data until it is formatted. These shortcuts allow you to quickly apply common currency, percentage, and date formats without the endless multi-click process in the format box. My top tip in this group is the date format: pressing Ctrl + Shift + # instantly turns a list of serial numbers into readable dates.
| Shortcut | Action |
| Ctrl + 1 | Open the Format Cells dialog box |
| Ctrl + B | Apply or remove Bold formatting |
| Ctrl + I | Apply or remove Italic formatting |
| Ctrl + U | Apply or remove Underline |
| Ctrl + 5 | Apply or remove Strikethrough |
| Ctrl + Shift + ~ | Apply the General number format |
| **Ctrl + Shift + $** | Apply the Currency format ($) |
| Ctrl + Shift + % | Apply the Percentage format (%) |
| Ctrl + Shift + ^ | Apply the Scientific/Exponential number format |
| Ctrl + Shift + # | Apply the Date format (DD-MMM-YY) |
| Ctrl + Shift + @ | Apply the Time format (HH:MM AM/PM) |
| Ctrl + Shift + ! | Apply the Number format (with 2 decimals) |
| Ctrl + Shift + & | Apply an outside border |
| Ctrl + Shift + _ | Remove all borders |
| Alt + H, H | Open the Fill Color menu |
| Alt + H, B | Open the Borders menu |
| Alt + H, A, C | Center align cell contents |
5. Editing & Data Entry
This is the heart of your data interaction. Instead of clicking and deleting, use these keys for the everyday copy/paste/fill operations. The sequence Ctrl + D (Fill Down) and Ctrl + R (Fill Right) can save you a mountain of tedious, repetitive work. I’ve personally seen Ctrl + D shave an hour off a simple task that was previously all click-based copying and pasting.
| Shortcut | Action |
| F2 | Edit the active cell (places cursor at the end) |
| Ctrl + Z | Undo the last action |
| Ctrl + Y | Redo the last action |
| Ctrl + C | Copy selection |
| Ctrl + X | Cut selection |
| Ctrl + V | Paste selection |
| Ctrl + Alt + V | Open Paste Special (for Values, Formulas, etc.) |
| Ctrl + D | Fill Down (copy from the cell above) |
| Ctrl + R | Fill Right (copy from the cell to the left) |
| Ctrl + Enter | Fill all selected cells with the same entry |
| Ctrl + ; | Insert the current date |
| Ctrl + Shift + : | Insert the current time |
| Alt + Enter | Start a new line inside a cell |
| Ctrl + K | Insert a hyperlink |
| Ctrl + ‘ | Copy formula from the cell above |
| Ctrl + Shift + “ | Copy value from the cell above |
| F4 | Repeat last action OR toggle absolute/relative refs in formula edit mode |
| Delete | Clear cell contents (keeps formatting) |
| Backspace | Clear cell contents and enter edit mode |
| Shift + F2 | Insert or edit a Comment |
| Ctrl + Shift + F2 | Insert or edit a Note |
6. Rows & Columns Management
Managing the layout and structure of your worksheet is crucial. Using the keyboard to quickly insert and delete rows and columns is far faster and less prone to error than right-clicking a header. My other key takeaway here is hiding rows/columns: Ctrl + 9 and Ctrl + 0 allow for quick data anonymization or clean-up before sharing.
| Shortcut | Action |
| Ctrl + Plus (+) | Insert cells, rows, or columns |
| Ctrl + Minus (-) | Delete cells, rows, or columns |
| Ctrl + 9 | Hide selected rows |
| Ctrl + 0 | Hide selected columns |
| Ctrl + Shift + 9 | Unhide selected rows |
| Ctrl + Shift + 0 | Unhide selected columns |
| Alt + H, O, I | Auto-fit column width |
| Alt + H, O, A | Auto-fit row height |
| Shift + Alt + Right Arrow | Group rows or columns |
| Shift + Alt + Left Arrow | Ungroup rows or columns |
7. Formulas & Data Analysis
For power users, these are indispensable for quick calculations, data structure, and auditing. Ctrl + Shift + L (Toggle AutoFilter) is perhaps one of the most useful combinations for quick data exploration. Another essential technique for troubleshooting is using Ctrl + (grave accent) to instantly view all formulas. This tool is critical for auditing your work and ensuring accuracy. The American Institute of Certified Public Accountants (AICPA) emphasizes that thorough auditing and verification are foundational to sound accounting practices and risk management.
| Shortcut | Action |
| Alt + = | Automatically insert an AutoSum formula |
| Shift + F3 | Open the Insert Function dialog box |
| Ctrl + Shift + L | Toggle AutoFilter on or off |
| Alt + Down Arrow | Open a filter or drop-down list in a cell |
| Ctrl + T | Convert the selected range into an Excel Table |
| Ctrl + ` (Grave) | Toggle showing formulas vs. values |
| F9 | Calculate all worksheets |
| Shift + F9 | Calculate the active worksheet |
| Ctrl + F3 | Open Name Manager |
| Ctrl + Shift + F3 | Create names from the selection |
| Alt + A, M | Open the Remove Duplicates dialog box |
| Alt + A, V, V | Open the Data Validation dialog box |
| Alt + F1 | Create an embedded Chart |
| F11 | Create a Chart on a new sheet |
8. Miscellaneous & Utility
This category contains the small yet highly impactful shortcuts that keep your flow going. The Alt key alone is perhaps the most important utility key, as it activates the key tips on the Ribbon, a hidden map to every command without ever needing the mouse. And then there’s Flash Fill (Ctrl + E), which Microsoft’s own resources rightly describe as a powerful tool for recognizing and automatically filling in patterns of data. It feels like magic when you first use it.
| Shortcut | Action |
| Alt | Show key tips for the Ribbon |
| F1 | Open Excel Help |
| F7 | Run a Spell Check |
| Esc | Cancel an entry or a dialog box |
| Enter | Complete cell entry and move down |
| Tab | Complete cell entry and move right |
| Shift + Tab | Complete cell entry and move left |
| Ctrl + E | Execute Flash Fill |
| Alt + F8 | Open the Macro dialog box |
| Alt + F11 | Open the VBA Editor |
Mastering the Path: A Strategy for Adoption
Learning this complete list of 100 shortcuts shouldn’t be your goal for today or even this week. In my personal experience, attempting to learn too many at once leads only to frustration, making you more likely to revert to the familiar mouse click. Think of it like a new language; you start with key phrases, not the entire dictionary.
I recommend a phased approach. For your first week, commit to mastering only the basic File & Workbook Management category. For example, replace all manual saving with the quick Ctrl + S. In the second week, add the Navigation & Selection shortcuts to eliminate manual scrolling. This methodical build of muscle memory ensures deep, practical learning. The Alt keys, specifically, can feel complex at first because they require a sequence of taps, but once they become ingrained, they become the universal key to every single ribbon command, a true secret weapon of Excel power users.
Common pitfalls to prepare for include differences in laptop keyboard layouts, where the Fn (Function) key must often be held for keys like F2 or F4 to work correctly. Don’t let these minor obstacles deter you. The time you invest now in mastering these shortcuts, particularly for navigation and selection, will return to you thousands of times over, and you, too, might soon be that person with the fluid, mouse-free focus, dancing your way through massive datasets.