Flash Fill Option In Excel 2010. Click the flash fill button in the data tab of the ribbon. Click the advanced in the left pane and ensure that the automatically flash fill box is checked.
Another option for using flash fill is to add it to the quick access toolbar. Adding flash fill to the quick access toolbar. On the data tab in the data tools group click flash fill or press ctrl e.
On the data tab in the data tools group click flash fill or press ctrl e.
First tell excel what you want to do by entering a correct social security number in cell b1. Ctrl e so the beauty is excel will automatically fill all the names by the use of flash fill. Start typing the next full name in cell c3. Using flash fill in excel.
