What you need before you start
Clean up blank rows and long apartment strings in your spreadsheet before connecting a label template.
A list of addresses in a spreadsheet
Keep recipient columns neatly organised (Full Name, Street Line 1, Street Line 2, City/State/Postcode) with clear column headers in Row 1 and zero trailing blank spacer rows.
Your label sheet size
Confirm your adhesive pack layout—typically 2×7 (14-up) on A4 or 3×10 (30-up) on US Letter—before formatting address fonts.
Step-by-step: print using mail merge or a bulk address tool
Complete these exact five steps for smooth how to print labels with multiple address on one page runs without duplicate glitches.
Step 1: Tidy the address list
Scan long business names and dual-line apartment numbers so no single address climbs over 4–5 lines tall—oversized addresses clip horizontally on narrow 3-column sheets.
Step 2: Choose the label layout
Open a blank grid matching your sheet SKU or custom cell dimensions in millimetres.
Excel and CSV columns
Format postcodes/ZIP codes as Text inside Excel BEFORE saving so leading zeros (e.g. 02138 or 0800) aren't accidentally stripped into 4-digit numbers!
Word mail merge
In Word open Mailings -> Start Mail Merge -> Labels -> pick sheet number -> Select Recipients -> Use Existing List -> point at your spreadsheet -> insert Address Block into cell 1 -> ALWAYS click Update Labels (otherwise only label 1 updates!) -> Finish & Merge.
Step 3: Merge or paste addresses
When doing just 10–30 holiday parcels, skipping Word's complex Next Record rules by simply clicking into individual browser label cells lets you type or paste unique recipients straight onto page 1 visually.
Step 4: Preview every label
Always inspect the Preview Results view across every row—checking especially where long double-barrelled street names wrap.
Online address label tool
Browser address label tools swap instantly between Repeat Mode (return addresses) and Multi-Entry Mode (distinct shipping recipients per cell) with zero CSV wizard menus.
Return-address labels
Reserve the remaining unused empty cells at the bottom of a mixed dispatch sheet for extra return-address stickers so zero adhesive labels go to waste.
Step 5: Print and check alignment
Run a quick copy-paper alignment check, lock Print Scale to 100% Actual Size, and feed matte white adhesive sheets flat via the rear manual tray.
— FASTER BROWSER ALTERNATIVE —
Skip Manual Setup — Use Our Free A4 Address Labels
Instead of wrestling with printer driver scaling or manual table margins, generate a locked 100%-scale PDF directly in your browser using our a4 address labels tool.
Common problems and quick fixes
Mail merge throws classic frustrating errors when one tiny button gets skipped—spot all three below immediately.
Addresses run off the label
Drop font size slightly from 12 pt to 10–11 pt readable sans-serif, tighten paragraph line spacing inside table cells to 1.0 single spacing (0 pt after), and verify zero unwanted extra tabs slipped into Excel cells.
Same address on every label
In Word Mail Merge, you forgot the «Next Record» field tag before cells 2–14! Always click 'Update Labels' under Mailings after formatting cell 1 so Word inserts «Next Record» across every label automatically.
Special characters appear wrong
Accents (é, ü, ñ) corrupt when CSV files export in legacy ANSI encoding instead of UTF-8. Either save straight as native .xlsx for Word Mail Merge or copy-paste directly into a UTF-8 browser label maker.
Faster option: let a layout tool do the work
Only mailing 14 holiday cards or 8 e-commerce parcels today? Skip configuring multi-step Excel ODBC Mail Merge links altogether.
When a sheet maker saves time
Switch our browser address label maker to Multi-Address mode to edit every single slot on your A4 sheet visually in thirty seconds flat.
A4 address labels
Open A4 Address Labels, toggle individual cells, enter or paste distinct recipient addresses cleanly, and download a 100% crisp PDF immediately.
Frequently asked questions
Common scaling, paper tray, and export troubleshooting questions for step-by-step: print using mail merge or a bulk address tool before printing a final sheet.
How to print multiple address labels on one sheet?
For fast how to print multiple address labels on one sheet batches, use Print Sheet Maker's Individual Cell mode for 8–24 recipients directly, OR run Word Mailings -> Start Mail Merge -> Labels linked to a clean .xlsx sheet.
How to print labels with multiple addresses on one page?
Whether using Word Mail Merge ('Update Labels' inserts «Next Record» tags automatically) or pasting straight into multi-cell grid editors, every slot pulls a unique recipient without wasting single sheets.
Can I print different shipping labels on one page?
Yes. Larger 2×4 (8-up) A4 shipping label presets give ample room for unique To/From addresses and tracking references across eight distinct parcels per page.
— PUT THIS WORKFLOW INTO ACTION —
Build Your Sheet with A4 Address Labels
Generate a print-ready PDF with exact margins, custom gutters, and hairline crop marks right now—completely free and with no sign-up.