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

← Avery labels

Avery 5161 address sheet labels will not line up

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

Here is what to change when Avery 5161 address sheet labels will not line up. Open the Avery 5161 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 Avery 5161 address sheet labels will not line up

When Avery 5161 address sheet labels sit high, low, or slide into the gap, scaling is usually on, or the paper guide is loose. Set the print box to actual size, US Letter, and do not fit to page.

Open Avery 5161 address sheet and print one page. Compare it with the sheet in your hand before you print Asha's whole list of 36.

  1. Open https://app.mylabelmaker.com/?template=avery-5161-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. In the print box, turn scaling off and pick this exact size. Print one before the rest.
  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 (Twenty wider address labels, two across and ten down). 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.

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

Why will Avery 5161 address sheet labels not line up?

Open the Avery 5161 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 5161 address sheet label

The size is already set. You change the words.

Open this label