Autofill in Excel No Longer Working

%3CLINGO-SUB%20id%3D%22lingo-sub-2388382%22%20slang%3D%22en-US%22%3EAutofill%20in%20Excel%20No%20Longer%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2388382%22%20slang%3D%22en-US%22%3E%3CP%3EToday%2C%20for%20the%20first%20time%2C%20the%20conditional%20formatting%20little%20pop%20up%20bubble%20is%20at%20the%20bottom%20when%20I%20drag%20to%20autofill%20a%20column%20in%20excel.%26nbsp%3B%20So%20I%20want%20my%20column%20to%20list%201%2C%202%2C%203%2C%204%2C%205%2C%206%2C%207....%20but%20it%20will%20only%20copy%20the%20cell%20I%20am%20dragging%2C%20not%20fill%20in%20the%20sequence.%26nbsp%3B%20This%20was%20previously%20corrected%20with%20the%20autofill%20pop%20up%2C%20which%20has%20been%20replaced%20now%20with%20a%20conditional%20formatting%20bubble.%26nbsp%3B%20Can%20someone%20tell%20me%20a%20work%20around%20or%20how%20to%20fix%20the%20settings%20so%20I%20can%20perform%20this%20simple%20task%3F%26nbsp%3B%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2388382%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.