![]() |
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 |
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