Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cutting and pasting from rows into columns and visa versa. | New Users to Excel | |||
Need a macro to hide certain columns | Excel Discussion (Misc queries) | |||
Selecting different multiple columns | Excel Worksheet Functions | |||
adding three consecutive columns | Excel Worksheet Functions | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |