Flash Fill Excel 2007. Flash fill did not correctly extract the decimal numbers only the digits after the decimal point. Click the arrow on the box to see a menu.
Click the advanced in the left pane and ensure that the automatically flash fill box is checked. To do a flash fill hold down the ctrl key on your keyboard. Notice the small box that s appeared in the bottom right of the selected cell b3.
Keep the ctrl key held down and press the letter e on your keyboard.
On the data tab in the data tools group click flash fill or press ctrl e. Using flash fill in excel. Click file options. On the data tab in the data tools group click flash fill or press ctrl e.
