Quick Guide To Printing Labels From Excel - Step By Step Tutorial

In this video, I talked about how you can easily print your customer name, addresses or other demographics details onto a label quickly with the help of Excel. This is the fastest way to generate multiple labels in few seconds.

We also talked about that how you can customizing the label setting to print the labels from your excel address list as people may buy different size labels and need different setting. Hence we covered how you can browse excel address list into Microsoft word Mailing merge to create labels from Excel.

You can easily filter out the specific city, country labels from your excel list without doing any modification in excel. Also we explained how you can add greeting lines on your labels.

Lets learn how you can create labels from Excel address list in the easiest way. Below are the steps and time stamps which we covered in this video

00:00 Printing Labels from Excel
01:16 Adjusting word layout for labels creating
02:33 Printing Labels through Mail Merge
03:36 Importing Excel List into Mail Merge
03:57 How to check which labels are available
04:50 Label Size Settings and Custom Label Setting
06:54 Sort or Filter Labels
07:40 Edit Recipient List
08:15 Label Layout Settings - Adding New Fields
09:18 Label Fields Mapping to Excel Address List
10:00 Applying one label setting to all labels
11:12 Adding Greeting Lines
12:00 Preview Labels before Printing
12:30 Printing Labels from Mail Merge

Few more videos which may help you to learn more about other Excel Function:

If you wanna support us and want us to write more. You can buy us a coffee from here:

Follow us to get new updates

#msexcel #excellabels #productivitytip

[tylerjuarez]

This video was perfect, helped me get done exactly what I was trying to get done with making labels for inventorying chemicals. With some small adjustments to your instructions, you were able to help me turn a job that wouldve taken up to a month into just 5 minutes on Microsoft Word.
Thank you so much for putting up this video and being so clear and concise.

[mccnyc]

Very clear and helpful and so much better than 4 other videos trying to explain the same process that left out critical steps.

[goodfriendstgllc]

Thank you
💻💻Excellent 🧰Tech-Heads-Up✅
===
✍🏽 Proper Planning Prevents Poor Project Performance...
✍🏽Watching👁👁 👩🏾‍💻 through your eyes ...Excellent video
🗞 📰 One Journey🗺🌎🌍🌏 Let's Make It Count❗
====

[mrhbagsindia]

Amazing. Very helpful and clearly explained

[harshavardhankhare]

Great Video ! Crystal clear instructions and guidance !! Bahut Badhiya !!!