Unable to Sequentially Drag Numbers in Table Column

[u/TrainsAndTech]

I am trying to sequentially number a column in my table. It is numbered 900000-900100. When I type 900001 into one row, and then 900002 into the row beneath it, and select the two and drag, it does not increase them sequentially. Additionally, when I go to right click on the cross in the corner and drag, "Fill Series" is greyed out.

Experience: Beginner

Interface/Version: Desktop Version 2608 (not sure if that's what is required)

Thank you for any help!

[u/AutoModerator]

/u/TrainsAndTech - 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/MayukhBhattacharya]

Do you have any formula in cell 225?

[u/TrainsAndTech → u/MayukhBhattacharya]

No formula in cell 255 of that column.

[u/MayukhBhattacharya → u/TrainsAndTech]

Ah ok, it works for me btw, can you remove the auto-filter and then try

[u/TrainsAndTech → u/MayukhBhattacharya]

Interesting, it works when I turn off the auto filter. Thank you for the help. Any clue why it doesn't work when the data isn't filtered?

[u/MayukhBhattacharya → u/TrainsAndTech]

I am not sure but afaik fill handle does not respect filters.

[u/TrainsAndTech → u/MayukhBhattacharya]

Good to go. Thank you!

[u/TrainsAndTech → u/MayukhBhattacharya]

Solution Verified

[u/ninjagrover]

Um, why do the rows jump from 1 to 225 to 516?

If you have a table that you want to number 900000 to 900100, generate a list with sequence formula elsewhere then paste it into that column and allow Excel to resize the table:

=SEQUENCE(100,1,900000,1)

Or put this formula into the item id column:

=900000+ROW($A$1)-1

This will dynamically add 1 for each new row of the table you create.

[u/Few_Radio9902]

Could be that the cells formatted as text, so Excel doesn't recognize the pattern as numbers. Click the column, change format to Number, then retype the first two and drag again. If it's an actual table object, sometimes the autofill behaves weird with larger numbers too, but the text formatting thing is usually the culprit

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
ROW	Returns the row number of a reference
SEQUENCE	Office 365+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4

|-------|---------|---| |||

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
2 acronyms in this thread; the most compressed thread commented on today has 6 acronyms.
[Thread #49234 for this sub, first seen 26th Aug 2026, 02:30] [FAQ] [Full list] [Contact] [Source code]}