✦Template Printable Ideas Insights

How to Print Avery Labels from Google Sheets for Free

By

Printing Avery labels directly from Google Sheets can save you time andeffort, especially if you're frequently creating and managing labels. While Avery doesn't offer a free, built-in print option, you can use a workaround to achieve this at no cost. Here's a step-by-step guide on how to print Avery labels from Google Sheets for free.

Before we dive into the process, ensure you have the Avery template ready. You can find free Avery template downloads on their website, which you'll use to organize your data in Google Sheets. Let's get started!

Preparing your Google Sheet

Once you've downloaded the Avery template, follow these steps to prepareyour Google Sheet for printing:

Free: Create Avery Address Labels in Google Docs
Free: Create Avery Address Labels in Google Docs
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
Microsoft Word Label Templates Avery 5160
Microsoft Word Label Templates Avery 5160

1. Open Google Sheets and create a new blank spreadsheet.
2. Click on "File" and select "Import." Choose the Avery template you downloaded and click "Replace spreadsheet."
3. Your data should now fit perfectly into the Avery template. Make any necessary adjustments or additions.

Setting up Page Setup

Now that your data is prepared, it's time to set up the page layout for printing:

30 Avery Label Template 5960 – Simple Template Design
30 Avery Label Template 5960 – Simple Template Design
Retired Avery Software
Retired Avery Software
Avery Label Templates - Blue Layouts
Avery Label Templates - Blue Layouts

österreich

1. Click on "File" and select "Print."
2. In the Print setup dialog box, under "Scaling," ensure "Actual size" is selected.
3. In the " Sheets to print" section, choose the range that corresponds to your Avery template (e.g., "Avery 5160").
4. Click "Print preview" to ensure your labels look as expected. If everything is fine, close out of this window.

Creating a Print-friendly Copy

To avoid accidentally printing or modifying your original Google Sheet, follow these steps:

Free PDF Label Templates for Graphic Designing
Free PDF Label Templates for Graphic Designing
sticker labels template 4 How To Save Avery Custom Template Format
sticker labels template 4 How To Save Avery Custom Template Format
Avery Template 5163 Shipping Labels 2
Avery Template 5163 Shipping Labels 2
Free Blank Label Templates Online
Free Blank Label Templates Online
30 Label Templates Free Download – Simple Template Design
30 Label Templates Free Download – Simple Template Design
Avery Template 6871 Print-to-the-Edge Address Labels 1-1/4
Avery Template 6871 Print-to-the-Edge Address Labels 1-1/4

1. Click on "File" and select "Make a copy."
2. Name the copy "For Print" or something similar to indicate its purpose.
3. Right-click on the "For Print" tab at the bottom and select "Move or copy" to place it next to your original sheet.
4. Now, when you're ready to print, you can do so from the "For Print" sheet without affecting your original data.

Printing Avery Labels

With everything set up, you're now ready to print your Avery labels:

Avery Template 60505 UltraDuty GHS Labels 2
Avery Template 60505 UltraDuty GHS Labels 2
How to Download Free Avery Label Templates
How to Download Free Avery Label Templates

Printing from Google Sheets

1. Click on "File" and select "Print."
2. Choose your printer and check that the correct range of cells is selected in the "Sheets to print" section.
3. Click "print" to start printing your labels.

Printing from the "For Print" Copy

1. Double-check that you're on the "For Print" sheet.
2. Follow the same print steps as above.
3. Once printed, you can cut out your Avery labels and apply them as needed.

Congratulations! You've successfully printed your Avery labels from Google Sheets for free. This method can save you time and effort when managing and printing labels, making label creation an efficient and cost-effective process.