View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Soundar Soundar is offline
external usenet poster
 
Posts: 43
Default disable consecutive date option

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.

"srain001" wrote:

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