Column headings switched to numbers

D

Dcdrj2

Bit Frustrated and know the answer is simple but can't seem to find i
anywhere.

I have one spreadsheet where the column headings are numbers rathe
than letters and all referenced appear to be distinct to the Row an
Column R1C5 etc. In some cases formulas are generated with what appear
to be relative row/column numbers. I would like to get this spreadshee
back to the Normal row and column headings so the functions work as
know them.

Any suggestions
 
C

Cesar Zapata

dude,

go to Tools> options > then click on the General Tab

Make sure the "R1C1 refernce" style is unchecked.



Regards,

Cesar Zapata
 
D

Dcdrj2

Problem Solved.

Actualy found the answer in another post on this site.

Tools/options/General tab

Uncheck R1C1 style.

Knew it was simple

:
 

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 to numbers and row headings to alphabets? 2
Excel 2007... fix column headings from numbers back to letters 4
Column Heading Error 3
Column Headings 2
Column headings 2
Changing grey column headings from numbers back to capital letters 2
Column headings display as a numbers 7
How: reset the column headings from numeric to alphabetic? 1

Top