I've protected the first 12 rows of a sheet, and I have tables & calculations below that. In this protected sheet, a few keys act strangely.
* HOME doesn't move horizontally to column A of the current row; it moves to A13, the top-left unprotected cell.
* CTRL-Next and CTRL-Prev don't move between sheets in the file; they scroll the sheet right/left.
In other (empty) sheets of the same file, HOME/etc work the way I expect.
???
* HOME doesn't move horizontally to column A of the current row; it moves to A13, the top-left unprotected cell.
* CTRL-Next and CTRL-Prev don't move between sheets in the file; they scroll the sheet right/left.
In other (empty) sheets of the same file, HOME/etc work the way I expect.
???
Last edited: