1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Help with Excel XP 2002 column headings

Discussion in 'Business Applications' started by lminassiankiefel, Apr 14, 2010.

Thread Status:
Not open for further replies.
  1. lminassiankiefel

    lminassiankiefel Thread Starter

    Joined:
    Apr 14, 2010
    Messages:
    1
    My 2002 version of XP Excel has changed the set column headings from letters to numbers. For example, cell "A1" is indicated by a "1" for the row and a "1" for the column and when I click on the cell, it is designated as "R1C1". I would like to get the letter column headings back as the program was originally designed but I cannot figure out how to do this. I have no idea why the set column headings changed to numbers. Does anyone know how to get back the letter designations for the column headings and know why it changed to begin with? Could it have changed because of a virus or because I downloaded the patch to be able to read MS Excel 2007 files?

    Thanks.
     
  2. WendyM

    WendyM Retired Trusted Advisor

    Joined:
    Jun 27, 2003
    Messages:
    4,042
    Hi, welcome to TSG. I don't know what caused it, but to change it back you can go to Tools/Options and select the General tab. The first checkbox should say "R1C1 reference style". Uncheck the box and select OK, and it should return to normal. Hope that helps.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/916834

  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.
    Dismiss Notice