Can't move between cells. (Not the scroll lock)

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??
 
R

Ron@Buy

Before you click the OK button to Protect Sheet add a tick alongside "Select
locked cells" and "Select unlocked cells"
This will allow you to place the cursor anywhere on your sheet but will not
allow you to change locked cells.
Hope this helps
 

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

Protecting Worksheet - Cannot move between cells. 2
How to change format protection default to unlocked? 2
How do I turn scroll lock off (2007 excel)? No scroll lock key 1
Can't lock cells 4
Scroll Lock 2
Move direction problem when protected 0
Can't access cells 2
Enabling Autofilter and Sorting in a Protected Sheet 2

Top