automatic dates in a column

  • Thread starter Thread starter gsbbr
  • Start date Start date
G

gsbbr

I know this is an elementary question, but I do not have a manual, and
the "Help" doesn't open in Excel. I've used Excel for several years,
made graphs, etc., but I still don't know how to do the following.

The first column needs to be consecutive dates, e.g., 1/1/04, 1/2/04,
1/3/04, 1/4/04, etc. I have been entering each date in manually, but I
know there must be a simple way for Excel to do this for me. I have to
enter dates for the entire year.

Can anyone help? Thanks for your patience.
 
Put the date in the first cell, select the cell again, move the cursor to
the lower right corner of the cell,
copy it down by left clicking and holding down the mouse button while
dragging downwards
 
Back
Top