Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: vertical scrolling in Excel skips my 2000 rows: jumps to 100.000+

04 Feb 2017   #1
WimYogya

windows 7
 
 
vertical scrolling in Excel skips my 2000 rows: jumps to 100.000+

I am working on a big excel sheet, with around 2000 vertical rows.
Until recently there was no problem scrolling up and down to check/add content 'down under', towards the end of my workspace.
But now, if I use the SCROLL BAR button, it jumps from let's say row 100 directly to row 100.000+ or so.
What is the cause?
How can I prevent it?

Thanks


My System SpecsSystem Spec
.
04 Feb 2017   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

You have not mentioned which version of Excel, you are using. When you say the Scroll Bar button, are you referring to button on the side of the screen or the mouse button.
My System SpecsSystem Spec
05 Feb 2017   #3
WimYogya

windows 7
 
 

Sorry for the omission.
It's Excel 2010 professional.
And I mean the scroll bar button on the right hand side of the excel window. Even the slightest 'pull down' movement brings it already to row 4550... My real workspace of 2000 rows cannot be reached this way.
Scrolling with the mouse wheel works normal - but is slow. Takes ages to go down a few hundred rows....
Any idea?
My System SpecsSystem Spec
.

05 Feb 2017   #4
WimYogya

windows 7
 
 

By mistake my previous post was posted twice.... Sorry.
This is the modified second one ;-)
My System SpecsSystem Spec
05 Feb 2017   #5
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

In Excel 2013 using Ctrl+End will take you to the last row on a spreadsheet & Ctrl+Home will take you back to the first row, if you wish to go back up again.

I really can't suggest how to slow down the scroll bar. Have a look in your Excel help files for keyboard short cuts. Using short cuts does save a lot of time, especially with large spreadsheets.
My System SpecsSystem Spec
06 Feb 2017   #6
WimYogya

windows 7
 
 

It's not a matter of settings or shortcuts, I know those features.
It is an all-of-a-sudden-strange-change in the behavior of the scroll button, jumping 1000's of rows down
Mystery!
Did I by accident hit/change any hidden setting?
Anyone?
My System SpecsSystem Spec
12 Feb 2017   #7
WimYogya

windows 7
 
 

After endless searches I found a link that did not describe exactly MY scrolling problem, but a similar one.
Nevertheless: by applying the same solution worked - so my scrollbar works perfectly normal again.
Thanks to those who tried to help.
Apparently there was an 'invisible' problem: some cell(s) far down below had acquired (how?) invisible data that Excel remembered as being relevant for me. Só relevant that it immediately jumped to that cell when you start scrolling. Don't ask me what and why...
The solution:
1. Select and delete ALL columns to the right of your existing data block
2. Select and delete ALL rows below your existing data block.
3. SAVE THE NEW FILE - OTHERWISE EXCEL STILL 'REMEMBERS' THOSE ERRONEOUS CELLs!
4. Done!
My System SpecsSystem Spec
12 Feb 2017   #8
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Glad to hear you have fixed it & thanks for getting back & letting us know.
My System SpecsSystem Spec
Reply

 vertical scrolling in Excel skips my 2000 rows: jumps to 100.000+




Thread Tools




Similar help and support threads
Thread Forum
How do I enable touchpad vertical scrolling?
When I go to the Control Panel > Mouse, I get an error message that says that my laptop is not recognizing my touchpad. It still lets me open the configure window if I hit "no," and when I go to Device Settings > Scrolling > One-Finger Scrolling, it does not let me check the "Enable...
Hardware & Devices
Excel: Combining Rows Based on An Equal Value in One Column
I have attached two images of an Excel worksheet. I have gone to the trouble of taking multiple sets of three columns of associated data, that is data of x, y, z where y and z are associated with x. In building a new table with six sets of data, I put x1, x2, ..., x6 in a single column, and then...
Microsoft Office
Re: EXCEL- resorting rows so they each relate to original rows
Hi, I couldn't find an answer in the Forums for this in the past half hour of looking through them- there are so many, and I need an answer sooner than in the 4 or 5 days it will take me to get through them in HOPES of finding my answer. Sorry. So could someone who knows Excel in Windows 7...
Microsoft Office
Vertical Scrolling on Laptop Touchpad?
I have a Dell D620 Laptop, and I'm looking for a vertical scrolling driver. I have a synaptics driver now, but under settings it does not allow me to turn on vertical scrolling (nor is it even a visible as an option). I've tried installing another synaptics driver a few times, but so far I've...
Drivers
Media Player sound Skips/jumps
Hello I'm using Media Center & Media Player on my 32bit Win7 machine, which worked perfectly until recently.. Current problem is that the sound is skipping/jumping i.e. plays some sec. and then silent for a period, and then returns with sound, and continues like this through the song... Issue...
Media Center


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 07:03.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App