Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you're connected to the Internet, you have access to a whole slew of label templates to help you design and create your labels through Microsoft Office Online. Let's explore this now. We don't use the Mailing tabs on the Ribbon, rather click the Office button and select New as though you're creating a new document. Under Templates, you'll notice the category for Microsoft Office Online, and below there, you'll see one dedicated to Labels. Select that. Now, there are subcategories for working with labels: Gift labels, Media, Mailing and shipping and so on.
If you're going to be creating, let's say, a Return Address Label, you might choose Mailing and shipping. Here, you can now choose whether they're for use at Home, Holiday labels or Business. Let's select Business. Now, we see the thumbnails for each of the different labels. As we scroll through, we see the description down below indicating what brand and what product number these label templates will work with. So if you've already got labels, let's say the Avery 5160, you'll want to make sure you select one that works with those labels.
I'm going to go a little further down and select the Address labels Flowers design, with macro. Now, I see a preview on the right-hand side. Now, if you see a label that you want to be able to use, but you don't have the labels, just simply take note of what label brand and product number it works with. Go out and purchase these labels, come back and complete these steps. Once you've got your labels selected, and you've viewed the preview, all you need to do is click Download to download the template, which starts a brand-new document in front of you and you're ready to start entering names and addresses.
Now, if you don't see the gridlines that I do around each of my labels, and this is something I like to see so I know where my content is going to appear on the label, and how much space there is in between and so on, make sure you go up to the Layout tab under Table tools and turn your gridlines on by clicking View Gridlines. This is a toggle that will turn them off and on. Now because this template also contains a macro, you'll notice there's a new tab on the Ribbon, right at the beginning, for Avery template. Select that and you'll have a whole bunch of options for working with this particular template.
For example, if you want to create a sheet with the same address, you've got a button for that, or different addresses. You can change alignment. You can work with your pictures, if there are any graphics on your label. You can add new sheets and access Avery.com for more templates and learn about the template you're using. Let's say we're doing Return Address Label. So, in this case we would click Same Address, which allows us go in and type in a name and address that will appear then on every label. So you can type in your own name, if it's a Return Address Label, and then go in there and select the entire address by clicking-and-dragging over it and just type your own address over that.
I'm going to make one up. And when you're done, click OK. Watch what happens to your labels. Each of the labels is filled with the same address. The only thing you might want to do now is save this, if you want to be able to reuse it. So, once you've used up a sheet of labels, go back and print another sheet. You'll notice that because we've used a template, we've created a brand new document. So, you're going to see a document and a number following it. Then you'll want to go over to the Save button to save this up. I'm going to save this to my Desktop and you can see the file name is automatically using my name.
I'm going to leave that there and type in RAL for Return Address Label and click Save. Now, anytime I need another sheet of labels, I can come back to this file. When you're ready to print, just go up to the Office button, go down to Print and make sure all of your settings are correct. You want to print the current page, which is probably the same as all. When you click OK, off it goes to your printer and you've now got your Return Address Labels having used the template from Microsoft Office Online to help you with the design process.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 82595 Viewers
80 Video lessons · 133836 Viewers
52 Video lessons · 67117 Viewers
59 Video lessons · 52955 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.