Like Tree9Likes

URGENT! excel~ making columns stick?

Closed Thread
Page 1 of 2 1 2 LastLast
  1. #1

    Join Date
    Apr 2005
    Location
    Sai Kung
    Posts
    8,561

    URGENT! excel~ making columns stick?

    PLEASE need help, FAST!

    using excel.... how do i make the column headers stick in place so i can scroll down and still see the headers?

    i knew, once upon a time, but have forgotten...

    THANKS!


  2. #2

    Join Date
    May 2008
    Location
    DB
    Posts
    3,699

    window
    split
    freeze panes

    shri, carang, Dreadnought and 1 others like this.

  3. #3

    Join Date
    Oct 2006
    Location
    Sarcasm - because beating the crap out of people is illegal
    Posts
    14,622

    Select Row 2
    Windows (pull-down menu) - select Freeze Panes

    carang likes this.

  4. #4

    Join Date
    Apr 2005
    Location
    Sai Kung
    Posts
    8,561

    thanks... but it's not doing it where i want it to be done... sorry... i'm getting really stressed out about this because my assistant was supposed to do all of this and hasn't~


  5. #5

    Join Date
    Apr 2005
    Location
    Sai Kung
    Posts
    8,561

    never mind! i got it!

    THANKS!


  6. #6

    Join Date
    Oct 2007
    Posts
    108

    headers

    Just make sure the cell underneath the row of headers is highlighted

    carang likes this.

  7. #7

    Join Date
    Apr 2005
    Location
    Sai Kung
    Posts
    8,561

    you ladies are SUPERSTARS! thanks!


  8. #8

    Join Date
    Oct 2006
    Location
    Sarcasm - because beating the crap out of people is illegal
    Posts
    14,622

    Just realised I assumed the top row was the header. But good that you managed it!


  9. #9

    Join Date
    Jan 2004
    Location
    Discovery Bay
    Posts
    5,018

    Hi,

    How do you set it to print multiple pages using the top row as the header? Thanks.


  10. #10

    Join Date
    Oct 2006
    Location
    Sarcasm - because beating the crap out of people is illegal
    Posts
    14,622
    Quote Originally Posted by Dreadnought:
    Hi,

    How do you set it to print multiple pages using the top row as the header? Thanks.
    Go to Page Setup, and then select the Sheet tab.

    To print row labels on every page: under Print titles in the Columns to repeat at left box, enter the columns that contain the row labels, and then click Print.
    Last edited by Claire ex-ax; 23-06-2010 at 12:48 PM.
    Dreadnought likes this.

Closed Thread
Page 1 of 2 1 2 LastLast