Scroll through the Product Number list and select the file folder label. Click the first cell in the new sheet and press CTRL+V to paste the data.
Click the plus sign to add a new blank worksheet. Copy all the data on the sheet by pressing CTRL+C. Keyboard shortcut: Press CTRL+Spacebar, on the keyboard, and then press Shift+Spacebar. Select the label manufacturer, such as Avery, 3M or Staples, from the Label Vendors drop-down menu. Here’s how: Select all the data in the worksheet. Scroll down to Avery 8160, click it so it is highlighted, click “OK,” then click “New Document.” A page of separated labels appears on the page.Ĭlick the “Options” button and select the printer you are using to print the labels. Using Word Click the image of the label in the bottom right-corner, which opens up the “ Label Options” window. Select "Text Direction" and click on the image that shows the vertical direction of text you want.īeside above, how do I create Avery 8160 labels in Word? Highlight the text with your cursor and click on the "Format" menu at the top of Word.
Type the desired text into the Address box. Likewise, how do I print Avery labels vertically? Click on the "Mailings" tab and select " Labels" in the Create section. 4) Select the Labels tab, click Options, select the type of labels you want to create and then click OK.3) From the Tools menu, select Letters and Mailings, then select Envelopes and Labels.Then scroll to find your Avery product number and click OK.īeside this, how do I make labels in Microsoft Word? (In older versions of Word, the Options setting is located in Tools at the top of the page.) Select Avery US Letter from the drop-down menu next to Label Vendors. Once setup and saved - your next mail-merge is really simple just open the same Word Document and you will see this message pop up.Ĭlick Yes (as this will refresh the link to your Excel Address list.With your Word document open, go to the top of screen and click Mailings > Labels > Options. Now save this Word Document and call it something like My 14 labels If you want to print off all the address leave it on All and click OK. When you are ready click on Finish & Merge and then Print Documents.Īnother pop up will give you these options.
If you are happy with the test here's how to print off all your labels.įirstly make sure you have enough label sheets loaded in your printer (so if your database contains 137 addresses and you have 14 labels per sheet that will be 10 sheets) Then hold up your result over a label sheet to ensure it lines up. So just print one page on ordinary A5 paper by clicking File > Print as usual. Tip: Click the button again to switch the Preview Off againīefore you print onto your actual labels sheets it's a good idea to test is all lines up. Here's a magic button that lets you preview what the first sheet of mail merged labels will look like. Now we need to copy all the merge fields into all the boxes. Then click the Open buttonĬlick in the first box and click the Insert Merge Field buttonįrom the pull-down select each of the following fields and place on a new line so it looks like this. Navigate to where you have saved your addresses.xlsx file and select it. Now we need Word to link to your Excel database of addresses.Ĭlick Select Recpients and then select Use and existing list DO NOT ADJUST THIS (it should be the precise measurements for your Avery number) Now scroll down the list and find the Avery number for your labels - usually on the box ( L7162 is a common one for 8 rows and 2 columns)Ĭlick OK and you should see a table created for you with dotted lines. If it isn't already selected make sure your Label vendors is set to Avery A4/A5 sizes from the pull down list first. Use Word to create a document to design the labelsĬlick on Mailings along the top and then the Start Mail Merge button - looks like this.
Use Excel to create a Database of AddressesĪ ready made sheet called addresses.xlsx can be downloaded by clicking the link below Click here to download addresses.xlsxĢ. This article describes how to use Excel and Word to print out address labels on a standard Avery 8 rows by 2 columns (16) of sticky labels per sheet of A4.Īll you need is Excel and Word and some Sticky labels.ġ.