Is there any way to disable snap scrolling in Microsoft Excel 2016 so that the "normal" smooth zooming is enabled? Pressing mouse's middle click seems to be a temporary solution but once I middle click again the scroll snaps to grid again.

6

2 Answers

No, this cannot be overcome.

It is a feature their MVP's defend on the MS sponsored support site. Defend as in "No one could ever want anything else! It wouldn't be a spreadsheet unless it snapped like that!"

Check:

MS's site for user suggestions.

The Macintosh people DO have the smooth scrolling you, and everyone else, would like. It is in the operating system and Excel does not override it so you can do smooth scrolling.

It is starting to be a bit shocking how many things Excel relies upon the operating system for and is therefore bound by its limitations, even limitations that no longer apply but still affect it because code was written assuming those limits as if they could never improve. The path length possible in a formula for example.

But no, there is absolutely no way on earth to overcome the issue you raise. Everything involving the mouse works while holding mouse buttons down, but the instant you release them, the display snaps to the cell by cell movement. Just grabbing the scroll bar and moving down half a cell... cool while you hold the button down... release it and the full cell pops into the display rather than leaving it stable as it was until some new action is performed. So not even that.

1

Hi you may toggle Scroll Lock key on your PC or laptop to disable snapping to cell when scrolling.

For Mac OS, press Shift+F14 (depending on settings and OS version) to toggle Scroll Lock.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy