Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
Print Labels From Excel (Table of Contents)
How to Print Labels From Excel Spreadsheet?
The format of the excel spreadsheet is helpful in storing, managing, and printing the labels of the contact details. After the arrangement of data into the rows and columns properly into the sheets, the data can be used for many tasks with the help of the Microsoft applications. With the help of mail merge feature in Microsoft Word, one can easily print the details directly to the labels from the excel sheet. It is also presented with a feature of creating multiple customized labels for data.
Explanation of Print Labels from Excel
Printing address labels in excel is a very easy task. It works associatively with the Microsoft word to create and print the labels. We can use the number of label templates presented in the word to avoid recreation. In printing labels, we need to focus mainly on the mail merge process. This involves the configuration of the main document for mailing labels. It is done at a time in using the mail merge for all labels. There are two ways to do mail merge in a word document.
- In the first method, the ‘mail merge wizard’ is used. It supports the beginners through step by step procedure
- In the second method, the mailings ribbon group’ option is used.
Use Print Labels From Excel
Print label option in Excel used for various purposes. It saves a lot of time to the users in the arrangement of data and convenience in printing data presented under the single label or multiple labels. The following steps are to be followed to the creation of labels and printing them as shown in the figure.
As described in the figure, the steps should be followed clearly to create and use the labels effectively. These steps are the same for all versions of Excel from 2007 to 2016. Each step described is further required to follow the sub-steps to print the labels.
Examples of Print Labels From Excel
In excel, labels are printed in two ways. The following examples illustrate the use and print labels from excel sheet.
Method #1 – Print Address Labels from Excel with the Help of Word
Step1: In the first step, the data is arranged into the rows and columns creating the headers as shown in the figure.
As shown in the figure, header columns are created as Customer ID, Title, First Name, Last Name, Date of birth, Address, city, and state.
Give a name to the data presented in the excel sheet in the following way:
Select the list of addresses in excel sheet including the header.
Go to “Formulas” tab and select “Define name” under the group “Defined Names”.
A dialog box called a new name is opened. In that give a name and click on “OK” to close the box.
Step 2: Create the mail merge document in the Microsoft word. Place the cursor over the Mailings tab and select the ‘Start mail merge’ option then, choose the labels option as shown in the figure.
Then, the label options dialog box is displayed as shown in the figure.
Click on the Details tab to preview the label properties.
Here, we can change the margin, height, width, pitch, and size of the label and width, height, and size of the page. Click on ‘OK’ after making the required changes. Then, the page is displayed as shown in the figure.
Click on the Design tab to add table styles to the labels. The appearance is changed as shown below.
Step 3: Link the labels from the existing list from Excel to the mailing list.
Go to Mailing tab and choose “Use an Existing List” option from the select participant’s category.
It displays the ‘select data source’ dialog box shown in below screenshot.
Choose the Excel sheet in which the table created is presented and click on open.
Choose the table name and click on the “ok” button.
Then, the page is displayed as shown in the figure.
Step 4: Arrange the labels into the table.
Place the cursor in the first record of the table and insert the labels. To do this click on the “Insert Merge Field” button.
Click on each label one by one. While inserting the labels focus on the arrangement of labels and press “Enter” to add a label to the next line.
Next, click on “update labels” option to apply the same format to remaining records of the table. Then, the page is displayed.
Go to Finish and Merge and choose the option “Edit Individual Documents”.
Enter the record numbers from 1 to 12 (varies based on the table size in the excel sheet) to merge the data to the labels to the new document.
It will be displayed as given below.
Step 5: Print the labels
To print the labels, go to print option in excel File Menu.
The Labels are printed as shown below.
Method #2 – Print Single Address Label from Excel without Word
Step 1: Use the excel sheet which has a tiny macro to rearrange the column data to the printable address labels.
Step 2: Enter data into column A.
Step 3: Press CTRL+E to start the excel macro.
Step 4: Enter the number of columns to print the labels.
Then, the data is displayed.
Step 5: Set the custom margins as top=0.5, bottom=0.5, left=0.21975, and right=0.21975.
Step 6: Set scaling option to “Fits all columns on one page” in the print settings and click on print.
Things to Remember
- Don’t forget saving a label created for reports and invoices. It supports in use of the labels in the future.
- Using the labels templates in word saves a lot of time in creating and printing labels
- Make ensure that excel sheet doesn’t present any empty cells, rows, and columns to avoid inappropriate results while merging in Word document
- Create individual columns for the first name, last name, and title headers instead of one to segregate the recipient information.
This has been a guide to Print Labels From Excel. Here we discuss how to print address labels from excel with and without MS Word along with some examples and downloadable excel template. You may learn more about excel from the following articles –