disable consecutive date option

[srain001]

Hi,

How do I disable the consecutive date function? I'm trying to drag and drop
JANUARY in a column, but it keeps displaying the different months.

Thanx
Srain

 

[Soundar]

Hi,

First type Jan in the cell and then hold CTRL key and then drag using fill
handler.

Hope this will clear your doubt.

Regards,
Soundar.

 

[Gord Dibben]

Right-click and drag.

Release button and "Copy Cells"


Gord Dibben MS Excel MVP