Flash Fill Excel Shortcut. Usually flash fill starts automatically and you only need to provide a pattern. How to use flash fill in excel.
Now it will insert all the fy numbers from the invoice numbers columns. Flash fill automatically fills your data when it senses the pattern. Those of you who prefer working from a keyboard most of the time can run flash fill with this key combination.
Firstly drag the first entry until the end and now click on the autofill option in excel and select the flash fill.
First type both the name in the single column and by holding on ctrl key press e i e. How to use flash fill create a table same as like picture above and type the data that needs to be extracted out of it in cell c2. Insert a new column adjacent to the column with your source data. You can also press ctrl e on the keyboard.
