✦Template Printable Ideas Insights

How to Print Address Labels from Excel

By

Need to print address labels from Excel but not sure how? You're in the right place. Excel offers a quick and efficient solution, and we're here to guide you through the entire process. Let's dive right in!

Before we begin, ensure you have Microsoft Word installed on your computer, as you'll need it to create and print the labels. Once you've checked that, let's proceed with formatting your Excel sheet for address labels.

Formatting Your Excel Sheet for Address Labels

Firstly, ensure your address data is in a single column with each address separated by a new row. This makes the process simpler and prevents mixing up addresses.

an image of a screen shot of the excel spreadsheet
an image of a screen shot of the excel spreadsheet
How to Create Address Labels in Microsoft Word from an Excel File (PC & Mac)
How to Create Address Labels in Microsoft Word from an Excel File (PC & Mac)
Excel help & learning
Excel help & learning

Secondly, let's set up the column width to accommodate your addresses properly. Follow these steps:

Adjusting Column Width

1. Select the entire column containing your addresses (Click the column header).

Address Label Template | Free Word Templates
Address Label Template | Free Word Templates
How to mail merge and print labels from Excel to Word
How to mail merge and print labels from Excel to Word
How to Make Address Address Labels with Mail Merge using Excel and Word
How to Make Address Address Labels with Mail Merge using Excel and Word

2. Right-click and choose 'Column Width'. Enter a suitable width (e.g., 70) that fits your longest address.

Applying Merge and Center forBetter Formatting

To display addresses properly, merge duplicate cells and center your data.

1. Select the range containing your addresses.

Excel help & learning
Excel help & learning
Use Excel's Power to Print Labels in No Time
Use Excel's Power to Print Labels in No Time
Creating Labels from a list in Excel
Creating Labels from a list in Excel
Make Your Own Christmas Address Labels...Picture Tutorial
Make Your Own Christmas Address Labels...Picture Tutorial
Excel - 30 Labels per Page (you supply addresses)
Excel - 30 Labels per Page (you supply addresses)
How to Create Address Mailing Labels in Microsoft Word 2007 Using Excel Data
How to Create Address Mailing Labels in Microsoft Word 2007 Using Excel Data

2. Click 'Merge & Center' in the 'Home' tab (or press 'Alt + H, C').

Creating Labels Using Microsoft Word

Now that your addresses are formatted, let's create labels using Word's built-in label feature.

Before proceeding, ensure you have Avery 5160 or 5161 label templates. These support common label sizes and types.

White Address Labels A4 Template
White Address Labels A4 Template
Address or Gift Label Tutorial...
Address or Gift Label Tutorial...
How to Make Address Address Labels with Mail Merge using Excel and Word
How to Make Address Address Labels with Mail Merge using Excel and Word

Preparing Word for Address Labels

1. Open Word and go to 'Mailings' > 'Labels'.

2. Select 'Avery US Letter' or your specific label template.

Adding Your Excel Addresses to Labels

1. Click inside the label field, then in Excel, copy your formatted addresses.

2. In Word, right-click and choose 'Paste'. Ensure the addresses fit within each label.

Printing Your Address Labels

1. If your labels look good, go to 'File' > 'Print' (or press 'Ctrl + P').

2. Choose your printer and select the right label print option (usually 'Printing options' or 'Printer Properties').

Congratulations! You've successfully printed address labels from Excel. Now you're ready to use them for postcards, envelopes, or gifts. Happy printing!