Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    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.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I don't know a solution for that. (I thought of turning on Scroll Lock but that doesn't do what you want either.)

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    [quote name='HansV' post='772400' date='26-Apr-2009 16:45']I don't know a solution for that. (I thought of turning on Scroll Lock but that doesn't do what you want either.)[/quote]

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •