asked on

Excel 2010 How can I get mouse to scroll when editing a formula

If I am in excel 2010 and I click on a cell with a formula, then click above on the formula bar.
I can not scroll with my mouse anymore (could in 2003).
Have read that it now scrolls in the formula bar but all of my formulas are short - I need the old way back.
Thanks,

andrewssd3

I had a number of users raise this issue when we migrated to 2007, and I have never been able to find a solution I'm afraid. I think you will just have to use the scroll bars until MS decide to fix it in Office 15/16/17/18/19....

Glenn Ray

I will state that the scroll function works for me in Excel 2007. That is, I can place my cursor in the function bar and scroll through long formulas. I usually expand the formula bar (double-down chevron on the far right) instead.

Fragclub27

ASKER

GlennLRay
thanks for the reply
that is not my issue - my issue is when I put my curser in the function/formula bar I used to be able to scroll through my spreadsheet to pick cells etc - now it just wants to scroll through the funtion/formula bar (but all my formulas are use 1 line long).
Trying to get rid of or go back to Office 2003 functionality of being able to scroll while curser is in the function bar
Thanks!

ASKER CERTIFIED SOLUTION

Glenn Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ron Ronn

just
1. left click inside the cell you want to edit
2. left click the formula bar
3.left click inside the cell you want to edit again and then it is possible to use the scroll wheel