Set up your spreadsheet before you start printing

Excel can print address labels if your data is organized in columns that match the label template you're using. Before you do anything else, arrange your spreadsheet so each part of the address is in its own column: first name in column A, last name in column B, street address in column C, city in column D, state in column E, and zip code in column F. If your addresses are already in one cell per person (like "John Smith, 123 Main St, Springfield, IL 62701"), you'll need to split them into separate columns first using Excel's "Text to Columns" feature under the Data menu.

Check that you have no blank rows in the middle of your data. Excel's mail merge feature, which is what you'll use to print labels, stops reading when it hits an empty row. If you have 50 addresses with a blank row at position 25, it will only see the first 24. Delete any blank rows, then save your file.

Key Takeaways

  • Your address data must be in separate columns (first name, last name, street, city, state, zip) with no blank rows between entries.
  • You'll use Word's mail merge feature, not Excel itself, to actually print the labels—Excel just holds the data.
  • Avery label templates are the most common and work with both Word and Excel; you need the exact product number (like 5160 for standard address labels).
  • Test your merge on a single sheet of regular paper before printing on expensive label stock.

Use Word's mail merge to connect Excel data to label templates

Excel doesn't have a built-in label printing feature, but Microsoft Word does—and Word can read data directly from your Excel file. Open a new document in Word. Go to the Mailings tab, then click "Start Mail Merge" and select "Labels." A dialog box will ask you to choose a label vendor and product number. Avery is the most widely available brand; if you're using Avery 5160 labels (the standard white address labels), select that from the list. If you have a different brand or size, find the product number on your label box and search for it in the dialog.

After you choose your label template, Word will create a sheet with placeholder boxes matching your label layout. Now you need to tell Word where your address data lives. Click "Select Recipients" and choose "Use an Existing List." Navigate to your Excel file and open it. Word will ask which sheet contains your data—select the correct one. Then it will show you a preview of the addresses it found. If the preview looks wrong, go back and fix your Excel columns before continuing.

Insert merge fields to match your label layout

Word now shows you a blank label template. You need to tell it which Excel column goes where on the label. Click in the first label box and position your cursor where you want the name to appear. Go to Mailings, click "Insert Merge Field," and select the column that contains first names. Type a space, then insert the last name field. Press Enter to move to the next line, then insert the street address field. Continue until you've placed all the fields you need in the order they should appear on the label.

The most common layout is: first name and last name on the first line, street address on the second line, and city, state, and zip on the third line. After you've placed all the fields in the first label, click "Update Labels" in the Mailings tab. Word will automatically copy this layout to every label on the sheet.

Preview your labels before printing

Click "Preview Results" in the Mailings tab to see what your actual addresses will look like on the labels. Scroll through several to make sure the names, streets, and cities all appear correctly and fit within the label boundaries. If text is cut off or positioned wrong, go back and adjust the merge fields or the spacing between them.

If you notice that some addresses are missing or in the wrong order, go back to your Excel file, check for blank rows or misaligned columns, and save the changes. Then close and reopen your Word document to reload the data.

Print a test sheet on regular paper first

Before you print on actual label stock, print one sheet on regular white paper. This costs nothing and catches mistakes that are expensive to fix on labels. Go to File, Print, and print just one page. Hold it up to a sheet of blank labels and check that the addresses are positioned correctly within each label box. If the text is too close to the edge or slightly off-center, you can adjust the margins or field positions in Word before printing the real labels.

Once the test sheet looks right, load your label stock into the printer. Most label sheets feed the same way as regular paper, but check your printer manual if you're unsure. Print your full batch, starting with a small number (5 or 10 sheets) in case there's a printer-specific issue you didn't catch in the test.

Troubleshoot common printing problems

If Word says it can't find your Excel file, make sure the file is closed in Excel before you try to merge. Word sometimes has trouble reading files that are open elsewhere. Save your Excel file, close it completely, then try the merge again.

If some addresses appear on the wrong labels or labels are blank, check your Excel data for extra spaces before or after names and addresses. These invisible spaces can confuse the merge. Use Find and Replace (Ctrl+H) to search for " " (space, space) and replace it with a single space throughout the sheet. Also verify that every row has data in all the columns you're using—even a missing zip code can throw off the alignment.

If text is printing too small or too large, you can adjust the font size in Word before merging. Select all the merge fields in the first label, change the font size, then click "Update Labels" to explore it to the whole sheet.

Frequently Asked Questions

Can I print labels from Excel without using Word?

Not directly. Excel doesn't have a mail merge or label printing feature. You must use Word as the middle step. However, some third-party label software (like Avery Design Pro) can read Excel files directly, though these programs often cost money or require a subscription.

What if my addresses are all in one cell per row?

Use Excel's "Text to Columns" feature to split them. Select the column with all your addresses, go to the Data menu, click "Text to Columns," choose "Delimited," and tell Excel what character separates each part (usually a comma). This will split one cell into multiple columns so Word can read them separately.

Do I have to use Avery labels?

No, but Avery is easiest because Word has built-in templates for most Avery products. If you use a different brand, find the product number on your label box and search for it in Word's label template dialog. Many brands use the same dimensions as Avery, so you may find a match. If not, you can manually set the label size by measuring the width, height, and margins of your label sheet.

Can I print different addresses on different label sizes?

Yes, but you need separate Word documents for each size. Create one merge document for your standard labels and another for any oversized or specialty labels. Keep your Excel file the same—just create a new Word template for each label product you want to use.

What happens if I have fewer addresses than labels on a sheet?

Word will print only the labels that have data. If you have 15 addresses and a sheet holds 30 labels, you'll get one sheet with 15 filled labels and 15 blank ones. You can reuse the blank labels or trim and save them for later.