Column headings to numbers and row headings to alphabets?

J

Juliana

Hi there,
My spreadsheet has gone crazy and now the column headings are in numbers
instead of alphabets and at the same time, the row headings are in alphabets
instead of numbers. Can anyone advice on how to rectify this?

J
 
G

Gord Dibben

Have another look at the sheet.

You may have numbers for column headers but I doubt if you have letters for row
headers.

To change the column numbers back to letters go to Tools>Options>General and
uncheck R1C1 Reference Style


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

HOW TO CHAGE COLUMN ADDRESS FROM NUMBERS TO ALPHABETS 2
columns showing numbers instead of alphabets 1
how do i change column numbers to alphabets from numerals 2
How: reset the column headings from numeric to alphabetic? 1
My Column display as "numbers" instead of "alphabets" 1
Excel 2007... fix column headings from numbers back to letters 4
How do I change headings (column name) from numbers to letters? 2
Change worksheet column headings from numbers to letters 2

Top