Scroll problem in Excel sheet
In one of worksheet, the sheet is protected. Locked cells can not be selected.
I have freezed the row and column both. At the extreme left and right
columns of sheet are locked, therfore cant be selected.
Sheet size is more than one screen. Now when I scroll from left to right
thru arrow keys, the scroll restarts automatically from the first selectable
column on screen-1, when it reaches at thelast selectable column on
subsequent screens.
How to stop the scroll when at the last selectable column?
Can anybody plz help me?
Thanks in advance.
|