How to Print Labels from Excel

This guide shows you how to how to Print Labels from Excel. Instructions work for Excel and Word for Microsoft 365, 2019, 2016, and 2013. To use Excel to make sending labels, your spreadsheet must be set up right. In the first cell of each column, type a heading that describes the data in that column in a clear and brief way. Make a column for each part of the label you want to include. 

Microsoft Excel is a tool that is used in many fields to enter data and do calculations. You can use it for other things as well, such as making address labels. Companies that send mail to a lot of people can save time by making them in Excel. Excel’s “Print Label” choice is used for many different things. First, it saves users a lot of time when putting data in order and makes it easy to print data under a single label or multiple labels. Follow these steps to Print Labels from Excel.

How to print labels from Excel using Word

Importing a mailing list made in an Excel spreadsheet is one of the most popular ways to print labels from Word. You can link your worksheet to the Word Mail Merge tool and use the data, such as names, addresses, and other customer information, to print your labels. Here’s how to Print Labels from Excel. 

Set up the data in Excel

1. Open Excel.
2. Click Blank Workbook. 
3. Enter and organize your data according to categories or import data from an app. 
4. Click File > Save. 
5. Close the workbook

Use Word Mail Merge Tool to create labels in Word

1. Open MS Word. 
2. Click New Document.
3. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard.
4. Select Labels.
5. Select Starting document > Label Options. Choose your Label vendors and Product number.
6. Click OK after you have chosen your label size. 
7. Click Select recipients > Browse. Select the appropriate spreadsheet file and then OK > OK.
8. To customize your labels, click Arrange your labels > Address block and add or remove recipient information. Click OK. To replicate the first label, select Update all labels. 
9. To edit the layout of your labels, click Preview your labels.
10. Click Complete the progress. 
11. To print, click Print > OK > OK to print your labels.
12. To save, click File > Save.

How to print labels from Excel without Word

Print Labels from Excel without Work Using VBA Code

1. Open Excel.
2. Click Blank Workbook. 
3. Insert Data in Column A.
4. Press Alt + F11 to open the VBA Window. 
5. Right-click the sheet that contains your label data. 
6. Go to Insert > Module to open a module to create VBA Code for labels. 
7. Copy and paste the code. 
8. Press F5 and select Createlabels ().
9. Click Run.
10. Type 3 in Enter Number of Columns Desired. 
11. Click OK.
12. Click File > Print. 
13. Select the printer you want to use and customize the settings. 
14. Click the Print Icon. 

 Print Labels in Excel Without Word Using Page Layout

1. Open Excel.
2. Click Blank Workbook. 
3. Insert Data in Column A.
4. Click Page Layout > Margins > Custom Margins. 
5. For address labels, enter 0.5 in the Top and Bottom margin fields and 0.215 in the Left and Right margin fields. 
6. Click OK. 
7. Click File > Print.
8. Select your printer. 
9. Click No Scaling > Fit All Columns in One Page.
10. Click the Print Icon. 

When should you make an address label using Excel?

If you are sending a lot of mail to a lot of people at once, you might want to make an address label in Excel. Companies send mail to customers for many reasons, such as billing statements, ads, or reminders about future appointments. Mail merge in Excel and Microsoft Word makes it easy to make hundreds or even thousands of mailing labels in a short amount of time. With the mail merge tool, you can use the names and addresses in an Excel worksheet file to make sheets of mailing labels that you can print. If you want to know more information about this Visit Official Microsoft Excel site.