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
Highlighted

@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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies