Man!
Now, in Excel, just do SHIFT+SCROLLWHEEL to pan/scroll horizontally. Works Super!
ALT+SCROLLWHEEL to fast-scroll vertically - similar to CTRL+SCROLLWHEEL in NEdit.
https://github.com/T800G/OfficeScroll
Hvala vam!!
Google searches that got nowhere :
excel keyboard shortcuts horizontall scrolling
excel keyboard shortcuts horizontall pan
the one that worked -rresult #4
excel macro horizontal scroll
thank you for posting the solution link :
Stanislav Pitsul
Tomasz Truszczynski
What if you wanted to use CTRL-ALT-Wheel to move between worksheets? Wouldn't that be nice? Some clown has actually requested that on the github, and been rebuffed probably. Scouring the AHK world provides a workaround at a higher level - trap your bindkey and send the shortcut that the app already responds to (CTRL-PgUp) :
#IfWinActive ahk_class XLMAIN
^!WheelUp::Send ^{PgUp}
^!WheelDown::Send ^{PgDn}
#IfWinActive
Update - this is exactly why Croatia will never be Israel. Think about it - such a *heavy* solution. We want lite!! Get it? As you guessed, this worked for a few months till the idiots in Redmond did an upgrade. Screw the Croatian creation - it's crap!
What's the lite solution then? Autohotkey to the rescue. Did you even know about this? If you enable Scroll Lock, then the arrow keys in Excel no longer navigate cells but scroll the worksheet. Exactly! You just Lock, Send Arrow, Unlock and you're done!! This genius has the answer :
#IfWinActive ahk_class XLMAIN
+WheelDown::SendInput {ScrollLock}{Right}{
+WheelUp::SendInput {ScrollLock}{Left}{ScrollLock}
#IfWinActive
From : https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10726656-scroll-horizontally-by-pressing-shift-wheel-scroll
Try it! I dare you! :)
First published 3/23/18
No comments:
Post a Comment