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.
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.