I have a spreadsheet where I have unlocked the cells in the user input area and turned on sheet protection. Rows and columns outside the user input area are hidden and their cells are locked. Frozen panes is turned on with cell B3 as the upper left.
Ctrl-home works fine; it takes me to B3.
When sheet protection is on, the home key doesn't behave right. Rather than moving the cursor to column B in the current row, it jumps to row 1 in the first hidden column.
When I turn protection off it works as expected; the cursor moves to column B.
Another strange behavior I'm encountering when protection is on is that when I use arrow keys to move the cursor to the right and I hit the end of the user input area the cursor jumps to the first column of the next row. With protection off, the cursor hits the end of the row and just stops. Right arrow does nothing at that point. Similarly, when I use down arrow and hit the bottom of the user area the cursor jumps to the top of the next column. With protection off, the cursor stops at the bottom of the column and does nothing in response to more down arrow inputs.
Transition navigation keys is not selected.
What is causing this behavior? Is there an option or setting somewhere that I'm missing? I haven't seen this happen before.
Ctrl-home works fine; it takes me to B3.
When sheet protection is on, the home key doesn't behave right. Rather than moving the cursor to column B in the current row, it jumps to row 1 in the first hidden column.
When I turn protection off it works as expected; the cursor moves to column B.
Another strange behavior I'm encountering when protection is on is that when I use arrow keys to move the cursor to the right and I hit the end of the user input area the cursor jumps to the first column of the next row. With protection off, the cursor hits the end of the row and just stops. Right arrow does nothing at that point. Similarly, when I use down arrow and hit the bottom of the user area the cursor jumps to the top of the next column. With protection off, the cursor stops at the bottom of the column and does nothing in response to more down arrow inputs.
Transition navigation keys is not selected.
What is causing this behavior? Is there an option or setting somewhere that I'm missing? I haven't seen this happen before.