•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
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!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#Excel
#Autofill
#Formulas
#Sheet
#Windows 7
#Drag
#Value
#Increment
#A1
#Tile
#Downward
#Cell
#Formula
#Numbers
#Spreadsheet
#Microsoft Excel