Learn how to use Flash Fill with a right click or with its shortcut; save time filling your Excel worksheets. Ted Jordan will show you 3 ways of using this handy data tool!
Watch our short video on the right to use Flash Fill with a right click.
Read our tutorial to learn the Flash Fill shortcut and where to find this great Excel tool!
What is Flash Fill?
In MS Excel, Flash Fill automatically fills your data when it recognises a pattern.
Where is Flash Fill in Excel?
You can find Flash fill by clicking Data then Flash Fill (lightning symbol).
![Screenshot highlighting where to find Flash Fill in Excel. Data tab.](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/where-is-flash-fill-excel.png)
You can also find it with a right click: watch the first video on the right!
Flash Fill shortcut in Excel
The Flash Fill shortcut is Ctrl+E. Press Control then E on your keyboard to use Flash Fill.
![Flash Fill shortcut keys for Excel.](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/keyboard-excel-flash-fill-shortcut-.jpg)
How to use Flash Fill in Excel
Using Flash Fill is quick! Flash Fill can sometimes be quicker to use than Text to Column when you want to split text. (Learn how to split text with Text to Column by clicking here.)
Today, learn 3 ways of using this data function and pick the one you prefer!
If you watched our video on top of this tutorial, you already know how to use Flash Fill with a right click. Now, time to learn how to use Flash Fill with its shortcut (Control + E) or by selecting Flash-fill in the Data tab.
Flash Fill – Data tab
To use Flash Fill, follow these 3 steps:
- Enter the first value of your pattern in a cell
- Click Data then Flash-fill
- Accept suggestions
Example
In this example, we want to combine first and last names of our students in column E. Watch our 14-sec-video to see how!
- We type Olivia Mitchell in cell E50 then Enter.
- We click Data then Flash-fill
- We accept suggestions (the system understood the pattern correctly)
Flash Fill shortcut – Control E
Use the Flash Fill shortcut by following these 2 steps:
- Type your value and press Enter
- Press Control then E
Example
In this example, we want to combine the first name of our students with the first letter of their last name using Flash Fill.
We type Olivia M in cell E50 then Enter.
![Flash Fill shortcut use example. Screenshot of Excel table with "Olivia M" highlighted in cell E50.](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/excel-flash-fill-example-shortcut-1.png)
After pressing Control then E keys on our keyboard, the system completes the rest of the column, following the same pattern.
![Flash Fill shortcut pressed so data in column E is appearing in Excel.](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/excel-flash-fill-control-e.png)
We click Accept Suggestions and voilà !
![The system asks us to accept or not its suggestions after pressing the Flash Fill shortcut in Excel.](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/excel-flash-fill-control-e-accept-suggestions-1024x281.png)
Now, you know how to use Flash Fill in Excel and its shortcut!