Name columns

  • Thread starter Thread starter az-willie
  • Start date Start date
You can't. The usual way is to use a col header, eg input: Date into say,
A1 (as the name of the col)
 
How do I name columns so instead of column A I have Date?
Click to expand...

Select the following:
Insert--->Name--->Define

Enter the name "Date" in the top text box
Click inside the textbox at the bottom under the words:"Refers To"
Now select column A by clicking on it. There should be something like
the following in the textbox now ---> =Expenses!$A:$A

Your sheet name will be different of course.

Hope that got it for ya
Mark
 
Mark said:
Select the following:
Insert--->Name--->Define

Enter the name "Date" in the top text box
Click inside the textbox at the bottom under the words:"Refers To"
Now select column A by clicking on it. There should be something like
the following in the textbox now ---> =Expenses!$A:$A

Your sheet name will be different of course.

Hope that got it for ya
Mark
Click to expand...
=================
I forgot to mention this is in Excel 2007.

Under Insert there is no Name or define. Been poking around but have not
figured it out.
 
Formulas tab, Defined Names chunk, Define Name

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Mark wrote:
| >> How do I name columns so instead of column A I have Date?
| >
| > Select the following:
| > Insert--->Name--->Define
| >
| > Enter the name "Date" in the top text box
| > Click inside the textbox at the bottom under the words:"Refers To"
| > Now select column A by clicking on it. There should be something like
| > the following in the textbox now ---> =Expenses!$A:$A
| >
| > Your sheet name will be different of course.
| >
| > Hope that got it for ya
| > Mark
| >
| =================
| I forgot to mention this is in Excel 2007.
|
| Under Insert there is no Name or define. Been poking around but have not
| figured it out.
 
Niek said:
Formulas tab, Defined Names chunk, Define Name
Click to expand...
============
Ummm, just tried that --- it puts the name in the box to the left but
does not change the label at the top of the column and when I look at
Print Preview it is still column A etc. etc.

I must be doing something wrong.
 
az-willie

I don't know 07 but I can't see why this would not work. Here is what I do:
IN A1 put "Date" (No quotes) the in B1 put "Name" (or whatever) and fill your
proposed column headers across. Then I Hide the Column and Row headers. If
you need the row numbers move everything to the right and use column "A" to
place the Row numbers. I have learned to be careful when editing my formulas
when I can't see column and row headers.

Mike Rogers
 
Mike said:
az-willie

I don't know 07 but I can't see why this would not work. Here is what I do:
IN A1 put "Date" (No quotes) the in B1 put "Name" (or whatever) and fill your
proposed column headers across. Then I Hide the Column and Row headers. If
you need the row numbers move everything to the right and use column "A" to
place the Row numbers. I have learned to be careful when editing my formulas
when I can't see column and row headers.

Mike Rogers
Click to expand...
===============
Thank you, I didn't know you could hide the row and column headings.
This enables me to make a printout without the A B C at the top of the
columns and with the proper name on them.

Now if I can just remember this the next time I want to do that :)
 
This was really helpful. Now, if i were to export this to Access, I would
have my columns defined so that i can tell the columns apart, correct?

angie
 
Back
Top