Label printing guides

How to get a list onto a sheet of labels, from whichever program the list lives in, and how to fix it when the labels come out wrong.

Address labels from Excel US address layout, ZIP codes that keep their zeros, long lists and part-used sheets. Mail merge labels from Excel The Word mail merge, step by step on Windows and Mac, and the fixes for when it goes wrong. Labels not lining up Why printed labels drift off their cuts, and how to find and fix the cause. Labels from Google Sheets Copy, paste, print. No add-on and no access to your Drive. Labels on a Mac Excel for Mac, Numbers and Pages, and what differs from Windows. Christmas card address labels A holiday card list turned into labels, with a list template you can reuse every year.

Tools for particular labels

The same tool, with the layout and sheet already chosen for the job.

Labels from Excel Any list, any Avery sheet. The starting point. Return address labels Type your address once and fill a whole sheet. Name tags A guest list onto badge labels, name large and bold. Barcode labels Code 128 from a column, drawn as sharp vector bars. QR code labels A QR code on every label, with text beside it. Amazon FNSKU labels FBA product labels on 30-up sheets or rolls. Thermal printer labels Zebra, Rollo and DYMO rolls, one label per page. Barcode calibration sheet Find the narrowest bars your printer can manage.

Templates

Exact measurements and a blank PDF for every label sheet, including the values to type into Word’s Label Options.

Browse label templates →