How to print mailing labels from Excel
HTML-код
- Опубликовано: 1 июн 2024
- In this video I show you how print your mailing labels from a list of addresses in Excel. I show you how to check which labels will work with Office.
If you're looking to type directly onto your labels using Word, check out my other video that I'm releasing at the same time:
• How to print mailing l...
Buy the Avery L7160 address labels here:
geni.us/bdOEao
Buy genuine Microsoft Office at Amazon:
Office 365 Personal - geni.us/365Persona
Office 365 Home - geni.us/365Hom
Office 2019 Home & Student - geni.us/Office2019
DONATE - Several viewers have kindly asked how they can support my channel. You're welcome to make a donation through PayPal using this link if you wish. Thanks!
www.paypal.me/davestechrescue
#christmascards
** My gear **
Camera - Canon EOS 700D (Rebel T5i)
geni.us/mVaL
Microphone - Rode Videomic Pro
geni.us/ymKY5R
Laptop - HP Spectre x360
geni.us/OS4d
As an Amazon Associate I earn from qualifying purchases.
Music: www.bensound.com - Наука
this is one of the best you tube video's of any subject description that I've ever watched. Thank you for being clear, concise, and plain.
This tutorial is so incredibly helpful! Thank you so much!! This is the second year in a row I have referred back to your tutorial for help printing my Christmas card labels. I must say the second time around was much quicker given I already had everything set up the way you explained. 10/10!!
This was an awesome tutorial. I tried to print from Excel a few years ago, and I had terrible problems then. This was smooth and easy! Terrific!
I learned, or say was instructed in, Mail Merge over 25 years ago, but now, when I need it, you were there for me, and I so appreciate it! You made it so easy even on my older Word & Excel programs.
THANK YOU! Your instructions were very easy to follow and at the perfect pace for me.
I absolutely love this video. Every year I get a pit in my stomach when I have to print labels for company holiday cards. The directions were easy to follow. Thank you Dave!
I’m happy it helped!
Dave, I come here twice a year for my mailings. Without you, it would not get done. So easy to understand and follow.
Every year my Christmas labels are a nightmare - this year I saved your video and it was a walk in the park!!! thank you so much!!
Every year I forget how to print my labels from Excel. Thank you for helping me print my labels once again!!!!
Saved me. Spent an hour on another tutorial and it never worked. I needed a good Englishman to help sort me out. Cheers Dave!!
Excellent tutorial. He speaks clearly, and moves his cursor smoothly enough I could follow it easily. Again, EXCELLENT tutorial. Thanks!
Thank you for this wonderful step-by-step guide. Very easy to follow, and it worked perfectly the first time. Appreciate your clarity.
I can't thank you enough for making this video! For years and years I have been addressing my Christmas cards by hand, and its such a pain! I was determined to figure out how to make printer labels. You saved me so much time!!! Thank you!!
This tutorial is just what I needed today. Your directions are very clear and at a pace that is easy to follow. Thank you so much for producing this tutorial that is so helpful!
😂
I won't 96 labels per page .how can I do?
Top tutorial !!!!
I wish everything on RUclips was as professional and well explained as this.
I was dreading having to write out hundreds of addresses and this very well structured tutorial has saved me heaps of time.
I will definitely be following this channel from now on.
This is a great tutorial! Dave explained clearly and patiently what to do, and it made creating and printing labels for my Christmas card list so easy! It was vert helpful!
Hey thanks! I loved how you let us know how to adjust the list and it reflects this in the labels doc! Perfect for Christmas Card recipients list as addresses change!
This was tremendously helpful. Thanks so much. Clear and concise and easy to follow. Good job!
Having commented on your Word tutorial, suffice to say that this too was a very easy to follow and clearly explained video tutorial, the flow of the explanation is at such a relaxed pace, and even though I do like to view tutorials twice, there really is no need with the way in which this whole method of address label preparation and printing is illustrated, the delivery as I said previously is first class, thank you so much for your well presented tutorial.
I cannot thank you enough. I have always relied on assistants to do these things and I don’t understand tech at all. And I was actually able to do this following step by step!!!! Really appreciate it.
I spent several hours trying to follow MIcrosoft's Help columns without managing to produce labels. Then I looked at your video and it explained everything. Many thanks Dave.
I have seen a few, but this is easily the best video on printing labels from Excel. Dave is very clear and logical. Most impressed and very well done! !🙂
Thank you so much! I struggle every Christmas to get my labels printed. This is so helpful and I am thrilled to never have to relearn how to do this every year. Merry Christmas!
You are a God among men. I've muddled my way through other tutorials for labels in the past. This one was by far the most foolproof.
Dave, Thanks for a very comprehensive explanation with a couple of tips I didn't know. Something you might like to know is that if you use the Shift Return trick, you can't edit the result because you are left with a large gap in the resultant labels at that position. Also the editing and reuse of the label does depend on you saving the label!
So helpful! I've tried printing labels so many times in the past, and this was my first success! Thank you!
Thank you for this informative and easy to follow instructional video. You just saved me have to type our whole database into labels manually. Super job. xx
Great tutorial. Easy to follow and not verbose as many of these are. Helped me out a ton printing labels for my Christmas card mail out.
I have wasted time trying to learn from other sources how to do this. You're video is the Best! Works well.
"I'm going to save it on the desktop"
Ahhh, I see you are a man of culture as well.
you must be Brit!!!
Ha haaaa! Everything I save gets saved to desktop so this made me laugh!!
Wow! What a great video! Everything that you mentioned was very clear, concise, and paced quite nicely. You even put our minds at ease by covering the quirks that we run across in Word. Again, great job! Bravo! You now have a new subscriber. Well, back to my 2021 Christmas card list. Thanks again and God bless.
Thank you so much! Exactly the instructions I needed and you explain in a way that makes it super easy to follow! Perfect thank you again!
Excellent, comprehensive instructions that covers a few quirks in MSWORD that drove me nuts for years. First, the process used by WORD is not nearly as intuitive as other functions. Also, the need to "insert merge field" has to be used and closed with each field as no mechanism to add spaces or punctuation. Even more helpful is his hint to use SHIFT/ENTER to start new line in label. Without this critical but hidden trick, WORD will space lines too far apart... EXCELLENT help. Finally, the hint to NOT use typical print command in WORD as this will only print first page... Follow tutorial and engage FINISH/MERGE tab to engage printing... great help!!!!
You helped so much letting me do my own labels for my wedding envelopes! It was so confusing trying to figure it out myself-
Thank you very much Dave😀
Perfect presentation. Absolutely the best RUclips tutorial I have ever followed. Thank you!
Third year following your steps, thanks for the clear instructions!!
Really appreciate this!! I was on the phone with Avery and they were not able to help me essentially do what you just showed how to do. Thank you!
Just checked out your tutorial on how to print out labels from excel. Fantastic tutorial and very clear and concise. Saved me a lot of typing them individually. 👍
Well thought out and explained in great detail. Thank you!
An excellent tutorial. The first time I have compiled and printed address labels, using Dave's instructive 'step by step' video I was successful first time. Top class!
This is the clearest and most helpful video I've ever seen on any subject. I spent hours trying to find a way to reduce the space between the lines on an address label. Your hint about Shift/Enter solved the problem. If Microsoft would fix their design flaw, a workaround wouldn't be necessary.
This was perfect. Thank you a million times over!
Exquisitely simple directions! I'm so grateful for the instruction.
You've taught an old dog new tricks! Well done, you! Your instructions are so clear. Thanks so much!!😀
You always cover important subjects and make them understandable....or easily corrected....Thanks !!
Excellent tutorial, Dave. Very well done. I have tried previously to make labels from Excel without success. This is awesome!
Omg THANK YOU SO MUCH for making the task of printing labels for wedding invitations so easy!!!! Very clear and concise instruction! Best video out there on how to mail merge and print!
Happy to hear my video helped! Congratulations :)
This tutorial was awesome and very detailed. Highly recommend it!
Superb!! I'm not very IT savvy but this tutorial was brilliant - a very clear, step-by-step instruction video that even I could understand, with added hints to make life easy!! Many thanks!
Once you get past the mundane business of purchaser and ordering, etc....this was spot on. Thanks for the help mate.
Thank you! This is the best video I have found to walk me through this!
This video was insanely helpful! Thank you so so so much!
What a clear and concise presentation! This is exactly what I need. Thank you!
Awesome. Finally was able to convert the excel data into Word Labels. Thanks so MUCH!!!
Thank you, Dave! Great video. It was clear and east to understand.
I helped a friend today do this and your video was SO helpful. Thank you! My friend has rather minimal computer skills, so I sat next to him at my dining room table with your video on my laptop while he followed the steps on his laptop. Worked great!
I fixed it and completed the labels. You are fantastic!
Your tutorial is just what I had to do today. Thanks for the video Dave. 👍
Very helpful and well done. I love the way you deliver your message. Clear, concise, and at an easy pace. I also like that you've broken up your presentation into easy to find sections. Cheers!
thank you! just printed 80 birth announcements using your video! incredibly helpful!
This was a brilliant and very clear explanation with some small but critically important detail missing from other explanations. Thank you.
Awesome Dave! You have saved my day. Thanks for your clear and precise instructions. Printed my boss's greetings card mailing successfully.
Clear instructions - SO HELPFUL!! Thank you so much!!!!
Thank you so much! Your video was the only one of many, that worked for producing labels i needed from Excel.
So appreciate this tutorial! Quick and easy to follow along!! THANKS
This was so incredibly helpful! I avoided this for a while because I thought the process would be much more daunting. thank you for explaining it in a way that was easy to understand!!
Even though this video is a few years old, it was EXCELLENT for my education. It worked like a champ!
Thank you so much for this. Just what I needed!!
Absolutely what I needed - Thank you!
Great info! Exactly what I needed. Clear and nicely paced. Bravo!
Excellent instructions! Thank you very much! My labels came out perfectly.
THANK YOU! This was so helpful and I appreciate it!
Clear, concise tutorial. Thank you!
Thank you,
Your Presentation is characterized by careful reasoned thinking with heedful anticipation of the needs and wants.
Hi Dave, thank you so much for this video. You saved my bacon at work! Much appreciated.
Extremely helpful and easy to follow tutorial. Much appreciated.
Thank you! This was straight forward and easy to follow. Super helpful!
Really clear Dave. Many thanks.
Thanks Helen 😀
Your easy instructions were indispensable. Thank you so much and keep up the great work!
Extremely clear and made no assumptions about prior knowledge. Many thanks
Very well done. Good attention to detail. Easy to follow and logical presentation. Thank you.
Excellent job, very clear and direct instructions. Very much appreciated.
This is an excellent tutorial! Thank you very much. It is exactly what I needed!
Thank you so much for creating this video! Your step-by-step directions were perfect!
Thank you so much. I could not have done it without you!
Thank you! This was very detailed, helpful, and easy to follow.
Super helpful. in 5 minutes i had my labels printed. thank you so much.
You saved my wedding invitation process!! I was afraid to even try but writing an address on each one wasn't worth the hassle. Thank you! I'm saving this to my favorites!
Nice job, Dave. I print labels so infrequently that I'll bookmark this and come back to it. again.
This was so clear and to the point. Excellent video 😊
Very helpful! Great directions. I watched this 2 years ago with great success, so I came back for a refresher (and I'm so glad I did)!! Thank You!!
Excellent Job, Dave!! Thanks!!
Thank you! Very helpful and easy to follow. I especially needed the step to remove the space between lines! So helpful!
I feel like this is going to help me a lot when i need to print my labels for my save the dates thank you!!!
Thanks Dave. Not the simplest thing to remember but managed with your superb instructions.
SUPERB step-by-step, THANK YOU!!!!!!
You are awesome!!! I’m retired and don’t use labels much anymore so It gets so confusing and I’m not very patient. You explain so clearly. You just saved me a headache. Thanks
I watch a couple of videos and saw yours. I then came back to it and did it along with it (pausing several times) until I got it right. Everything came out perfect, thanks.
Thank you! Very helpful and thorough!
This was fantastic! Thank you! I'd looked at other things to learn how to do this, and they skipped steps or just didn't make sense to me. You went step by step, and I followed along and my results were just what you said I should get! Yea! Thank you SO MUCH!
I have always been intimidated to print labels in excel/word but this video has made me think I can do it! Great directions!, and I'm a teacher so I appreciate it. Pretty intensive, but I'm gonna go for it.