Are you a Mac user looking to print Avery labels from your Excel data? You're in the right place. In this guide, we'll walk you through the process step by step, ensuring you get your labels printed perfectly every time.

Before we dive in, make sure you have Avery label templates installed on your Mac. If not, you can download them from the Avery website. They offer a wide range of templates compatible with Microsoft Excel and Apple's Pages.

Preparing Your Excel Data
First, ensure your data in Excel is organized and formatted correctly. Each label should have its own row, and columns should correspond to the label's fields.

For instance, if your Avery template has fields for 'Name', 'Address', and 'Phone Number', your Excel sheet should have columns labeled accordingly.
Formatting Your Data

To ensure your data fits perfectly on the labels, use the 'Wrap Text' option in Excel. This prevents text from spilling over into the next cell. You can find this option in the 'Home' tab under 'Alignment'.
Also, adjust the column widths to fit your data. You can do this by hovering over the line between two column headers until the double-sided arrow appears, then click and drag to resize.
Saving Your Workbook

Before printing, save your workbook in a format compatible with Avery templates. The Avery website recommends saving as an Excel 97-2003 Workbook (*.xls) or a CSV (Comma delimited) (*.csv) file.
To do this, go to 'File' > 'Save As', then select the desired format from the 'Format' dropdown menu.
Printing Avery Labels from Excel on Mac

Now that your data is ready, it's time to print your Avery labels. Here's how:
1. Open your Excel workbook containing the data you want to print.




















Selecting the Right Printer
MacOS allows you to select a printer even after you've started printing. So, first, click on 'File' > 'Print'. In the print dialog box, under 'Printer', select your Avery label printer. If you don't see it, click on the plus (+) button to add it.
If you're using a standard printer, you'll need to insert the Avery label paper into your printer's tray before selecting the printer in the print dialog box.
Setting Up the Print Options
After selecting your printer, click on the 'Layout' button (it looks like a piece of paper with lines on it). This will open the Page Setup dialog box.
In the 'Paper Size' dropdown menu, select 'Custom'. Then, enter the dimensions of your Avery label paper. You can find these dimensions on the Avery website or on the packaging of your label paper.
Under 'Scaling', select 'Fit to page width'. This ensures your labels print at the correct size.
Click 'OK' to close the Page Setup dialog box.
Printing Your Labels
Back in the print dialog box, make sure the number of copies is set to the number of labels you want to print. Then, click 'Print'.
Excel will print your labels one at a time. If you're using a standard printer, make sure to remove the printed label from the tray before the next one prints.
And there you have it! Your Avery labels are now printed and ready to use. Happy labeling!