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

Solution 1:

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.

Solution 2:

This is a limitation of excel.
2 options...

1. Change your cell height manually. Right click on the row number on the left side, choose row height. Don't use enormous cells.
2. If it's only one cell, don't use one big cell, but instead merge a large # of cells vertically using "merge and center". This will allow a smooth scroll in relation to that newly merged cell.

Solution 3:

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.

Solution 4:

You can also insert two blank rows between your large rows, then hide the blank rows. This will make excel act as though you changed your mouse line scroll to 1 line but not affect your other applications. This might not solve your entire need (if one large row doesn't even fit on one screen), but it will help a little.