Design, Create, and Print Identical Avery Sticker Labels
With an Online Label Maker
Install the Avery Label Merge add-on to design, create, and print multiples copies of the same Avery sticker label using Google Docs and Google Sheets
This article describes how to design, create, and print identical Avery sticker labels using an online label maker in Google Docs and Google Sheets. Making multiple copies of an identical label has never been easier. Through a few clicks, multiple copies of the same label can be made using the Avery Label Merge add-on.
Using Online Label Maker in Google Docs
Step 1: Start Avery Label Merge add-on
Start the Avery Label Merge add-on in Google Docs by clicking on Extensions > Avery Label Merge > Start to display the Avery Label Template Box and the Avery Label Merge sidebar.
Step 2: Add text
Add the required text into the Google Docs Label Template Box.
Step 3: Browse Avery label templates
Click on the Label / Envelope field to display the list of the available Avery label templates.
Step 4: Choose Avery label template
Select an Avery label template from the list of available Avery label templates and click on Apply. Search for an Avery label template by label code, size, description, etc.
Once an Avery label template is selected, the Avery Label Template Box changes to the size of the chosen template.
Step 5: Design and format Avery label
Format the text as required. The font, color, size, etc., of the *|merge fields|* can be changed in the Google Docs label template in the same way as regular text.
The Google Docs label template can be further customized with advanced label formatting.
Step 6: Create identical Avery labels
Click on Identical Labels to create multiple copies of the same Avery sticker label in a Google Doc.
There is also an option to create multiple copies of the same Avery sticker label in a PDF.
Step 7: Enter number of identical Avery labels required
When prompted, enter the number of how many of the same Avery label is required, then click on OK.
Step 8: Print identical Avery labels
In the newly created Google Doc, click on the Print icon to print multiple copies of the same Avery label.
Make sure the correct printer settings are used.
Using Online Label Maker in Google Sheets
Step 1: Start Avery Label Merge add-on
Start the Avery Label Merge add-on in Google Sheets by clicking on Extensions > Avery Label Merge > Start to display the Avery Label Merge dialog box.
Step 2: Add text
Add the required text into the Avery label template.
Step 3: Browse Avery label templates
Click on the Label / Envelope field to display the list of the available Avery label templates.
Step 4: Choose Avery label template
Select an Avery label template from the list of available Avery label templates and click on Apply. Search for an Avery label template by label code, size, description, etc.
Step 5: Design and format Avery label
Format the text (font, color, size, etc.) in the Avery Label Template as required.
Step 6: Create identical Avery labels
Click on Identical Labels to create multiple copies of the same Avery sticker label in a Google Doc.
There is also an option to create multiple copies of the same Avery sticker label in a PDF.
Step 7: Enter number of identical Avery labels required
When prompted, enter the number of how many of the same Avery label is required, then click on OK.
Step 8: Print identical Avery labels
In the newly created Google Doc, click on the Print icon to print multiple copies of the same Avery label.
Make sure the correct printer settings are used.
