| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format column to link file names in that column | Excel Discussion (Misc queries) | |||
| Replacing A,B,C column names to other names | Excel Discussion (Misc queries) | |||
| How do I replace A, B, C, Column names, with my own names? | Excel Discussion (Misc queries) | |||
| how to check for recurrence of same names in column 1 and column | Excel Discussion (Misc queries) | |||
| Importing data to column from column with differnet names | Excel Discussion (Misc queries) | |||
Linear Mode
