Copy data using the fill handle in Excel 2007

Select the cell or the range of cells that you need to copy. Press the CTRL key. Place the mouse cursor over the Fill handle. The mouse cursor will change to a double plus (a big plus and a small plus at top right). Keeping the CTRL key in pressed state, drag the mouse cursor.
Unlike the Copy and Paste, you can only copy the data to subsequent cells.

Example:
1. In cell A1, type Sunday and press the ENTER key.
2. Click cell A1.
3. Press the CTRL key and drag the fill handle till cell A4.
4. You will see Sunday being copied to cells A2, A3, and A4.
You can also perform the drag operation to the cells that are to the right, or left, or top.

You can also copy the data by keeping the right mouse button in pressed state and dragging the fill handle. You will see the list of options for Auto Fill. Click Copy Cells.