How do I name columns in Excel?
 

Have I gotten stupid in my old age? I used to know how (or be able to) name
columns in Excel and have the rows start numbering themselves below the
headings. Is this option no longer available, and if so, how do I do it?
This is NOT for a database project; it's just a short list of things I need
listed. Please do not suggest that I use Access.

The only way to create Column Names in Excel is to type them into a Row. Row
one is a good candidate a lot of the time.
If you want Numbering to happen starting with 1, you'll have to type the
number manually, or use a formula.
Enter this into A2, for example:
=IF(B2=<"",COUNTA($B$2:B2),""))
and copy down as far as necessary to number items sequentially as you type
them.
Anytime you type something into Column B, a number will appear in Column A.

tj


"Naming Excel Columns" wrote:

Have I gotten stupid in my old age? I used to know how (or be able to) name
columns in Excel and have the rows start numbering themselves below the
headings. Is this option no longer available, and if so, how do I do it?
This is NOT for a database project; it's just a short list of things I need
listed. Please do not suggest that I use Access.

TJ

I think that should be:

=IF(B2<"",COUNTA($B$2:B2),"")

Another option might be:

=IF(B2<"",ROW()-1,"")

Regards

Trevor


"tjtjjtjt" wrote in message
...
The only way to create Column Names in Excel is to type them into a Row.
Row
one is a good candidate a lot of the time.
If you want Numbering to happen starting with 1, you'll have to type the
number manually, or use a formula.
Enter this into A2, for example:
=IF(B2=<"",COUNTA($B$2:B2),""))
and copy down as far as necessary to number items sequentially as you type
them.
Anytime you type something into Column B, a number will appear in Column
A.

tj


"Naming Excel Columns" wrote:

Have I gotten stupid in my old age? I used to know how (or be able to)
name
columns in Excel and have the rows start numbering themselves below the
headings. Is this option no longer available, and if so, how do I do it?
This is NOT for a database project; it's just a short list of things I
need
listed. Please do not suggest that I use Access.