How to Flash Fill in Excel with a button click or shortcut

To find the number of the Flash Fill changed cells, just look at the Excel status bar.

If Flash Fill does not start automatically, try these simple troubleshooting techniques.

If you are unhappy with the Flash Fill results, you can undo them by pressing Ctrl + Z or via the Flash Fill options menu.

Press the Enter key to accept the preview.Start typing in the next cell, and if Excel senses a pattern, it will show a preview of data to be auto-filled in the below cells.

In the first cell of a newly added column, type the desired value.Insert a new column adjacent to the column with your source data.Usually Flash Fill starts automatically, and you only need to provide a pattern. Those of you who prefer working from a keyboard most of the time, can run Flash Fill with this key combination: Ctrl + E In Excel 2013 and later, the Flash Fill tool resides on the Data tab, in the Data tools group: All this is done in milliseconds in the background, and the user sees the results almost immediately! Started in December 2009 as an attempt of Sumit Gulwani, a senior researcher at Microsoft, to help a businesswoman he accidentally met at the airport with her merging challenge, a few years later it has evolved into a powerful ability to automate many Excel chores.įlash Fill easily copes with dozens of different tasks that otherwise would require complex formulas or even VBA code such as splitting and combining text strings, cleaning data and correcting inconsistencies, formatting text and numbers, converting dates to the desired format, and a lot more.Įach time, Flash Fill combines millions of small programs that might accomplish the task, then sorts those code snippets using machine-learning techniques and finds the one that suits best for the job. The Flash Fill feature was introduced in Excel 2013 and is available in all later versions of Excel 2016, Excel 2019, Excel 2021, and Excel for Microsoft 365. With a premium version* of Excel 2016 and a Power BI license, you can also use search to discover corporate data available to you across your company that is shared in a corporate catalog or even share your own queries with others.Excel Flash Fill is a special tool that analyzes the information you are entering and automatically fills data when it identifies a pattern. And once you have the information prepared, you can share your queries easily with others.Īdditional features available under the Get & Transform section include accessing recent sources you've used in previous queries and options to combine queries together. When you refresh the data connections, every step you took to transform the data is preserved. Each step you take to transform the data can be repeated and rearranged to help you work faster and more efficiently. The Query Editor, which opens when creating a new query or opening an existing one under Get & Transform, provides intuitive data shaping and transformation options, enabling you to prepare a data set with only the information you want to see and in the way you want to see it. Access them from the Get & Transform section on the Data tab. These new capabilities, previously only available as a separate add-in called Power Query, can be found within Microsoft Excel 2016.

Microsoft Excel 2016 now comes with built-in functionality that brings ease and speed to getting and transforming your data, allowing you to find and access all the data you need into one place. The software has new and improved business analytics features and makes improvements to the design with analysts in mind. Excel is the world's most widely used and familiar data analysis tool, especially now with the new Power BI and Power BI Desktop to provide business analysts with a powerful portfolio of analytic tools unique in the industry.

Microsoft excel for mac flash fill