excel- change column name from "A, B, etc" to "First Name, etc"

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

Guest

How do I change the default column name from A, B, C, etc to the date I'm
entering- First Name, Last Name, Address, etc?
 
You can change these column headings to letters or numbers or hide them
completely.

But I'd just put the field headers in row 1 and use the rest for data. You can
freeze that row so that it's always visible:

Select A1 (just to make sure it's visible)
select B1
window|freeze panes

And remember that most users of excel are pretty familiar with the
interface--they expect to see those header letters (or numbers).

And new users will become more acquainted with excel by using your workbook.
 
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

Importing data from Excel worksheet into Excel template 2
Naming columns in excel (Name, Address, Phone, etc) 1
Matching Names 5
naming a column 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Formula To Split Name 5
Having Blank Cells, etc. ? 1
how do I change the default name of a column from numbers to lett. 4

Back
Top