How to Print Avery Labels from Excel

Evelyn Jul 09, 2026

Ever found yourself in a situation where you need to print Avery labels directly from an Excel file? You're not alone. Avery labels are widely used for various purposes, from addressing envelopes to organizing files, and having the ability to print them directly from your Excel data can save you a significant amount of time and effort. In this comprehensive guide, we'll walk you through the step-by-step process of printing Avery labels from an Excel file, ensuring you get the most out of your data and labels.

Use Excel's Power to Print Labels in No Time
Use Excel's Power to Print Labels in No Time

Before we dive into the process, let's ensure you have the right tools. You'll need an Excel-compatible spreadsheet software and Avery label templates. Avery provides a wide range of templates that you can download for free, which are compatible with Microsoft Excel, Google Sheets, and other spreadsheet software. Once you have these tools ready, let's proceed to the main topics.

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

Preparing Your Excel File

Before you can print Avery labels, you need to ensure your Excel file is well-structured and compatible with the Avery label template. Here are the key steps to prepare your Excel file:

How to Print Avery Labels in Microsoft Word on PC or Mac
How to Print Avery Labels in Microsoft Word on PC or Mac

1. **Organize Your Data**: Ensure your data is organized in columns and rows, with each label's information starting from the top-left cell (usually A1).

2. **Choose the Right Avery Template**: Select an Avery template that matches the size and layout of your labels. You can find these templates on the Avery website or by searching for 'Avery label templates' in your spreadsheet software.

Design Templates for Christmas Cards | Free & Customizable
Design Templates for Christmas Cards | Free & Customizable

Using Avery Label Templates

Using Avery label templates is straightforward. Here's how you can do it:

1. **Download and Open the Template**: Download the Avery template that matches your label type and open it in your spreadsheet software.

How to Download Free Avery Label Templates
How to Download Free Avery Label Templates

2. **Paste Your Data**: Select the range of cells containing your data in your original Excel file, then copy and paste them into the Avery template, starting from the top-left cell.

Adjusting Column Widths and Row Heights

Sometimes, the Avery template's column widths and row heights might not perfectly fit your data. Here's how you can adjust them:

a woman with glasses and a red hoodie in front of an excel file screen
a woman with glasses and a red hoodie in front of an excel file screen

1. **Adjust Column Widths**: Hover your cursor over the line between two column headers until the cursor turns into a double-headed arrow. Click and drag to adjust the column width.

2. **Adjust Row Heights**: Similarly, hover your cursor over the line between two row headers until the cursor turns into a double-headed arrow. Click and drag to adjust the row height.

How to make printable labels for FREE (using Canva)
How to make printable labels for FREE (using Canva)
Excel help & learning
Excel help & learning
Editable Avery Label 5610 and 5613 Power Point Template Bundle
Editable Avery Label 5610 and 5613 Power Point Template Bundle
How to Use Avery 5160 Labels on Excel | Techwalla
How to Use Avery 5160 Labels on Excel | Techwalla
Avery Template 5161 Address Labels 1
Avery Template 5161 Address Labels 1
Avery Label Templates - Blue Layouts
Avery Label Templates - Blue Layouts
Free: Create Avery Address Labels in Google Docs
Free: Create Avery Address Labels in Google Docs
How to add your own text to printable labels (plus FREE printable cleaning labels!)
How to add your own text to printable labels (plus FREE printable cleaning labels!)
Free PDF Label Templates for Graphic Designing
Free PDF Label Templates for Graphic Designing
How To Print Labels From An Excel List - SlashGear
How To Print Labels From An Excel List - SlashGear
free  avery file folder label template sample
free avery file folder label template sample
How to Print Labels in Word 2011 with Mail Merge
How to Print Labels in Word 2011 with Mail Merge
Creating Labels from a list in Excel
Creating Labels from a list in Excel
How To Create Microsoft Word Labels
How To Create Microsoft Word Labels
Video: How to Make Pretty Labels in Microsoft Word
Video: How to Make Pretty Labels in Microsoft Word
blank label template for avery products
blank label template for avery products
Avery Template 5567 Hanging File Folder Labels 1/5 Cut
Avery Template 5567 Hanging File Folder Labels 1/5 Cut
Make Your Own Return Address Labels
Make Your Own Return Address Labels
How to Create Address Mailing Labels in Microsoft Word 2007 Using Excel Data
How to Create Address Mailing Labels in Microsoft Word 2007 Using Excel Data
🎨 Create Stunning Labels in Microsoft Word with Free Printable Guide
🎨 Create Stunning Labels in Microsoft Word with Free Printable Guide

Printing Avery Labels

Once your Avery template is filled with your data, you're ready to print your labels. Here's how you can do it:

1. **Select the Range**: Select the range of cells containing your label data. Ensure you don't select any extra cells to avoid printing unnecessary information.

2. **Print the Labels**: Go to the 'File' menu, select 'Print', and choose the printer connected to your label printer. Ensure you've selected the correct paper size (usually 'Custom' or 'Label') and orientation (usually 'Landscape').

Printing Multiple Sheets

If your data spans multiple sheets, you can print them all at once. Here's how:

1. **Select All Sheets**: In the 'Print' dialog box, click the 'Select Sheets' dropdown and choose 'All Sheets'.

2. **Print All Sheets**: Click 'Print' to print all sheets containing label data.

And there you have it! You've successfully printed Avery labels directly from your Excel file. This process can be a game-changer, especially when you need to print multiple labels with varying information. Whether you're addressing envelopes, labeling files, or organizing your office, this method ensures efficiency and accuracy.

Remember, the key to successful label printing is preparation. Always ensure your data is well-structured and organized before attempting to print labels. Also, don't hesitate to adjust column widths and row heights to fit your data perfectly.

Now that you know how to print Avery labels from an Excel file, why not give it a try? Start with a small project, like labeling a few files, and gradually take on larger tasks as your confidence grows. Happy printing!