Copying dates in Excel [Solved/Closed]

Question

Copying dates in Excel [Solved/Closed]

Report

Jessica - Nov 23, 2010 at 09:14 PM
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.

How to copy date in excel without changing
Drag date in excel without changing - Best answers
Copy date - Best answers
Excel vba - change cell color based on value ✓ - Forum - Programming
Excel language change shortcut key - How-To - Keyboard
Excel author change - How-To - Excel
Excel vba change row color - How-To - Excel
Excel vba change cell color - How-To - Excel

1 reply

Ask a question

mohasin · Accepted Answer · 2010-11-25T02:25:46-0500

Answer 1 / 1

mohasin
Nov 25, 2010 at 02:25 AM

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

Report

Twigdust
Sep 15, 2015 at 05:45 PM

Thanks :-)

Report

berry
Oct 29, 2015 at 04:24 PM

thanks!!

Copying dates in Excel [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!