ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Why does paging down skip ten rows? (https://www.excelbanter.com/excel-worksheet-functions/86095-why-does-paging-down-skip-ten-rows.html)

RADEANO

Why does paging down skip ten rows?
 
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

Why does paging down skip ten rows?
 
On Sun, 30 Apr 2006 09:25:02 -0700, RADEANO
wrote:

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

Why does paging down skip ten rows?
 
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
"RADEANO" wrote in message
...
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.





All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com