Make it so that Autofill only increases by 1 no matter how many tiles are involved
Excel Version: Windows 7
I am working on a sheet that, to put it together, requires the use of Autofill to drag multiple formulas downward. I want to know, rather than the current situation I am in:
(The selected tile has been autofilled by dragging the top three tiles down, as shown below: The first tile's value was =$A1, as shown on the image underneath the below one)
The values are to only increase by 1 no matter what happens.
...Like this!