Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
navigate through Excel-sheet with arrow keys
- Thread starter Swamphen
- Start date
- Thread starter
- #2
:-( :-(
wow...I feel so ashamed.
Euhum....it was the scroll lock - button.
And to defend myself a bit: I have a new keyboard since this weekend and now the ScrollLock button is located where the Home-button of my former keyboard used to be.
And (maybe this makes it worse again) on my other keyboard I never even noticed this scrollock-button (can it be it wasn't there?),I have never even heard of the sheer existence of this utterly useless button.
greetings,
swamphen (notice the little s)
wow...I feel so ashamed.
Euhum....it was the scroll lock - button.
And to defend myself a bit: I have a new keyboard since this weekend and now the ScrollLock button is located where the Home-button of my former keyboard used to be.
And (maybe this makes it worse again) on my other keyboard I never even noticed this scrollock-button (can it be it wasn't there?),I have never even heard of the sheer existence of this utterly useless button.
greetings,
swamphen (notice the little s)
Taken from the Excel Help Files:
Arrow keys and keys such as PAGE UP, HOME, and SHIFT+TAB don't perform the expected action.
The keys may be performing the equivalent action in Lotus 1-2-3. On the Tools menu, click Options, and then click the Transition tab. Clear the Transition navigation keys check box, and then try to use the keys again.
If you want the active selection to move as you scroll through a worksheet, make sure scroll lock is off. If scroll lock is on, you can use the navigation keys without affecting the current selection.
Arrow keys and keys such as PAGE UP, HOME, and SHIFT+TAB don't perform the expected action.
The keys may be performing the equivalent action in Lotus 1-2-3. On the Tools menu, click Options, and then click the Transition tab. Clear the Transition navigation keys check box, and then try to use the keys again.
If you want the active selection to move as you scroll through a worksheet, make sure scroll lock is off. If scroll lock is on, you can use the navigation keys without affecting the current selection.
- Status