Ctrl+E in Excel: What the Shortcut Does and How to Use It

In Excel for Microsoft 365 on Windows, Ctrl+E runs Flash Fill. Flash Fill recognizes a pattern in your example and fills neighboring cells with matching results, such as separating first names from full names or reformatting phone numbers.

What Ctrl+E does in Excel

Flash Fill uses the example you enter to infer a text pattern, then applies that pattern to other rows in a nearby column. For instance, if column A contains full names and you type one person’s first name in B2, Flash Fill can identify the first-name portion in the rest of the list. Pressing Ctrl+E tells Excel to try to complete the pattern.

It is a data-entry and text-transformation tool, not a formatting shortcut and not a formula. The results are placed in cells as values. Flash Fill is particularly useful for one-time cleanup when the transformation is predictable and the source data follows a reasonably consistent structure.

The shortcut is context-sensitive: use it from the worksheet with a relevant example and source data nearby. It does not mean “center align” in Excel. Shortcuts differ between Microsoft apps, so a key combination that centers text in another program should not be assumed to do the same thing in a worksheet.

How to use Ctrl+E step by step

Put the source values in one column and leave the adjacent destination column available for the results. Type an example of the desired output beside the first source row. That example gives Excel a pattern to analyze; it is not a command to transform every possible kind of text.

For example, suppose A2 contains Maria Chen and A3 contains David Ortiz. Click B2 and type Maria.
Keep the destination cell selected, then press Ctrl+E. Alternatively, use Data > Flash Fill on the ribbon.
Check the filled values against the source. If the pattern is not clear from one example, undo the result, enter another example in the next row, and try again.
Review the whole output column, especially rows with unusual names or formats, before using the results elsewhere.

Excel may also display a Flash Fill suggestion as you type. If the suggested preview is what you want, accept it; otherwise, keep typing or use the ribbon command when you are ready. The shortcut is a direct way to request the fill, rather than waiting for Excel to offer a suggestion.

Common jobs Flash Fill can handle

Flash Fill is strongest when the desired output is a clear, repeatable text pattern. A single example can be enough for simple data, but more varied source values may require additional examples and careful checking.

Split names: extract first names or surnames from a column of full names, provided the name structure is consistent enough to interpret.
Combine text: create a display name from separate first-name and last-name columns by typing one combined example.
Standardize phone numbers: reformat digits into a familiar presentation, such as adding parentheses or hyphens. Check that every source value has the same number of digits and country-code conventions.
Extract part of an identifier: pull a store code, product prefix, or other recurring portion from a longer text value when the position or pattern is recognizable.
Change capitalization or presentation: create consistently styled text from entries that use mixed capitalization, then inspect names and acronyms that may have special rules.
Make email-related text: extract a portion such as a username or domain from addresses when the pattern is unambiguous.

These are pattern-based transformations, not guarantees that Excel understands the meaning of the data. A name with a middle initial, a two-part surname, or a suffix can be interpreted differently from a simple two-word name. Treat the output as a draft to review, not as proof that every row was understood correctly.

Automatic Flash Fill and the ribbon command

Flash Fill can run automatically when Excel detects that your entry follows a pattern in nearby data. If Excel presents a preview, you can accept the suggested completion or continue entering examples if it is wrong. Automatic detection is convenient, but it can also make a premature guess when the first few rows do not represent the entire list.

If automatic suggestions do not appear, you can request the feature explicitly with Ctrl+E or choose Data > Flash Fill. In the Windows desktop app, the automatic behavior can be controlled under File > Options > Advanced, in the editing options. The setting affects whether Excel attempts to fill data automatically; it does not change what the manual Flash Fill command is for.

For a predictable workflow, enter a representative example first, invoke Flash Fill deliberately, and inspect the results. The ribbon command is useful if you prefer menus, if you are troubleshooting the shortcut, or if you want to confirm that you are invoking Flash Fill rather than another keyboard command.

What Flash Fill cannot reliably do

Flash Fill infers a pattern; it does not let you define a precise rule with conditions. It may struggle when the source has inconsistent spacing, missing values, variable numbers of words, mixed date or phone formats, or exceptions that require a different result. If a list contains both one-word and multiword surnames, for example, a simple first-and-last-name pattern may not produce the intended split for every row.

It is also not a general substitute for cleaning imported data. It does not provide a transparent formula showing how each result was derived, and its values do not automatically recalculate when the source changes. If your output must remain linked to source cells or follow complicated business rules, use formulas or a repeatable data-cleaning process instead.

Before using a large result, look for blanks, unexpected extra words, inconsistent punctuation, and values that differ from the pattern. Keep the original source column until you have confirmed the transformation. If a mistake appears, undo immediately with Ctrl+Z and try again with better examples or a more explicit method.

Flash Fill versus formulas and AutoFill

Flash Fill and AutoFill can both populate cells, but they solve different problems. Flash Fill learns a text transformation from examples. AutoFill, commonly used by dragging the fill handle, copies cell contents or extends recognizable sequences such as dates and numbers. For example, dragging a date may continue a series; that is not the same as extracting a name from a text string.

A formula is usually the better choice when results must update as the source changes, when the rule needs to be precise, or when you want a visible and reusable calculation. Flash Fill is useful when you want a quick, one-time set of values and can verify the output. The trade-off is transparency and maintenance: a formula preserves the rule in the cell, while Flash Fill leaves the completed values without a formula link to the original data.

For recurring workbooks, consider whether a formula, a carefully designed data import, or a documented cleanup procedure would be safer than repeating a manual fill. For a small list that will not change, Flash Fill may be the simpler option. Whichever method you choose, retain an untouched copy of important source data until the result is checked.

Windows, Mac, and Excel for the web

In Excel for Microsoft 365 on Windows, Ctrl+E is the Flash Fill shortcut. In current desktop versions of Excel for Mac, the corresponding shortcut is generally Control+E as well; use the Control key, not Command, for this command. Keyboard behavior can vary with application version, keyboard layout, or system-level shortcut settings, so the ribbon route is a useful fallback.

On either desktop platform, look for Data > Flash Fill if the keyboard shortcut is unavailable or does not behave as expected. Excel for the web does not always provide the same desktop Flash Fill functionality or shortcut. If you cannot find the command in the browser app, open the workbook in the desktop version or use a formula or another supported editing method.

Shortcuts can also be affected by the active cell and the current editing state. If you are typing inside a cell rather than working with the worksheet selection, finish or cancel that edit first, then select the destination cell and try again. This helps distinguish a shortcut issue from a context issue.

Common problems and practical fixes

If Ctrl+E seems to do nothing, first confirm that the active worksheet has source data and a suitable example beside it. Flash Fill needs a pattern to infer; pressing the shortcut in an unrelated blank area may not produce useful output. Check that you are in the desktop Excel application and that the destination area is available.

The results are wrong: undo, then provide a more representative example or a second example that clarifies the pattern. Check rows with exceptions separately.
No preview appears: do not rely on automatic detection. Select the target cell and use Ctrl+E or Data > Flash Fill.
The shortcut is intercepted: use the ribbon command to see whether Flash Fill itself is available. Other software, keyboard utilities, or remote-desktop settings can affect key combinations.
The source changes but results do not: this is expected because Flash Fill inserts values, not live formulas. Run the transformation again after checking the updated source, or use a formula if automatic updates are important.
Some rows are inconsistent: inspect the source for extra spaces, missing pieces, or different formats. Correct the source or handle exceptions with a method that makes the rule explicit.

For sensitive or important data, review the output before deleting or replacing the original. A few spot checks are helpful, but checking every row is safer when the list is short or when errors could affect later reporting.

Frequently Asked Questions

What does Ctrl+E do in Excel?

In desktop Excel, Ctrl+E runs Flash Fill. It uses a pattern in an example cell to fill related values in a nearby column, often for text cleanup or extraction.

How do I use Flash Fill without the shortcut?

Enter an example in the destination column, select the appropriate cell, and choose Data > Flash Fill. On Windows, the command is also available from Ctrl+E.

Does Flash Fill update when I change the original data?

No. Flash Fill produces values rather than formulas, so those results do not automatically change when the source changes. Use a formula when you need a live relationship.

Why is Ctrl+E not working in my workbook?

Check that you are using desktop Excel, that the worksheet has a recognizable example and nearby source data, and that you are not still editing inside a cell. If necessary, try Data > Flash Fill.

Is Ctrl+E the same as AutoFill?

No. Flash Fill infers a text pattern from examples, while AutoFill copies cell contents or extends sequences using the fill handle. Choose based on the job you need to complete.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.