ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I make labels from an Excel spreadsheet?? (https://www.excelbanter.com/excel-worksheet-functions/152764-how-do-i-make-labels-excel-spreadsheet.html)

Jill

How do I make labels from an Excel spreadsheet??
 
.....before I throw my computer out the window!! the trouble shooter doesn't
seem to have any instructions for how to do it.

Any help will be greatly appreciated.

Bernard Liengme

How do I make labels from an Excel spreadsheet??
 
You don't! You use the Excel Data to make labels in Word
If you have Microsoft Office then you would use Microsoft Word to
do the printing with Excel as the database.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

If your data is all in one column then you would first have to prepare you
Excel data so that each recipient is on one row.
http://www.mvps.org/dmcritchie/excel/snakecol.htm
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"jill" wrote in message
...
....before I throw my computer out the window!! the trouble shooter
doesn't
seem to have any instructions for how to do it.

Any help will be greatly appreciated.




Don Guillett

How do I make labels from an Excel spreadsheet??
 

You don't give ANY detail but you may try google for
mailing labels:excel
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jill" wrote in message
...
....before I throw my computer out the window!! the trouble shooter
doesn't
seem to have any instructions for how to do it.

Any help will be greatly appreciated.



John Bundy

How do I make labels from an Excel spreadsheet??
 
Excel doesn't do this, but you can search here for mail merge with word and
that will get it done. Actually check the Word boards for how to mail merge
with excel.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"jill" wrote:

....before I throw my computer out the window!! the trouble shooter doesn't
seem to have any instructions for how to do it.

Any help will be greatly appreciated.



All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com