Forum Discussion
Skip a cell when entering data
I want to skip calculated cells in the row.
My apologies, Hans. I was mistaken earlier:
If I have a workable area A1:CT324 (the area of my actual sheet I want to apply this to)
On row 1 data is entered in A1:BG1. When I press enter I would like the selection to return to A2. (This is the normal movement throughout an unprotected sheet.) But with a protected sheet, if my last entry was BG1 and I press enter, the selection drops to BG2.
Is there any way to have the selection return to A2, A3, etc. when pressing enter while on a protected sheet?
It works the way you want for me on a protected sheet, the same as on an unprotected sheet.
I don't know why it works differently for you, sorry.