How do I change Excel column cell identifiers back to letters?

G

Guest

While merging data from different worksheets and formatting cells, I suddenly
noticed the column identifiers at the top of my worksheet changed to numbers
instead of letters. Any good ideas on how I should change them back to
letters? I searched Help Online and came up empty thus far. Thanks!
 
L

Leith Ross

Hello Cotmc,

On the the menu go to Tools>Options>General>Settings and click the box
marked R1C1 style to clear it.

Sincerely,
Leith Ross
 
G

Guest

Try this:

Tools>Options>General tab
UNcheck: R1C1 reference style

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
G

Guest

Yes! Thanks a million!

Ron Coderre said:
Try this:

Tools>Options>General tab
UNcheck: R1C1 reference style

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 

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

Excel 2007... fix column headings from numbers back to letters 4
How to change column labels back to letters? 1
How do I change headings (column name) from numbers to letters? 2
Columns now numbers rather than letters how do i get letters back 2
How do I change column identifiers from numbers to letters? 3
Changing grey column headings from numbers back to capital letters 2
Column chngd fm letters to numbers. What that & how do I go back? 1
2007, excel column hdings are now numbered - how do I get letters 1

Top