![]() The point of this post isn't to sell you labels, or a certain kind of printer. When you begin to learn the different features, you can start to fit them together to build powerful label designs with ease. Label LIVE has many other features to create labels that, by themselves, are simple and easy to use. That way, your newly edited data isn't trapped in a label design document. If you need to make a quick adjustment to the imported data you can hover over the filename and click "Edit." Your hands never have to leave the keyboard. You can immediately start typing again to begin another search. ![]() If you press ENTER once more, a single label will print. Select a product by pressing the ENTER key on your keyboard. To search for a product just click the ROWS dropdown menu and start typing. Let's get printing! We made Label LIVE easy to navigate and easy to print. On the new barcode object, click on "Value" and choose "UPC"Įach time you select a row the barcode will update from the spreadsheet data. To make a label easy to scan you can add a barcode that uses your imported spreadsheet data. ![]() To create new variables by hand you just create text and barcodes in the Design tab and add your own formatted "Ĭlick on the Data tab, and click on "SELL_BY"Ĭhange the "Printed Format" to something shorter The green ➕ button offers shortcuts for utilizing variables created from spreadsheet imports. Test how the text changes by selecting a different row on the Data tab. Optional: If you want your text to automatically wrap to multiple lines, click on "Word Wrap" and select "Automatic" and adjust the width of the text object to use the available label space. Click on "Align" and choose "Right." This ensures that when the text changes, the label text stays aligned to the right side of the label. From the Data tab:Ĭlick on the new text object and place it on the right side of the label. Label LIVE makes the easy things easy, and the hard things possible.įirst, let's add the product name as a text object. You can also watch the YouTube video demo at How To Print Labels From An Excel Spreadsheet To A Dymo, Zebra, Rollo Or Brother Thermal Printer. Try Label LIVE right now by downloading in the Mac App Store or Microsoft Windows Store. Once you feel good about the spreadsheet data you are ready to import. The column header "DATE:SELL_BY" tells Label LIVE to automatically create an "SELL_BY" variable and format it as a DATE. Label LIVE will remove any punctuation or spaces and will change all of the letters to upper-case. The text in the first row (header) will be referenced later as a variable. Label LIVE can import label data from Microsoft Excel and CSV (comma separated value) files which means learning to print labels from an excel spreadsheet is fast and easy.įor best results, ensure that the spreadsheet has short and simple header values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |