Forum Discussion

Dubbs210's avatar
Dubbs210
Copper Contributor
Sep 03, 2022

Split Window Scrolling not working

As of today when I scroll with a split window it is scrolling my entire page instead of just the portion of the window I am on.   I split my excel sheet horizontally only (top/bottom half) Click ...
excel
Kevin_Roberts's avatar
Kevin_Roberts
Copper Contributor
Nov 01, 2022

Dubbs210 , I'm having exactly the same issue, and it seems to occur when the selected cell scrolls out of the view of the split window.  Otherwise, scrolling behaves normally for me.

 

I would also add the following (seemingly related) bugs to the list:

  • The GUI behave unpredictably when I'm trying to construct formulas that reference cells across the different split windows.  GUI seems to misread mouse input as indicating a range. 
  • Also, I'm noticing that, at times, the GUI misinterprets the cell I'm pointing to ... I have to point the cell a row below to get the GUI to select the cell in the row I want.  This last problem seems to clear up when I close out of everything/restart Excel/reboot.

It's my impression these bugs popped-up in the wake of an upgrade.  My hunch is that the problem may be more OS-driven than Excel-driven, but I could be wrong.

 

Someone from MS needs to get right on this.  How many frustrated Excel users are there out there right now seething with frustration?

 

jadewinter's avatar
jadewinter
Copper Contributor
Nov 24, 2022

Decades with Excel - this scrolling anomaly cuts into my time so much I may need to hold my nose and transfer this one worksheet to Google sheets. It's a most serious issue. (Related to Windows 11 upgrade?)

  • jadewinter's avatar
    jadewinter
    Copper Contributor
    Nov 24, 2022
    Just copy saved and now use my worksheet as Excel 97-2003. The scrolling issue appears to have gone. Luckily I haven't lost functionality with this particular worksheet. So for the time being I'm OK, but......................... Good luck Microsoft!
    • AZRoger's avatar
      AZRoger
      Copper Contributor
      Nov 29, 2022
      I did the SaveAs to get to the Excel 97-2003 format. I got lots of warning about functions "I used" that might work differently. Doesn't look like it did. And I still have the scrolling issue. Doesn't matter which half has the cell that rolls off the screen. This is bad.
    • jadewinter's avatar
      jadewinter
      Copper Contributor
      Nov 25, 2022
      Returned to Windows 10. I was within the 10 day adoption window. Excel is back to normal. BUT one surprise - excel files I had saved on onedrive while on Windows 11 could not be opened. I managed to retrieve some of the data when I discovered the Windows 11 excel files could be opened in Google Sheets - slow, and a limit of some 5000 rows. Disconcerting.

Resources