Labels and names in Excel are used to identify cells in Excel that have specific information. If you use labels, you don’t have to refer to a cell by its code name, like B5 or C6. You can simply set a specific name for a cell and then use it as a reference.
But the problem is that most users don’t know how to create labels in Excel. Read this detailed guide to find answers to all your questions about creating labels in Excel.
1. How to Create Labels in Excel by Using Templates
Creating labels in Excel is very easy. All you have to do is have a workbook in your Excel file and then follow the steps mentioned below. Remember, to create labels in Excel by using templates, you will need to have a stable internet connection so the labels can be loaded in Microsoft Excel.
Let’s read the steps mentioned below to find out how to create labels in Excel.
Step 1: You will have to open a workbook in Excel. You can either open an already-made workbook in your Microsoft Excel or create a new book and edit data in that book. Here, in this example, we will open an already-made workbook that has multiple rows and columns of data.
Step 2: Once you have opened the file, select all the data available in the sheet by pressing Ctrl+A or click on the upper left corner of the sheet between column A and row 1.
Step 3: Go to the Mailings tab on the upper header of the Excel workbook, and in that option, select Start Mail Merge. Inside that option, you will see Labels. Click that option, and you will be taken to another window.
Step 4: From this window, update the settings you want to update and then select OK.
Step 5: This will add labels to the Excel file into the workbook. To link the labels from the existing file in Microsoft Excel, you will have to go to the same Mailings tab, but now you will have to click Select Recipients by using an existing list.
Step 6: The prompt will ask you to select an Excel file from the directory. Select the file and click Open to open the file.
By following these steps, you can create labels in Excel from already-made templates. This is an easy way to create labels in Excel. To find out how to do it on Windows and Mac devices, read the below paragraphs.
2. How to Create Labels in Excel on Windows
Step 1: To export labels from Microsoft Excel to Word, you will have to go to MS Word main screen and open a blank document.
Step 2: After opening a document, you will have to go to the Mailings tab on the upper header.
Step 3: In the mailings tab, you will find the Labels option. Click this option.
Step 4: After clicking the Labels option, you will see another window popping on the screen. Select the product number from the window and click OK.
Step 5: Now you will have to select the recipients from inside the mailings tab.
Step 6: To select recipients, click on the Use Existing List to open a file with recipient data.
Step 7: From the files, select the Excel file you want to open. In our case, this will be the test file.
Step 8: Now that you have opened the file in Microsoft Word, go to the Mailings tab and click Update Labels to update all the labels in the file.
Step 9: After updating the labels, click Finish & Merge from the same tab to finalize the settings and save the file on your PC.
Updating the labels will make your file ready to go. Just save the file, and you will be set to use it however and whenever you want.
3. How to Create Labels in Excel on MacOS
Step 1: To create labels in Microsoft Excel on MacOS, you will have to first open a blank file. From the Mailings tab on the upper most header, go to the Start Mail Merge and then select Labels.
Step 2: This will take you to a new window where you will have to select the label supplier in the Label Products list. Also, choose the Product Number on your package of labels. Then select OK.
Step 3: Now go to the Select Recipients in Mailings tab and select an option you want to choose, then press OK.
Step4: Now go to another option named Insert Merge Field from the Mailings tab.
Step 5: After updating the labels, you can preview the results on your screen. To do this, press the Preview Results option from the Mailings tab.
Step 6: If the labels look as you want them to be, click Finish and Merge inside the tab and click Print Documents.
Doing this will print the label documents you want to print. To print, you can also go to the File option and select Print from the options. It will also print the documents you want to print.
Free Office Suite for Word, Excel, PowerPoint ——WPS Office
WPS Office is a free, comprehensive office suite that provides alternatives to Microsoft Word, Excel, and PowerPoint. It offers a range of powerful tools for word processing, spreadsheet management, and presentation creation, making it an excellent choice for individuals and businesses looking for cost-effective alternatives.
Here's how WPS Office compares and excels in various aspects, including data-related tasks:
1. Data Cleaning:
WPS Office includes a spreadsheet program called WPS Spreadsheets, similar to Microsoft Excel. It offers functions and tools that can be utilized for data-cleaning tasks. You can filter, sort, and remove duplicates within your data.
2. Substring Extraction:
When it comes to extracting substrings from text data, WPS Spreadsheets provides functions such as MID and LEFT/RIGHT, which allow you to extract specific portions of text based on character positions. These functions are valuable for parsing and manipulating text data, such as extracting dates, names, or other relevant information from a larger string.
3. Data Transformation:
WPS Spreadsheets support various mathematical and logical functions that facilitate data transformation. You can perform arithmetic operations, apply conditional formatting, and utilize functions like IF, SUMIF, COUNTIF, and more.
4. Improved Data Manipulation:
With its spreadsheet program, you can create and manage complex datasets easily. The suite supports a wide range of data formats, making importing and exporting data from different sources convenient. Additionally, the suite's compatibility with Excel files allows for smooth collaboration with users who might be using Microsoft Office.
How to Download WPS Office?
Step 1: To download WPS Office Suite, you will have to first go to the WPS Official website by following this link: wps.com.
Step 2: On the homepage of this website, you will find multiple options to download WPS Office. One option will be on the upper right corner while the other will be on the middle of homepage screen.
Step 3: If you want to download WPS Office for other devices, including Windows, Mac, Android, or iOS, you can scroll further and find the options to download WPS Office for any device you want.
Step 4: After you have clicked the Download button, you will find WPS Office being downloaded in the side panel. Wait for the download to complete.
Step 5: You can then locate the downloaded file on your device. To install WPS Office, you will have to right-click the installation file and click Run as Administrator to start the installation.
Step 6: Check the box demanding that you agree to the WPS License agreement and click Install Now.
Step 7: WPS will start downloading some files from the server and will automatically start the installation process. Once the installation is complete, you can open WPS and start working on it.
By following these steps, you will be able to download and install WPS Office Suite on your device. Once you have installed the application, open it and start working on it as you want.
FAQs about creating labels in Excel
Q1. How to deal with the missing mailing tab problem when creating labels in excel?
If you can't find the "Mailings" tab in Excel, it might not be visible by default. You can enable it by following these steps:
Go to "File" > "Options."
In the Excel Options dialog box, select "Customize Ribbon."
Check the box next to "Mailings" under the right column ("Main Tabs"), then click "OK."
Q2. What to do when the label options dialog box is not showing up?
If clicking on the "Labels" button does not open the Label Options dialog box, try this:
Check if you have installed any required add-ins or plugins related to labels. Install them if needed.
If the problem persists, try restarting Excel and attempting to access the Label Options dialog box again.
Q3. Do creating labels in Excel help officers in customizability?
Excel allows you to customize labels according to your specific needs. Therefore, you can design labels with different fonts, colors, and sizes, as well as add logos or other graphics to create a more personalized look.
Thoughts
In this article, we have seen how to create labels in Excel using multiple methods. We saw how to do it for Windows as well as Mac devices. All the options we used to create labels are also available in the WPS Office Suite.
The only difference is that WPS Office is free to use, while you will have to pay a subscription fee to download and use Microsoft Excel. That’s why we recommend you download WPS Office Suite for free and start using it as a better alternative to MS Office.
