Using Excel 2007 is it possible to insert a column of dates in sequential order?

Question

Without having to enter them individually. I've got about three months worth of dates and really don't want to have to go into each cell to change a number.

Answer 1

Enter the first date and then click on the cell and hover over the bottom right corner until the cursor turns into a cross. Drag the cross down to the desired number of cells.

Answer 2

Yes - enter 3 sequential dates in 3 cells, select those cells, take mouse to bottom right corner when it becomes a + click and drag down. Stop when expexted end date you seen on the box



Or just prees F1 in excel and look for autofill help.

Answer 3

Set the cells to the date format you want. In the first cell type your first date. In the one below type the next in the sequence. Then highlight both cells, put the cursor at the bottom right corner so you get a cross. Then click and drag the cells you want filled

Answer 4

Type the first day or date in the list, for example Monday or 6/13/08, in a cell.

Select the cell and use the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) to fill a list of consecutive days.

Note If the fill handle is not displayed, click Options on the Tools menu. On the Edit tab, select the Allow cell drag and drop check box.



If you want only weekdays in your list or if you want to display dates with monthly or yearly intervals, click Auto Fill Options and then select Fill Weekdays, Fill Months, or Fill Years.

Answer 5

Yes - enter 3 sequential dates in 3 cells, select those cells, take mouse to bottom right corner when it becomes a + click and drag down.



It will autofill.

Answer 6

Yes, just enter two dates then highlight both and use autofill to complete the sequence, ie mouse pointer on little black box bottom right of border of bottom cell and drag downl. Don't forget to format the cells for date format.

Answer 7

Can't understand your situation, put it on table or IM me.