Want to know all the tips and tricks on making your sheet labels? In this guide, we will deliver guides on how to print with different tools, namely Microsoft Word, Microsoft Excel, Google Docs, and Google Sheets. Here is a complete guide in printing your sheet labels. 

Sheet-Label

Sheet labels are basically ready-to-use labels on printer paper sizes. However, they are used in many applications, given that they have the advantage of being printed on color with inkjet and laser printers. 

Sheet labels are the best option for printing product labels. However, sheet labels are also used for other small labels and are the best options to print labels when you’re starting, and you have an office printer ready. Other common label applications for sheet labels are printing address/ mailing labels, barcode, shipping label, packaging, and others.

We will be going through steps on the most common things you can print with sheet labels.

How do I make Product Labels with Sheet Labels?

Product labels are the best things you can get with sheet labels. Since sheet labels are used with inkjet and laser printers, you can maximize your printer’s capability when creating your product label. 

1.

Measure the product

rulers

Source: Unsplash

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

When you have the product at hand, the best thing to find the right label 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

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

For the finish, would you go for a matte or a glossy finish? A glossy finish makes color pop out, while matte finish labels create a classic, faded effect. 

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

Depending on your product, take note of the policies with regards to proper labeling of products. Especially for sensitive products such as food and cosmetics, 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, 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:

    • 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, make the best use of online tools such as Canva, where you can create labels free, and come with templates 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. 

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 use when you use them. Default and pre-installed fonts are a no-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?

Sheet Labels

: 1,000 (100 sheets)
: 2″ x 4″
: Deskjet & Laser Printers

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 is effective with labels such as barcode labels, product labels, and other label 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. 

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