Please follow the steps below to enable automatically flash fill, or check here to disable flash fill.
Step 1: Click the "File" Tab from the ribbon;
Step 2: Click "Options" from the left navigation menu;
Step 3: Click "Advanced" from the left navigation menu in the dialog box;
Step 4: Check "Automatically Flash Fill" under the section of "Editing options";
Step 5: Click "OK" at the bottom.
