Excel: how to keep table header in place?

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

Thread Status:
Not open for further replies.
  1. hendra

    hendra Notebook Deity

    Reputations:
    156
    Joined:
    Mar 17, 2006
    Messages:
    1,987
    Likes Received:
    0
    Trophy Points:
    55
    How do I keep the first row of Excel, the table header, to stay in place while dragging the scroll bar down?
     
  2. lbohn

    lbohn Notebook Consultant

    Reputations:
    320
    Joined:
    Jan 28, 2007
    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.
     
  3. hendra

    hendra Notebook Deity

    Reputations:
    156
    Joined:
    Mar 17, 2006
    Messages:
    1,987
    Likes Received:
    0
    Trophy Points:
    55
    Thanks. It works! :)
     
Loading...
Thread Status:
Not open for further replies.

Share This Page