TechSpot

Excel Columns Problem - No letters, numbers instead

By SNGX1275
May 31, 2005
  1. I don't really know what I did to cause the problem, but whatever it was I didn't intend to do it. I no longer have letters up for the column headers, this makes it a real pain to type in forumlas.

    Anyway, attached is a screenie of what I'm talking about, anyone know how to make it normal again?
    [​IMG]
     
  2. RealBlackStuff

    RealBlackStuff TS Rookie Posts: 8,165

    In Excel, click Tools/Options
    Select the "General" tab and UNtick the "R1C1 Reference Style" checkbox.
     
  3. SNGX1275

    SNGX1275 TS Forces Special Topic Starter Posts: 12,700   +338

    Ah, many thanks RBS.
     
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.