What Does Ctrl+E Do in Excel?

Ctrl+E in Excel is the keyboard shortcut for Flash Fill — a feature that detects a pattern from example cells you type, then applies that pattern to the rest of the column. It was introduced in Excel 2013 and is available in every Windows release since, plus Excel for Microsoft 365 and Excel for the web.

That single behaviour — Flash Fill — is the only thing Ctrl+E does. It does not clear formatting, edit cell contents, or select the current region; those are common confusions covered at the end of this article.

Table of Contents

1. What Ctrl+E does
2. Pattern 1: Split a column into parts
3. Pattern 2: Combine columns into one
4. Pattern 3: Extract text from a longer string
5. Pattern 4: Reformat or change case
6. When Flash Fill fails and how to recover
7. Shortcuts often confused with Ctrl+E
8. FAQs

What Ctrl+E does

Ctrl+E activates Flash Fill in Excel. Flash Fill works by reading one or more example cells in a column adjacent to your source data, inferring the transformation rule, and filling the remaining rows. It does not write a formula — it pastes values directly into the destination cells.

Use the right keyboard for Excel to keep both hands on the keys when you switch between typing examples and pressing Ctrl+E.

The four patterns below cover the use cases that account for almost all real-world Flash Fill work.

Pattern 1: Split a column into parts

You have a single column containing “Last, First” or “First Last” names, and you need them split.

1. Place the cursor in the cell immediately to the right of the first source cell (for example, B2 if your names are in column A).
2. Type the part you want to extract for that row — for example, type John if A2 is John Smith.
3. Press Ctrl+E.

Excel reads your one example and fills the rest of column B with the first names. Repeat in column C for last names.

Flash Fill handles other split patterns the same way — splitting email@domain.com into local part and domain, splitting 123-456-7890 into area code and number, splitting addresses into street, city, postal code.

Pattern 2: Combine columns into one

You have first names in A and last names in B and want a combined column.

1. In C2, type the combined value you want — for example, Smith, John.
2. Press Ctrl+E.

Excel detects the combination rule (last name, comma, space, first name) and fills the column. Unlike a formula approach with =B2 & ", " & A2, the Flash Fill result is static text — useful when you intend to delete the source columns afterwards.

Pattern 3: Extract text from a longer string

You have a column with email addresses like colin@excel.tv, and you want only the domain.

1. In the adjacent column, type excel.tv for the first row.
2. Press Ctrl+E.

Excel recognises the rule “everything after the @ symbol” and extracts the domain from each remaining row. The same approach extracts file extensions from paths, country codes from phone numbers, or order IDs from a longer reference string.

If your sample row is ambiguous (multiple valid patterns explain it), Flash Fill picks one. Type a second example to disambiguate — Excel relearns the rule from the broader sample.

Pattern 4: Reformat or change case

You have product codes typed inconsistently (abc-123, DEF-456, Ghi-789) and want them all uppercase.

1. In the adjacent column, type ABC-123 for the first row.
2. Press Ctrl+E.

Excel applies the casing rule. The same approach reformats dates (2025-05-17 → May 17, 2025), restructures phone numbers (5551234 → (555) 123-4), or pads numeric IDs with leading zeros.

When Flash Fill fails and how to recover

Three common failure modes and the corresponding fix:

• Flash Fill produces wrong results. The single example was ambiguous. Type a second corrected example in the next row and press Ctrl+E again; Excel relearns from both rows.
• Ctrl+E does nothing. There is no example to learn from. Type at least one example in the destination column first.
• Flash Fill is disabled. Open File › Options › Advanced › Editing options and confirm “Automatically Flash Fill” is checked. On macOS, the command lives on the Data tab — the Ctrl+E binding may not be wired up by default.

Flash Fill writes values, not formulas. If your source data changes after running Flash Fill, the destination column will not update. For dynamic transformations use the TEXTSPLIT, TEXTBEFORE, and TEXTAFTER functions (Microsoft 365) or LEFT, RIGHT, MID, FIND for older Excel.

Shortcuts often confused with Ctrl+E

Search traffic suggests several keyboard shortcuts get attributed to Ctrl+E. None of these are correct — here is what each task actually requires:

The last row is the source of much of the confusion: in Microsoft Word, Ctrl+E centre-aligns the current paragraph. The Excel binding is unrelated.

FAQs

Is Flash Fill available in all versions of Excel?

Flash Fill was introduced in Excel 2013 for Windows. It is available in all subsequent Windows releases, in Excel for Microsoft 365, and in Excel for the web. On Excel for Mac, Flash Fill is on the Data tab; the Ctrl+E binding may not be active by default.

Can Flash Fill replace VLOOKUP or formulas?

No. Flash Fill writes static values based on a pattern in adjacent cells; it cannot reference a separate lookup table or recalculate when source data changes. For dynamic transformations, use formulas or Power Query.

Why is Ctrl+E not working?

Most often, there is no example for Flash Fill to learn from — type a sample value in the destination column first. If that does not help, check File › Options › Advanced › Editing options › Automatically Flash Fill is enabled, and confirm your Excel version is 2013 or later.

Does Ctrl+E clear formatting?

No. Clear formatting is Alt, H, E, F (Home › Editing › Clear › Clear Formats). Ctrl+E only triggers Flash Fill.

Does Ctrl+E select the current region?

No. Use Ctrl+A (once) for the contiguous data block, twice for the whole sheet, or Ctrl+Shift+* (asterisk) as an explicit current-region shortcut.