WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to Print Address Labels from Excel Spreadsheet in WPS Office

November 23, 2023
3.8K Views

Creating address labels in WPS Office is not only practical but also efficient. In just a few simple steps, you can streamline your label printing process. Let's delve into the world of WPS Office and unleash the potential it holds for effortless label creation.

Part1: What is an address label? 

address label in WPS


 

An address label is a small, adhesive piece of paper or plastic that is used to identify the sender or recipient of a mail item. It is typically affixed to the front of an envelope or package, and contains the recipient's name, address, and other relevant information, such as the sender's return address.

Daily usage of address labels

Address labels are used for a variety of purposes, both personal and professional. Some common uses include:

  • Mailing letters and packages: Address labels can be used to quickly and easily apply the recipient's address to mail items, saving time and effort.

  • Shipping products: Businesses often use address labels to ship products to customers. This helps to ensure that the products are delivered accurately and efficiently.

  • Sending out invitations and announcements: Address labels can be used to quickly and easily address invitations and announcements, making it easy to keep track of who has been invited.

  • Labeling packages and storage containers: Address labels can also be used to label packages and storage containers, helping to keep things organized and easy to find.

Company's address labels and individual address labels

Company address labels typically contain the company's name, address, and logo. They are often used for business correspondence, such as letters, invoices, and shipping labels.

Individual address labels typically contain the individual's name, address, and phone number. They can be used for a variety of purposes, such as mailing personal letters, shipping packages, and labeling belongings.

Address labels are a convenient and efficient way to address mail and packages. They are also a cost-effective way to save time and effort.

Part 2: 2 Easy Methods to Print Address Labels from Excel Spreadsheet in WPS Office

Printing address labels from an Excel spreadsheet in WPS Office is a straightforward process, offering two convenient methods: Using WPS Writer and Using WPS Spreadsheet Page Layout.

Method 1: Using WPS Writer

Step 1: Open WPS Writer and Excel Spreadsheet

Commencing with opening both WPS Writer and the Excel spreadsheet is a straightforward initiation, ensuring users have the necessary documents ready.

Step 2: Select Data Range in Excel

Instructing users to highlight the data range in Excel streamlines the process, providing clarity on the specific information that will be utilized.

Select range


 

Step 3: Copy Data in Excel

Copying the selected data from Excel is a standard yet essential step, and your guide covers it succinctly.

copy data


 

Step 4: Paste Data in WPS Writer

Guiding users to paste the copied data into WPS Writer is a seamless transition. It maintains the continuity of the process without unnecessary complications.

Paste data


 

Step 5: Insert Table in WPS Writer

The inclusion of a table in WPS Writer is a practical step, allowing users to organize and format the data effectively within the document.

Insert table


 

Step 6: Adjust Layout and Styling

Your emphasis on adjusting layout and styling within WPS Writer adds a personalized touch to the labels, contributing to a more professional appearance.

Step 7: Print Labels

Concluding with the step to print labels is the logical endpoint. This method using WPS Writer is user-friendly and efficient.

print labels


 

This method is a good option for beginners because it is relatively simple and straightforward. It is also a good option for printing large numbers of labels, as it can be automated using the mail merge feature.

Method 2: Using WPS Spreadsheet Page Layout

Step 1: Open WPS Spreadsheet and Excel Spreadsheet

Similar to the first method, starting by opening both WPS Spreadsheet and the Excel spreadsheet ensures users have the necessary files accessible.

open spreadsheet


 

Step 2: Select Data Range in Excel Spreadsheet

Repeating the instruction to select the data range from the Excel spreadsheet maintains consistency with the previous method.

Select range


 

Step 3: Copy Data in Excel Spreadsheet

Copying the selected data from the Excel spreadsheet is reiterated here, reinforcing its importance in the process.

Step 4: Paste Data in WPS Spreadsheet

The process of pasting data into WPS Spreadsheet is presented coherently, ensuring users can easily follow along.

Select paste


 

Step 5: Adjust Page Layout

The emphasis on adjusting the page layout within WPS Spreadsheet is a crucial step, contributing to the visual appeal and organization of the labels.

Page layout


 

Step 6: Print Labels

Concluding with the step to print labels from WPS Spreadsheet is a logical endpoint for this method. It's a concise and clear guide to completing the task.

Print labels

 

This method is a good option for experienced users because it gives you more control over the layout of the labels. It is also a good option for printing small numbers of labels, as it does not require you to use the mail merge feature.

Differences between the 2 methods:

  • The first method uses the mail merge feature in WPS Writer to print the labels. This method is relatively simple and straightforward, and it can be automated to print large numbers of labels.

  • The second method uses the Page Layout tab in WPS Spreadsheet to print the labels. This method gives you more control over the layout of the labels, and it is a good option for printing small numbers of labels.

Which method is quick and simple?

The mail merge method is the quickest and simplest method for printing address labels.

Part 3: Why Choose WPS Office for Your Work?

WPS Office logo

 

Printing address labels can be a challenging task. You might be dealing with different sizes of labels, various formats, and perhaps even multiple addresses. It can be time-consuming to manually enter each address, and formatting them correctly can be tricky.

That’s where WPS Office comes in. This free office suite is fully compatible with Microsoft Office, allowing you to open, create, and edit Word, Excel, and PowerPoint files with ease. But more than that, it also supports a variety of other file formats, including PDF, TXT, and HTML.

Here are 3 reasons why you should choose WPS Office for your work:

  1. Feature-rich:

    A variety of fine label templates, including free types

    Compatibility with Excel, and the ability to print directly

    A user-friendly interface

    Collaboration features, such as the ability to co-edit documents with other users

  2. Lightweight and fast: 

    WPS Office is a lightweight and fast office suite, which means that it will not take up a lot of space on your hard drive or slow down your computer.

  3. Available on a variety of platforms:

    including Windows, Mac, Linux, Android, and iOS.


How to Download and Install WPS Office

To download and install WPS Office, follow these steps:

Step 1: Go to the WPS Office website: https://www.wps.com/download/

Download WPS

 

Step 2: Click on the Download button for the version of WPS Office that you want to download.

Step 3: Once the download is complete, double-click on the downloaded file to start the installation process.

Step 4: Follow the on-screen instructions to complete the installation.

WPS installing

WPS installing

 

Once WPS Office is installed, you can launch it by double-clicking on the WPS Office icon on your desktop.

WPS Office is a great alternative to Microsoft Office, especially for users who are looking for a free and open source office suite. WPS Office offers a wide range of features, including compatibility with Microsoft Office, a user-friendly interface, collaboration features, and a variety of fine label templates. WPS Office is also lightweight and fast, making it a good choice for users with older computers.


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

FAQS:

1.Can you print address labels from an Excel spreadsheet?

Yes, you can print address labels from an Excel spreadsheet. WPS Office provides a user-friendly environment for this task. Simply open either WPS Writer or WPS Spreadsheet, import your Excel spreadsheet containing the addresses, and follow the label printing options available in the respective application. The process is intuitive, allowing you to customize label settings and print directly from your Excel data.

2. How do I mail merge from Excel to WPS?

To perform a mail merge from Excel to WPS, follow these steps:

Step 1: Open WPS Writer and start a new document.

Step 2: Navigate to the "Mailings" or "Mail Merge" tab, depending on your WPS version.

 mail merge

mail merge

 

Step 3: Select "Start Mail Merge" and choose the type of document you want to create.

Step 4: Click "Select Recipients" and choose "Use an Existing List."

Step 5: Browse and select your Excel spreadsheet with the recipient data.

Step 6: Insert the merge fields into your document where needed.

Step 7: Preview the merge, and if satisfied, complete the mail merge process to generate personalized documents.

Summary

This guide demonstrates the simplicity of printing address labels from an Excel spreadsheet using WPS Office. It provides a detailed walkthrough of two user-friendly methods using WPS Writer and WPS Spreadsheet, complete with step-by-step instructions and visuals. WPS Office offers diverse label templates and smooth compatibility with Excel, making it an ideal choice for this task. The guide also recommends the best method for beginners based on practical experience. So, if you’re looking for an efficient way to print address labels, WPS Office is a versatile and straightforward choice.


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