Unable to move or navigate a row after a drag attempt

Question

Level 1

9 points

Unable to move or navigate a row after a drag attempt

What is going on here (I tried moving a row)

The line with left column value 234.2.4.2.4.1.1 was being dragged from below the line with 24.2.4.2.4.1.5. I tried dragging it up, but it didn't drop. Instead, if I click on this row, and I tap the up/down arrows, nothing happens. If I instead tap on one of the other rows, e.g., 234.2.4.2.4 and use the arrow keys, it goes to the other rows but not 234.2.4.2.4.1.1. It seems like the drag/drop is stuck in a transition state. How can I resolve this?

Posted on Dec 13, 2025 6:18 PM

Reply

Answer 1

victor99 Author

Level 1

9 points

Dec 13, 2025 7:29 PM in response to victor99

I resolved this by reverting to an older saved version, then copy/pasting items from this spreadsheet. I'd still like to know what is going on here. It was acting like the row with 234.2.4.2.4.1.1 was a separate sheet, but displayed on top of the one it was dragged from. If I dragged the = icon, it added more rows. I couldn't figure out anything to do with the circle icon. More importantly, I couldn't simply finish dragging the row to where I wanted it. It was originally after the row with left column 234.2.4.2.4.1.5 (so with last digit 6 - I renamed the 6 to a 1 then tried moving it up - that's when the problem happened).

Reply

Answer 2

SGIII

Level 8

37,538 points

Dec 14, 2025 3:48 AM in response to victor99

From your screenshot you did indeed end up creating a separate table. That easily happens when you drop location is not precise enough. With a little practice you'll find that dragging and dropping gets easer.

SG

Reply