Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
New to Excel - I want to add a few columns across (P and Q)...How? | New Users to Excel | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
I have Excel columns with different statements (yes, no; numbers). | Excel Worksheet Functions |