====== Auto fill data in a large sheet ======

Author: Michelle McCausland

  - With the range selected (A2:A11), press [F5] to display the Go To dialog.
  - Click **Special**.
  - Select **Blanks**.
  - Click **OK**. Doing so selects only the blank cells.
  - In the anchor or active cell, enter **=A2** (be sure to adjust the cell reference accordingly when applying this to your own work).
  - 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.