Quantcast Excel: how to keep table header in place?

Closed Thread
Results 1 to 3 of 3
  1. #1
    Notebook Deity
    Join Date
    Mar 2006
    Posts
    1,987
    Rep Power
    28

    Default Excel: how to keep table header in place?

    How do I keep the first row of Excel, the table header, to stay in place while dragging the scroll bar down?

  2. #2
    Notebook Consultant
    Join Date
    Jan 2007
    Location
    2947'30"N 9843'50"W
    Posts
    235
    Rep Power
    19

    Default Re: Excel: how to keep table header in place?

    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. #3
    Notebook Deity
    Join Date
    Mar 2006
    Posts
    1,987
    Rep Power
    28

    Default Re: Excel: how to keep table header in place?

    Quote Originally Posted by lbohn View Post
    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.
    Thanks. It works!

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -4. The time now is 08:10 PM.
Powered by vBulletin® Version 4.2.2
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.
SEO by vBSEO 3.6.1