Autofill in Excel No Longer Working

Copper Contributor

Today, for the first time, the conditional formatting little pop up bubble is at the bottom when I drag to autofill a column in excel.  So I want my column to list 1, 2, 3, 4, 5, 6, 7.... but it will only copy the cell I am dragging, not fill in the sequence.  This was previously corrected with the autofill pop up, which has been replaced now with a conditional formatting bubble.  Can someone tell me a work around or how to fix the settings so I can perform this simple task?  Thanks!

1 Reply

@Dana_Cisneros 

If you drag the fill handle with the right mouse button, Fill Series should be one of the options in the popup menu.