Dragging to fill dates

G

Gord Dibben

Sounds like the dragged dates are not real dates.

Re-enter as a date that Excel recognizes.


Gord Dibben MS Excel MVP
 
M

M Kan

If it's a consecutive series of dates, you might just have to enter the
second date, select both, and then drag down.
 
M

Matt S

The problem I’m having is not limited to dates. I can’t fill sequential
numbers either. And, the problem is only occurring on one worksheet in the
workbook.

On the problem worksheet, whether I try to fill dates or integers, I can’t.

But, I added a worksheet and I can do exactly what I’m accustomed to. I can
drag a date or a set of numbers and get a sequential fill.

Honestly.

This is one has me really stumped. HELP!
 
Top