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
now when I open new excel file, the column Name is 1 2 3 and the row als 1 2 3
how can I change the column name back to A B C please I need your help Thanks Ahmad |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change column Name from 1 2 3 to A B C in excel 2007
Change in options. Depends on your version of xl what you need to do so I'll
give you both. XL 2007 Click Microsoft button (large button top left of screen) Click Options (towards bottom right of dialog box) Select formulas (in left column.) Uncheck the box R1C1 Reference Style Earlier versions of xl. Click menu itme Tools - Options - General Tab Uncheck the box R1C1 Reference Style -- Regards, OssieMac "Ahmad Sanad" wrote: now when I open new excel file, the column Name is 1 2 3 and the row als 1 2 3 how can I change the column name back to A B C please I need your help Thanks Ahmad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 change column labels from numbers to letters | Setting up and Configuration of Excel | |||
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) |