how do you change column headings in excel?

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

Guest

how do i change the column headings from A, B, C etc to what i want them to
be eg, Name, Address etc
 
You can't, you can remove them and use the first row and column to create
your own, to remove the built in do tools>options>view and uncheck row &
column headers


Regards,

Peo Sjoblom
 
thick

You can't change these.

You can however, enter your titles in Row 1 then freeze row 1 so's it remains
in view.

Select A2 and Window>Freeze Panes.

If you also want Column A frozen, select B2 instead of A2.

Column and Row headers can be hidden by Tools>Options>View. 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

Changing Column Titles in Excel 2
Column headings - urgent help needed please 3
Having Blank Cells, etc. ? 1
Column headings 2
column headings 3
How Do I Put in My Own Text into Column Headings 3
What causes column headings in Excel to change from A, B, to 1,2? 1
METRO 2039 Revealed 0

Back
Top