Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Thanked 0 Times in 0 Posts

    Repeating Rows? (Office 2003)

    Hi All,
    I'm trying to set a row to continually display as I scroll down in my spreadsheet. Example: I used row 1 as column titles and as I scroll down to row 100, I want to see Row 1 displayed at the top. I found the information here a while ago but can't remember how to do it. Hopefully I've explained this well.

    Thanks in advance for any help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Repeating Rows? (Office 2003)

    Select row 2 by clicking on its row header (the button labeled "2"). Then select Window | Freeze Panes.

    Similarly, if you always want to see columns A and B, select column C, then select Window | Freeze Panes.

    And if you want to see row 1 and columns A and B, select cell C2, then select Window | Freeze Panes.

    The next time, the menu option will "unfreeze" the row(s) and or column(s).

Posting Permissions

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