Help with scrolling down excel spreadsheet

Brighton_belle

Hoping someone can tell me how to do this - I have set up an excel spreadsheet, but when I want to scroll down by 'click, hold and drag', on the small rectangular 'button' on the top right of the spreadsheet, the tiniest of movements makes the page just down about 1000 rows at a time, completely by passing the info I have on it.
Other spreadsheets I have, where I can scroll down a few lines at a time, the rectangular button is much larger.


How do I make that rectangle larger and get the slower scroll down affect?


Hope this makes sense to someone!

rmg1

Have you checked your zoom level (on my version of 2010 there an icon in the bottom-right corner to show that).
The only think I can you're doing it dragging formulas down the page. Is that right?

Brighton_belle

rmg1 wrote: »

Have you checked your zoom level (on my version of 2010 there an icon in the bottom-right corner to show that).
The only think I can you're doing it dragging formulas down the page. Is that right?

Unfortunately I am no longer at work where the problem is, so I will check this tomorrow morning.
Thanks for the suggestion.

Mirno

It sounds like you've got something in one of the rows near the bottom of the spreadsheet.
The scroll bar is relative to the number of rows populated (or at least the last row in the spreadsheet).

A quick check - put an "A" in the first cell, ctrl + down arrow to get to the bottom, but a "Z" in that cell. Back to the top, and you'll scroll about 77 rows at a time on a maximised window.

After deleting the offending item, save and re-open and excel will have the correct scroll bar sizes.

ctrl + end will take you to the last row/column that is populated.
ctrl + right and ctrl + up will help you find the values that lead to that point.

Mirno

Brighton_belle

Thanks a lot Mirno - that sounds very hopeful: I'll try it as soon as I get into work tomorrow and report back!

EchoLocation

As Mirno says, you may just have a cell populated at the bottom of the sheet which is then causing the sheets' enormous scroll range. If you select all rows under your data down to the end of the sheet, delete them then save the file, it may reset the range. Unfortunately this does not always work as Excel still has problems with this sometimes.

If you cannot identify any cell values, and the above row deletion does not work, you can run the following code to reset the scroll range programmatically...

Sub ClearRng()
With ActiveSheet
.Cells.Clear
.UsedRange
End With
End Sub

Brighton_belle

Thanks Echo - sounds like your saying that with a huge spreadsheet, the scrolling facility would leap large chucks of rows per miniscule movement. All hopeful!
I don't understand about the code bit - is this something I have to type in somewhere? (If first idea doesn't work)

Brighton_belle

Many thanks everyone for all helpful ideas: I've solved the problem with your help, hurrah!
For some reason, the spreadsheets with the problem were massive, even though there was nothing in the very bottom row. So I have deleted the excess and voila, now have functioning spreadsheets with simple scrolling.


Seems obvious now I have done it, but I just didn't understand enough about spreadsheets to work it out for myself.