Fill handle options

%3CLINGO-SUB%20id%3D%22lingo-sub-2353486%22%20slang%3D%22en-US%22%3EFill%20handle%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2353486%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20use%20the%20autofill%20option%2C%20however%2C%20the%20flashfil%20is%20not%20there.%20It's%20showing%2C%20it's%20just%20not%20the%20'fill%20series'%2C%20'copy'%2C%20ect.%20It's%20showing%20data%20validation%2C%20chart%20options.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MorganRebecca_0-1620959803016.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280668i66CEB6CBEAA6C5C6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MorganRebecca_0-1620959803016.png%22%20alt%3D%22MorganRebecca_0-1620959803016.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2353486%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2385905%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20handle%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053522%22%20target%3D%22_blank%22%3E%40MorganRebecca%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Etry%20the%20setting%20on%20the%20right.%20If%20it%20is%20not%20enough%2C%20try%20deactivating%20the%20quick%20analysis%20option%20as%20per%20the%20left%20picture.%20To%20access%20this%20dialogue%20box%20go%20to%20File%20%26gt%3B%20Options.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Disable%20Quick%20Analysis%20Options%20%2B%20activate%20fill%20series%20button.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283770i1CE3FFE70D5681E7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Disable%20Quick%20Analysis%20Options%20%2B%20activate%20fill%20series%20button.jpg%22%20alt%3D%22Disable%20Quick%20Analysis%20Options%20%2B%20activate%20fill%20series%20button.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm trying to use the autofill option, however, the flashfil is not there. It's showing, it's just not the 'fill series', 'copy', ect. It's showing data validation, chart options.

MorganRebecca_0-1620959803016.png

 

1 Reply

@MorganRebecca 

try the setting on the right. If it is not enough, try deactivating the quick analysis option as per the left picture. To access this dialogue box go to File > Options.

 

Disable Quick Analysis Options + activate fill series button.jpg