Excel defaults to filling a series with the autofill. I put 1 in cell a1 and autofill down it goes to 2,3,4,5...
How do I change the default so it stays 1 all the way down?
I know to use CTRL/click/drag to copy.
What I am asking is if the default can be changed so that clicking and dragging produces a copy; CTRL/click/drag produces the series.
Thanks!
How do I change the default so it stays 1 all the way down?
I know to use CTRL/click/drag to copy.
What I am asking is if the default can be changed so that clicking and dragging produces a copy; CTRL/click/drag produces the series.
Thanks!