Forum Discussion
Tabs in Excel Online worksheet move unexpectedly
awilcoxThis is the solution! If you click on a tab just one time and then move your mouse pointer to another tab, you'll see a small "move" arrow. Wherever you click, it will move your tab to this location. If you don't want your tab to move, you must click your original tab one more time. Now, when you move your mouse pointer to another tab, you'll see that there is no "move" arrow this time. Thanks!
ThomasVarshalOh my goodness, you are absolutely correct!!! AND, this is absurd default behavior!
Yes, so when you click a tab, it auto activates the "move" arrow. Clicking the tab again deactivates the move arrow.
It should be the EXACT OPPOPSITE. Clicking once should do nothing more than select the tab, period, end of action. If I want to move it I can manually drag it, or Microsoft could make it optional that if a tab is clicked a second time, THEN it activates the move arrow.
Thank you for discovering this!!!
This is definitely a UI design flaw!!
When you first click on a tab, you should not be in auto move mode. It should be click, hold, and move.
The current design flaw is click and move mouse, the tab will start to be in moving mode, and some time you don't experience it because the worksheet did not get reload.
To overcome this: you have to click, DO NOT move the mouse, let the worksheet load, or wait for a while, and the the auto-move mode will not be activate.
But hey, I click and I want to go inside my worksheet to edit something, I will sure move my mouse. Isn't this a design flaw?
So, I discovered something. This may have been fixed and you just don't know it.
I noticed that for one of my files the tabs were jumping everywhere, just as we are saying. I noticed I had a newer file where that behavior was NOT happening.
So I closed the document where it WAS happening and reopened it and now it's NOT happening.
So one of two things. Either it was fixed, but I wasn't seeing it (you aren't seeing it), because the file is perpetually open, 24 hours a day, so that "instance" of Excel is not current and fixed with whatever patch MS issued.
The other option is there is some sort of hotkey command that activates the move feature. And everyone on this thread (including myself of course), somehow magically stumbled upon that hotkey to activate the move feature.
I'm going to opt for scenario A, that the current workbook that's open just needs to be closed and reopened with the latest update/patch.
Seriously have to say how helpful it is to have this chat option. We all thought we were crazy and the only ones that were experiencing this "moving tabs" deal.
Anyways, super helpful to have a chat like this. Thanks everyone for your input!
