Mailing labels from Excel

Long lists paginate on their own

A list longer than one sheet paginates by itself — you set nothing. Load four hundred rows against an Avery 5160 sheet and you get thirteen full sheets and one with ten labels on it; the tool works that out and lays the pages out for you. There is no per-sheet setup and no upper limit imposed by the tool itself.

If your spreadsheet has a quantity or copies column, map it in the tool and each row repeats that many times. This is the usual shape for a mailing where some recipients get two or three pieces, and it saves duplicating rows by hand before you start.

Part-used sheets

The most wasteful habit in label printing is throwing away three quarters of a sheet because the last job needed seven labels. Set the start position to the first unpeeled cell and printing begins there, leaving the already-used positions blank.

The position picker mirrors the physical sheet, so you can count across and down on the real thing and click the matching cell rather than working out an index. It appears for every multi-label sheet format. Get it wrong in the preview rather than in the printer.

Cleaning the list before you print

Sort the list by each mapped field in turn and read the top and bottom rows before printing a large run. Labels are unforgiving about data quality in a way a screen is not — a blank name or a stray comma becomes a physically printed mistake stuck to an envelope. Empty cells and misaligned columns surface immediately that way.

Rows where every mapped column is empty are skipped rather than printed as blank labels, so a trailing empty row in the spreadsheet will not cost you a label. Rows with some content still print, which is deliberate: a partially filled row is more likely to be real data than an accident.

Print settings that matter

Actual size, not "fit to page" — the same rule as for single-envelope address runs. Best or normal quality rather than draft, since draft output on label stock tends to be grey and soft. Feed label sheets one at a time if your printer will let you, and check the tray guides are snug — a sheet that skews by a degree on the way in prints every label a degree off.