Fill Series as default when drag-n-drop

[hajiali]

is there a way to have excel to only allow Fill series instead of copy cells when dragging the + sign down. For example if I input value #2 in a2 and i slecect cell a2 and drag the + (bottom right of cell) to only go to 3,4,5,6 etc, instead of copying the value #2 .

If there is a way to default this to happen when the workbook is opened that would be wonderful.

Any suggestions is greatly appreciated.

 

[Jeffrey Mahoney]

Fill Series is only going to work if you select at least two cells. Copy happens when you select only one cell

If you only give it one value, Excel doesn't know how to fill the cells down. Example:
A2 = 2
A3 = 3
Select cells A2:A3
Pull the + down

I did a search and cannot find a way to disable copy with the + fill handle.