How do I change the colum headings?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to change the preset colum headings (A,B,C.....) to something
different.....How do i do that?
 
You have the option of letters or numbers (Tools/Options/General "R1C1
Reference Style"). That's all.
 
From the menu choose

Tools, Options, General,

then check the "R1C1 reference style"-box
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Jululian 2
how do I change column heading in excel (2007) 5
Character Index 1
Help for the formula 9
Excel 2000 Formula or Macro 7
Heading on each page 1
how do I sort data excluidng headings? 2
in excel where it says a b c d on top how to shrink that 1

Back
Top