The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Excel: how to keep table header in place?

    Discussion in 'Windows OS and Software' started by hendra, Mar 16, 2010.

  1. hendra

    hendra Notebook Virtuoso

    Reputations:
    157
    Messages:
    2,020
    Likes Received:
    6
    Trophy Points:
    56
    How do I keep the first row of Excel, the table header, to stay in place while dragging the scroll bar down?
     
    hendra, Mar 16, 2010
    #1
  2. lbohn

    lbohn Notebook Consultant

    Reputations:
    320
    Messages:
    235
    Likes Received:
    0
    Trophy Points:
    30
    Window > Split

    Drag the pane borders to set the static rows and/or columns.

    After you set the static rows/columns, you can continue using Excel with the large pane borders or use Window > Freeze Panes to set the view and "hide" the borders.

    --L.
     
    lbohn, Mar 16, 2010
    #2
  3. hendra

    hendra Notebook Virtuoso

    Reputations:
    157
    Messages:
    2,020
    Likes Received:
    6
    Trophy Points:
    56
    Thanks. It works! :)
     
    hendra, Mar 16, 2010
    #3