Skip to content
Tutorials Center
My learning

Topics

Lesson 91 of 93 ยท Practice and Review

Keyboard Shortcuts and Productivity Tricks

Work faster in Excel: navigation, selection, editing, formatting and formula shortcuts, Paste Special, Quick Analysis and Go To Special, explained with examples.

Most people use Excel with the mouse for everything, and then wonder why a colleague finishes in ten minutes what takes them an hour. The difference is rarely one magic trick. It is a few dozen small habits: jumping to the end of a table with one key combination, selecting a block without dragging, pasting only the values, and finding every empty cell in a second.

This lesson collects the habits that pay off most, grouped by the job you are doing. The shortcuts are for Excel on Windows. On a Mac, Ctrl is usually Cmd, Alt is Option, and a few combinations differ, so check the ribbon tooltips there. Excel cannot run on this site, so every shortcut is shown read-only. Two of the most useful ideas, Paste Special and Go To Special, also come with live JavaScript stand-ins that show what those commands really do to your cells.

Where the time goes

Moving Reaching the right cell.
Selecting Picking ranges fast.
Editing Typing, filling, fixing.
Pasting Only what you need.

Four habits cover most daily work.

1 / 2

Scrolling with the mouse wheel is the slowest way to move. The keys below take you anywhere in a large sheet at once.

Shortcut What it does
Ctrl + arrow key Jumps to the edge of the current block of data; from an empty cell it jumps to the next filled cell
Ctrl + Home Goes to cell A1
Ctrl + End Goes to the last cell that has ever been used
Ctrl + Page Down / Page Up Switches to the next or previous sheet
Page Down / Page Up Moves one screen down or up
Alt + Page Down Moves one screen to the right
Ctrl + G or F5 Opens Go To: type a cell, range or name and jump
Ctrl + Backspace Scrolls back to the active cell
Ctrl + F / Ctrl + H Find / Replace

A very common combination is Ctrl + Down to reach the last row of a column of data, then Down once more to land on the first empty row where new data goes. Ctrl + End can overshoot: if you once typed something far away and deleted it, Excel may still count that cell as used until you save the file.

You can also type a name into the Name Box left of the formula bar. Typing B2:D500 there and pressing Enter selects the whole range without any dragging. See the interface tour if you have forgotten where it is.

Selecting

Selection shortcuts all build on Shift. Holding Shift while you move extends the selection from the cell you started in.

Shortcut What it selects
Shift + arrow key Extends the selection one cell
Ctrl + Shift + arrow key Extends to the edge of the data block
Ctrl + A The current data region; pressed again, the whole sheet
Ctrl + Space The entire column of the active cell
Shift + Space The entire row of the active cell
Ctrl + Shift + End From the active cell to the last used cell
Ctrl + click Adds separate cells or ranges to the selection
Alt + ; Only the visible cells (skips rows hidden by filters or grouping)

The last one matters more than it looks. If you filter a table and then copy a column, Excel copies only the visible rows. But rows you hid by hand or collapsed in a group are still part of the selection and get copied too. Selecting with Alt + ; first makes sure only what you see is copied.

Editing and filling

Shortcut What it does
F2 Edits the active cell without replacing its content
Enter / Tab Confirms and moves down / right (Shift reverses the direction)
Esc Cancels the edit
Alt + Enter Starts a new line inside the same cell
Ctrl + Enter Confirms and fills the entry into every selected cell
Ctrl + D / Ctrl + R Fills the top cell of the selection down / the left cell right
Ctrl + ; Enters today's date as a fixed value
Ctrl + Shift + : Enters the current time as a fixed value
Ctrl + Z / Ctrl + Y Undo / Redo
F4 Repeats your last action (outside a formula)
Ctrl + E Flash Fill, which learns a pattern from your example
Ctrl + - / Ctrl + Shift + + Deletes / inserts cells, rows or columns
Ctrl + 9 / Ctrl + 0 Hides the selected rows / columns

Ctrl + Enter is a hidden gem. Select a range of 500 cells, type 0, and press Ctrl + Enter instead of Enter: all 500 cells get the value. The same works with formulas: Excel adjusts relative references for each cell, just as when you copy.

The date and time shortcuts insert a value, not the TODAY() function, so the date will not change tomorrow. That is exactly what you want for a log or a timestamp. See dates and times for why dates are really numbers.

Formatting

Shortcut What it does
Ctrl + 1 Opens Format Cells
Ctrl + B / I / U Bold / italic / underline
Ctrl + Shift + ~ General number format
Ctrl + Shift + 1 Number with thousands separator and two decimals
Ctrl + Shift + 3 Date format
Ctrl + Shift + 4 Currency format
Ctrl + Shift + 5 Percent format
Ctrl + Shift + & Outline border
Alt + H, O, I Autofits the column width to its content
Alt + H, H Opens the fill color menu

The Alt sequences are not chords: you press Alt, release it, and then press the following keys one after another. Excel shows little letter badges on the ribbon after you press Alt, which is the best way to discover more. Formatting only changes how a value looks, never the value itself; formatting cells explains why.

Formula shortcuts

Shortcut What it does
Alt + = AutoSum: inserts SUM for the cells above or to the left
F4 (while editing a formula) Cycles a reference through A1, $A$1, A$1, $A1
F2 (while editing a formula) Switches between pointing at cells and moving the text cursor
Ctrl + ` Shows formulas instead of results, and back
F9 Recalculates; inside a formula bar selection, evaluates just that part (press Esc to undo)
Ctrl + Shift + Enter Enters a legacy array formula (not needed in current Excel)
Ctrl + ' Copies the formula from the cell above, with references unchanged
Ctrl + Shift + U Expands or collapses the formula bar
Alt + Down Opens the list of earlier entries in the column or a dropdown
Ctrl + T Turns a range into a table
Ctrl + Shift + L Turns filter buttons on or off
Shift + F3 Opens the Insert Function dialog

F4 has two jobs. In a formula it toggles $ anchors, as explained in cell references. Anywhere else it repeats the last thing you did, such as applying a fill color or inserting a row, which makes it a cheap way to apply a formatting change to many separate places.

Paste Special

Normal paste copies everything: value, formula, number format, borders and validation. Paste Special lets you choose. Open it with Ctrl + Alt + V after copying, or use the small clipboard menu that appears next to the pasted cells. The options you will use most:

  • Values: replaces formulas with their current results. This is how you "freeze" a calculation.
  • Formulas: pastes the formulas but not the formatting.
  • Formats: copies only the look, like the Format Painter.
  • Column widths: copies widths only, which is surprisingly hard to do otherwise.
  • Transpose: swaps rows and columns.
  • Operation (Add, Subtract, Multiply, Divide): applies the copied number to every selected cell.
  • Skip blanks: leaves target cells alone where the source is empty.

The stand-in below keeps a tiny sheet with three formulas and applies four paste modes to it. It shifts relative references the way Excel does (the $ anchors are respected), evaluates simple arithmetic formulas, and prints the result of each mode. It is a model written for this lesson, not Excel's own code.

JS Paste Special modes on a tiny sheet

Press Run (or Ctrl + Enter) to see the console output here.

No output.

The first block is the classic mistake: a normal paste moves the formulas and their inputs along with them, so they point at empty cells and quietly return 0. Pasting values, or anchoring the inputs, avoids it.

Quick Analysis

Select a block of data and a small icon appears at its bottom-right corner. Press Ctrl + Q to open it. Quick Analysis offers one-click formatting (data bars, color scales, icon sets), charts, totals, tables, and sparklines for the selection. It is the fastest way to try an idea, and everything it creates is ordinary Excel content that you can edit afterward. See sparklines, data bars and icon sets and creating your first chart for the details.

Go To Special

Go To Special selects cells by kind instead of by address. Open it with Ctrl + G, then Special, or with Ctrl + G followed by Alt + S. Useful options:

  • Blanks: every empty cell in the selection, for example to fill gaps.
  • Constants and Formulas: separates typed values from calculated ones, with sub-options for numbers, text, logicals and errors.
  • Row differences / Column differences: finds cells that break a pattern.
  • Visible cells only: the same as Alt + ;.
  • Data validation and Conditional formats: finds where those rules live.
  • Last cell: the cell Ctrl + End goes to.

A classic recipe: select a range, choose Blanks, type = and press Up, then Ctrl + Enter. Every blank cell now repeats the value above it, which repairs a report where group names appear only once.

The stand-in classifies the cells of a small sheet the way Go To Special groups them, including errors produced by formulas.

JS A Go To Special stand-in

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Notice that C3 is not an error: a blank cell counts as 0 in arithmetic, so the formula quietly returns 0. That is why hunting blanks with Go To Special is a good first step when totals look suspicious.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. You want to enter the same value into 200 selected cells at once. What do you press after typing it?

    Ctrl + Enter confirms the entry and fills it into every selected cell. Enter only fills the active cell.
  2. 2. After copying cells that contain formulas, which Paste Special option keeps only the current results?

    Paste Values replaces formulas with their calculated results, so later changes to the inputs no longer affect them.
  3. 3. What does F4 do while you are editing a formula and the cursor touches a reference?

    In a formula, F4 cycles A1, $A$1, A$1 and $A1. Outside a formula it repeats your last action.
  4. 4. Which tool selects every empty cell in a range so you can fill them all in one go?

    Go To Special with the Blanks option selects only the empty cells of the current selection.

Summary

  • Move with Ctrl + arrows, Ctrl + Home and Ctrl + G; select with Shift, Ctrl + Shift + arrows and Ctrl + Space / Shift + Space.
  • F2 edits a cell, Ctrl + Enter fills a selection, Ctrl + D and Ctrl + R fill down and right, F4 anchors references or repeats an action.
  • Ctrl + 1 opens Format Cells, and the Ctrl + Shift + number keys apply common number formats.
  • Paste Special (Ctrl + Alt + V) pastes only values, formats, widths, or applies math; Transpose swaps rows and columns.
  • Quick Analysis (Ctrl + Q) previews formats, charts and totals; Go To Special selects blanks, formulas, constants, errors and visible cells.
  • Add one new shortcut at a time until it becomes automatic.

Next, test what you have learned in Excel Interview Questions and Answers.