Cloudlabels home

Guides

How to print on Avery and HERMA label sheets without wasting a sheet

Choose the sheet by the product code on the pack, export your labels as a PDF and print it at actual size, not fitted to the page. Print the first page on plain paper and hold it against a label sheet before you load the real ones. A partly used sheet can be continued from any position, but Avery and HERMA both advise against feeding a sheet through the printer twice, so it is better to fill the sheet in one pass.

Written by Michael, who builds Cloudlabels · Last updated

Text version of the video

The Label sheets tab under Labels in Cloudlabels. On the left are the lists of label sheets and rolls. Avery (A4) is open, with 44 sheets.

The pointer clicks Search sheets and rolls and types 5160. One result is left: Avery 5160, Address, 30 labels (3 × 10), 66.7 × 25.4 mm.

The pointer selects it. The preview shows the sheet with three columns and ten rows, the Use sheet button, and the details: Paper Letter, Label 66.7 × 25.4 mm, Grid 3 cols × 10 rows, Total 30 labels/page, Margins L 4.8 mm and T 12.7 mm, Gaps H 3.2 mm and V 0 mm.

What you need

  • Your label sheets and the pack they came in. The product code is printed on the pack.
  • A printer that takes label sheets, and a few sheets of plain paper for the test.
  • Your products in “Items Table” in Cloudlabels, typed in or imported from Excel or CSV.
  • A ruler with millimetres, if your sheet is not in the list.
  • A Cloudlabels account. The Free plan is enough to follow along with up to 20 items.

Step by step

  1. Find the product code and the paper size

    Start with the pack. It carries a product code, for example Avery 5160, and that code stands for one layout: label size, columns, rows, margins and gaps. Note the paper size too. A4 is 210 × 297 mm and US Letter is 8.5 × 11 inches, and a layout made for one does not line up on the other.

    • Check that the labels suit your printer. Avery's own advice is inkjet labels for an inkjet printer and laser labels for a laser printer.
    • If the pack is gone, measure one label with a ruler and count the columns and rows. You can search by label size in step 2 or enter the sheet yourself in step 3.
  2. Choose the sheet in Cloudlabels

    Open “Labels” and go to the “Label sheets” tab. The list has “Avery (A4)”, “Avery (Letter)” and “Herma”. Type the code from the pack in “Search sheets and rolls...”, click the sheet and choose “Use sheet”. Design Center opens with an empty label the size of one label on that sheet.

    • The Avery lists are split by paper size. Avery 5160 is a US Letter sheet, so it is under “Avery (Letter)”. The sheets under “Herma” are all A4.
    • Read the preview before you choose: “Paper”, “Label”, “Grid” and “Total” should match the pack.
    • The search also takes a label size, for example 63.5 x 38.1.
    • Choose the sheet before you design. Picking a sheet starts an empty label, and if the label already has elements on it, Cloudlabels asks “Replace current design?” first.
    • US Letter sheet for Avery 5163: ten 4 × 2 in bin labels, locations A-01-01 to A-03-02, each with a Code 128 barcode.
    Made in Cloudlabels with the template “Bin Label 4×2 in · Code 128”, 10 labels per Letter sheet. Not a drawing.
  3. Add your own sheet if it is not in the list

    On the “Label sheets” tab, choose “Add your own sheet”. The form is called “New label sheet”. Give the sheet a “Name”, set “Paper” to A4 or Letter, and enter what you measure in millimetres: “Width” and “Height” of one label, “Columns”, “Rows”, “Gap across” between columns and “Gap down” between rows.

    • Under “Margins” you type one edge in each direction, for example “Left” and “Top”. The opposite edge is worked out from the paper and marked “Fills the page”.
    • Watch the preview as you type. A label that would land outside the paper is drawn in red, which means one of the numbers is wrong.
    • “Sheet library” at the top of the form loads the measurements of a listed sheet. Use it when your sheet is close to one of them.
    • Choose “Create Template”. The sheet is saved under “My sheets”, and you pick it like any other.
  4. Design one label for the sheet

    You design a single label, and Cloudlabels repeats it across the sheet with one row from your list on each label. Add text, a barcode or an image and connect each field to a column, as shown in the guide to hang tags from a spreadsheet. Then choose “Save” and give the label a name.

    • Above the canvas you see which sheet the label belongs to, and the line “Editing one label” with the label size in millimetres.
    • Leave “Width (mm)” and “Height (mm)” under “Size” alone. They change the label, not the sheet, and a label that no longer matches is stretched or squeezed into the sheet's label size in the PDF.
    • To put a label you already have on a sheet, open it, go to the “Sheets” tab and turn on “Enable Custom Label Sheet”. “Select Template” lists the sheets you have saved yourself. For an Avery or HERMA sheet, choose “Create New Template”, open “Sheet library”, pick the sheet and save it. The label keeps its elements and takes the sheet's label size.
  5. Tick the rows and open Generate PDF

    Go to “Items Table”, tick the rows you want labels for, choose your saved label and then “PDF”. The dialog “Generate PDF” has a box called “Label sheet” with the name of the sheet, its columns and rows, the number of labels and the paper size. Check that against the sheet in your hand.

    • No “Label sheet” box, and “Multi-page PDF” at the bottom of the dialog, means the label was saved without a sheet. You would get one label per page. Go back to step 4.
  6. Set the start position and the copies

    “Start from position” decides where on the first sheet the print begins. Positions are counted from the top left, across each row and then down. On a sheet with three columns, position 5 is the middle label in the second row. Leave it at 1 for a fresh sheet. “Copies per label” sets how many you get of each row you ticked.

    • The line under the field says what will happen: “Starts on a fresh sheet.” at 1, or for example “Skips positions 1 to 4 on a partly used sheet.” at 5. Only the first page is affected.
    • “Copies per label” offers 1, 2, 3, 5 or 10 copies and “Full sheet”, which gives each ticked row as many copies as the sheet has labels. Copies of the same row are placed one after another.
    • “Fill sheet” shows up when the rest of the sheet has room for more than ten copies of each ticked row. With two rows ticked on a sheet of 24 labels it reads “Fill sheet (12)”, and the sheet comes out full with nothing left over.
    • Choose “Export PDF”.
  7. Print the PDF at actual size

    Open the PDF and print it with the scale set to actual size or 100 %. Turn off fit to page, shrink to fit and any other scaling. Set the paper size to the same as the sheet, A4 or Letter. Avery and HERMA give the same advice for their own label PDFs.

    • If the printer has a paper type setting, choose labels or thick paper. Avery recommends it, and HERMA recommends it for laser printers.
    • Print from a PDF reader if you can. HERMA's help for its own label PDFs warns that printing from the browser window can put the print in the wrong place.
    • The page in the PDF is the whole sheet, A4 or Letter, with the labels already in position. Nothing has to be scaled.
  8. Test on plain paper before the real sheet

    Print the first page on plain paper. Lay it over a label sheet and hold both up to a window or a lamp. The print should sit inside every label, at the top of the sheet and at the bottom. Avery recommends the same check. Use the test page to see which side your printer prints on and which edge goes in first, then load the label sheets the same way.

    • If the print is crooked, feed one sheet at a time. HERMA says single-sheet feed often solves it, and Avery suggests the manual feed tray or the tray with the straightest paper path.
    • When the test fits, print the label sheets with exactly the same settings.

Mistakes that waste a sheet

  • Letting the print dialog scale the page.With scaling on, the whole page shrinks or grows, so the error is different from row to row: some labels fit and others are clearly off. Set the scale to actual size or 100 % and print the test page again.
  • A Letter sheet printed with A4 settings, or the other way round.The page in the PDF takes its size from the sheet you chose, A4 or Letter. If the printer is set to the other size, the page and the paper no longer match and the print misses the labels. Check the paper size in the “Label sheet” box and set the same one in the print dialog.
  • Choosing a sheet by the number of labels.Sheets with the same grid can differ in label size and margins. The “Herma” list alone has three sheets with 24 labels in a 3 × 8 grid, each with its own label size. Go by the product code, and compare “Label” in the preview with the pack.
  • A start position left over from last time.Cloudlabels remembers “Start from position” and “Copies per label” in your browser from the last export. Starting at 12 on a fresh sheet leaves eleven labels blank, and starting at 1 on a used sheet puts the print on the backing paper where labels are missing. Read the line under the field every time.
  • Feeding a used sheet through the printer again.Avery and HERMA both say a label sheet should go through the printer only once. Avery explains that the heat and the tight paper path in a laser printer can make labels curl, jam or peel off inside the printer, and HERMA warns that sheets with some labels removed may cause problems on a second pass. “Start from position” puts the print in the right place, but it does not change that. Where you can, fill the sheet in one pass, with “Fill sheet” or by ticking more rows.
  • Resizing the label after choosing the sheet.The sheet keeps its own label size. If you change the label under “Size”, the PDF fits it into the sheet's label size anyway, and text and barcodes come out stretched or squeezed. Switch to another sheet instead, or keep the label at the size the sheet gave it.

Questions

Still unsure? Contact us

The top row is right but the bottom row is off. Why?

Most likely the page was scaled when it was printed. Set the scale to actual size or 100 %, turn off fit to page, and check that the paper size is the same as the sheet. On a sheet you entered yourself, check “Height” and “Gap down” as well.

Every label is off by the same amount. How do I fix it?

Rule out the print settings first: scale, paper size and how the sheet is fed. If the shift is still there, adjust the margins on a copy of the sheet. Click the sheet name above the canvas in Design Center, and “Edit label sheet” opens with the sheet's measurements. Change “Left” or “Top” by the amount you measured and choose “Save to Gallery”. The copy is saved under “My sheets”, the label uses the copy, and the original sheet is unchanged. Save the label afterwards.

Which label is position 1?

The one at the top left. Positions run across the first row from left to right, then the second row, and so on down the sheet.

Can I print on a sheet where some labels are already used?

Yes, as far as the layout goes. Set “Start from position” to the first unused label and the positions before it stay empty. Whether the sheet should go through the printer again is another matter. Avery and HERMA both advise against it, and Avery's guarantee against jams only covers a sheet that has been through a laser printer once.

Can different products get different numbers of copies?

Not in one export. “Copies per label” is one number for all the rows you ticked. Export the rows in separate rounds, one for each quantity. Each round is its own PDF.

My sheets are not from Avery or HERMA. Can I use them?

Yes. Search the “Label sheets” tab by label size first, because the list holds other formats too. If nothing matches, add your own sheet with the label size, columns, rows, gaps and margins in millimetres, on A4 or Letter.

Is the Free plan enough to try this?

Yes, for a small test. The Free plan includes 20 items and 200 labels per month, at 300 DPI with a small watermark. Pro and Business start with a 7-day trial, no credit card.

Try it on one sheet first

GS1® and EAN are registered trademarks of GS1 AISBL. Avery, HERMA, Excel, Google Sheets, iOS, Windows and other names are trademarks of their respective owners. They are used only to identify standards, products and compatible formats. Cloudlabels is not affiliated with, endorsed by or certified by GS1 or any other company named on this page.