how to scroll while in formula bar (Excel 2007)



In Excel 2003, I was able to select an existing RANGE of cells in the formula
bar such as =average (b97:b130). Then while the RANGE was selected I was then
able to change/update that RANGE in the formula by scrolling down in my
spreadsheet and select a new extended RANGE of cells such as b131:b140. When
I then clicked Enter, the RANGE in the formula bar would correctly change
=average (b97:b130) to =average (b131:b140).
But now when I try to do that same exercise in Excel 2007, I am having a
problem being able to scroll down anywhere in my spreadsheet while my cursor
has selected the original RANGE in the formula; =average (b97:b130) . It
appears that when my cursor has selected the range of cells in the formula
bar, I cannot do any scrolling. The spreadsheet seems to be locked up. Anyone
have a solution or have similar issue?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question