Skip to content
Gookit Help

Pick your store platform

Choose your store platform and install BarcodeMan. Plans, pricing and trial eligibility vary by platform. Confirm the available plans in the app and the final charge on the approval or checkout screen.

Keep your list in Google Sheets instead? BarcodeMan for Google Sheets

Articles

Choose rows and label quantities in Google Sheets

Pick selected or all visible rows, print copies from a quantity column, and skip used positions on a partly used label sheet with BarcodeMan for Google Sheets.

Verified
On this page

These Print settings decide which rows print and how many labels each row makes. The examples use the three-row worksheet from Prepare a worksheet for BarcodeMan labels.

Choose the rows to print

20-second video Watch on YouTube

Under Print settings, set Rows before you print. With no saved choice, BarcodeMan starts with All visible rows. An existing saved choice is kept when you reopen the sidebar.

  • Selected rows uses the rows containing your selected cells in the active worksheet. For example, selecting A2:A3 includes rows 2 and 3 and reads the columns needed for those rows. Selecting only the header does not select any data to print.
  • All visible rows uses the active worksheet’s data rows, not just the rows currently on your screen. It does not include other worksheet tabs.

Both options exclude blank rows, manually hidden rows, and rows hidden by a basic filter.

Rows hidden by a filter view still print if they fall within your chosen range. To exclude them, use a basic filter or explicitly select only the rows you want to print. Check your selection before choosing Print labels.

Set label quantities

Under Label quantity, choose one of these options.

  • One label per row prints one label for each valid included row. The three example rows produce three labels, regardless of the values in qty.
  • Quantity from a column uses the column you select in Quantity column. Choose qty for the example. BarcodeMan does not choose the column for you.

In quantity-column mode, 3 prints three copies of that row’s label. An empty cell prints one. 0 skips the row. The example therefore produces four labels: three for Mug, one for Tote, and none for Box.

Printing the qty value as text on the label does not change the number of copies. Invalid quantities, such as non-numeric text, appear in Data review so you can correct them.

If a quantity column is renamed or removed, select an available column again. If no columns are available, fix the first-row headers and choose Refresh.

Skip positions on a partly used sheet

Use Skip used label positions when some positions at the start of your label sheet have already been used.

For example, enter 3 to leave the first three label positions blank and start at the fourth position in the template’s layout. This does not skip the first three worksheet rows. Use 0 for a fresh sheet.

Check the PDF layout before feeding the partly used sheet into your printer.

Next, check the data and generate a PDF.

Questions about this article? Email our team.

Send feedback