column names

E

erregsec

I got a excell sheet that the column names have been changed from A,B,C,D ect
to 1,2,3,4 ect. I need to change them back to the A,B,C,D ect. How do I do
that??
 
J

Jacob Skaria

Uncheck the check box in
menu Tools>Options>General Tab>R1C1 reference style...


If this post helps click Yes
 
E

erregsec

It comes up with a box
Name Conflict

Name cannot resemble a reference

Old Name: A1
New Name: (space to type)
 
E

erregsec

It comes up with a box
Name Conflict

Name cannot resemble a reference

Old Name: A
New Name: (space for typing)
 
J

Jacob Skaria

There are names ranges A,B etc; which will need to be converted to something
different (say nameA,nameB etc;) OR otherwise there will be conflict with the
column name referencing.. where A denotes column A

If this post helps click Yes
 
E

erregsec

Thank You!!!

Jacob Skaria said:
There are names ranges A,B etc; which will need to be converted to something
different (say nameA,nameB etc;) OR otherwise there will be conflict with the
column name referencing.. where A denotes column A

If this post helps click Yes
 

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

Top