Page down to top of next page?

Topic

New Reply

Is there a way to make the Page Down button in Excel move to the first cell on the top of the next page rather than the bottom cell? It seems to me that would be a far more useful function.
Mr Johbot seems to recall that this was available in ‘an older version’. He started using Excel with version 4, so there’s a bit of memory there.

Reply | Quote

Replies

Page Up and Page down move the active cell one “screenful” (more accurately, as many rows as the worksheet window displays) up or down, preserving the relative location of the active cell. So if the active cell was at the top of the window, it will still be at the top after pressing Page Down, and if the active cell was in the middle, it will still be in the middle after Page Down.

Page Up and Page Down ignore page breaks.

Reply | Quote

Thanks Hans.

That behaviour can be annoying when you are entering data into a long list.

I enter the data line by line (or entry by entry – sometimes missing some lines) and then page down to get the next screen full, but have to arrow up to get back to my place. The only other option is to leave the insertion point at the bottom of the page and not be able to see the next line. I would be entering data into about 120 places on a worksheet with 500 lines of data. So there are a few screens full.

Johanna

Reply | Quote

I don’t know a solution for that. (I thought of turning on Scroll Lock but that doesn’t do what you want either.)

Reply | Quote

I don’t know a solution for that. (I thought of turning on Scroll Lock but that doesn’t do what you want either.)

Try this VBA

The VBA was provided to me by Hans a while back. It works great.

Sub ScreenDown()
‘
‘ Macro ScreenDown Macro
‘ Macro from AskWoody
‘
Application.Goto Reference:=ActiveCell.Offset(0, 0), Scroll:=True
End Sub

You can put the VBA as a button on the toolbar or attach it to a TextBox then put the box at the top or your worksheet and freeze the box by using a Window Freeze or Windows Split. Once the Window is split the box won’t move as you page up and down with data.

Whenever you hit the bottom of your screen just run the VBA code to start a new Screen.

Hope this helps.

Tom Duthie

Reply | Quote