Dragging to fill dates

[Matt S]

When I drag dates the date remains the same.

What do I need to ajust?

 

[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 Kan]

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

 

[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!