If you spend any meaningful time in Microsoft Excel, you already know the feeling: you’re clicking through menus, dragging cells, and formatting columns — and suddenly an hour has slipped by. The good news is that most of that time is recoverable. Learning a solid set of keyboard shortcuts can turn a slow, click-heavy workflow into something that actually feels fast. This guide covers 50 of the most useful Excel shortcuts, grouped so you can learn them in stages rather than all at once.
Why Shortcuts Are Worth the Learning Curve
Every time your hand moves from the keyboard to the mouse, you lose a small slice of time. Do that a hundred times a day and it adds up to real minutes — sometimes real hours. Shortcuts keep your hands on the keyboard, your eyes on the data, and your brain in flow. Even learning ten of the shortcuts below will make a noticeable difference by the end of your next workday.
Navigation Shortcuts
Moving around a large spreadsheet efficiently is the foundation of everything else. These shortcuts help you jump exactly where you need to go.
- Ctrl + Home — Jump to cell A1 instantly, no matter where you are.
- Ctrl + End — Jump to the last used cell in the sheet.
- Ctrl + Arrow Key — Leap to the edge of a data region in any direction.
- Ctrl + G — Open the Go To dialog to navigate to a specific cell or range.
- Ctrl + F — Open Find. Add Ctrl + H to open Find and Replace.
- Ctrl + Page Up / Page Down — Switch between worksheet tabs.
- F5 — Another way to open Go To; useful when you want to reach a named range quickly.
- Ctrl + Backspace — Scroll the view back to the active cell without moving it.
Selection Shortcuts
Selecting the right cells quickly is half the battle. These shortcuts let you highlight exactly what you need without reaching for the mouse.
- Ctrl + Shift + Arrow Key — Extend the selection to the edge of a data block.
- Ctrl + A — Select the entire worksheet (press twice if you’re inside a data table).
- Shift + Space — Select the entire row of the active cell.
- Ctrl + Space — Select the entire column of the active cell.
- Ctrl + Shift + End — Extend the selection to the last used cell.
- Ctrl + Shift + Home — Extend the selection back to A1.
- Ctrl + Click — Add non-adjacent cells or ranges to your selection.
- Shift + Click — Select a continuous range from the active cell to wherever you click.
Editing Shortcuts
These are the ones that save the most time in day-to-day work. Learn these first if you’re new to shortcuts.
- F2 — Edit the active cell without using the mouse.
- Ctrl + Z — Undo. You probably know this one already, but it works deeply in Excel.
- Ctrl + Y — Redo the last undone action.
- Ctrl + D — Fill Down: copy the top cell into all selected cells below it.
- Ctrl + R — Fill Right: copy the leftmost cell into all selected cells to the right.
- Ctrl + ; — Insert today’s date as a static value.
- Ctrl + Shift + ; — Insert the current time as a static value.
- Alt + Enter — Add a line break inside a cell while editing.
- Delete — Clear cell contents without affecting formatting.
- Ctrl + – (minus) — Delete selected cells, rows, or columns.
- Ctrl + Shift + + — Insert new cells, rows, or columns.
- F4 — Repeat the last action. Also toggles absolute/relative cell references inside a formula.
Formatting Shortcuts
Formatting by hand is one of the biggest time sinks in Excel. These shortcuts cut it down considerably.
- Ctrl + B — Bold.
- Ctrl + I — Italic.
- Ctrl + U — Underline.
- Ctrl + 1 — Open the Format Cells dialog — the fastest route to full formatting control.
- Ctrl + Shift + $ — Apply currency format.
- Ctrl + Shift + % — Apply percentage format.
- Ctrl + Shift + # — Apply date format (DD-MMM-YY).
- Ctrl + Shift + ! — Apply number format with two decimal places and thousands separator.
- Alt + H + O + I — AutoFit column width (press keys in sequence, not simultaneously).
- Alt + H + O + A — AutoFit row height.
Formula and Function Shortcuts
Formulas are where Excel earns its reputation. These shortcuts make working with them faster and less error-prone.
- Alt + = — AutoSum: inserts a SUM formula for the range above or to the left of the active cell.
- Ctrl + ` (backtick) — Toggle between showing formula results and showing the formulas themselves. Brilliant for auditing a sheet.
- F9 — Evaluate a selected part of a formula to see its current value. Press Escape to cancel without committing.
- Shift + F3 — Open the Insert Function dialog when you can’t remember a function’s exact name.
- Ctrl + Shift + Enter — Enter an array formula (in older Excel versions before dynamic arrays).
- Tab — Accept an autocomplete suggestion for a function name while typing.
- F4 — Inside a formula, cycle a cell reference through absolute and relative options (e.g., A1 ? $A$1 ? A$1 ? $A1).
Workbook and Worksheet Shortcuts
Managing files and sheets is faster than most people realise once you know these.
- Ctrl + N — New workbook.
- Ctrl + O — Open a workbook.
- Ctrl + S — Save. Use this obsessively.
- Ctrl + W — Close the current workbook.
- Ctrl + P — Open Print settings.
- Alt + Shift + F1 — Insert a new worksheet.
- F11 — Create a chart from selected data on a new sheet instantly.
- Ctrl + F2 — Open Print Preview.
If you ever get stuck and can’t remember a shortcut, press Alt on its own. Excel will overlay letters on every ribbon button, letting you navigate the entire menu system without touching the mouse. It’s slower than a true shortcut, but it’s faster than hunting with the cursor — and it often teaches you shortcuts you didn’t know existed.
