My boss has an Excel file filled with contacts and wants to know if hes able to search by properties such as state, city or zipcode. How can I do this?
Also, he wants to selectively print labels (ex: company name and address). I dont think this is possible but thought I'd ask anyway.
2007-03-15 15:53:35 · 7 answers · asked by Anonymous in Computers & Internet ➔ Software
Easy, if he was smart enough to keep city, state, zip in separate columns.
Click the table select button (to the left of A, above 1)
The whole file will be highlighted.
click Data
cl Autofilter
there will be a down arrow next to each column header
click the down arrow on the zip header
select the zipcode you want
only those records will display
when finished, click Data, cl Autofilter to turn off the filter.
As for labels:
Open a Word document
cl Tools
Mailmerge (the Mailmerge Helper box displays)
cl Create
cl Mailing labels
cl Active window
now you have to name the data file, click Get Data
cl Open data source
search for the file
in the Open Data Source window, be sure filetype is set to Excel
find the file and double-click it
now you setup the labels
click options
click the down arrow and select a label
Next, insert the fields, one by one
when finished, click o.k.
now click close, or merge
if you close, you will get the label merge document.
you can merge at any time to a document, then print
save the label merge document
You can add to the datafile and reuse the merge document indefinitely
2007-03-15 16:59:47 · answer #1 · answered by TheHumbleOne 7 · 0⤊ 0⤋
you can do this by using filters after you select the headers as well as the data itself goto the following (Data>Filter>Autofilter), or by using the search tool in excel (CTRL+F). if you are looking to automate these things then that is a completely different story.
as for the labels, i dont get exactly what you mean, but if you mean to take only certain rows of these companies, and print their names and addresses, then you would do the same as above, with filtering
2007-03-15 16:00:12 · answer #2 · answered by unknown311 2 · 0⤊ 0⤋
Well anything you can do with excel... just right click the said file and go to the properties, there you will find the information of the data that you want to know if you want to know its details... in order to arrange the properties in your own desire is that go to the tools or data of ms excel where there are programs that can help you sort your file in your desire, filtering and sorting is a great help in your problem.
2007-03-15 16:08:41 · answer #3 · answered by jun 2 · 0⤊ 0⤋
Yes, you can search an Excel file. Two possible approaches: do a Find (CTRL-F), and it will find one record at a time. Or, you can use Filters -- go to Data-->Filters.
Not sure about the address labels.
2007-03-15 15:58:31 · answer #4 · answered by kittenpie 3 · 0⤊ 0⤋
Use Ctrl F to find anything.
Use the document as a Mail Merge to print labels, envelopes ect. You do this via Word and direct to the XLS as the source for the mail merge.
2007-03-15 16:01:18 · answer #5 · answered by blndchik 5 · 0⤊ 0⤋
Excel does it all. You might want to google, excel, and it will help you along.
Other ways, Office has online help, you can always get help, while you are one the computer.
Finally, Excel has so many options, very fuctional, I think your boss is just seeing if you know what you are doing.
2007-03-15 16:02:09 · answer #6 · answered by SFC V 5 · 0⤊ 0⤋
You can do this by filter or use a lookup formula
2007-03-15 16:02:49 · answer #7 · answered by eg_303 5 · 0⤊ 0⤋