Home » Questions » Computers [ Ask a new question ]

How do you view the bottom of really tall cells in Excel?

How do you view the bottom of really tall cells in Excel?

When there are very tall cells in Microsoft Excel, trying to scroll via mouse or even via scrollbar (clicking on "<-" "->" pointers) just jumps below to the next cell, hiding the bottom content of the large cell in question.

Asked by: Guest | Views: 66
Total answers/comments: 5
Guest [Entry]

"This is more of a design flaw in Excel than a bug. It's definitely a usability problem as it is super easy to scroll past a cell with it basically never showing in the view.

As much as I hate to suggest this (I hate this feature) you can middle-drag to scroll smoothly. Once you release/click again/move the mouse over top of the origin, Excel will snap the top of the view again.

This same problem is present in Office 2010 under Windows 7."
Guest [Entry]

"You won't be able to not scroll by rows, but you can minimize them to one row. Just change the mousewheel setting to 1, as per this link.

If you use the Scroll Lock button then using the arrow keys will move the screen instead of the cursor."
Guest [Entry]

My solution to this is to zoom out slightly to 90%, this seems to turn off the "feature" in Excel 2016 at least.
My solution to this is to zoom out slightly to 90%, this seems to turn off the "feature" in Excel 2016 at least.
Guest [Entry]

Quick fix: right click on the column header and select:
Guest [Entry]

"See if you are able to scroll smoothly in other applications with the middle wheel. This will help determine if the problem is with Excel or your mouse.

If you can't scroll smoothly in other programs, you may want to check your mouse driver settings, update the driver, or both."