Fill Handle - Double Click is Incrementing Dates

[polarisking]

Is there a way when you double click the fill handle to have it NOT increment date values?

 

[Debraj]

After completion.. in the bottom right side.. excel display you and took confirmation from you. if excel has done correct for you or not..

In the bottom Autofill option.. you can choose..
* Copy Cell.
* Fill Series
* Fill Days weekend or month

tell excel.. what you want to see after double click..

 

[polarisking]

Debraj, thank you. That's a perfect solution.

 

[Abhijeet R. Joshi]

If I am getting you right, you don't want the dates to be incremented..

So you can convert the dates to values and then try using the fill handle..