CODEWITHSUNDEEP
excelms-officeautofill
JF4bes
JF4bes

Reputation: 157

Excel Autofill not working

I'm using Excel 2016. I want to autofill numbers (I.e 1,2 when dragged would autofill with 3 and so on).

For some reason, when highlight the cells of both 1 and 2 when I trying to drag to autofill to the cell below all three cells now contain the value 1.

Autofill is turned on in the options>advanced menu.

Thanks for all help in advanced

Upvotes: 1

Views: 9289

Answers (2)

JF4bes
JF4bes

Reputation: 157

I figured out my own question. I had filtered columns that were sorted and with some values filtered out. Although the cells I was trying to figure were adjacent this stopped the autofill from working correctly.

Upvotes: 2

Hoejanson
Hoejanson

Reputation: 134

After you drag you have to select "fill series" from the fill options menu that pops up.

Upvotes: 0

Related Questions