We understand the frustration. When you press Enter after navigating with Tab, you expect the cursor to stay put, not to jump back to a different column. That behavior is a small but persistent friction point, and it matters because every unexpected click or keystroke breaks your flow. The user who posted this knows exactly what they want: control over where Enter takes them next. They aren't asking for a revolution in spreadsheet design, they're asking for a logical, predictable interaction that respects their last active cell.
The default behavior described here, where Enter latches back to the original column after Tab navigation, is a legacy holdover. It assumes you always want to move down a column after entering data, even if you've deliberately moved to another column. For anyone working across rows, this becomes a maddening time-sink. You hit Enter, and suddenly you're three cells away from where you were working. The solution isn't complicated: give users a simple toggle or preference setting that lets them choose where Enter goes. Let it stay in the same cell, go to the cell immediately below, or move to the adjacent cell on the right. This isn't about adding flashy features; it's about removing unnecessary clicks and corrections.
The deeper point here is about respecting the user's intent. When you press Tab, you're telling the tool, "I'm moving to the right." When you press Enter, you're saying, "I'm done with this cell." The tool should honor both commands without second-guessing you. That's not a radical ask, it's basic ergonomics. AI-native spreadsheets have the opportunity to learn from these patterns and adapt, rather than forcing a one-size-fits-all default. Imagine a tool that remembers you mostly work across rows and adjusts Enter behavior accordingly. That's the kind of quiet intelligence that transforms a spreadsheet from a source of irritation into a genuine productivity partner.
The fix is small, but the impact is large. Every second you spend re-navigating to the cell you wanted is a second you don't get back. Spreadsheets should be tools that get out of your way, not obstacles that require you to work around them. So here's our plain opinion: make Enter behavior configurable. Let users decide where they want to go next. It's a minor change in code, but a major improvement in how people feel about their daily work.