Feb 13 2020 07:39 AM
Feb 13 2020 07:39 AM
I have an excel workbook that is many columns wide. I am on a Macbook Pro, Office 365.
Scroll lock is *not* on, please do not suggest I turn it off.
I can scroll in other workbooks.
On this workbook, if I am selecting cells and trying to scroll horizontally, it won't continue the horizontal scroll beyond what is visual on screen. I am extremely annoyed, please help.
Feb 13 2020 08:38 AM
Try any/all of the following:
Feb 13 2020 08:40 AM
Thanks for your help.
Didn't have any filters to remove or panes to unfreeze, and I'd already closed and opened the app.
For whatever reason - is there a reason or is this just a glitch in the matrix? - your suggestion to move from normal to page break to normal worked - THANK YOU.
Feb 13 2020 08:55 AM
It happens every now and then. When it happens, "refresh" the view any way you can.
Sep 16 2021 10:17 AM
Mar 05 2022 03:00 AM
I have this same problem too, and already searching for a very long time for a solution!! In all forums/Uservoices/TechCommunities i read, i see that MS does not come out with a(ny) feasable solution (or comment).
The big issue is: this worked very good (and so simple) in former Windows versions (just using Shift or Ctrl-Shift + scroll with a normal mouse up or down, couldn't be more simple, that was the perfect solution).
I also (specially for this issue!) bought the Microsoft Arc mouse, but same issue, no horizontal scrolling in Excel, even with their own special horizontal scrolling mouse... mind-boggling...
What is also very troubling (and mind-boggling) is that for some people the Shift (or Shift-Control) works with Horizontal scrolling in Excel with a regular mouse, and for others this is not possible... completely not logical ! And another thing is: on Mac completely no issue with horizontal scrolling with Apple mouse !!!! Try to get some logic in that.... MS-logic?.... I don't get it... And especially since so many people already wrote about this on all kinds of forums & communities....
I also found info here, but still no solution... https://answers.microsoft.com/en-us/msoffice/forum/all/excel-how-to-scroll-horizontally/5f9fb0ae-467...
Is there somewhere any sensible solution or explanation why this is not working, and when is MS going to do something about this (since this worked before) ??!
Mar 11 2022 06:14 AM
@Yannic_BelgiumI right-clicked on the scroll bar and clicked on "Scroll Right" and seemed to get more space to scroll back and forth.
Really more of a workaround than a solution but maybe you could try it and see if it works for you.
Mar 20 2023 09:40 AM
May 16 2023 04:37 AM
As long as this topic old enough and no one answered correct or useful, problem still alive.
Because of its name (excel ~ spread sheets), cells may continue to horiz. or vert. ways and its so difficult to scroll long way with scrollbar, so when you need to reach last active column drage the scrollbar and hit opposite direction way and its shows last or first column then seek one by one column in that area to work with cells.
(windows on PC)
May 31 2023 04:47 PM
Jun 11 2023 07:56 AM
@Patrick2788 , unfreezing panes re-enabled scrolling. I could then refreeze frames and continue scrolling.
Using Excel Version 16.73 on Mac.
Sep 13 2023 11:39 AM
Just seeing the alternate method you posted (CTRL+SHIFT+MOUSE wheel) worked for me. Everywhere else said to use only SHIFT+MOUSE wheel. The latter failed for me, so when I found your post, I added the CTRL key and it work beautifully! Thank you!!
Sep 18 2023 11:21 PM
I *think* this has to do with the Freeze Pane function. I have noticed that on sheets (within the same workbook) that have only rows as 'frozen' panes, I can side scroll. on sheets where I have both rows and columns frozen, there is no side scrolling.
It's also worth noting that prior to having this side scrolling issue, I would often have visual glitches when side scrolling (say, if I had columns A-D frozen, when I scrolled back to the start, I might see columns A-D, and then it would start as A again, or when scrolling, my screen would randomly contain chunks of black).
But I want my frozen columns, so that's a pain.