EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools How to Print Labels From Excel
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

How to Print Labels From Excel

By Madhuri ThakurMadhuri Thakur

how to print labels from excel

How to Print Labels From Excel (Table of Contents)

  • Introduction to Print Labels From Excel
  • Steps to Print Labels From Excel

Introduction to Print Labels From Excel

Microsoft Excel is a tool handier than we think and know. It can do a lot of things in a jiffy and without any hassle. It is a tricky job to try printing labels on the paper sizing beyond standard documentation in real life. Believe me, a lot of people are there in the world who are struggling with this issue. However, a proper step-by-step guide and some practice will do the task for you guys. Excel can be way too handy in this regard due to its spreadsheet format, which is ideal for storing contact and address information of the user.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Excel makes life easy in collaboration with Microsoft Word in printing mailing labels. It provides features that can allow you to create labels and preview them before you print. Using the mail merge feature with Microsoft Word, you can do this task neatly and print out the mailing labels with ease directly from Excel.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)

How to Print Labels from Excel?

Let’s see how we can print the mailing labels from Excel with a few examples.

You can download this How to Print Labels From Excel Template here – How to Print Labels From Excel Template

Step #1 – Add Data into Excel

  • Create a new excel file with the name “Print Labels from Excel” and open it.
  • Add the details to that sheet. As we want to create mailing labels, make sure each column is dedicated to each label. Ex. Salutation, First Name, Last Name, Address, City, State, Postal Code these should be the columns, and respective information should be filled in those columns. See the screenshot below:

how to print labels from excel step 1.1

  • As shown in the screenshot, your details should be one entry per column. It helps to manage and print labels properly.
  • Save the file once you are done with entering the data and close the same.

Step #2 – Confirm File Format in Microsoft Word

As I have mentioned earlier, we are going to use an Excel file in Word. It is mandatory to set some file format settings under Microsoft Word so that you can use the excel file in it. Basically, this step helps to have a smooth conversion between Word and Excel.

  • Open a word file. Click > File. Select > Options (placed at the bottom of the left pane).
  • A new options pane will be popped up. Click > Advanced. Under Advanced settings, scroll down to the General settings section.
  • Make sure Confirm file format conversion on open is checked and then click OK. Please see the screenshot below.

how to print labels from excel step 2

Step #3 – Set up Labels in a Blank Word Document

  • In a blank word document, Go to > Mailings, select > Start Mail Merge, select > Labels.

how to print labels from excel step 3

  • A new pane called Label Options will open up. Under that, select Label vendors as Avery US Letter, Product number as 5160 Address Labels. Then, click OK. See the screenshot below.

how to print labels from excel step 3.2

Also, have a look at the button New Label… using it, you can create labels of your own with custom dimensions.

Step #4 – Connect Worksheet to the Labels

Now, let us connect the worksheet, which actually is containing the labels data, to these labels and then print it up.

  • Go to Mailing tab > Select Recipients (appears under Start Mail Merge group)> Use an Existing List. A new Select Data Source window will pop up.

how to print labels from excel step 4

  • Navigate towards the folder where the excel file is stored in the Select Data Source pop-up window. Select the file in which the labels are stored and click Open.

how to print labels from excel step 4.2

  • A new pop up box named Confirm Data Source will appear. Click on OK to let the system know that you want to use the data source.

how to print labels from excel step 4.3

  • Again a pop-up window named Select Table will appear. Click on OK to select the table from your excel sheet for labels.

how to print labels from excel step 4.3

Step #5 – Add Mail Merge Fields

This is the step where your well-formatted column headings will make sense. If you feel you have some labels not assigned proper columns, you can change the same. It’s that easy.

  • Please select the first record from the document and click Address Block (it appears on Write & Insert Fields under Mailings).

how to print labels from excel step 5

  • Select the appropriate format in which you need the recipient’s name to appear. This will allow the first name from our list along with address details to get assigned to that first record.

how to print labels from excel step 5.2

  • Select Match Fields from write & Insert Field.

how to print labels from excel step 5.3

  • Select the appropriate column headings for required fields. Click OK once you are done with it.

how to print labels from excel step 5.4

  • Click on Update Labels that appear in Write & Insert pane.
  • Once you click on the Update Labels, all the names along with address details will be taking positions of each record in the document one by one, and eventually, every record gets updated.

PLE step 5.5

Step #6 – MergeWorksheet and Word File

We are almost done and up-to-the final step of printing named labels for our mailing list. After this step, you will see the mailing labels on a new word sheet and print them.

  • On the rightmost side of the Mailings pane, you can see a dropdown called Finish & Merge. Click on it to see the different options available.

PLE step 6

  • On the dropdown that appeared, click and select Edit Individual Documents.

PLE step 6.2

  • Now, a new pane appears named Merge to New Document. Select All in Merge Records selection and click OK to merge all the information from the excel sheet to the word mailing labels.

PLE step 6.3

  • A new label document will open with all the mailing labels inserted one by one in the format you needed. See the screenshot below.

PLE step 6.4

 

You can give the print of these labels and use them in your mailing. It makes your task pretty easy, isn’t it?

Things to Remember

  • Please make sure you use one column at a time for each label in excel; it will work then and only then.
  • While connecting the word and excel file, make sure the proper column name is selected as a field so that the resulting label will be formatted accordingly and no differences will be found.

Recommended Articles

This is a guide to How to Print Labels From Excel. Here we discuss the Steps to Print Labels from Excel along with examples and a downloadable excel template. You may also look at the following articles to learn more –

  1. Excel Print
  2. Print Gridlines in Excel
  3. Excel Print Area
  4. VBA Print
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download How to Print Labels From Excel Template

EDUCBA

Download How to Print Labels From Excel Template

EDUCBA

डाउनलोड How to Print Labels From Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more