Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn scroll lock off (2007 excel)? No scroll lock key | Excel Discussion (Misc queries) | |||
how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
excel-how to get the spreadsheet to move as I move the scroll tab | Excel Discussion (Misc queries) | |||
How do I lock a column so it doesn't move when I scroll across? | Excel Discussion (Misc queries) | |||
When I move scroll bar in excell the contents do not move with it | Excel Discussion (Misc queries) |