Flash Fill Option In Excel 2007. Below is a step by steb guide on how to setup and use flash fill. Click the flash fill button in the data tab of the ribbon.
First type both the name in the single column and by holding on ctrl key press e i e. To accept the preview press enter. The shortcut key for flash fill in excel is ctrl e.
Enter the first name of ken.
Now click inside cell c2. For example if we have two separate names in two different columns. Press the enter key on your keyboard. Adding flash fill to the quick access toolbar.
