Catalog

How to Create Labels in Word Using WPS Office (Step-by-Step)

August 16, 2023 5.0K views

When the world started its digital transformation, one of the first things to get off the market was traditional mail. Yet, the potential of mailing goes beyond just letters. Mailing with labels empowers users to seamlessly incorporate external information, crafting documents primed for postage.

In this article, we will learn how to create labels in Word using WPS Office, exploring their utility not only in conventional mailing but also as a means of brand labeling.

How to Create Labels in Word Using WPS Office

Creating labels in Word using WPS Office is a simple and convenient way to design and print your own labels for various purposes. In this section, we will show you how to create Avery labels in Word using WPS Office by setting up a Word document, adjusting margins, inserting a table, utilizing Mail Merge, and arranging fields for clean, professional labels in a few simple steps:

Step 1: Open WPS Office and create a sheet with the names, addresses, states and zip codes of your recipients. Save this sheet as a CSV file in a location you can access later.

Step 2: Create a new word document in WPS Writer to make labels.

Step 3: Go to the Page Layout tab and click on “Margins” in the ribbon menu.

Step 4: In the Margins drop-down menu, select “Narrow”.

Step 5: Now select “Size” in the ribbon menu and click on the “More Paper Sizes” option.

Step 6: The Page Setup window will pop up. Go to the Paper tab. We will be setting the paper size as 20cm x 20cm. In the width and height fields enter 20cm. Make sure the scale is set in cm.

Step 7: Now go to the Margins tab and set the top, left and right margins as 0.5 cm and bottom margin as 1.5 cm.

Step 8: Next we will be making guidelines. Go to the Insert tab and click on “Table” to insert a table of 4 x 3 cells in our document.

Step 9: Now we have to set the table properties. Go to the Table Tools tab and click on “Table Properties” in the ribbon menu.

Step 10: Go to the Row tab and set the height of the rows as 3.30 cm. Make sure the box labeled "Specify height" is selected.

Step 11: Go to the Column tab next and set the width of the column as 6.40 cm.

Step 12: Go to the Reference tab and click on “Mail Merge” in the ribbon menu.

Step 13: Click on “Open Source” and browse for the spreadsheet saved in step 1 with labels data.

Step 14: In the ribbon menu, click on the “Insert Merge Field”.

Step 15: Add all the fields from the spreadsheet: name, address, state and zip. Select each field and click on Insert for each field and close the pop up.

Step 16: Now arrange each field in separate lines within each cell of the table.

Step 17: Select all text using cursor and go to the Home tab to change the font style and font size as you wish.

Step 18: Copy and paste the selected text to each label section in our table.

Step 19: Now go to the Mailing tab again, and click on “View Merged Data” to view the actual names, addresses, and others that were exported from the labels spreadsheet.

And there you have it—your very own personalized Avery labels have been created with WPS Office, ready to be printed and shared with everyone.

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

Advanced Create Labels in Word

Creating Address Labels

If you want to create address labels in WPS Office, you can use WPS Writer, a word processor that can handle various types of documents, including labels. You can also use a spreadsheet that contains the names and addresses of your recipients as a data source for your labels. This way, you can create personalized and professional-looking labels for mailing, shipping, or organizing purposes. Here are the steps to follow:

Step 1: Open WPS Office and create a spreadsheet with the names and addresses of your recipients. Save this spreadsheet as a CSV file in a location you can access later.

Step 2: Open WPS Writer and create a new document for your labels.

Step 3: Set the Page settings, Margin settings and insert a table.

Step 4: Adjust Table rows and columns.

Step 5: Go to the Reference tab and click on Mail Merge > Open Source. Browse for your CSV file that contains the names and addresses of your recipients.

Step 6: Go to the Reference tab and click on Mail Merge > Insert Merge Field. Select the fields you want to add to your labels, such as name, address, state, and zip code. Arrange each field in separate lines within each cell of the table.

Step 7: Go to the Home tab to format your labels as you wish. The font style, size, color, alignment, and other features are all editable.

Step 8: If you want to add a background image to your labels, go to the Page Layout tab click on Page Color > Fill Effects > Picture or Texture > From Picture. Browse for your image file and apply it to your labels.

Step 9: Go to the Reference tab and click on Mail Merge > View Merged Data. This will show you how your labels will look with the actual data from your spreadsheet. You can save your document for later use or print it directly.

Creating Avery Label

WPS Office is a free and powerful office suite that can help you create various types of documents, including labels. One of the easiest ways to make Avery labels using WPS Office is to use one of their pre-built templates. Here are the steps to follow:

Step 1: Open WPS Office and click on “New” in the navigation panel.

Step 2: Using the search bar, search for “Avery labels”.

Step 3: Select the template of choice from the results. You can choose from different label sizes, shapes, and formats.

Step 4: Download the template to edit and personalize.

Step 5: Edit the template using various editing tools provided by WPS Office. You can customize your labels with fonts, colors, images, logos, and more.

Step 6: Save your personalized Avery template for future use or print it directly.

Now that you know how to create Avery labels using WPS Office, you can use your newfound skills to create professional-looking labels for a variety of purposes. Whether you need to label your home inventory, create mailing labels, or make custom gift tags, WPS Office has you covered.

Best 3 Simple & Beautiful Avery Label Templates Free Download

The term "label" encompasses a wide range of possibilities, with various types tailored for different needs. Avery labels, in particular, often take the forefront of this concept. WPS provides a remarkable selection of Avery label templates, offering an exceptional avenue to enhance your brand representation. Here are three illustrative examples that highlight the potential of WPS Avery templates.

1. Simple Coco Label

The minimalist "Coco Label" is an excellent choice for any brand aiming to introduce products with a cocoa essence. Its versatility extends to various product categories, ranging from food items to skincare products. This label offers limitless possibilities, allowing you to expand your product line under its branding. With a few personalized tweaks, you can even make it uniquely your own, making it a valuable asset for your brand.

2. Fresh Apple Label Card

The "Fresh Apple" label card is an excellent option that can be customized for effectively marketing your farm's homegrown apples. Not only can it be used for packaging purposes, but it can also serve as a branding sticker to promote your unique farm brand. Interestingly, the "Fresh Apple" label doesn't have to be solely about the actual fruit; it can also be marketed as an apple-scented product, such as candles, mists, or other scented items. This versatile label design offers creative opportunities beyond just the fruit itself.

3. Brown Vintage Bottle Label

The purpose of the brown vintage bottle label is to serve as a decorative sticker for bottles. Although the initial use might appear limited, its value extends significantly due to the vintage design. You can employ this label for beverages aiming to emphasize the organic origin of their ingredients or any other product with a vintage appeal.

Microsoft Office Compatibility in WPS

Transitioning from Microsoft Office to WPS Office is remarkably seamless and hassle-free. The process is incredibly accessible, and you'll encounter minimal compatibility concerns. Moreover, a noteworthy advantage is the seamless conversion to PDF format without any compatibility hiccups. With WPS Office, editing Word documents using Writer, as well as other productivity tools, is an effortless endeavor.

Why Use WPS

WPS Office is an impressive office suite that stands shoulder to shoulder with Microsoft Office 365, and its growing popularity suggests it might surpass it in significance soon. WPS Office offers the same robust features as Office 365, all completely free of charge. Whether it's creating mailing labels or editing templates for your brand, WPS Office provides versatile solutions that cater to your needs.

FAQs

Q1. Can you print Labels on the WPS Office?

Absolutely, you can print labels using WPS Office. This versatile software suite offers various tools, including a word processing application, which can be used to create and print labels.

Q2. How do I turn a mail merge into Labels in Word?

Step 1: Create a new Word document > go to Mailings tab > Start Mail Merge > Labels

Step 2: Choose label type and size > OK

Step 3: Select Recipients > Use an Existing List > browse for data source file > Open

Step 4: Select sheet with data > check First row of data contains column headers > OK

Step 5: Insert Merge Field > select and arrange fields in first label > Update Labels

Step 6: Preview Results > make changes if needed

Step 7: Finish & Merge > Print Documents > choose records and printer > Print

Effortless Label Creation with WPS Office

This article offers a comprehensive guide on how to create free printable labels. While this feature is present across various productivity tools, the remarkable intuitiveness of WPS Office, coupled with its user-friendly interface, makes accessing and utilizing the labeling functionality a seamless and straightforward endeavor. Enhance your experience by downloading WPS Office today.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.