Why does paging down skip ten rows?

[Guest]

I have a worksheet that has 180 rows of data. When I use the page up and page
down keys, 10 rows are skipped over. Scrolling up or down brings these rows
on the page.

 

[Richard Buttrey]

I have a worksheet that has 180 rows of data. When I use the page up and page
down keys, 10 rows are skipped over. Scrolling up or down brings these rows
on the page.

Why do you think this is working incorrectly? The number of rows that
are 'skipped' is dependent principally on the row height that's been
set, and the size of your screen. Reduce the row height and you'll
find that more rows will be skipped with PgUp & PgDown.

Locking the scroll will simply lock the cursor to a particular row.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Otto Moehrbach]

What is your question? What you describe is the way Excel operates. What
do want to happen when you use the page up and the page down keys? HTH
Otto