How do I change headings for columns from numbers to letters?

C

Chip Pearson

Go to the Tools menu, choose Options, then the General tab.
There, uncheck the "R1C1 reference style" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
R

Rowan Drummond

Tools>Options>General. Uncheck R1C1 reference style.

Regards
Rowan

scott wrote:
 
M

Max

Tools > Options > General tab
Uncheck "R1C1 reference style" > OK
[/QUOTE]
Re: How do I change headings for columns from numbers to letters?
 

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 STOP THE TAB KEY FROM ADVANCING TO THE NEXT PAGE IN EXCE 1
I want to get rid of columns with numbers as headings, how do I? 0
How to rename the head A,B,C,D,E etc. on every column 0
How do I get Excel column headings to be letters not numbers? 3
How do I change headings (column name) from numbers to letters? 2
what do you mean by macros?What it does? 0
how do I insert electric symbol (resistance,condenser,coil,...) 1
How do I show schedule 11pm to 8 am in Excel? 2

Top