Friday 13 December 2019

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.


Is there an option to have Excel scroll smoothly?


So far I found only one way - click middle button on mouse - and scroll smoothly by moving mouse aside.



Answer



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.


No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...