Protecting Worksheet - Cannot move between cells.

G

GEM

I have locked & unlocked the necessary cells, and have protected my worksheet
(Tools/Protection/Protect Sheet). I cannot move up, down, left or right
between cells. But if the sheet is unprotected I can easily do this.

No, it's not the scroll button, I tried.

Does anyone know how to fix this??
 
A

AltaEgo

Could be your worksheet protection options.
When you protect your worksheet, do you allow the option to select locked
and unlocked cells?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't move between cells. (Not the scroll lock) 1
How to change format protection default to unlocked? 2
Method for protecting cells which still allows quick editing 2
Can't access cells 2
David Biddulph is correct 8
Locked cells are still able to be selected with proper protection 1
corrupted formula in protected worksheet 21
Copy data from unlocked cells 3

Top