column headings

A

Aaron Caldwell

Every time i open a new excel file the column headings
come up as numbers rather than letters. How can i change
them back to letters.
Thanks
 
C

Chip Pearson

Aaron,

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 (e-mail address removed)
 

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 2
column headings display as numbers 2
Excel 2007... fix column headings from numbers back to letters 4
Setting Column Headings 1
Column headings question 5
Column Heading 1
Changing grey column headings from numbers back to capital letters 2
column headings 3

Top