Subscribe to How-To Geek

Welcome to the How-To Geek Forums

We encourage you to register on our forums and post any questions you might have. The How-To Geeks monitor this forum and will respond to your question quickly.

How-To Geek Forums » Windows Vista

Excel scroll issue

(7 posts)
  • Started 10 months ago by Smashpmk712
  • Latest reply from gculhane
  • Topic Viewed 936 times


Smashpmk712
Smashpmk712
Posts: 313

All of my users with excel 2007 are having the same issue. When the cursor to the formula bar the scroll wheel on their mouse no longer lets them scroll through the document. Is there a way to change this behavior? I would assume that excel is at that point attempting to scroll on the formula bar itself. Any suggestions would be a great help.

Posted 10 months ago #
 
Smashpmk712
Smashpmk712
Posts: 313

Just trying to get this one back on the first page. this time I won't make the mistake of naming names!

Posted 10 months ago #
 
taybay
taybay
Posts: 483

I don't think you can do anything about that. When the cursor is in the bar, the focus is there and only there. All you have to do is click outside of it to change the focus, though.

Posted 10 months ago #
 
Smashpmk712
Smashpmk712
Posts: 313

the problem with that is that the end user, throughout the day, need to change a formula in a cell so the go to the cell and select the formula bar, then they would need to scroll down further on in the worksheet. does this make sense? Also this works in excel 2003.

Posted 10 months ago #
 
jd2066
Posts: 3331

I think taybay is right. I just checked and it appears the reason is the Excel 2007 supports displaying/scrolling multiline formulas so the scroll on scrolling the forumla bar makes sense.

Posted 10 months ago #
 
Smashpmk712
Smashpmk712
Posts: 313

I know that is the reason. do you know of an option to change to make it like excel 2003?(where it doesn't support scrolling through multiple formulas)

Posted 10 months ago #
 
gculhane
Posts: 1

You must have the "allow editing directly in cells" box checked. Go to excel options/advanced. Once this is checked you will be able to enter a formula command and then scroll to the cell reference. This is a change from 2003 version. I prefer to not have the edit directly in cell box checked, but I would rather be able to scroll to the reference cell.

Posted 1 month ago #
 

RSS feed for this topic

Reply

You must log in to post.

Sponsored Links
Getting Started
About How-To Geek
What Is That Process?
svchost.exe
jusched.exe
dwm.exe
ctfmon.exe
wmpnetwk.exe
wmpnscfg.exe
rundll32.exe
wfcrun32.exe
Ipoint.exe
Itype.exe
Wfica32.exe
Mobsync.exe
Cmd.exe
Dpupdchk.exe Adobe_Updater.exe

Copyright © 2006-2008 HowToGeek.com. All Rights Reserved.