How to Create Labels Microsoft Excel

‍

‍

Here's how to do it:

‍

1. Start a new Word file and navigate to the Mailings tab.
2. Click Start Mail Merge > Labels.
3. Select the label type based on the brand and product number printed on your label sheet, then click OK.
4. Click Select Recipients > Use an Existing List.
5. Locate your Excel file, and ensure the data is on the first sheet.
6. Use Insert Merge Field to add fields like First Name, Last Name, Address, and City to the label template, ensuring proper spacing between fields.
7. Click Update Labels to apply the format to all labels.
8. Select Finish & Merge > Edit Individual Documents to preview and edit the labels.
9. Specify the number of labels you want to print (e.g., 1–10) and click OK to print your labels.