1. You may have noticed things look a little different around here - we've switched to a new platform (XenForo) and have some new forum styles and features. This how-to guide will help you find your way around. If you find anything that looks strange, post it in this thread.

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
    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
    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
    Thanks. It works! :)
     
Thread Status:
Not open for further replies.

Share This Page