ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't move between cells. (Not the scroll lock) (https://www.excelbanter.com/excel-discussion-misc-queries/245734-cant-move-between-cells-not-scroll-lock.html)

GEM

Can't move between cells. (Not the scroll lock)
 
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??

Ron@Buy

Can't move between cells. (Not the scroll lock)
 
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

"GEM" wrote:

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



All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com