ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Change column Name from 1 2 3 to A B C in excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/223842-change-column-name-1-2-3-b-c-excel-2007-a.html)

Ahmad Sanad

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

OssieMac

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



All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com