sodcalculator

10 Tech How-To

How to Make Address Labels on a Computer

Guide 10-51920 · Updated · Step by step

This guide walks you through creating and printing address labels directly from your computer using Microsoft Word, Google Docs, or a similar word processor. You’ll learn how to set up a label template, enter your addresses, and print them on standard label sheets—saving you time and money compared to handwriting or paying for printing services. No special software is required; just a computer, a printer, and label sheets (like Avery 5160 or equivalent).

What You’ll Need

  • A computer with Microsoft Word or Google Docs (both free/available in most setups).
  • A printer (inkjet or laser).
  • Label sheets—common sizes include 30 per page (1″ x 2 5/8″) or 20 per page (2″ x 4″). Check the packaging for the product number (e.g., 5160, 8160, 30 per page).
  • Your address list (can be typed manually or imported from a spreadsheet).

Step-by-Step

  1. Open a new document in Microsoft Word or Google Docs.
  2. Start a label template:
    • In Word: Go to the Mailings tab, click Labels (or Start Mail Merge > Labels). In the Envelopes and Labels dialog, click Options, choose your label brand (e.g., Avery US Letter) and product number (e.g., 5160). Click OK to load the template.
    • In Google Docs: Go to Insert > Building blocks > Mail merge (if available) or use the Extensions menu to install a label template add-on. Alternatively, search for a free label template in the template gallery and open it.
  3. Enter addresses manually: If you have only a few labels, click inside each label cell and type the address. Press Tab to move to the next label. For many labels, use mail merge to import a list.
  4. Use mail merge (for multiple addresses):
    • In Word, go to Mailings > Select Recipients > Use an Existing List (choose a CSV or Excel file) or Type a New List.
    • Click Insert Merge Field to place fields like First Name, Last Name, Address, etc. in the first label.
    • Click Update Labels to copy the layout to all other labels.
    • Click Preview Results to see actual addresses.
  5. Format the text: Highlight the label text and choose a font and size that fits (e.g., Arial 10 or 11). Keep margins small (0.2″ or less) to avoid clipping.
  6. Print a test sheet: Place a plain sheet of paper in the printer and print the document (Ctrl+P). Hold the paper up against a label sheet to ensure the text aligns with the label boundaries. Adjust margins or template if needed.
  7. Load label sheets: After the test looks good, load the actual label sheets into your printer (check the printer manual for which side faces up). Print the final document.
  8. Peel and apply: Peel each label from the sheet and apply to envelopes or packages.

Common Mistakes

  • Using the wrong template: If the label product number doesn’t match the template, text will misalign. Always verify the product number on the label package.
  • Skipping the test print: Printing directly on label sheets without a test can waste expensive sheets.
  • Incorrect printer settings: Some printers have a “labels” or “heavy paper” setting—use it to prevent smudging or jams.
  • Overlapping text: If the font is too large or margins are too wide, addresses may get cut off. Reduce font size or adjust margins.
  • Not updating all labels in mail merge: Forgetting to click Update Labels results in only the first label being filled.

Tips

  • Use a clear, sans-serif font (like Arial or Calibri) for readability.
  • Keep addresses to 3-4 lines (Name, Street, City/State/ZIP) to fit neatly.
  • For return labels, create a separate template with just your address, and print on a sheet of return-address labels (e.g., Avery 5167).
  • Save your label document as a template for future use.
  • If you’re printing many sheets, print a single sheet first, then check alignment before printing the rest.

Troubleshooting

  • Text is misaligned: Re-check the template product number. If it matches, try adjusting the top and left margins in the label setup (usually under Layout or Format). Use the test print method to fine-tune.
  • Labels are printing upside down or on the wrong side: Check your printer’s paper orientation. Most label sheets have a printable side that feels slightly rough; load accordingly. Consult the printer manual for face-up vs. face-down loading.
  • Printer jams: Ensure the label sheets are not curled or damaged. Fan the sheets before loading. Use the printer’s rear or manual feed slot if available.
  • Mail merge shows blank fields: Verify that your data source (Excel/CSV) has correct column headers matching the merge fields. Refresh the data by clicking Refresh in the Mailings tab.
  • Only the first label prints: In Word, ensure you clicked Update Labels after inserting merge fields. Also check that the document is set to print all pages, not just the current one.

Frequently Asked Questions

Can I use Google Docs to print labels without buying an add-on?

Yes, you can use a free template from the Google Docs template gallery. Search for “address labels” and choose a template that matches your label size. However, mail merge for multiple addresses may require an add-on like “Mail Merge with Attachments” (free tier available).

What is the standard address label size?

The most common is Avery 5160, which has 30 labels per sheet, each 1″ x 2 5/8″. Other popular sizes include 5167 (return labels, 80 per sheet) and 5162 (2″ x 4″, 14 per sheet). Check your label package for the exact size.

How do I print return address labels?

Create a new label template using the return label product number (e.g., 5167). Type your address in the first label, then copy it to all other labels (in Word, use Copy and Paste or Update Labels). Print on the return label sheets.

Can I print on labels using a regular printer?

Yes, any inkjet or laser printer can print on label sheets as long as the sheet size (usually US Letter 8.5″ x 11″) is supported. Check the printer manual for recommended paper types.

Why are my labels peeling off after printing?

This usually happens if the printer’s fuser (in laser printers) is too hot or if the label adhesive is poor. Use labels designed for laser printers if you have a laser printer. Also, allow the labels to cool before peeling.

How do I save a label template for future use?

After setting up your labels, go to File > Save As and choose Word Template (*.dotx) in Word, or in Google Docs, go to File > Make a copy and rename it. This way you can reuse it without re-entering formatting.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →