Forum Discussion
Solved
Autofill Random Dates
PC/ Windows 10 Pro | Microsoft 365 MSO (16.0.13901.20366) Hello, I was wondering if there was a way to autofill the empty spaces in the "Date Created" column like I have starting from lines 2-73....
Select column A.
Press F5 to display the Go To dialog.
Click Special...
Select Blanks, then click OK.
Note the address of the active cell in the selection -in your sample spreadsheet it is A75.
Enter the formula =A74 (where A74 is the cell above the active cell) and confirm it with Ctrl+Enter.
Easiest is with Power Query - query the range and fill down the dates.