Google Docs Label Template Compatible With Avery® L7970


Avery L7970 Label Template

Format: A4

Description: Freezer labels

How to make Avery L7970 in Excel?

It’s much easier to do this in Google Sheets using Foxy Labels Add-on. But in case you like Excel take these steps:

  1. To mail merge Avery L7970, create a new Excel Sheet, type in a heading in each column’s first cell describing the data. Make a column for each element you want to include on the labels.
  2. Type the names and addresses or other data you’re planning to print on labels.
  3. Open Word document. Click Mailing ->Start Mail Merge ->Labels. Select the template.
  4. Click Select Recipients -> Use an Existing List in the dialog window, then select created file.
  5. Click on Insert Merge Field to input data from the Excel file.
  6. Don’t forget to click on Preview Results before printing.

How to make Avery L7970 in Word?

It’s much easier to do this in Google Docs using Foxy Labels Add-on. But in case you like Word, take these steps:

  1. To set up Avery L7970 template, open a Word document, go to the top of the screen and click Mailings > Labels > Options.
  2. Select Avery US Letter from the drop-down menu next to Label Vendors. Then scroll to find your Avery product number and click OK. Download Avery L7970 template for Microsoft Word
  3. If you want all of your created labels to have the same information, type it into the address box and click New Document. If you want different information on each title, click New Document and then fill in your labels.
  4. If you would like to see gridlines, click Layout > View Gridlines.
  5. The template is ready to print.
Menu