Dragging in Excel

O

ollyj

Am confused how to stop this happening!:confused: When I drag a formul
down through many cells, excel only allows me to go to bottom of th
screen and then I have to scroll manually to make the bottom of th
screen the top and then can drag down formula again!! Hope this make
sense quite hard to describe! (simply put I can only drag a screen'
length down then it stops so thats around 50 cells!!) Very frustrain
as I am always using huge lists of data!!

HELP
 
R

RickBurda

Unsure what type of mouse you are using, but you may try this if yo
have intelamouse. Look for the settings and adjust the acceleratio
properties, not the speed... It helped on mine
 
J

Jim Rech

The only time I've seen this is when the workbook window does not fit in
Excel's window. Meaning the bottom of the workbook window is below Excel's.
 
O

ollyj

Thanks but no luck so far, checked speed but it not really
acceleration issue, have set it to all settings and no joy. The scree
is fitting in the window fine so dont thikn it that either. The rea
mstery is that I can scroll all around the sheet no problem only whe
it comes to dragging data through a number of cells it only lets m
move within the screen.....:mad: really frustrating!!.... could it b
the actual software got a bug??

Thanks for ideas so far though, but need more !!!!

:
 
R

RickBurda

What I also have done is start from the bottom, and go up... This will
at least stop at the top, instead of going all the way to the end of
the file...
 
Top