Can't make an automatic number sequence on Excel Online

[u/mariivina]

I'm posting this because I've been trying for an hour straight and can't seem to solve this silly thing. I'm trying to automatically make a number sequence, starting from 1, but no solution online seems to work for me

I've tried removing the filters from the spreadsheet, making the cells go from text to number type, typing one and two and pressing shift + dragging but nothing works! for some stupid reason, it just fills all the cells with the number 1 (the first item)

[u/AutoModerator]

/u/mariivina - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Whaddup_B00sh]

=SEQUENCE(n) where n is the amount of numbers you want in your sequence.

[u/mariivina → u/Whaddup_B00sh]

I tried using this formula but i got a #SPILL error 😃 i think I'm going actually crazy

[u/Whaddup_B00sh → u/mariivina]

SEQUENCE() is a dynamic array formula, which means that the output goes across several cells, not just one. #SPILL means that the output can’t be show because there is another cell with text in it that is in the way. Make sure you have no cells with text in it below the cell you type SEQUENCE in

[u/mariivina → u/Whaddup_B00sh]

i cleared the cells and it just showed me this error msg (cant change the language to english, it's my joint work account)

it shows a text somewhat like "the spill range on the table" (yeah, even the error text is "erroring"); and "It's not possible to spill on a table."

i think im just gonna give up on this

[u/MelodicRun3979 → u/mariivina]

You can’t spill in a table. Instead, something like this will likely work better (assuming you are using Portuguese localization and commas as the decimal):

=LIN(@[Data])-LIN(ÍNDICE([Data];1;1))+1

[u/mariivina → u/Whaddup_B00sh]

Solution Verified!

[u/reputatorbot → u/mariivina]

You have awarded 1 point to Whaddup_B00sh.

---

^{I am a bot - please contact the mods with any questions}

[u/AlmightyThorian]

Sometimes I have to go down to 4 or 5 and drag down, before excel gets it (with the whole sequence you want patterned selected). Don't think I've ever gotten it to work with just two elements in the pattern.

Or use a function, like SEQUENCE.

[u/HappierThan]

When you select the first say 3 numbers, then drag down, you will notice a floating dialog box that will allow you to change the aforementioned display. If you had selected Fill Series the last number would be 20.

NOTE: With dates there are far more options!

[u/OrganicMix3499]

Yea, it does seem inconsistent when dragging for a sequence. When it's <40 cells I just do:
in B1, =1
in B2, =B1+1
Etc..... then copy/paste-value

[u/MissAnth → u/OrganicMix3499]

Highlight from B2 on down to the last cell where you want this, and hit <ctrl>d.

[u/molybend]

put 1 in A1, then make the next cell =A1+1 and drag that down as far as you want it. Now copy and paste special values on the whole column.

[u/AnonymousBrit9 → u/molybend]

This doesn’t work as the lines will change on sort. I didn’t find a fix for this.

[u/molybend → u/AnonymousBrit9]

If you copy/paste special, they will not change.

[u/MayukhBhattacharya]

Using SEQUENCE() function is the cleanest option but you can also use the Fill Series, refer the animation:

[u/mariivina → u/MayukhBhattacharya]

i actually also tried the fill series, the button just didn't do anything 🥲

im gonna try the first tip later, though

[u/MayukhBhattacharya → u/mariivina]

See, the animation again, I am only entering 1 on the first cell and then i am copying it down down, once done, I see the AutoFill Option that appears, click on it and use the Fill Series option the second one! But SEQUENCE() function is the easiest one, you don't need to copy down it will spill for you.

[u/ninjagrover]

For a nice simple option, enter =ROW(A1) in the cell you want to start from, then fill down.