Microsoft Office Tutorials and References
In Depth Information
Inserting Content with Flash Fill
Select the range you want to flash fill.
Click the Data tab.
Click the Flash Fill button on the Data tab to have Excel try to recognize the
Excel auto fills in the cells with the recognized data pattern.
To choose how to fill the selection, click the Flash Fill Options button, and
then click the option you want:
• Undo Flash Fill. Performs an undo of the flash fill.
• Accept suggestions. Accepts the flash fill.
• Select all X blank cells. Selects all the blank cells from the flash fill.