Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
the name of my columns in excel
the name of my columns in excel changed from A, B, C.. to 1, 2, 3...
now because of that it is difficult for me to read my formulas... how do I change the name of the columns back to A, B, C, D,.....??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
the name of my columns in excel
ToolsOptionsGeneral tab, uncheck R1C1 Reference style
-- Kind regards, Niek Otten Microsoft MVP - Excel "BEBE_CABRERA" wrote in message ... | the name of my columns in excel changed from A, B, C.. to 1, 2, 3... | now because of that it is difficult for me to read my formulas... how do I | change the name of the columns back to A, B, C, D,.....??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
the name of my columns in excel
On Oct 11, 7:16 am, BEBE_CABRERA
wrote: the name of my columns in excel changed from A, B, C.. to 1, 2, 3... now because of that it is difficult for me to read my formulas... how do I change the name of the columns back to A, B, C, D,.....??? Tools|Options|General|Settings...deselect R1C1 reference style Ken Johnson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
the name of my columns in excel
Somehow you have turned on R1C1 reference style. In Excel 2007 to turn it
off: Office Button/Excel Options/Formulas/Working with formulas. Uncheck R1C1 reference style. In previous versions of Excel this will be under Tools/Options. But I'm not sure just where. Tyro "BEBE_CABRERA" wrote in message ... the name of my columns in excel changed from A, B, C.. to 1, 2, 3... now because of that it is difficult for me to read my formulas... how do I change the name of the columns back to A, B, C, D,.....??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
"Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
unable to insert columns in excel, insert- columns (disabled) | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) |