Auto fill data in a large sheet

Author: Michelle McCausland

1. With the range selected (A2:A11), press [F5] to display the Go To dialog.
2. Click Special.
3. Select Blanks.
4. Click OK. Doing so selects only the blank cells.
5. In the anchor or active cell, enter =A2 (be sure to adjust the cell reference accordingly when applying this to your own work).
6. Press [Ctrl]+[Enter] to copy the formula in the active cell to all of the selected cells. Doing so will produce the repeated-date series.