Top Row on Excel has changed to 1, 2, 3... in lieu of A, B, C?

L

Layman D. Cobb

Somehow I have changed the column lable from letters - A - B - C .... to 1,
2, 3? Its driving me crazy and I dont know how to change back? Help!!!!
 
F

FSt1

hi
2003
on the menu bar>tools>options>general tab>uncheck R1C1 reference
2007
Office button>Excel options>formulas>uncheck R1C1 reference

regards
FSt1
 

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

Scrabble Value calculation for Welsh words 0
Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3 1
Excel Write a formula in excel where 1 = .05, 2 = .75, 3 = .30 etc. 4
column heading label 1
Calculation based on changing conditions 3
Change column Name from 1 2 3 to A B C in excel 2007 1
Paste in column B using Last row of either column B, C or D. 10
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5

Top