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.
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
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
qtyfor 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.
Questions about this article? Email our team.
Send feedback