Print Mailing Labels

How to print address labels

1. Paste your addresses with a blank line between each one, one address per line, or the address columns copied from Excel or Google Sheets. You can also open a .txt or .csv file with File.
2. Choose your label sheet under Labels; the number is on the label package.
3. Press Make labels and check the preview.
4. Press Print labels. In the print window choose Scale: 100% (not “Fit to page”) and Margins: Default or None.

Print one page on plain paper first and hold it up against a sheet of labels to the light: if the addresses sit inside the labels, load the label sheets. Tick Draw label outlines to make that test easier, and untick it for the real thing.

Labels from Excel or Google Sheets, without a mail merge

Select the columns with the addresses, including the heading row, copy, and paste them here. Headings like Name, First Name, Last Name, Company, Address, Address 2, City, State, ZIP and Country are understood, and each label is put together in the usual order: name, company, street, “City, ST ZIP”. Other columns, such as email or phone, are left off; the summary above the preview says which. Without a heading row, each cell becomes a line and City, State and ZIP share one.

Label sheets

Other brands sold as “compatible with Avery 5160” (or another number) have the same layout, so choose that number. All of these are US Letter sheets. On A4 paper? Seven A4 sheets, from 8 to 65 labels, are in the Labels menu too: see the Avery L7160 template.

Options

• Addresses: leave them as typed, use the USPS abbreviations (Street → St, Apartment → Apt), or spell the abbreviations out (St → Street, IL → Illinois), as wedding and formal invitations usually are. Names are never changed.
• ALL CAPS, no punctuation: the style the Postal Service prefers for bulk mail.
• Start at label: reuse a sheet that’s partly used. Count across, then down: on a 5160 sheet, label 4 is the first one on the second row.
• Copies of each and Fill the last sheet: for several labels per address, or a full sheet of one.
• Text centered or on the left. Text that’s too long for a label is made smaller until it fits; any label it still won’t fit is shaded in the preview.

Need the list in order first? Sort addresses by last name, or remove duplicates so nobody gets two cards.

Copied from a spreadsheet, with a heading row

First Name	Last Name	Address	City	State	ZIP
Amy	Smith	12 Main Street	Springfield	IL	62701
Bob	Jones	4 Elm Ave Apt 2	Salem	OR	97301

Amy Smith
12 Main Street
Springfield, IL 62701

Bob Jones
4 Elm Ave Apt 2
Salem, OR 97301

Try this example

One address per line

Ann Lee, 9 Elm Street, Salem, OR 97301
The Jones Family, 4 Oak Road, Austin, TX 78701

Ann Lee
9 Elm Street
Salem, OR 97301

The Jones Family
4 Oak Road
Austin, TX 78701

Try this example

Wedding invitations, with the words spelled out

Mr. and Mrs. Tom Smith
12 Main St. Apt 4
Springfield, IL 62701

Dr. Ann Baker
40 N. Elm Ave.
Shelbyville, IL 62565

Mr. and Mrs. Tom Smith
12 Main Street Apartment 4
Springfield, Illinois 62701

Dr. Ann Baker
40 North Elm Avenue
Shelbyville, Illinois 62565

Try this example