Part of Avery labels. The sizes and the other how-tos for that printer start on that page.

← Avery labels

Test print one Avery 5160 address sheet label

Published: · 3 min read · How-to
Open it and print: this Avery 5160 address sheet. No signup.

You can print test print one Avery 5160 address sheet label in the browser. Open the Avery 5160 address sheet template. It is already 8.5 x 11 in. Change the words, or load a list, and print. No signup.

Good to know: Print from this computer on any inkjet or laser that prints US Letter. In the print box, pick US Letter and leave scaling off so the words stay on the labels. A spreadsheet here prints one label per row. This sheet is the letter page you edit. Excel does not drop a different address into every cell by itself.

How to print test print one Avery 5160 address sheet label

Print one before you print 36. Open Avery 5160 address sheet, put a long name on it, and choose Print this. That is only the label on screen.

If the city or the price is cut off, make the type smaller or drop a line. Then check the rows and print the rest. Print from this computer on any inkjet or laser that prints US Letter. In the print box, pick US Letter and leave scaling off so the words stay on the labels. A spreadsheet here prints one label per row. This sheet is the letter page you edit. Excel does not drop a different address into every cell by itself.

  1. Open https://app.mylabelmaker.com/?template=avery-5160-sheet. No signup.
  2. The label is already 8.5 x 11 in. Change the line that should differ, or click your column names onto it.
  3. If you have a list, like Asha's 36 with Name, Street, and City, upload Excel or CSV, or paste a published Google Sheet.
  4. Check the rows you want. Print this is the label on screen. Print is the checked rows.
  5. Print from this computer on any inkjet or laser that prints US Letter. In the print box, pick US Letter and leave scaling off so the words stay on the labels. A spreadsheet here prints one label per row. This sheet is the letter page you edit. Excel does not drop a different address into every cell by itself.

This template is the whole letter page (Thirty address labels on one US Letter page, in the 5160 positions). If you put a column on one spot, each row prints a page where that spot changes. The other spots stay as you designed them. A list does not fill every cell with a different row. If you want one address per row, open the single 5160 label instead of filling this page from the sheet.

The other Avery sizes are on the Avery labels page. Open the number that matches the box in your hand. Check a short name and a long one, like Noah Ellis, 14 Pine Ave, Boise, before you print the rest of the 36.

Questions people ask

How do I print test print one Avery 5160 address sheet label?

Open the Avery 5160 address sheet template (8.5 x 11 in). Edit it or load your list, and print. No signup. Print from this computer on any inkjet or laser that prints US Letter. In the print box, pick US Letter and leave scaling off so the words stay on the labels. A spreadsheet here prints one label per row. This sheet is the letter page you edit. Excel does not drop a different address into every cell by itself.

Do I need an account?

No. Open the label, edit it, and print. You do not pay to download it. A published Google Sheet is fetched from Google. The label itself stays in this browser.

Does a spreadsheet fill every label on a page?

A spreadsheet prints one label per row. It does not fill every cell of an Avery 5160 sheet by itself. The sheet template is the letter page you edit.

Open the Avery 5160 address sheet label

The size is already set. You change the words.

Open this label