What causes column headings in Excel to change from A, B, to 1,2?

G

Guest

Using Excel 2003 sometimes the column headings change from A, B, C, etc to 1,
2, 3, etc. The rows maintain their headings of 1, 2, 3 but only the column
headings change. This makes the creation of formulas difficult. Thanks.
 
G

Gord Dibben

Richard

Tools>Options>General.

Uncheck "R1C1 reference style".

This a user-generated change from unchecked mode.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column headings 3
Excel - Hiding Column Headings (A,B,C,...) and Row Names (1,2,3,.. 4
Column headings - urgent help needed please 3
How: reset the column headings from numeric to alphabetic? 1
How to change Colomn headings from (1,2,3,) to (A,B,C,) 3
Excel 2007... fix column headings from numbers back to letters 4
Column headings 2
Change worksheet column headings from numbers to letters 2

Top