Blank Labels Using Excel With BarTender?

Do you get annoyed when BarTender selects empty rows in Excel and prints a bunch of blank labels? Here's a quick solution!

[@deomartinez77]

This totally worked. Thanks man

[@idintegration]

I believe you can control this in an easier way via Excel. Select your range that you wish to use for printing with Bartender. Within Excel, select PageLayout/PrintArea/SetPrintArea

[@Tio-Nino]

The older version was smarter, just enter part number and how many labels rather than select records. Wish they could put back this function