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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top