AutoFill issues

%3CLINGO-SUB%20id%3D%22lingo-sub-2326835%22%20slang%3D%22en-US%22%3EAutoFill%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326835%22%20slang%3D%22en-US%22%3E%3CP%3EOffice%20'16%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20create%20a%20new%20sheet%20in%20the%20workbook%20autofill%20series%20works%20correctly.%26nbsp%3B%20On%20my%20existing%20sheets%20it%20simply%20copies%20the%20information%20in%20the%20cell%2C%20repeating%20any%20patterns%20that%20may%20exist.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAutoFill%20feature%20is%20turned%20on%2C%20but%20when%20I%20try%20to%20change%20the%20autofill%20options%20the%20only%20available%20choices%20are%20%22Fill%20Formatting%20Only%22%20or%20%22Fill%20Without%20Formatting%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20performed%20select%20all%20and%20tried%20to%20clear%20any%20filters%20in%20the%20home%20or%20data%20tabs%2C%20but%20the%20option%20was%20grayed%20out.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2326835%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Office '16

 

If I create a new sheet in the workbook autofill series works correctly.  On my existing sheets it simply copies the information in the cell, repeating any patterns that may exist. 

 

AutoFill feature is turned on, but when I try to change the autofill options the only available choices are "Fill Formatting Only" or "Fill Without Formatting"

 

I have performed select all and tried to clear any filters in the home or data tabs, but the option was grayed out. 

 

 

0 Replies