I have an Excel spreadsheet that is locked except for some cells where I want a user to enter text. Pressing Tab or Enter jumps to the next unlocked cell just fine in most cases except for in one case where, after pressing enter, the selected cell jumps to the top of the sheet instead of selecting the cell just below.
- I have a bunch of named ranges (don't know if that's relevant)
- The problem does not span across a page break.
- The problem occurs every time I lock the sheet and try to tab/arrow key/enter from row 41 to 42. It's almost as if there is a hidden page break there!
- It always jumps to the topmost unlocked cell.