Home

Autofill options are not appearing when I drag the cell

%3CLINGO-SUB%20id%3D%22lingo-sub-432690%22%20slang%3D%22en-US%22%3EAutofill%20options%20are%20not%20appearing%20when%20I%20drag%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-432690%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20drag%20cells%20down%20the%20same%20row.%20However%2C%20when%20I%20do%20it%2C%20it%20only%20repeats%20the%20same%20one%2C%20even%20though%20I%20select%20different%20dates%2C%20for%20example%20when%20selecting%2009%2F04%2F19%20%26amp%3B%2010%2F04%2F19%20and%20dragging%20them%20down%2C%20all%20the%20cells%20would%20have%2009%2F04%2F19.%20As%20I%20drag%20the%20cells%2C%20autofill%20options%20do%20not%20appear%2C%20instead%2C%20I%20get%20the%20option%20for%20%22quick%20analysis%22.%20Please%20help.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-432690%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-432960%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20options%20are%20not%20appearing%20when%20I%20drag%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-432960%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F318872%22%20target%3D%22_blank%22%3E%40Sebastian_Mora%3C%2FA%3E%26nbsp%3B%2C%20even%20your%20dates%20actually%20texts%2C%20autofill%20shall%20appear%20as%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20205px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F108212i0C0A7988078E3211%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EQuick%20analysis%20if%20only%20you%20select%20entire%20range%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%2071px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F108213iD4CE3E298B2409B3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ETry%20to%20drag%20pressing%20right%20button%2C%20when%20you%20shall%20have%20menu%20as%20this%20after%20releasing%20the%20button%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20238px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F108214i63E2BC950E87EBE2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Sebastian_Mora
Occasional Visitor

Hi,

 

I want to drag cells down the same row. However, when I do it, it only repeats the same one, even though I select different dates, for example when selecting 09/04/19 & 10/04/19 and dragging them down, all the cells would have 09/04/19. As I drag the cells, autofill options do not appear, instead, I get the option for "quick analysis". Please help.  

1 Reply

@Sebastian_Mora , even your dates actually texts, autofill shall appear as

image.png

Quick analysis if only you select entire range

image.png

Try to drag pressing right button, when you shall have menu as this after releasing the button

image.png