Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to format and print labels from an excel file
I have an excel list of people with 12 cells of information. I want to
format and print "name tags" (labels?) using only the information in four cells. How can I do this? |
#2
|
|||
|
|||
You can print labels in Excel but formatting can be a problem.
Best to use Word for the mailmerge operation and select the 4 labels to print during the setup in Word. For help on Word mail merge using Excel as the data source. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm And a training tutorial for creating envelopes and labels. http://office.microsoft.com/training...RC010390291033 Gord Dibben Excel MVP On Tue, 12 Apr 2005 09:46:03 -0700, DDAANN wrote: I have an excel list of people with 12 cells of information. I want to format and print "name tags" (labels?) using only the information in four cells. How can I do this? |
#3
|
|||
|
|||
If you have Word, it is easier to do a tools/mail merge from there using
excel as the data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving print area as file | Excel Discussion (Misc queries) | |||
How do I automatically format subtotals in excel? | Excel Worksheet Functions | |||
How do you disable save file dialog? | Setting up and Configuration of Excel | |||
How to print invoices for each advertiser from Excel worksheet | Excel Worksheet Functions | |||
print 1 long row(20 columns) in excel to one single page | Excel Worksheet Functions |