How to Print Labels



how-to-print-labels.png

Printing labels allows you to easily create your own stickers for products, boxes, and envelopes.

You can integrate your own branding design into these labels and save time and money by not ordering custom products from outside vendors.

Many major programs, like Excel, Word, and Google Sheets, have features that allow you to create and print labels.

Here’s a guide to all of these processes.



How to Print Labels from Word

You can use Word to create a single label, a sheet of various labels, or a sheet of the same labels using page formatting.

Word even has a dedicated labels button to make formatting easy.



And there’s a Mail Merge feature that makes it easy to input a large number of addresses at the same time.

Here’s a rundown of the most basic method to create labels in Word.

  1. Click the “Mailings” tab, then the “Labels” button.
  2. Enter the address you want included on your label in the dialog box
  3. To print a single label, select “Single Label.” To print a full page, select “Full Page of the Same Label.”
  4. Choose the row and column where the label is located on your sheet.
  5. Select “Options,” and a dialog window should pop up.
  6. Choose the type of sheet specified on your label package. For example, if you have a sheet of 30 labels, select the 30 Per Page option that matches your dimensions.
  7. Format or edit any individual labels if necessary.
  8. Select “Print” to send your labels to your printer. Make sure your label sheet is correctly inserted into the tray.

Printing Labels in Word Using the Envelopes and Labels Dialog Box

The labels and envelopes dialog box is available in the “Mailings” tab of Word 2007 and newer.

This feature makes printing labels in Word significantly easier by giving users a pop-up to add all the relevant information.



Once you add the address and choose your formatting settings, Word simply creates the layout that works for your sheet of labels.

How to Print Labels from Excel

Excel is the perfect tool for creating a list of contact information that you can later use to create labels in Word.

The idea is to create a table with all the information for your contacts.

Then you can transfer it to Word using the Mail Merge feature and add formatting in the “Mailings” tab described above.



Here’s the process:

  1. Create a new Excel sheet and type a heading in the first cell of each column describing the information you want included in each label. This may include things like: title, first name, last name, street address, city, state, and zip code.
  2. Type the information for each recipient into the correct column. Make sure none are left blank, as this could throw off the formatting. Save the sheet when finished.
  3. In a new Word document, go to the “Mailings” tab and select “Labels.” Use the label options dialog box to choose the correct template.
  4. Select “Start Mail Merge, then “Labels.” Select the document you created in Excel and add those recipients to your Word doc.
  5. Review the formatting in your Word document before sending it to your printer.

How to Print Labels from Google Sheets

Google Sheets offers a free cloud-based spreadsheet tool with features similar to Excel.

It doesn’t include label features automatically. But you can use an add-on to easily accomplish this.

Here’s how:



  1. Download the “Avery Label Merge” add-on to your Google account.
  2. Create a new Sheet in your Google Drive dashboard and add columns for all the data you want on your labels. This may include names, street address, city, state, and zip code.
  3. Add information for all of your recipients under the specified columns.
  4. Create a blank Google Doc. Click “Add-ons” from the top menu and select “Avery Label Merge.”
  5. A pop-up window will appear to let you choose the spreadsheet with your address list. Select the fields you want included in your labels and the label and sheet size. Check your label package for this information.
  6. Click “Merge” and it should automatically add the information from your spreadsheet to the Google Doc.
  7. Insert your label sheet in the printer and send the document to your device.

How to Create Labels from Google Docs

You can also create labels just using Google Docs. Here’s a guide:

  1. Download the Labelmaker add-on if you haven’t already.
  2. Open a new Google Doc, click on the “Add-ons” menu, and select “Create & Design Labels.”
  3. In the Labelmaker sidebar, click “Select a template,” then choose the one that fits your label sheet.
  4. Add an address and formatting to the first cell in the document. Select that cell and click “Create labels.” This creates a full sheet of labels copied from that first cell.
  5. Click “File” then “Print.”

Is there a Label Template in Google Docs?

Google Docs doesn’t come with a label template. But you can use an add-on like Labelmaker or Avery Label Merge” to access templates. If you are looking for another option, you can email instead of mail your message, here’s how to create distribution lists in GMail.

How to Print Return Address Labels

You can easily print return address labels using tools like Word or Google Docs. Simply choose a template, input the address, and copy it throughout the document before sending it to your printer.

How to Print Mailing Labels

To print mailing labels, create a table full of addresses in a spreadsheet program like Excel or Google Sheets. Then use a mail merge feature to input those addresses into a document in Word or Google Docs and print.



Use a template that matches your product number to format your envelopes and labels. Tools such as the Avery holiday labels are another option for special days and events.

Can you print labels with a regular printer?

Yes, most printers work with custom sheets full of sticky labels. Many of these products are made in normal paper dimensions.

You can also create labels of various sizes in Word or a similar program. Then print them using regular paper and tape them to packages.

How do I get my printer to create and print labels?

Start by creating your sheet of labels in a program like Word or Google Docs. Use a template that matches your label sheet.



If you’re using sticker paper to create labels, follow the package instructions for adding it to your paper tray before printing.

Image: Depositphotos Comment ▼



Annie Pilon Annie Pilon is a Senior Staff Writer for Small Business Trends, covering entrepreneur profiles, interviews, feature stories, community news and in-depth, expert-based guides. When she’s not writing she can be found on her personal blog Wattlebird, and exploring all that her home state of Michigan has to offer.

Comments are closed.