| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Arrow keys when cells locked
Can anyone help. In a protected worksheet when the up or down arrow keys are
used the cursor moves to row 1 (if you use down it moves over one column; up moves it back one column) instead of moving up or down one row only. Also if you hit return the cursor also moves to row 1. Without protection this does not happen...We are perplexed and would appreciate any help you can offer -- thanks sam |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Arrow keys when cells locked
While protecting worksheet, check 'Select Locked Cells'
"sam" wrote in message ... Can anyone help. In a protected worksheet when the up or down arrow keys are used the cursor moves to row 1 (if you use down it moves over one column; up moves it back one column) instead of moving up or down one row only. Also if you hit return the cursor also moves to row 1. Without protection this does not happen...We are perplexed and would appreciate any help you can offer -- thanks sam |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My arrow keys won't move between cells only rows & columns | Excel Discussion (Misc queries) | |||
| I can't use the arrow keys to move between cells. | Excel Discussion (Misc queries) | |||
| Is it possible to set the enter and arrow keys to skip locked cel | Excel Discussion (Misc queries) | |||
| Enter, tab, arrow keys aren't allowing me to move to other cells | Excel Discussion (Misc queries) | |||
| instead of moving cells my arrow keys scroll the page | Excel Discussion (Misc queries) | |||
Linear Mode
