•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
After tab, selected cell return to original column
Our take
If you've ever found yourself frustrated by the way your spreadsheet behaves after hitting "Tab" and "Enter," you're not alone. Many users expect their selection to remain in the same column after navigating with the tab key, yet it often shifts unexpectedly. This behavior can disrupt your workflow and lead to errors. Fortunately, there are ways to customize your settings to align with your preferences, allowing you to regain control over your navigation.
This is nitpicky, but it drives me nuts. If I select a cell, lets say E14, and hit tab a couple of times to E17, then hit enter, it will latch back to the same column but one below. In this case, it would launch to F14 from E17. I would expect it to say in the E17 cell. Obviously, this isn't default behavior, but would it be possible to make it so? Or where hitting enter may go to the adjacent cell to the right, or one below. Thanks
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Pressing tab results in the cell focus moving right one cell AND down one cell.This only happens in one worksheet of one document and only with one specific cell. No formulas exist in either cell, nor are they referenced to by any other formulas. What gives?? submitted by /u/AdhesiveSeaMonkey [link] [comments]
- Enter moving horizontally when the row is selectedas in the title, when I select an entire row and use enter it moves me horizontally across cells instead of going down so if I do from a1 it goes to b1 and c1 and so on, instead of a2 a3 etc submitted by /u/Dramatic_Bobcat7046 [link] [comments]