Turn Flash Fill On In Excel 2016. On the Data tab in the Data Tools group click Flash Fill or press CTRL E. I use many different spreadsheets a day and its a real drag to have to turn.
Click the Advanced in the left pane and ensure that the Automatically Flash Fill box is checked. I cannot stand Flash Fill in Excel because what it attempts to fill is never even close to what I need. In Excel 2019 Excel 2016 and Excel 2013 the Flash Fill tool resides on the Data tab in the Data tools group.
Secondly after typing the first FY into the cell press CTRL E.
You can also press CtrlE on the keyboard. How to Use Flash Fill in Excel 2016. Secondly after typing the first FY into the cell press CTRL E. It will pop up Excel Options dialog box.