Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PgUp to top of sheet (Excel XP/97)

    Let assume the cursor is at row 10. Then I use the PgDn key to page-down a few times. When I page-up the cursor returns to same row. If I press the PgUp key once more, the cursor stays at the same row and doesn't move. Is it possible to make the PgUp key move the cursor to row 1 at the same column?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: PgUp to top of sheet (Excel XP/97)

    Tools - options
    Transition tab
    Check: "transition navigation keys"
    <ok>

    This might affect other key patterns though I am not sure what the entire list of things is.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PgUp to top of sheet (Excel XP/97)

    I use ctrl-home to get to cell A1. If you're not in column A, ctrl-up arrow will eventually get you to row 1.

  4. #4
    New Lounger
    Join Date
    Nov 2001
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PgUp to top of sheet (Excel XP/97)

    Thank you Steve.
    Your advice does work, but you were correct about the changes in the function of other keys too, especially Tab.

    avi_r

Posting Permissions

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