Question about Microsoft Excel. Please help!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • czarina
    Webmaster Extraordinaire
    • Jul 2002
    • 10752

    #1

    Question about Microsoft Excel. Please help!

    hi there!
    I'm trying to work on a big Excel file, and I have to keep scrolling back up to see what the name of the columns in the first row is. Is there some way to change the default name of the A B C D columns (since those are static and can be seen no matter what row number I'm working on, even if I'm on row 100000)?
    Thanx!
  • the Shemp
    congrats to the winners
    • Nov 2001
    • 10891

    #2
    i havent used excel in a while, but the "freeze columns" command should work
    i use Vacares...so should you
    Submit your picture galleries to my site...Outlaw TGP

    Comment

    • TexasDreams
      former Miserable Admin :)
      • Oct 2003
      • 4700

      #3
      Originally posted by czarina
      hi there!
      I'm trying to work on a big Excel file, and I have to keep scrolling back up to see what the name of the columns in the first row is. Is there some way to change the default name of the A B C D columns (since those are static and can be seen no matter what row number I'm working on, even if I'm on row 100000)?
      Thanx!
      Highlight the first row with the header names, then click on Window and select "Freeze Panes".
      ICQ: 168-914-369 >>> sysop [at] TexasDreams [dot] com

      Comment

      • czarina
        Webmaster Extraordinaire
        • Jul 2002
        • 10752

        #4
        you guys are SWEETHEARTS!!!! I love you soooooooooo much!!!

        Thanx tons! You just saved me a ton of scrolling up and down...


        MUAH!!!!!

        Comment

        • the Shemp
          congrats to the winners
          • Nov 2001
          • 10891

          #5
          Texas is correct, it the "Freeze panes" not "freeze columns"...
          i use Vacares...so should you
          Submit your picture galleries to my site...Outlaw TGP

          Comment

          • gooddomains
            Too lazy to set a custom title
            • Jul 2003
            • 10127

            #6
            1+1 = 2 or maybe 3 (not sure though)

            Comment

            Working...