1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel header

Discussion in 'Software' started by Boycie, Jul 13, 2006.

  1. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    Can i insert a name or description where the column letter is normally displayed? On a very long spreadsheet with lots of data it is a bit of a bummer having to scroll up to check you have inserted the right part!

    Si
     
    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT
  2. Phil
    Honorary Member

    Phil Gigabyte Poster

    1,680
    7
    87
    you could just add a header row then use the window > split menu command, that way the headers will stay in place when you scroll
     
    Certifications: MCSE:M & S MCSA:M CCNA CNA
    WIP: 2003 Upgrade, CCNA Upgrade
  3. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    phil,

    got the split bit, just looking to add the description...

    Si
     
    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT
  4. Gaz 45

    Gaz 45 Kilobyte Poster

    404
    4
    39
    Don't think you can in Excel?

    I tend to put the column headers in Row 1 (or whichever one is relevant) then use Freeze panes to lock them at the top of the screen.
     
    Certifications: MCP (70-229, 70-228), MBioch
    WIP: MCDBA (70-290)
  5. Mr.Cheeks

    Mr.Cheeks 1st ever Gold Member! Gold Member

    5,369
    85
    190
    Freeze pane is the way to go on this one...
    click Window, then Freeze Pane
     
  6. Nelix
    Honorary Member

    Nelix Gigabyte Poster

    1,412
    3
    82
    Just to add to the cheekmaster

    highlight the row BELOW where you want to freeze.
     
    Certifications: A+, 70-210, 70-290, 70-291
    WIP: 70-294
  7. Mr.Cheeks

    Mr.Cheeks 1st ever Gold Member! Gold Member

    5,369
    85
    190
    and to add to Nelix - if you want to freeze both column and row so you want to Column A to be static and row 1 to be static, you will need to click on B1... sorry im not being pedantic, its just that it took me ages to figure that part out
     
  8. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    thanks for your help guys, appreciated :thumbleft

    Si
     
    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT
  9. nugget
    Honorary Member

    nugget Junior toady

    7,796
    71
    224
    Boyce, if you put your headers in the 1st row, you can then go to the right side and at the top of the scroll bar you'll see a little line. Click on this and drag it down and then you'll have a split view.
     
    Certifications: A+ | Network+ | Security+ | MCP (270,271,272,290,620) | MCDST | MCTS:Vista
    WIP: MCSA, 70-622,680,685

Share This Page

Loading...