Excel Q: Anchoring Headings?

Discussion in 'Computers' started by Chuck C, Oct 12, 2004.

  1. Chuck C

    Chuck C Cinematographer

    Joined:
    Jan 6, 2001
    Messages:
    2,224
    Likes Received:
    1
    I'm working with a big spreadsheet and I need to some sort of way to keep the headings at the top when I scroll far down the sheet. any help would be apprc.
     
  2. John_Bonner

    John_Bonner Supporting Actor

    Joined:
    Oct 25, 2000
    Messages:
    664
    Likes Received:
    0
    Click on WINDOW | FREEZE PANES to lock both the rows and columns.
     
  3. EricWilliam

    EricWilliam Agent

    Joined:
    Aug 31, 2004
    Messages:
    37
    Likes Received:
    0
    just to clarify, find the cell that is one row BELOW and one column to the RIGHT of where you want to freeze, then go to Window on the menu bar and choose Freeze Panes
     
  4. Chuck C

    Chuck C Cinematographer

    Joined:
    Jan 6, 2001
    Messages:
    2,224
    Likes Received:
    1
    ahh beautiful, thanks
     

Share This Page