I want to change the preset colum headings (A,B,C.....) to something different.....How do i do that?
H help Jan 5, 2005 #1 I want to change the preset colum headings (A,B,C.....) to something different.....How do i do that?
J JE McGimpsey Jan 5, 2005 #2 You have the option of letters or numbers (Tools/Options/General "R1C1 Reference Style"). That's all.
You have the option of letters or numbers (Tools/Options/General "R1C1 Reference Style"). That's all.
P Paulw2k Jan 5, 2005 #3 From the menu choose Tools, Options, General, then check the "R1C1 reference style"-box
G Gord Dibben Jan 5, 2005 #4 If you mean change the A,B,C to something more meaningful such as "Name", "Address", "City" etc., you can't. You can use row 1 for your titles then select A2 or B2 if you also want column A frozen and Window>Freeze Panes. Now go to Tools>Options>View and uncheck "Row and Column Headers". Gord Dibben Excel MVP
If you mean change the A,B,C to something more meaningful such as "Name", "Address", "City" etc., you can't. You can use row 1 for your titles then select A2 or B2 if you also want column A frozen and Window>Freeze Panes. Now go to Tools>Options>View and uncheck "Row and Column Headers". Gord Dibben Excel MVP
