Flash Fill Option In Excel 2007. Excel will finish adding the first names to cells b3 to b7. 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. Excel will finish adding the first names to cells b3 to b7. Ctrl e so the beauty is excel will automatically fill all the names by the use of flash fill.
Perform a flash fill by holding the ctrl key and pressing the letter e.
Enter the full name in cell c2 and press enter. For example if we have two separate names in two different columns. Now click inside cell c2. Select the example cells right click and drag the fill handle down release the right click choose flash fill from the resulting menu.
