Want to know all the tips and tricks on making your sheet labels? In this article, we will share with you distinct guides on how to print label sheets using different tools, namely Microsoft Word, Microsoft Excel, Google Docs, and Google Sheets. 

Sheet labels are basically ready-to-use labels on printer paper sizes. And since they can be printed on color using an inkjet or laser printer, the labels are compatible with numerous applications,

Sheet labels are the best option for printing product labels. Aside from that, however, they are also applicable for printing other smaller labels and are perfect for beginners who have an office printer ready. Other common uses for sheet labels are printing address/ mailing labels, barcode, shipping label, packaging, and others.

Lets explore more on the most common things you can print with sheet labels.

How do I make Product Labels with Sheet Labels?

As mentioned earlier, sheet labels are the best options when it comes to printing product labels. Ands since they are compatible with inkjet and laser printers, you can easily print them at home or in the office.

1.

Measure the product

rulers

Source: Unsplash

It’s a good thing to know the dimensions of your product, not just because of packaging restrictions, but also for product labeling. 

When you have the product at hand, the best thing to find the right label for it is to cut out a mock-up label with paper and try it out on your product. Sheet labels are pre-cut, so it’s better to try them out with paper cut-outs first before purchasing those labels. 

2.

Choose the Right Label

When choosing the right label, make sure you consider three things: size/shape, finish, and application. Label sheets come with labels of different sizes and even shapes when customized. 

For the finish, you can choose between matte or glossy. A glossy finish makes color pop out, while a matte finish creates a classic, faded effect on your label. 

When you are creating products that are meant to be wet (soap, shampoos, etc.), you should opt for waterproof labels. 

3.

Take note of Legal Requirements

Take note of the policies governing the proper labeling of products, especially for sensitive products such as food and cosmetics. Make sure tp look up the requirements in creating proper labels for these types of products. 

4.

Complete Your Label Information

To start creating your label, make sure you have all the following information: 

  • Product Name
  • Company Logo 
  • Product Details, e.g., Ingredients, Nutrition facts
  • A short Product Description/ Product Story

5.

Design your Label

With all the info you have on hand, you can start designing the label from scratch, or you can use templates. There’s nothing wrong with starting with templates; using them can even make your design process easier. Just remember these pointers when designing your label:

  • The label should display your brand message
  • The label should be appealing to target customers
  • Keep the label clear and easy to read
  • Don’t overdo your label; always leave some white space

Also, consider using online tools such as Canva, where you can create labels for free and come with templates that you can start with. You can also go with software like Adobe Photoshop and Illustrator if you want a higher degree of control when it comes to designing your label. 

6.

Choose Your Fonts & Graphics

font-and-graphic

Source: Unsplash

You can find commercially available fonts, clipart, and graphics available online. Just make sure that they’re allowed for commercial applications when you use them. Default and pre-installed fonts are a big NO in product labeling, as they can make your labels look cheap. 

Finally, you can try out your product label and see how it looks in print. This is a good practice because most of the time,  what you see on screen is not really what comes out in print.

How Do I Make a Sheet of Labels in Word?

You can make the most of Microsoft Word using templates dedicated to your sheet label. At enKo Products, we provide templates for every label, available in different file types, namely .psd, .ai, .pdf, .doc, and .odt, so you can create labels with any software you might be using. 

Here is how to print labels in MS Word:

  1. Download and open the .doc template for your specific label.
  2. Fill out the spaces allocated for each label.
  3. Click Ctrl+P or click on the Print button. A dialog box will appear.
  4. Double-check your printing settings for the following:
    1. Select the correct printer.
    2. Check your paper size. 
    3. Set the margins to ‘None.’

This method is effective with labels such as barcode labels, product labels, and other types that can be easily created by copying the details into each label. 

Address labels, on the other hand, can be created and printed easier using Mail Merge in Microsoft Word or using the Labelmaker Plugin for google Docs. These procedures are discussed below. 

Sheet Labels

: 440 (110 sheets)
: 3-1/2″ x 5″
: Deskjet & Laser Printers

How Do I Make a Sheet of Labels With Different Addresses? 

To create address labels with different addresses, you can do it either in Microsoft Office using MS Excel and Word, or Google Docs and Google Sheets. Here’s how:

How Do I Make Labels From an Excel Sheet?

Using Microsoft Excel and Microsoft Word, you can use the Mail Merge Function to create address labels. Follow these steps:

1. Prepare your Excel Spreadsheet for data merge. Make sure that your sheet has the following:

    • Each column has a heading. This will make arranging info easier and more convenient later. 
    • All data needed is on the first sheet. 

2. Open Microsoft Word and create a new document. 

3. Go to Mailings, then click on Start Mail Merge, and select Labels.

4. Choose your label supplier in the Label vendors list, and select the product number of your label. Click Ok.

5. The document will then display the gridline of the labels. 

6. Save your document.

7. Click on Mailings, and then click on Select Recipients, and then Use an Existing List

8. This will open a dialog box. Navigate to your Excel File, and then click OK.

9. Go to Mailings, and click Address Block to insert an address. For mailing details, click on Insert Merge Field and select the other fields. 

10. Arrange and format the information according to your desired layout. 

11. Click on the Mailings tab again, and then Update Labels.

12. Click on Preview Results to see how it looks. You can edit the label again and click on Update Labels to have the changes updated. 

13. Once done, go back to Mailings, click on Finish & Merge, and finally Print Documents.

How Do I Make Labels From Google Sheets?

Creating address labels in Google Sheets is a bit similar to creating labels in Microsoft Excel, but for Google Sheets, you will be needing a plugin.

google-sheet-form

<Writer’s Photo>

  1. Go to the Google Workspace Marketplace, and install Labelmaker
  2. Once installed, open your spreadsheet for the data, and make sure they are also organized with headers for each column. 
  3. In Google Sheets, click on the Add-ons > Create & Print Labels- Avery & Co > Create labels.
  4. A sidebar will appear, then choose the label sheet being used. 
  5. Click on the drop-down of Add merge fields. Select the details to include want to include in the labels. 
  6. In the Label Content Space, you can see the format of your label. Arrange and format them according to your liking. 
  7. Once done, click Create Labels > Open Document. This will display your labels prepared in google Docs, ready to print. 
  8. Check for the correct paper size, set the margins to None, and set the scale to 100%, then hit Print.

Wrapping Up

To check out the most affordable compatible sheet labels without compromise in quality, check out enKo Products Avery Compatible Sheet Labels. We have a variety of sheet labels to choose from, with applications from shipping, address, posting, warehouse, etc. You can save up to 80%, plus all products come with a 2-year warranty and reliable customer service. 

Looking for more guides on sheet labels? Check out our other in-depth guides:

Like & follow our social media pages to see more updates and promotions !

Leave a Reply