If you click on a cell, in the bottom right of the cell is a black square. When you click on the square, drag it vertically or horizontally, and let go, Excel will autofill the cells in the range depending on your selection.

For example, if you wanted all of the cells in the first column to be the number 1, enter 1, click the black box, and drag down:

If you wanted to fill the numbers from 1 to 13:

- Enter 1 in the first cell
- Enter 2 in the cell below
- Highlight both cells
- Click the autofill box and drag down until the number displayed is 13:

There are a couple of ways to get all of the information filled down that you require.

- Enter the following in row 1 and 2:

1 Data1 TRUE 1 3-May-2012

2 Data2 TRUE 2 3-May-2012

- Highlight the whole thing and drag the autofill button down.

or

- Enter the following in row 1 and 2:

1 Data1 True 1 3-May-2012

2 Data2 True 2 3-May-2012:

- Enter the rest of the data in column 2.
- Highlight numbers 1 and 2 in first column and double click the autofill box (or you can drag down). This will fill until the last Data entered in column 2.
- Highlight from True to 3-May-2012 (C1 to E2) in the first 2 rows and double click the autofill box (or drag down the box). Again, this will fill until the last Data entered in column 2.

Hope this helps!