Label printing guides
Short, practical guides to printing labels from Excel, Google Sheets and Word, with the sheet codes you'll find on the box.
Alternatives to Avery Design & Print Online
Avery Design & Print Online is free. Compare it with Word mail merge, Google Docs add-ons, blank templates and LabelPeel, and fix common problems.
How to Print Labels on Mac: 3 Easy Ways
How to print labels on a Mac from Contacts, Word or Numbers. Covers the Mailing Labels style, Avery® sheets, 100% scale and pasting a list into LabelPeel.
Labels Not Lining Up? How to Fix Print Alignment
Labels not lining up? Fix print scaling, paper size, the wrong template and printer feed, then test on plain paper. Also print a single label.
Laser vs Inkjet Labels: Which to Buy and How to Print
Laser printer labels vs inkjet labels: how they differ, how to read the Avery® box, print settings to check, and why you should not reuse a laser sheet.
Mail Merge in Google Docs: How to Make Labels
Google Docs has no mail merge for label sheets. See what Gmail mail merge offers, then four ways to turn a spreadsheet list into printed labels.
Print Labels From Google Contacts or Outlook
Print labels from Google Contacts, Outlook or iPhone contacts. Export a CSV, tidy the columns, drop people with no address, then paste into LabelPeel.
Avery 5160 vs 8160: What's the Difference?
Avery 5160 vs 8160: both sheets have the same 1 by 2⅝ inch labels, 30 per sheet. 5160 is for laser printers, 8160 for inkjet. Here is how to choose.
Avery Label Sizes Chart: Every Common Size
Avery label sizes chart for US Letter and A4 sheets: labels per sheet, size and best use. Find your code, measure a label and pick the right sheet.
Christmas Card Address Labels: Print Your Whole List at Home
Print Christmas card address labels at home in minutes. Tidy your list, pick a sheet, add festive design and return labels, then test before you print.
How to Address Wedding Invitations: Etiquette and Labels
How to address wedding invitations: outer and inner envelopes, couples, families and plus-ones, plus printing options and a guest list setup.
How to Make Labels in Google Docs (Step by Step)
Google Docs has no label maker. Learn to build a label table the same size as your Avery sheet, print a test at 100%, then fill in every cell.
How to Make Name Tags From a Spreadsheet
Make name tags from an attendee list in a spreadsheet. Pick Avery 5395 badge sheets, set first names large and print a test before you run the whole list.
How to Print Address Labels at Home (4 Easy Ways)
Print address labels in Word, the Mac Contacts app or LabelPeel. Covers address layout, return labels, which Avery® sheet to buy and printing fixes.
How to Print Labels From Excel (3 Easy Ways)
Three ways to print labels from an Excel list: Word mail merge, Avery® Design & Print, or pasting the rows into LabelPeel. Steps for each and fixes.
How to Print Labels From Google Sheets
Print labels from a Google Sheets list in three ways: paste it into a label tool, export it to Excel for a mail merge, or build a table in Docs.
How to Print Labels in Word (Step by Step)
How to print labels in Word: pick your Avery® product number, print one label across a full sheet, print a single label, and fix alignment step by step.
Mail Merge Labels From Excel to Word, Step by Step
How to mail merge labels from Excel to Word: prepare the columns, connect the list, insert the address, preview and print. Fixes for ZIP codes and blanks.