Excel 2010 Scrolling Issues

I recently had MS Office 2010 installed on my PC and as a excel user I am running into some difficulties with scrolling through worksheets. When I am adding to a formula or even creating a new forumla I can'tuse my mouse to scroll through the worksheet. As an example if I were to do the formula below, I would have to page up and page down to create it, versus scrolling and this i iritating to do.

=C12+G512+H123

Has anyone else run into this issue, and is there a setting within excel I need to change or is it a mouse issue running the OS?

Appreciate the help.

I am having the same issue in Excel 2007 (also using Windows 7). I have recently been forced to upgrade from Excel 2003 and I was shocked to find that you can no longer scroll through the document while editing in the formula bar. For example, if I have a formula "=Q21/L21-1" I would like to scroll up through the worksheet to see what the contents of Q21 and L21 are while editing the formula in the formula bar. I am able to scroll with my mouse wheel any other time and my mouse functions properly. I am simply "locked" into position when I am editing in the formula bar.

I have read other posts that have stated you can allow scrolling through the document while editing formulas by selecting "Edit directly in the cell", however this is not a good method for formula auditing as you quickly lose sight of the formula in the cell. I have also read that this change is due to the formula bar being on multiple lines in Excel 2007, so Excel is attempting to scroll within the formula bar instead of in the worksheet.

Does anyone have a solution for this? Am I stuck to being less productive in the new version of Excel?

Thank you for any help you can provide.

This is the most annoying change to Excel, yet. Please, I hope there is a workaround!

Originally Posted by john riggs

I am having the same issue in Excel 2007 (also using Windows 7). I have recently been forced to upgrade from Excel 2003 and I was shocked to find that you can no longer scroll through the document while editing in the formula bar. For example, if I have a formula "=Q21/L21-1" I would like to scroll up through the worksheet to see what the contents of Q21 and L21 are while editing the formula in the formula bar. I am able to scroll with my mouse wheel any other time and my mouse functions properly. I am simply "locked" into position when I am editing in the formula bar.

I have read other posts that have stated you can allow scrolling through the document while editing formulas by selecting "Edit directly in the cell", however this is not a good method for formula auditing as you quickly lose sight of the formula in the cell. I have also read that this change is due to the formula bar being on multiple lines in Excel 2007, so Excel is attempting to scroll within the formula bar instead of in the worksheet.

Does anyone have a solution for this? Am I stuck to being less productive in the new version of Excel?

Thank you for any help you can provide.

Hi,

Yes, during editing a formula, mouse scroll still doesn't work. In this situation press & hold the scroll wheel and move the mouse slowly in any direction you wish. It will serve the purpose!

Regards,

I know this is an old post but I think i found the answer. For me it had to do with my mouse. Installing the following program fixed the issue for me: AlwayMouseWheel. Its small, runs in the background and is free!

I know this is an old post but I think i found the answer. For me it had to do with my mouse. Installing the following program fixed the issue for me: AlwayMouseWheel. Its small, runs in the background and is free!

Thanks for posting, that also worked for me with a Logitech mouse.