ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Arrow keys when cells locked (https://www.excelbanter.com/excel-worksheet-functions/204098-arrow-keys-when-cells-locked.html)

Sam

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

Gaurav[_3_]

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





All times are GMT +1. The time now is 06:05 PM.

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