Mastering Avery Templates in Excel: A Step-by-Step Guide

Evelyn Jul 09, 2026

Ever found yourself in need of creating professional-looking labels, tags, or other printed materials in Excel, but struggled with the design aspect? Avery templates for Excel can be your game-changer, offering a wide range of pre-designed layouts that you can customize to fit your needs. In this comprehensive guide, we'll walk you through the process of using Avery templates in Excel, ensuring you get the most out of this powerful tool.

Avery Address Labels 5160 Template
Avery Address Labels 5160 Template

Before we dive in, let's briefly understand what Avery templates are. Avery templates are pre-designed layouts that you can use to create labels, tags, business cards, and more, directly within Excel. They come in various sizes and formats, making them incredibly versatile for a multitude of projects. Now, let's explore how to use these templates to enhance your Excel experience.

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

Getting Started with Avery Templates in Excel

To begin, you'll need to have Avery Design & Print software installed on your computer. This software is compatible with both Windows and Mac operating systems and can be downloaded from the official Avery website. Once installed, you're ready to start using Avery templates in Excel.

Avery Template 5162 Address Labels 1-1/3
Avery Template 5162 Address Labels 1-1/3

Your first step is to open Excel and create a new workbook or open an existing one. Avery templates can be used with any Excel file, so you're not limited to creating new documents. Now, let's look at how to insert an Avery template into your Excel file.

Inserting an Avery Template

Top 7 Excel Inventory Management Tips and Free Template
Top 7 Excel Inventory Management Tips and Free Template

To insert an Avery template, follow these steps:

1. Click on the "Mailings" tab in the Excel ribbon. If you don't see this tab, you may need to enable the Developer tab and then add the Mailings group.

2. In the "Create" group, click on "Labels" to open the "Label Options" dialog box.

Free Spreadsheet Templates for Excel & Google Sheets
Free Spreadsheet Templates for Excel & Google Sheets

3. In the "Label vendors" drop-down menu, select "Avery US Letter" or the appropriate Avery template size for your region.

4. Choose the template design you want to use from the "Label templates" list. You can preview the design in the box below the list.

5. Click "OK" to insert the template into your Excel file. The template will be inserted as a table, with each label or item on a separate row.

Mail Merge Template for Rectangular Address Labels-Microsoft Excel to Word on Avery 5162 1-1/3 x 4 Printable - Instant Download Digital File
Mail Merge Template for Rectangular Address Labels-Microsoft Excel to Word on Avery 5162 1-1/3 x 4 Printable - Instant Download Digital File

Customizing Your Avery Template

Now that you've inserted your Avery template, it's time to customize it with your content. Here's how to edit the text and add images to your labels:

The ultimate excel templates you need
The ultimate excel templates you need
the advanced excel chart sheet is shown in green and has instructions on how to use it
the advanced excel chart sheet is shown in green and has instructions on how to use it
The 5 Best Websites to Download Free Excel Templates
The 5 Best Websites to Download Free Excel Templates
How to use an Excel spreadsheet in Google Sheets (access from any device, anytime) or Numbers for Ma
How to use an Excel spreadsheet in Google Sheets (access from any device, anytime) or Numbers for Ma
3+ Avery Name Badge Template Sample
3+ Avery Name Badge Template Sample
How To Create Blank Avery 5160 Free Template
How To Create Blank Avery 5160 Free Template
Top 101 Excel Templates for Productivity
Top 101 Excel Templates for Productivity
The 10 best free templates you should get for Excel
The 10 best free templates you should get for Excel
Free Task Tracker Templates for Excel & Google Sheets
Free Task Tracker Templates for Excel & Google Sheets
Use Excel's Power to Print Labels in No Time
Use Excel's Power to Print Labels in No Time
How to Create a Dynamic Financial Tracker in Excel Using Scribe | Step-by-Step Guide
How to Create a Dynamic Financial Tracker in Excel Using Scribe | Step-by-Step Guide
Day 2 – Introduction to Excel Excel
Day 2 – Introduction to Excel Excel
Your Free Excel Template Guide - 141 Must-haves
Your Free Excel Template Guide - 141 Must-haves
Excel Tips & Tricks
Excel Tips & Tricks
Create Form in Excel for Data Entry | MyExcelOnline
Create Form in Excel for Data Entry | MyExcelOnline
How to keep Inventory using an Excel Spreadsheet - [create your own Template]
How to keep Inventory using an Excel Spreadsheet - [create your own Template]
Free PDF Label Templates for Graphic Designing
Free PDF Label Templates for Graphic Designing
Labels Template A4  Five Things You Should Know Before Embarking On Labels Template A4 - AH – STUDIO Blog
Labels Template A4 Five Things You Should Know Before Embarking On Labels Template A4 - AH – STUDIO Blog
Excel Formulas Cheatsheet
Excel Formulas Cheatsheet
Have you ever wondered how to create a delivery tracker in Excel?
Have you ever wondered how to create a delivery tracker in Excel?

1. Double-click on the first cell in the table to open the "Edit Labels" dialog box.

2. Type your text into the "Label" field. You can use the "Font" and "Size" drop-down menus to format your text.

3. To add an image, click on the "Picture" icon (a small mountain range) in the "Edit Labels" dialog box. Select the image file you want to use and click "Insert". You can resize the image using the handles that appear around it.

4. Click "OK" to close the "Edit Labels" dialog box. Your changes will be applied to all the labels in the table.

Printing Your Avery Labels

Once you've customized your Avery template, it's time to print your labels. Here's how to ensure your labels print correctly:

1. Select the entire table containing your labels. To do this, click on the first cell in the table, then press and hold the "Shift" key while clicking on the last cell.

2. Right-click on the selected table and choose "Print" from the context menu.

3. In the "Print" dialog box, make sure the "Print range" is set to "Selection" and the "Print what" is set to "Active sheet".

4. Click "OK" to print your labels. Make sure your printer is set to print on the correct paper size and type for your Avery labels.

Troubleshooting Common Issues

If you're having trouble printing your Avery labels, here are a few common issues and their solutions:

Issue: Labels are printing too small or too large.
Solution: Make sure your printer is set to the correct paper size and type for your Avery labels. You can also try adjusting the scale in the "Print" dialog box.

Issue: Labels are printing out of alignment.
Solution: Make sure your printer is properly calibrated and that you're using the correct paper for your Avery labels. You can also try printing a test page to check the alignment.

Using Avery templates in Excel can save you time and effort when creating professional-looking labels and other printed materials. By following the steps outlined in this guide, you'll be well on your way to creating and printing high-quality labels with ease. Happy designing!