|
When I have rather big (height wise) cell in MS Excel and am trying to scroll via mouse or even via scrollbar (clicking on "<-" "->" pointers) - Excel just jumps below to the next cell, hiding even the bottom content of the needed large cell. Is there an option to have scrolling go smoothly? So far I found only one way - click middle button on mouse - and scroll smoothly by moving mouse aside. And I even can't drag the bottom line of a cell to make it higher. Why? | |||||||
feedback
|
|
This is a limitation of excel.
| |||
|
feedback
|
|
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. | |||
|
feedback
|
|
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. | |||
|
feedback
|
|
It may be helpful to expand the function text box (between the toolbar and the worksheet), and view the cell's content from there. Not ideal. | |||
|
feedback
|
|
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. | ||||
|
feedback
|
