Excel in adjacent cells to enter the same date data, although the method of lot, but what kind of method most convenient for you? The following list of what I gave you 11, what's most convenient for your own conclusion on it.

1, Earth people know the copy and paste Dafa:

enter in a cell after the date of completion, any other cell in the first click, then just right-click the cell you enter the date, left the pop-up shortcut menu, select "Copy" Finally ready to fill using the mouse drag the selected cells of the date and then select any of the mouse pointer targeting a cell right-click, left select "Paste" on it.

2, Ctrl + Enter key to filling method:

ready to enter the same date to all the cells are dragging selected, enter the date and press Ctrl + Enter (hold down with one hand, a Ctrl key, then the other hand press Return) . (This method is not continuous in the cell can also be achieved)

3, press the key combination Ctrl + D and Ctrl + R method:

in the last line entered after the date of completion, then move the cursor to the next line of the corresponding cell and press Ctrl + D or Ctrl + '(single quote) key, you can put the last date entered in cell replication to The cell was. If the cell should be left to the right of the date of copying the cell according to Ctrl + R key.

4, hold down the Ctrl key to drag the fill handle method after:

in a cell you enter the date, hold down the Ctrl key after a mouse pointer to the lower right corner of the cell, such as the mouse pointer becomes a black cross, hold down the left button down (or right) drag to fill. (If you do not press Ctrl key, fill out date will be increasing day by day.)

5, using the formula cell reference method:

in cell A2, enter the date of completion, to the cell A3 enter the formula: = a2, a3 and then the mouse pointer to the lower right corner of the cell, such as the mouse pointer becomes a black cross, hold down the left button down Drag the fill. This fills the result is dynamic, that is, if in the future if the date cell A2 to 2007-11-8, then other cells will automatically become 2007-11-8 date. (Figure 1)