Column Headers

J

John Underwood

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?
 
C

Chip Pearson

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?
 
P

Peo Sjoblom

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?
 
Top