Up and Down Arrows do not work

J

Josh C

I have a file that is Protected by Tools --> protection, with the Select
Unlocked Cells checked and the Select Lock Cells Not checked. When I am in a
group of unlocked cells, I can move from cell to cell using the right and
left arrow, but not the up and down arrow. I can select any unlocked cell in
that group with the mouse, but not the arrow keys. If I unprotect the cell,
then the arrows work fine. Does anyone have any ideas? Everything worked fine
earlier this week, but today it does not. Please help!!!!
 
F

Friemark

Josh - I'm searching this site because I'm having the same problem. If you
check, I'll bet you can Tab through your cells, but just not arrow up or
down. Similarily, Enter will not move your selection. If I protect my sheet
with "Select Locked Cells" selected, I can arrow, enter, and tab just fine.
Similar sheets in the same workbook do not have this problem. I'm echoing
your plea for help, here. Anybody, any ideas?
 
J

Josh

I am sorry to say that I have not found a fix yet, so can anyone please help
us????
 

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

Up down arrow keys do not select cells if select locked cells unch 3
How to change format protection default to unlocked? 2
cannot tab to next unlocked cell 0
Enabling Autofilter and Sorting in a Protected Sheet 2
Menu Macro Not Executing - Need Help 1
Locked cells are still able to be selected with proper protection 1
Locked Property off, but cannot select cell 2
Place picture in Excel cell 0

Top