In Excel when I press Page Up/Page Down it always scrolls no more than 1 page and jumps exactly to the next row that was not displayed fully (if the current row isn't taller than the window, of course). This is very useful as it prevents me from ever missing a row; for example when I want to have a quick check for something in every row I can just press Page Down repeatedly and scan the whole page or column.
However when I scroll using the mouse, things are different. It always scrolls exactly the number of rows equal to the number of lines set in Windows' vertical scrolling setting for the mouse, as seen below:
This is annoying as it skips many rows when the current 3 rows' total height is too tall to fit in the window. It also makes scrolling speed vary greatly when the rows' heights vary too much.
Is there any way to make the mouse scroll the screen by a page per notch of the scroll button?
Best Answer
I ended up using this autohotkey script