How to turn off Excel's 'Snap to Cell' when scrolling?!

July 18, 2009 11:08 AM

Excel 2007 - How do I stop the scrolling function from jumping to the top/bottom of a cell? This happens using the mouse scroll wheel, when clicking the scroll wheel and moving the mouse (free scroll type of thing), and when using the scroll bars onscreen.

I'm using a spreadsheet that has large paragraphs in each cell, and I can't see much of the sheet due to the 'snapping' to the edge of cell that happens each time I scroll. Please help me figure out how to turn off this 'snap to cell' feature so I can scroll wherever I want to!

posted by Merlin144 to computers & internet (3 comments total)

Are you using Vista? I don't have Excel 2007 but I've read that enabling smooth-scroll for list boxes might fix this issue:

http://www.vistax64.com/tutorials/75417-visual-effects-options.html
posted by multiphrenic at 1:08 PM on July 18

Excel won't let you end scrolling between rows.. ie.. it will always have a row at the top of the screen. If you have a REALLY tall row (like 50 pixels tall), you cannot scroll halfway through it. I believe this is the behavior you are talking about, and would like to avoid.
posted by SirStan at 4:52 PM on July 18

Thanks for the help - tried smooth scroll for list boxes, didn't work.
posted by Merlin144 at 2:55 PM on August 5