disable consecutive date option

S

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
 
S

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.
 
G

Gord Dibben

Right-click and drag.

Release button and "Copy Cells"


Gord Dibben MS Excel MVP
 
Top