Numbered labels from Google Sheets™: print 001, 002, 003 automatically
Need numbered labels from Google Sheets™? In Peelstack Label Maker, type a number token in a line and each label gets the next number. A hash sign in curly braces gives 1, 2, 3, adding zeros gives 001, 002, 003, typing the first number inside the braces starts higher, and the same token works in the text of a QR code or barcode. Check the numbers in the live preview, then print the PDF at Actual size. The items in the video are example data.
Read more
- QR Code Labels from Google Sheets™ (Product, Inventory and Jar Labels)
- Barcode Labels from Google Sheets™ (Code 128 for Inventory, Assets and Libraries)
- How to Print Address Labels from Google Sheets™ (Step by Step)
Transcript
Need labels numbered in order, without typing every number? In a line of your label, type a number token: a hash sign in curly braces. Add zeros inside it, and the numbers keep the same length. To start higher, type the first number inside the braces. The token also works in the text of a QR code or barcode. Each label in the run gets the next number. Check them in the preview, then print at Actual size. Follow for more label tips. Taskivator.com slash peelstack.
