How can change column title back to alphabet (A,B,C..)

G

Guest

In my worksheet the column title are numbers (1,2,3....) and I would like to
change back to alphabetic (A,B,C...). Can some one help my. Thank you very
much.
 
G

Guest

From the menu bar, Tools > Options, click General, deselect 'R1C1 reference
style' and click OK. (If it's already deselected, try to select, then OK,
then deselect and OK).
 
P

Paul B

Ray, tools, options, general, uncheck R1C1 reference style

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

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 do I change my cell reference columns from number to alphabet? 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
How do I change column headings from A,B,C to actual words? 3
Picking a cell that is next to a cell 4
Column Headings 3
Matching check to payment amounts 7
Adding a unique identifier to a column of data 2

Top