26 May 2026 ... Method 1: Using Excel Flash Fill Option. To use Excel flash Fill follow the following steps: Step 1: Enter the desired value in the first cell ...