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
    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
    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
    Messages:
    1,987
    Likes Received:
    0
    Trophy Points:
    55
    Thanks. It works! :)
     
Similar Threads: Excel keep
Forum Title Date
Windows OS and Software Excel Question Mar 10, 2013
Windows OS and Software Excel Tables question Feb 17, 2013
Windows OS and Software Excel 2010 encryption Oct 17, 2012
Windows OS and Software Excel 2010 - Error opening files Oct 3, 2012
Windows OS and Software X-Y-Z Scatterplots in Excel, or similar program Aug 10, 2012

Thread Status:
Not open for further replies.

Share This Page