Flash Fill Option In Excel 2007. Another option for using flash fill is to add it to the quick access toolbar. Start typing the next full name in cell c3.
Excel will finish adding the first names to cells b3 to b7. Select the example cells right click and drag the fill handle down release the right click choose flash fill from the resulting menu. Once you ve done this excel will do its best to carry on the pattern.
First tell excel what you want to do by entering the value 130 into cell b1.
Let s see how it did in our case. First tell excel what you want to do by entering the value 130 into cell b1. Excel will sense the pattern you provide and show you a preview of the rest of the column filled in with. Click file options.
