close

Privacy guaranteed - Your email is not shared with anyone.

Excel column headers

Discussion in 'Tech Talk' started by volky, Nov 21, 2010.


  1. volky

    volky
    Expand Collapse
    NRA Member
    Millennium Member

    Joined:
    Aug 30, 1999
    1,052
    12
    Location:
    Take a seat facing the door.
    I did this once, but have since forgotten. How do you keep the column headings on top, visible when you scroll down the columns ?

    This time I'll write it down, I promise.
     
  2. econjon

    econjon
    Expand Collapse

    Joined:
    Aug 10, 2004
    248
    0
    Location:
    OUC
    Assuming the column headers are in row #1, you'll want to highlight row 2 (the one below the one with the headers) and hit 'freeze panes'. In 2003 this is an option under the "window' tab at the top of the spreadsheet or in 2007 I think it's under the "view" tab.
     

  3. BobbyT

    BobbyT
    Expand Collapse

    Joined:
    Jul 27, 2008
    1,817
    2
    I don't have Excel on this computer, just OpenOffice, but on the left if you click the Row number where your headings are (or maybe the one below; fiddle with it), it should highlight that whole row.

    Then under Data I believe there's a "Freeze Cells" option. Once you freeze them, they won't scroll with the rest of the data below.

    But this is off the top of my head, so you may have to check the sub menus.
     
    #3 BobbyT, Nov 21, 2010
    Last edited: Nov 21, 2010
  4. MavsX

    MavsX
    Expand Collapse
    The Dude Abides

    Joined:
    Jan 19, 2009
    3,033
    0
    Location:
    Arlington, VA
    econjon ftw
     
Loading...
Similar Threads Forum Date
Excel spreadsheet Tech Talk Sep 7, 2015
Excel Help Tech Talk Feb 28, 2011
Excel Help Tech Talk May 15, 2010
Excel Help Tech Talk Aug 10, 2007
Excel Help Tech Talk Jan 19, 2007
Duty Gear at CopsPlus