column names
 

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

column names
 

Uncheck the check box in
menu ToolsOptionsGeneral TabR1C1 reference style...


If this post helps click Yes
---------------
Jacob Skaria


"erregsec" wrote:

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

column names
 

It comes up with a box
Name Conflict

Name cannot resemble a reference

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

"Jacob Skaria" wrote:

Uncheck the check box in
menu ToolsOptionsGeneral TabR1C1 reference style...


If this post helps click Yes
---------------
Jacob Skaria


"erregsec" wrote:

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

column names
 

It comes up with a box
Name Conflict

Name cannot resemble a reference

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

"Jacob Skaria" wrote:

Uncheck the check box in
menu ToolsOptionsGeneral TabR1C1 reference style...


If this post helps click Yes
---------------
Jacob Skaria


"erregsec" wrote:

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

column names
 

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
---------------
Jacob Skaria


"erregsec" wrote:

It comes up with a box
Name Conflict

Name cannot resemble a reference

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

"Jacob Skaria" wrote:

Uncheck the check box in
menu ToolsOptionsGeneral TabR1C1 reference style...


If this post helps click Yes
---------------
Jacob Skaria


"erregsec" wrote:

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

column names
 

Thank You!!!

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"erregsec" wrote:

It comes up with a box
Name Conflict

Name cannot resemble a reference

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

"Jacob Skaria" wrote:

Uncheck the check box in
menu ToolsOptionsGeneral TabR1C1 reference style...


If this post helps click Yes
---------------
Jacob Skaria


"erregsec" wrote:

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