Column Headers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I received an Exel file with Numbers (1, 2, 3...etc) as Column Headers instead of the Default letters (A, B, C....etc.). How do I change it back so that the letters are at the top of the columns?
 
John,

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



message
I received an Exel file with Numbers (1, 2, 3...etc) as Column
Click to expand...
Headers instead of the Default letters (A, B, C....etc.). How do
I change it back so that the letters are at the top of the
columns?
 
Tools>Options>General and uncheck R1C1 reference style

--

Regards,

Peo Sjoblom


John Underwood said:
I received an Exel file with Numbers (1, 2, 3...etc) as Column Headers
Click to expand...
instead of the Default letters (A, B, C....etc.). How do I change it back
so that the letters are at the top of the columns?
 
You must log in or register to reply here.

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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3 1
Excel sheet with numbers as column & row headers - How? 3
Column headings - urgent help needed please 3
Why is my header row numbers instead of letters? 2
Column Headers 1
Column Header is not in Letter 1
Column header format 5

Back
Top