How to print mailing labels from Excel

Подписаться 108 тыс.

Просмотров 554 тыс.

50% 1

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

Наука

Опубликовано:

31 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 512

@christinalennon2224 2 года назад

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!!

@carolynleechapman4942 2 года назад

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!

@janetmathews9713 3 года назад

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.

@devilsporkchop1263 2 года назад

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.

@MarshaCoke 3 года назад

Excellent tutorial. He speaks clearly, and moves his cursor smoothly enough I could follow it easily. Again, EXCELLENT tutorial. Thanks!

@lisamercure3427 4 года назад

THANK YOU! Your instructions were very easy to follow and at the perfect pace for me.

@iantolchard7669 2 года назад

Top tutorial !!!! I wish everything on RU-vid 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.

@cindyboyles2323 3 года назад

Thank you for this wonderful step-by-step guide. Very easy to follow, and it worked perfectly the first time. Appreciate your clarity.

@michaeljay3 Год назад

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! !🙂

@donandtammyhilt7237 Год назад

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!

@MrSteve90266 Год назад

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!

@laurapainterfdnp 3 года назад

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.

@michaeldoyle5242 2 года назад

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.

@sheilawayman5621 3 года назад

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!

@AkulMusic123 2 года назад

😂

@enkeledaavdia9006 Год назад

I won't 96 labels per page .how can I do?

@mariarolland6167 Год назад

So helpful! I've tried printing labels so many times in the past, and this was my first success! Thank you!

@beckykopesdy2569 Год назад

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!!

@lenibjerg3771 3 года назад

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

@BrookeBullmasterStewart 3 года назад

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!

@thomasdouglass8778 2 года назад

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.

@amycarman6292 3 года назад

Perfect presentation. Absolutely the best RU-vid tutorial I have ever followed. Thank you!

@debbiemoore8058 3 года назад

This was tremendously helpful. Thanks so much. Clear and concise and easy to follow. Good job!

@janedriscoll7459 2 года назад

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!

@jimriding1074 2 года назад

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. 👍

@carolmorgan9228 3 года назад

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!

@Don-uf4gt 2 года назад

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.

@bendonahower5325 2 года назад

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.

@alanharding2026 Год назад

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!

@annlord928 3 года назад

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!

@susandavis2132 2 года назад

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!

@DavesTechRescue 2 года назад

Happy to hear my video helped! Congratulations :)

@leonardbeddows3192 2 года назад

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.

@whozyourdaddy 2 года назад

Dave, I come here twice a year for my mailings. Without you, it would not get done. So easy to understand and follow.

@marilynbaxter1626 9 месяцев назад

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!!

@edbaartman4599 Год назад

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.

@connorfoley5459 Год назад

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!!

@evarae7531 2 года назад

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!

@rhodylanehoa7749 Год назад

This info is just what I needed and Very Helpful! Thanks so much for your time!

@AmandaJYoungs 3 года назад

Your instructions are so clear and straightforward. A person can become quite frazzled when the technology doesn't follow what seems most logical to the person, but you make it so simple, I had to subscribe. I know where to come in future when my technology and I are having a disagreement! Thanks so much.

@alicetan7141 2 года назад

Awesome Dave! You have saved my day. Thanks for your clear and precise instructions. Printed my boss's greetings card mailing successfully.

@theresalanning5817 2 года назад

Dave, Thank you!! This video was so helpful! instructions were so easy to follow!

@carlabrutico6978 2 года назад

Excellent tutorial, Dave. Very well done. I have tried previously to make labels from Excel without success. This is awesome!

@donr8191 4 года назад

You always cover important subjects and make them understandable....or easily corrected....Thanks !!

@suzyk08021 2 года назад

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😀

@kathleenclouse1397 3 года назад

Exquisitely simple directions! I'm so grateful for the instruction.

@dvanderstegen 2 года назад

Hi Dave, thanks a lot for this tuto, it was very clear to me and help me to create my labels in a few minutes. You saved my evening ! All the best for 2022. Diane

@petedarr9250 Год назад

Your tutorial is just what I had to do today. Thanks for the video Dave. 👍

@CatRolfesMusic 3 года назад

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!

@barbarapayne4964 Год назад

Thank you so much for creating this video! Your step-by-step directions were perfect!

@conniethomas1622 2 года назад

Thank You so much!! You are an amazing teacher. Thank you for going slow and explaining everything. VERY HELPFUL!!!

@terrybingham325 Год назад

Thank you! This was very involved and you helped every step of the way and did not leave anything out. Not too fast. Excellent tutorial!

@margaretfederal7378 Год назад

Your easy instructions were indispensable. Thank you so much and keep up the great work!

@srjackiejean-mariegitonga7186 2 года назад

Wonderful job! Thanks for the clear explanation. I was finally able to make labels from Excel! Thanks and God bless you!

@hellokandykatz Год назад

thanks Dave - this video was so helpful - I had issues using Avery's template, and this saved the day. Happy Holidays!!

@mikebower5811 Год назад

Thank you so much! Your video was the only one of many, that worked for producing labels i needed from Excel.

@kathyh.1720 Год назад

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!

@eulainemcintosh6538 2 года назад

I have wasted time trying to learn from other sources how to do this. You're video is the Best! Works well.

@rogerbick6437 2 года назад

Wow! Super Helpful. I tried understanding how to print labels from an excel file using microsofts written and cryptic videos. I was a waste of time. Dave's Step by Step approach was clear and led to success. Since I do not print labels but once a year or less having this instruction was wonderful. Thanks.

@Rocky101able 2 года назад

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!

@richardwilhite8316 Год назад

Thank you. A very easy to understand tutorial. First time I've ever used an Excel spreadsheet to merge with Word in order to create labels. Never would have figured it out but with the tutorial, very simple. Thanks.

@G_Boom 3 года назад

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.

@cynthiaamador5691 2 года назад

Thank you so much, I struggled for an hour trying to figure out the on line instructions. Your video was super helpful and easy.

@theresakirsch9179 3 года назад

This tutorial was awesome and very detailed. Highly recommend it!

@Lovforu2 3 года назад

Great info. I like the way you keep it concise and straight to the point..

@bobdyer1010 Год назад

Great info! Exactly what I needed. Clear and nicely paced. Bravo!

@sheepishusername 8 месяцев назад

This was a brilliant and very clear explanation with some small but critically important detail missing from other explanations. Thank you.

@cooktoy1 Год назад

Best tutorial, just made my Christmas Card Labels, Thanks and Merry Christmas!

@marytunney1108 7 месяцев назад

Thank you! Very helpful and easy to follow. I especially needed the step to remove the space between lines! So helpful!

@gezbo66 3 года назад

Saved me. Spent an hour on another tutorial and it never worked. I needed a good Englishman to help sort me out. Cheers Dave!!

@sharonavery8347 3 месяца назад

What a clear and concise presentation! This is exactly what I need. Thank you!

@marklee9602 3 года назад

Very well done. Good attention to detail. Easy to follow and logical presentation. Thank you.

@jackiehafler6264 Год назад

This was so clear and to the point. Excellent video 😊

@janetcorreia8130 Год назад

Clear instructions - SO HELPFUL!! Thank you so much!!!!

@Favorites2012mine 3 года назад

Thanks so much! Your tutorial worked perfectly for me. Christmas address labels are all done. New subscriber!

@tinathaotran2795 2 года назад

THANK YOU so much for making the video. The last time I created a mail merge document is more than 10 years ago. I remembered some steps but I was struggled to create a final product. Your video saves me.

@alecia175 3 года назад

Excellent job, very clear and direct instructions. Very much appreciated.

@gajjfitch 2 года назад

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.

@donnagabler2609 Год назад

wonderful simple instructions and easy to understand. Great speaker .

@johnspink6957 7 месяцев назад

You Sir, are a life saver! I've been struggling with this and your explanation was clear and concise. Thank you very much.

@zigmundwriggs Год назад

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!

@DavesTechRescue Год назад

I’m happy it helped!

@joannroskoski199 3 года назад

Thanks so much. Very straightforward and easy to understand. Next step getting blank labels and following the instructions.

@vinoawilson1049 Год назад

This tutorial was helpful. It saved me a lot of typing. Thank you so much for such a detailed tutorial.

@user-xb1dv1zs8u Год назад

Super helpful - spectacularly clear and straightforward. You are now on my Christmas card list :))

@mistybishop-martiss4565 3 года назад

Thank you! This is the best video I have found to walk me through this!

@kennethhaubert6301 3 года назад

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!!!!

@jimmoon87 7 месяцев назад

Dave, thanks so much. Excellent explanation with details and good pacing.

@johnmeacham7162 3 года назад

Extremely clear and made no assumptions about prior knowledge. Many thanks

@chibidog11 Год назад

Thanks for the GREAT tutorial! I've been struggling with details on how to do this. You were very methodical and detailed!

@Homestead1841 3 года назад

Thank you, Dave! Great video. It was clear and east to understand.

@mikegoodman9276 2 года назад

Thanks Dave. Not the simplest thing to remember but managed with your superb instructions.

@janacreek6184 2 года назад

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

@inhybridmoments 3 года назад

Extremely helpful and easy to follow tutorial. Much appreciated.

@ashabi2008 2 года назад

Thanks Dave, great & easy to follow step by step instructions. Thank you

@pvaidyan 2 года назад

thanks Dave - This was really helpful, clean & easy to get the desired output.

@AmyBluntRealtor 3 года назад

So appreciate this tutorial! Quick and easy to follow along!! THANKS

@cynthialilly5855 2 года назад

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!!

@irenemessina 7 месяцев назад

Every year I forget how to print my labels from Excel. Thank you for helping me print my labels once again!!!!

@alisonderham1529 Год назад

Thank you so much for this. Clear and concise and worked perfectly.

@sharonkennedy8701 Год назад

You've taught an old dog new tricks! Well done, you! Your instructions are so clear. Thanks so much!!😀

@NBBCLU Год назад

Thank you for saving me hours and hours of typing!!! Your video was very accurate in its instructions.

@feroserehman5235 Год назад

Thank you, Your Presentation is characterized by careful reasoned thinking with heedful anticipation of the needs and wants.

@dangutierrez1100 11 месяцев назад

Thank you so much for this!! I have used it several times and appreciate the detail and ease of it!

@BarbaraHauensteinArtist 2 года назад

Oh my goodness! How helpful!! You are so wonderful and I thank you from the bottom of my heart. Now I just need to figure out how to add a little picture to my Christmas labels! :)