Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page Down (2000 SR1a)

    I have a spreadsheet with a few hundred rows. The same pattern repeats about every 20 rows. With my current screen resolution and zoom preferences I've been unable to get exactly one set of the 20 rows on my screen at a time. I would like to be able to press the page down key (or something similar) and have the next set of twenty rows come up. I'm thinking of something similar to a bookmark inserted at a certain point. I have not been able to find anything yet that will work. Any suggestions?

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Down (2000 SR1a)

    I would think you should be able to do this by selecting the cells you want to view on your screen and hitting your Zoom dropdown button on the toolbar, and choose "selection". This should zoom it to 20 rows. If your screen is then at that percentage, I would think you'd always see 20 rows.

  3. #3
    Star Lounger
    Join Date
    Jul 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Down (2000 SR1a)

    Thanks. I've tried that though. It works okay except that I then can't "page down" to the next set of rows. When this spreadsheet was initially set up, we could just hit the "page down" key and go to the next set of rows, but that was on a different machine with a different resolution.

  4. #4
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Down (2000 SR1a)

    It works perfectly for me in a blank worksheet, showing A1 through J20. I hit page down, I'm on A21. What is different about your worksheet that this doesn't work?

  5. #5
    Star Lounger
    Join Date
    Jul 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Down (2000 SR1a)

    I tried that and it works. My spreadsheet is actually formatted as follows: I have header rows on rows 1 and 2. My data starts on row 3 and goes through row 23. If I select A3 through R23 (R is actually the last column) and choose selection, I get a zoom rate of 92%. Putting my cursor in A3 and hitting page down I go to A28 instead of A24.

Posting Permissions

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