Jul 25 2020 12:10 AM
Jul 25 2020 02:59 AMSolution
Jul 29 2020 06:00 AM
If you want the values in a column adjacent to a populated column that has no blanks, you can enter the starting value in the first cell, then double-click the fill handle in the lower right corner of the cell. Excel will automatically fill the column down to the last used row.
Alternatively, enter the starting value in the first cell. With that cell still selected, scroll down and then hold down Shift while selecting the last cell. On the Home tab of the ribbon, click Fill > Flash Fill.