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
Highlighted
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

Related Conversations
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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies