 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / March 2007Name columns
How do I name columns so instead of column A I have 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)  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > How do I name columns so instead of column A I have Date? > 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 >> How do I name columns so instead of column A I have Date? > [quoted text clipped - 10 lines] > 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. Formulas tab, Defined Names chunk, Define Name SignatureKind regards, Niek Otten Microsoft MVP - Excel | >> How do I name columns so instead of column A I have Date? | > [quoted text clipped - 16 lines] | Under Insert there is no Name or define. Been poking around but have not | figured it out. > Formulas tab, Defined Names chunk, Define Name ============ 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. 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 > > How do I name columns so instead of column A I have Date? > [quoted text clipped - 10 lines] > Hope that got it for ya > Mark 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 > How do I name columns so instead of column A I have Date? > az-willie > [quoted text clipped - 8 lines] > >> How do I name columns so instead of column A I have Date? =============== 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 :) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.