Inserting Content with Flash Fill
Flash Fill (New!) is a feature that automatically fills in data based on the content it recognizes in other cells. Excel uses pattern recognition to help you fill in the content. For example, if you have a cell with a first name and last name, you can split the information into two cells with Flash Fill. In an adjacent cell, when you type the first name in a couple of cells to create a pattern, Excel recognizes it, and then allows you to auto fill in the rest of the column. After the auto fill, you can click the Flash Fill Options button (New!) to undo the Flash Fill, Accept Suggestions, or select all blank or changed cells.
Insert Data Using Flash Fill
Select the first cell in the range you want to flash fill. ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
