![]() If I hide the bottom rows on any new sheet, I am able to Unhide again, but not on these weird sheets. Move the cell cursor to cell CA125 using the horizontal scroll bar. This behaviour occurs as soon as a file is opened.Įdit: one more maybe-relevant detail is that in the only persistent case I can find, the affected sheets all have rows ~500 onwards Hidden, and they are not recoverable (no amount of Unhide can make those bottom rows come back). Don't forget that scrolling is not the same as selecting After scrolling to a new. Other applications (Outlook, Edge, Word) all seem unaffected.įinally, I have checked the other obvious things like making sure I am not editing a cell formula or running a macro etc. If the problem is resolved, drag to the Trash. If the problem still occurs, quit Excel, restore the file to its original location, and go to the next step. I have obviously not deliberately changed anything, it seems to have happened spontaneously with some Excel/Windows update. Open Excel, and check whether the problem still occurs. Is anyone aware of a sheet-level scroll-lock setting anywhere, that could have been set somehow? One such affected workbook suddenly started only allowing scrolling on one of the sheets, but not others - no amount of restarting Excel or checking Scroll Lock is off (by putting it on and off again) has worked.įreeze Panes on the top row is on on all sheets (those that scroll and those that don't), but I have tried flipping this off to no avail. ![]() I am using Excel (MS 365 MSO version 2205, 64-bit) in 64-bit Windows 10 and recently (seemingly at random) my mouse wheel has stopped working in certain spreadsheets (by which I mean: certain sheets within a workbook).
0 Comments
Leave a Reply. |