View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Art Art is offline
external usenet poster
 
Posts: 587
Default Up down arrow keys do not select cells if select locked cells unch

When you protect the sheet, when you press enter or tab, it goes to the next
available cell thats unlocked. The same applies to the up and down arrow. It
just may seem not to go in the direction you want since you might have locked
a big amount of cells, so it seems as it goes up or down when you want to go
right or left, and vice versa.

"roandrob" wrote:

If I protect my work book and do not allow selection of locked cells the
arrow keys and enter key do not select cells ( unlocked ) in the up down
direction. I can use arrow keys to select cells right or left.