1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

excel xp column headers

Discussion in 'Other PC Software' started by maxmangion, 2004/03/26.

Thread Status:
Not open for further replies.
  1. 2004/03/26
    maxmangion

    maxmangion Inactive Thread Starter

    Joined:
    2002/08/13
    Messages:
    252
    Likes Received:
    0
    when opening excel xp, the column headers are numbered 1, 2,3 ,4 etc rather than as the old 2000 style A, B, C, D etc.

    Is there a way to get the letter column heading format rather than the integers ?

    Thanks
     
    maxmangion,
    #1
  2. 2004/03/26
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    This may be a feature of Excel XP - I run 2003 and can find no way of changing the column headers from letters to integers.

    Bound to be someone around the Board with a definitive answer on this.
     
    PeteC,
    #2


  3. to hide this advert.

  4. 2004/03/26
    KevinSaul

    KevinSaul Inactive

    Joined:
    2002/01/07
    Messages:
    425
    Likes Received:
    0
    I'm running Excel XP and mine shows letters accross the top and numbers down the side, the same as always. I can't find any way of changing the default headers in the help files but if I get a little free time later I'll continue to research this.
     
    Last edited: 2004/03/26
    KevinSaul,
    #3
  5. 2004/03/26
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Suggest you try a Repair of Excel
     
    PeteC,
    #4
  6. 2004/03/29
    maxmangion

    maxmangion Inactive Thread Starter

    Joined:
    2002/08/13
    Messages:
    252
    Likes Received:
    0
    thank you for your suggestions, but somehow i managed to solve the problem. Actually it is not a problem it is just a new feature in excel the "R1C1 reference style" which was turned on in the options. You can get to it by Tools->Options->General. By unticking it's option i got back the letters in the column headings.

    Thanks for your support!
     
    maxmangion,
    #5
  7. 2004/03/29
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Thanks for posting back with the solution - never really paid much attention to that check box!!
     
    PeteC,
    #6
  8. 2004/03/29
    KevinSaul

    KevinSaul Inactive

    Joined:
    2002/01/07
    Messages:
    425
    Likes Received:
    0
    Glad you found it, learn something new every day!!!! :D
     
    KevinSaul,
    #7
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...