Simple problem...

[NoNoBadDog!]

I am new to using Excel. I want to create a column that has the days of the
month (1 Nov 03 thru 30 Nov 03). I know there is a way I can put the date
in the first cell and then either paste or drag down and excel will add the
dates sequentially, but I can't seem to figure out how to do it...I did it
once before and don't remember the sequence that I followed. Could someone
please post the steps on how to do this?

Thanks!

Bobby

 

[Paul B]

Bobby, put the date in a cell, A1, and click on the black square in the
lower right hand corner and drag down

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[NoNoBadDog!]

Thanx!!!

Bobby

Bobby, put the date in a cell, A1, and click on the black square in the
lower right hand corner and drag down

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Brandenkopf]

Another way, without having to do any dragging:

Write 1 Nov 03 in cell A1.
Using menus: Edit-Fill-Series...
In series window select the following option buttons:
Select series in columns, Type Date, Date Units Day, Step Value 1,
Stop Value 30 Nov 03. Then press OK.