Recommended template for this guide
Multi-up sheet labels from Excel
Use a sheet-label template when you need several labels per row or a full page of repeated labels.
- Made for sheet labels
- Good for Avery-style layouts
- Better fit for multiple labels per row
Step-by-Step: Print Multiple Labels per Sheet
- Measure your label sheet (rows, columns, spacing)
- Set up a grid layout matching the sheet
- Import Excel or CSV data
- Design one label template
- Preview full sheet layout
- Print using correct scaling settings
Example Workflow
A4 and Letter sticker sheets (Avery, Herma, OnlineLabels) require precise alignment. Even a 1–2 mm offset can make the entire sheet unusable.
Common Sheet Label Problems
- Labels shift slightly on each row
- First row aligns, others drift
- Text overlaps label edges
- Entire sheet is offset
- Wasted sheets due to misalignment
Typical Sheet Layouts
- 2 columns × 7 rows (shipping labels)
- 3 columns × 8 rows (Avery standard)
- 4+ columns for small stickers
Measure Sheet Geometry
Identify label width, height, margins, and spacing. Use manufacturer specs or measure manually.
Configure Grid Layout
Set rows and columns to match your sheet exactly. Enter margins and gaps precisely to replicate physical layout.
Design One Label
Create a single label in the top-left position. The system automatically replicates it across the grid.
Bind Excel Data
Each row of Excel maps to one label position. The grid fills sequentially across rows and columns.
Test Alignment Before Printing
Print on plain paper and overlay it with the sticker sheet. Adjust margins by 1–2 mm if needed.
Print with Correct Settings
Use “Actual Size” or 100% scaling. Disable “Fit to Page” — this is the most common cause of misalignment.
Why Excel Alone Fails for Sheet Labels
- No control over grid layout
- Inconsistent spacing across rows
- Word Mail Merge breaks alignment
- No precise margin control
Common Mistakes
- Using “Fit to Page” scaling
- Incorrect margins
- Ignoring label spacing
- Testing only first row
FAQ
Why are my labels not aligning on the sheet?
Most likely due to incorrect margins, scaling, or grid setup.
What is the most important setting?
Scaling must be 100%. Any resizing breaks alignment.
Can I use Avery templates?
Yes, but a proper grid layout gives more control and consistency.
How do I avoid wasting sheets?
Always test on plain paper first and adjust margins before final printing.