how do you create labels from an excel spreadsheet

Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

In the popped out Insert Address Block dialog box, select the desired options, check the result under the Preview section, see screenshot: And then, go on clicking Address Block under the Mailings tab, see screenshot:ĩ. Make sure the cursor is on the upper-right corner of the document. Then, click OK to close the dialog box, and the Word document will look like the screenshot below:Ĩ. And in the following Select Table dialog box, select the sheet containing the mailing list, see screenshot:ħ. In the opened Select Data Source window, choose the Excel file you saved earlier, and click Open button, see screenshot:Ħ. Next, please click Mailings > Select Recipients > Use an Existing List, see screenshot:ĥ. Then, click OK button to close the dialog box.

(In this example, I will choose Microsoft and 1/4 Letter separately.)Ĥ.

Product number: Select product number listed on the package of label sheets.

Label information: Choose supplier of label sheets.

In the opened Label Options dialog box, set the Label information and Product number as you need: Save and close the workbook, then launch a Word document, and click Mailings > Start Mail Merge > Labels, see screenshot:ģ. Prepare the data information of your printing mailing labels, such as First name, Last name, Address, City, State, Zip Code as below screenshot shown:Ģ. In this case, the Mail Merge feature in Word document can help you to create the labels from Excel and then print or save them as you need.Ĭreate and print labels in Word from an Excel worksheet with Mail Merge featureġ. Each row in the worksheet needs to be transferred onto one label as below screenshots shown. Normally, we can organize a mailing list in Excel quickly and easily, but it’s not so convenient when it comes to printing the labels.

How to create and print labels in Word from an Excel worksheet？

How do you create labels from an excel spreadsheet