✦Template Printable Ideas Insights

How to Print Avery 18660 Labels from Excel

By

Looking to print Avery 18660 labels directly from your Excel data? You're in luck! This article will guide you step-by-step through the process, ensuring your labels are printed quickly and accurately. By the end of this tutorial, you'll be printing labels like a pro.

First things first, make sure you have the Avery 18660 label template designed for your specific label printer. The Avery 18660 template includes 30 labels per sheet, arranged in six columns and five rows. You can download this template from Avery's website.

Now, let's dive into printing your labels from Excel.

Preparing Your Excel Data

Before you start printing, ensure your Excel data is clean and organized. Remove any extra spaces, special characters, or line breaks that could cause formatting issues on your labels.

Learn How to Upload and Print a Project to Avery Design & Print Online
Learn How to Upload and Print a Project to Avery Design & Print Online
an image of a screen shot of the excel spreadsheet
an image of a screen shot of the excel spreadsheet
blue and white name tags with flowers on them
blue and white name tags with flowers on them

Your data should be structured in columns corresponding to the fields on your Avery 18660 labels. For example, if your labels have 'Name', 'Address', and 'City' fields, your Excel sheet should have these three columns.

Ensuring Data Fit

To avoid truncation or overlapping text, ensure your data fits within the designated fields on your Avery 18660 labels. You can use Excel's AutoWidth feature to adjust column widths to fit your data.

Microsoft Word Label Templates Avery 5160
Microsoft Word Label Templates Avery 5160
Avery Template 5163 Shipping Labels 2
Avery Template 5163 Shipping Labels 2
Design and Print Your Own Labels - DIY - Make Your Own Avery Labels/Stickers
Design and Print Your Own Labels - DIY - Make Your Own Avery Labels/Stickers

Another way to check data fit is to manually type in some sample entries from your data into a label, using the correct font and size specified in the Avery template.

Sorting and Filtering Data

Before printing, sort and filter your data to ensure only the desired records will be printed. This is especially useful if your label sheet contains multiple pages of labels.

For instance, you might want to sort your data by 'City' or 'State' before printing if you have organized shipments to different locations.

the printable labels dialogle is highlighted in the text box below, which indicates that each label has been changed
the printable labels dialogle is highlighted in the text box below, which indicates that each label has been changed
Avery | Labels, Cards, Dividers, Office Supplies & More
Avery | Labels, Cards, Dividers, Office Supplies & More
Avery Address Label Template 5162 | williamson-ga.us
Avery Address Label Template 5162 | williamson-ga.us
someone holding up a avery address label on a white wall with the words how to make address labels
someone holding up a avery address label on a white wall with the words how to make address labels
How to make printable labels for FREE (using Canva)
How to make printable labels for FREE (using Canva)
How to print cottage food labels on Avery sheets – step by step
How to print cottage food labels on Avery sheets – step by step

Setting Up your Printer

Make sure your label printer is set up correctly and has the Avery 18660 template installed. If you're unsure how to set up your label printer, consult the manufacturer's instructions.

Check that your printer is online and connected to the same computer as your Excel sheet.

Print Preview

Before printing, use the print preview function in Excel to check the layout of your labels. This way, you can catch any issues with your data or formatting before printing.

Learn How to Upload and Print a Project to Avery Design & Print Online
Learn How to Upload and Print a Project to Avery Design & Print Online
Avery Template 5167 Return Address Labels 1/2
Avery Template 5167 Return Address Labels 1/2
How to Create a DIY Sticker for Your Free Printables!
How to Create a DIY Sticker for Your Free Printables!

In print preview, you should see a preview of each label on your Avery 18660 sheet, displaying the data from your Excel sheet in the correct fields.

Adjusting the Print Area

Ensure you've selected the correct print area in Excel. Select only the cell range containing the data you want to print. This step is crucial to avoid printing unnecessary or unwanted data.

Avery templates typically provide guidelines on which cells to select for the print area. Consult your template for specific instructions.

Now that you've set up your data and printer, you're ready to print your Avery 18660 labels. Double-check everything once more, then click 'Print' in Excel. Watch as your labels are printed on your label printer, ready to be peeled off and used.