Forum Discussion
DianeDennis
Jul 14, 2023Copper Contributor
Excel TABBING all of a sudden not working right...
Hi Everybody! Happy Friday!
I'm having a tabbing (TAB key) order issue all of a sudden.
I opened a blank worksheet, unlocked columns A through O (all rows), and protected it.
When I try to TAB through the unlocked cells it just repeatedly tabs through the cells in Row 1, Column A through Column O, then back to A1, and over again. It won't drop to the lower rows.
If I select all of the cells that I want it tab through then it'll tab through them in the proper order.
I restarted my computer and I did a repair and the issue persists.
Is there a setting or something that somehow I switched or did something change within the last 24 or so hours or ... ?
Thank you so much!!
Diane
I opened a blank worksheet, unlocked columns A through O (all rows), and protected it.Did you select the column headers?
Try to select a specific range instead of the whole columns.
4 Replies
Sort By
- Detlef_LewinSilver Contributor
I opened a blank worksheet, unlocked columns A through O (all rows), and protected it.Did you select the column headers?
Try to select a specific range instead of the whole columns.
- DianeDennisCopper ContributorHi!
Thank you!
Yep, I selected the entire column.
But I just now opened another one and tried it as you suggested by selecting A1 through O1 without selecting the column headers, then SHIFT + CTRL + DOWN ARROW to select all the cells in the columns and unlocked the cells and it's still doing the same thing.
Thank you again!
Diane- Detlef_LewinSilver Contributor