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

Page won't show whole document unit you scroll 0
changing the number of rows the mouse scrolls through 1
How to navigate with arrow keys in Excel 2007? Tried Scroll Lock! 4
Excel 2007 - Can't scroll thru worksheet 2
NEED HELP ASAP PLEASE!! 7
how do i stop my arrow keys from scrolling? 3
How can I scroll page up/down with arrow keys 1
Arrow Keys scroll across the page instead of to the next cell 1

Top