I was at a holiday party recently and listened to my friend tell her woe-is-me story about how she wasted half her Saturday morning trying to print address labels for her holiday cards.
This page about how to create Microsoft Word labels was inspired by her. I felt her pain because I have struggled with creating my own labels several times in the past, but once I found the free Avery label download, this job could not be easier.
Before you watch me create the labels in the video below, an overview might be helpful.
First, you need 3 programs to do this job:
Second, open your Excel address spreadsheet. Select all the data and then open the Tools menu. If you download the Avery labels software properly, you should see it as a choice at the bottom as shown in this image.
Third, with the Avery dialog box open, follow these steps:
Finally, the Avery software opens Microsoft Word where you can print your labels and save the file. All printers are different but most of them require you to place your label stock face down in order the get them to print on the correct side.
I found a solution that you may want to try if you have trouble with the margins. Once the labels open in Microsoft Word, hit Print Preview and see if any portion of the labels are cut off. In my case, the left margin is usually the problem. I fix this by first selecting all the labels in Microsoft Word (choose "Select All" from the Edit menu).
Then, as the image above shows, I click on "Increase Indent" button in Microsoft Word to move the label text over the the right. This usually solves the problem.
Now that you understand how to create Microsoft Word labels at a high level, it is time to watch me do it! If you would also like to learn how to create invitations in Microsoft Powerpoint, watch that video here.