how do I change the scroll amount of page up/down key in excel?

  • Thread starter Michael Edwards
  • Start date
M

Michael Edwards

In Excel 2003 the amount of lines scrolled up/down by using the page up/down
is controlled by the size of the window you are looking at. In 2007 it
appears that the scroll amount is fixed to scroll 48 lines no matter the
window size. Can this be changed? How? If not, this is going to be a royal
pain.

Thanks

Michael
 
T

THendr2929

In my Excel 2007, in Normal view, the Page Up/Page Down keys jump one window
size, and the number of rows jumped varies depending on the size of the Excel
window I have open and my level of zoom - it is not fixed.

In Page Layout view, it does jump a fixed 48 rows, which is equivalent to
one page when the default cell format is set to Calibri 11 pt.

What view are you in when looking at your data?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I resize the scroll bar 1
increase number of items shown in drop down list? 12
how do I get the scroll bars on the Excel window 1
Microsoft Excel - Looking up values from a range by selection by scroll of arrow keys. 1
how do I change the size of vertical scroll bar 6
excel-how to get the spreadsheet to move as I move the scroll tab 6
How do I Make a drop-down box longer 2
How do I get the scroll wheel on mouse to work in Excel 1

Top