How to Print Labels from Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office 662 662 people found this article helpful

How to Print Labels From Excel

Make labels in Excel in a snap

By Tricia Goss Tricia Goss Writer Pima College Tricia Goss has been a writer and editor for 10+ years. She's written tips and tutorials for Microsoft Office applications and other sites. lifewire's editorial guidelines Updated on April 5, 2022 Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook

What to Know

Prepare your worksheet, set up labels in Microsoft Word, then connect the worksheet to the labels.Open a blank Word document > go to Mailings > Start Mail Merge > Labels. Choose brand and product number.Add mail merge fields: In Word, go to Mailings > in Write & Insert Fields, go to Address Block and add fields. This guide explains how to create and print labels from Excel using the mail merge feature in Microsoft Word. Instructions apply to Excel and Word 2019, 2016, and 2013 and Excel and Word for Microsoft 365.

How to Print Labels From Excel

You can print mailing labels from Excel in a matter of minutes using the mail merge feature in Word. With neat columns and rows, sorting abilities, and data entry features, Excel might be the perfect application for entering and storing information like contact lists. Once you have created a detailed list, you can use it with other Microsoft 365 applications for numerous tasks. Ellen Lindner / Lifewire

Prepare the Worksheet and Enter the Data

To make mailing labels from Excel, you need to add descriptive column headings so everything prints out correctly. For example, you might have the following column headings: Title (Mr./Ms./Dr.)First NameLast NameStreet AddressCityStateZIP Code Type in a heading in the first cell of each column describing the data. Make a column for each element you want to include on the labels. Lifewire Type the names and addresses or other data you're planning to print on labels. Make sure each item is in the correct column. Avoid leaving blank columns or rows within the list. Lifewire Save the worksheet when you have finished.

Set Up Labels in Word

Next, you need to choose the size and type of the labels you're printing. Open a blank Word document. Go to the Mailings tab. Choose Start Mail Merge > Labels. Choose the brand in the Label Vendors box and then choose the product number, which is listed on the label package. You can also select New Label if you want to enter custom label dimensions. Click OK when you are ready to proceed.

Connect the Worksheet to the Labels

Before performing the merge to print address labels from Excel, you must connect the Word document to the worksheet containing your list. The first time you connect to an Excel worksheet from Word, you must enable a setting that allows you to convert files between the two programs. In Word, click File. Scroll down, and select Options at the bottom of the left pane. Click Advanced in the left pane of the Word Options window and then scroll down to the General section. Make sure the Confirm file format conversion on open is selected and click OK. From Mailings, in the Start Mail Merge group, choose Select Recipients > Use an Existing List. Navigate to the Excel worksheet containing your list in the Select Data Source window that opens and click Open. Click OK to confirm that you want to use the list and click OK again to select the table containing your list. The page will now be filled with labels that say «Next Record».

Add Mail Merge Fields and Perform the Merge

After you've organized the data, you need to add mail merge fields before you can complete the merge. This is where those headings you added to your Excel worksheet will come in handy. Click on the first label on the page and then select Address Block in the Write & Insert Fields section of the Mailings tab. Click the Match Fields button on the Insert Address Block dialog box that appears. Make sure your headings correspond with the required fields. If any of them are incorrect, use the drop-down arrow beside it to match up to the correct field. Click OK. Click OK again to close the dialog box. Select Mailings > Write & Insert Fields > Update Labels. Once you have the Excel spreadsheet and the Word document set up, you can merge the information and print your labels. Click Finish & Merge in the Finish group on the Mailings tab. Click Edit Individual Documents to preview how your printed labels will appear. Select All > OK. A new document opens with the mailing labels from your Excel worksheet. You can edit, print, and save the labels just as you would any other Word document. FAQ How do I label an axis in Excel? To label chart axes in Excel, select a blank area of the chart, then select the Plus (+) in the upper-right. Check the Axis title box, select the right arrow beside it, then choose an axis to label. How do I label a legend in Excel? To label legends in Excel, select a blank area of the chart. In the upper-right, select the Plus (+) > check the Legend checkbox. Then, select the cell containing the legend and enter a new name.
How do I label a series in Excel? To label a series in Excel, right-click the chart with data series > Select Data. Under Legend Entries (Series), select the data series, then select Edit. In the Series name field, enter a name.
How do I apply label filters in Excel? To apply filters to a pivot table in Excel, select the Column Labels down-arrow to open the filter's drop-down list, uncheck Select All, then choose your desired filters. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Create Mail Merge Letters in Word How to Embed Excel Files in Word Documents How to Create a Report in Excel How to Combine Two Columns in Excel How to Limit Rows and Columns in an Excel Worksheet How to Set Print Area in Excel How to Merge and Unmerge Cells in Excel How to Make a Schedule in Excel Excel SUMIFS: Sum Only Values Meeting Multiple Criteria How to Export Data to Excel What Is Mail Merge in Word? Perform a Microsoft Word Mail Merge From Within Excel Splitting the Screen in Excel How to Use the MONTH Formula in Excel How to Password Protect an Excel File How to Turn a PDF into a Word Document Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies