1) Hold down the Ctrl key when you click and drag the fill handle.
2) Use Ctrl-C / Ctrl-V

HTH,
Bernie
MS Excel MVP


"PTN" wrote in message
...
I want to enter a date in a cell and copy it to cells below without the date
increase one day for each cell. I tried making the first cell a text cell, a
number cell, using quotes. None of these solutions worked. Please let me know
if you have a solution. Thank you. PTN