Thread: Name columns
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.setup
Angie Angie is offline
external usenet poster
 
Posts: 79
Default Name columns

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

"Mark" wrote:

On Feb 10, 11:12 am, az-willie 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