Copying dates in Excel [Solved/Closed]

Jessica - Nov 23, 2010 at 09:14 PM - Latest reply:  berry
- Oct 29, 2015 at 04:24 PM
Hello,

I created a workbook in Excel and frequently need to copy the same date down a single column. I've always been able to simply grab the + in the bottom right corner of a cell and drag it down the column to copy the same date into each cell. I must have done something wrong setting up this new workbook. When I try to copy the date, using the same method, the column fills with a series of consecutive dates instead of simply copying the same vale into each cell. What do I need to do to fix this? I know the solution is simple, but I can't think of the correct wording to find the answer.

Thanks.

See more 

3 replies

Best answer
11
Thank you
Immediately after dragging please have a right click at the last cell copied and select copy cells rather than fill series

Thank you, mohasin 11

Something to say? Add comment

CCM has helped 1679 users this month