| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change column name from 1 2 3 to A B C in Excel 2007
Hi All
when I open new Excel file the column name is 1 2 3 and the Row name als 1 2 3 how can I chane back the column name to A B C Many thanks Ahmad |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change column name from 1 2 3 to A B C in Excel 2007
Hi,
In Excel2003 and earlier, go to ToolsOptionsGeneral and uncheck the R1C1 box. In Excel2007, you'll have to wait for someone else to comment. Dave "Ahmad Sanad" wrote: Hi All when I open new Excel file the column name is 1 2 3 and the Row name als 1 2 3 how can I chane back the column name to A B C Many thanks Ahmad |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change column name from 1 2 3 to A B C in Excel 2007
Click the Office button -- upper left
Excel options Formulas Uncheck R1C1 reference style "Ahmad Sanad" wrote: Hi All when I open new Excel file the column name is 1 2 3 and the Row name als 1 2 3 how can I chane back the column name to A B C Many thanks Ahmad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change column Name from 1 2 3 to A B C in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 formatting wont change in column | Excel Discussion (Misc queries) | |||
| For Excel 2007 how do yu change column headers from numbers to let | Excel Discussion (Misc queries) | |||
| how do I change column heading in excel (2007) | Excel Discussion (Misc queries) | |||
| how do I change column header direction in excel 2007 | Excel Discussion (Misc queries) | |||
![Ahmad Sanad[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
