SOLVED

I cannot fill series with a gap of more than 1

%3CLINGO-SUB%20id%3D%22lingo-sub-1733547%22%20slang%3D%22en-US%22%3EI%20cannot%20fill%20series%20with%20a%20gap%20of%20more%20than%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1733547%22%20slang%3D%22en-US%22%3EHello%20sir%2Fma'am%2C%3CBR%20%2F%3EI%20have%20been%20trying%20to%20fill%20series%20with%20a%20gap%20of%203%20but%20I%20am%20not%20able%20to.%20When%20i%20take%202%20numbers%203%20and%206%2C%20and%20drag%20the%20cursor%20upto%20some%20cells%20and%20select%20flash%20fill%2C%20it%20doesn't%20fill%20the%20other%20cells%20with%20a%20gap%20of%203.%20If%20I%20use%20numbers%2010%20and%2015%2C%20it's%20perfectly%20fine.%20I%20am%20attaching%20a%20video%20with%20this%20message.%20Please%20help.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1733547%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1733704%22%20slang%3D%22en-US%22%3ERe%3A%20I%20cannot%20fill%20series%20with%20a%20gap%20of%20more%20than%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1733704%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F815983%22%20target%3D%22_blank%22%3E%40Gryffinpuf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20per%20your%20video%2C%20instead%20of%20dragging%20just%20C2%20(with%20value%203%20in%20there)%20down%20the%20rows%2C%20select%20C2%3AC3%20and%20then%20drag%20the%20C3%20down.%3C%2FP%3E%3CP%3Ei.e.%20Right%20now%20you%20are%20just%20dragging%20C2%2C%20now%20you%20select%20both%20the%20cells%20C2%20and%20C3%20and%20then%20drag%20C3%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1733706%22%20slang%3D%22en-US%22%3ERe%3A%20I%20cannot%20fill%20series%20with%20a%20gap%20of%20more%20than%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1733706%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F815983%22%20target%3D%22_blank%22%3E%40Gryffinpuf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20like%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hello sir/ma'am,
I have been trying to fill series with a gap of 3 but I am not able to. When i take 2 numbers 3 and 6, and drag the cursor upto some cells and select flash fill, it doesn't fill the other cells with a gap of 3. If I use numbers 10 and 15, it's perfectly fine. I am attaching a video with this message. Please help.
4 Replies
Highlighted
Best Response confirmed by Gryffinpuf (New Contributor)
Solution

@Gryffinpuf 

As per your video, instead of dragging just C2 (with value 3 in there) down the rows, select C2:C3 and then drag the C3 down.

i.e. Right now you are just dragging C2, now you select both the cells C2 and C3 and then drag C3 down.

Highlighted

@Gryffinpuf 

Just like this.

 

Highlighted
Thank you so much sir. Now I am able to do that.
Highlighted

@Gryffinpuf 

You're welcome! Glad it helped.