The reason the sheet doesn't scroll with the mouse wheel when edit directly
in cells is not selected is that the formula bar itself scrolls with the
mouse wheel instead. As you know, the formula bar has become multiline in
Excel 2007 so (with long cell entries) MS opted to have the scrolling take
place there as that's where the focus is. You and I may agree that that was
the wrong design decision but so it is.
I find that edit directly in cells works well for me most of the time and,
when it doesn't, I click up in the formula bar and continue editing there.
I don't know if this is the same issue that I have with 2007, but if
it is, it is quite annoying.
Scrolling (with the mouse's middle wheel) works for me if I am in an
Excel document but not editing a formula. If however I start a
formula and type e.g. "=H14+" and I then want to scroll down to row
254, say, to add H254 to the formula, I cannot do this with the scroll
wheel. Instead I have to click on the scroll bar to the right to go
down (or simply type H254, but unfortunately my memory isn't good
enough to remember exactly which row all my formulae are on).
There does appear to be a way around this, but it's not ideal. If you
have 'Allow editing directly in cells' enabled, the mouse scroll will
work, even when editing a formula. To change this setting, go to
Excel options (via the multi-coloured Office symbol in the top left
hand corner of the screen), and select Advanced. However, I do not
want this feature enabled, as I much prefer to edit my formulae in the
formula bar, and dislike the way that a long formula will make it
impossible to see the contents of the adjacent cells if 'editing
directly in cells' is enabled. Furthermore, there are other useful
features with not having this enabled (such as being able to double
click on the cell to go to where it is pointing - albeit CTRL+[ does
the same job).
Not sure if this helps, or if it's the same problem you have. Try
changing this setting and see if it fixes it for you. If anyone has
any comments on the issues I'm having, I'd also like to hear them.
I'm sure 2003 allowed me both to not allow editing directly in cells
but also scroll when editing formulae.