PgDn and PgUp Keyboard Commands

[sm2200]

Is it possible in Excel 2010 to change the number of rows the spreadsheet moves down or up when the PgDn or PgUp key is pressed ?
If so, How?

Thanks

 

[My Aswer Is This]

I try typing the stock symbol ACN into a cell. To correct this:
Choose File, Options, Proofing, Auto Correct Options, Replace Text As You Type.

 

[sm2200]

I try typing the stock symbol ACN into a cell. To correct this:
Choose File, Options, Proofing, Auto Correct Options, Replace Text As You Type.

On day 1 using Excel 2007 I used pgdn and the spreadsheet moved down a fixed number of rows. The next day using Excel 2007 I used pgdn and the spreadsheet moved down an 3 additional rows.

How can I change the number of rows pgdn and pgup move to be a fixed number I desire.

Thanks

(disregard the ACN question below)

 

[sm2200]

On day 1 using Excel 2007 I used pgdn and the spreadsheet moved down a fixed number of rows. The next day using Excel 2007 I used pgdn and the spreadsheet moved down an 3 additional rows.

How can I change the number of rows pgdn and pgup move to be a fixed number I desire.

 

[shg]

ADVERTISEMENT

How can I change the number of rows pgdn and pgup move to be a fixed number I desire.

They move up and down one screen, so short of writing a macro, you can't change it.

 

[sm2200]

They move up and down one screen, so short of writing a macro, you can't change it.

You misunderstand. I'm not trying to change the number of rows in pgdn or pgup.
It changed by itself from one day to the next.
So what I'm looking for is a method to fix the number of rows it will move and be the same from day to day.

Thanks,
Sam

 

[shg]

I probably don't understand that either.

It will scroll more rows if you hide the ribbon, fewer rows if you expand the formula bar or restore the window down. Either way, it scrolls one page up or down.

 

[My Aswer Is This]

Mine does what is says, it jumps down one page. The number of rows it jumps is dependent on the screen page size.