#Avery template 5160 excel free download how to
#Avery template 5160 excel free download download

Click on it and some options will appear in the lower section, show gridlines will be one of them. If they don’t, look at the top of screen for Table Tools. The gridlines for your template should now appear on the document.

#Avery template 5160 excel free download download

If the product is not listed, head over to and search for the designated template of your product and download it to get going. Once you find it, click on and then click on ok. Now from Label Vendors choose Avery® US letter and in the list of product numbers below, scan and search for your desired one. Click on page printers and select the default tray to make sure that the correct printer is selected here. Click on this.Ī pop-up window now appears before you.

Under this, a heading of change document layout appears below which you have to option of Label options. Look at the top again and click on change document layout. Now the contents of this section will change. Now look at the bottom of this same section that says Step 1 by 6 and below it is a button saying next. Since we intend to create labels, we are going to select this option. Now in that new section that just opened, you can see that there is an option of selecting the type of the document. This is the Mail Merge Wizard guiding through each step so that no essential step is missed. On your right side should now appear a new section. At the bottom of this drop-down menu, we have a step-by-step mail merge wizard option. Now a drop-down menu will come before you.

Once you click on that, all the options below this horizontal menu will change, giving a look somewhat like this.

#Avery template 5160 excel free download how to

Click on it to begin how to print Avery® labels from Excel spreadsheet. Right next to references, there is an option of Mailings. Now go back to your blank document and look on the horizontal bar present on the top. Open your Excel Spreadsheet and make sure that the data is arranged in a proper way like this in columns, where the header is present above each column of data labelling what is what. Make sure that your excel spreadsheet from which you want to import data to Avery® Labels is present here on this computer too. Using this, you will understand how to print from excel to Avery® labels and create labels such as those having shipping addresses for the customers of your newly found businesses.įire up your computer and open your Microsoft Word application. In order for one to know how to merge excel to Avery® Labels, an extensive step by step guide has been lain down. How to Print from Excel to Avery® Labels? It indeed is a tedious task and one does wonder is there a way around it? Does anyone actually know how to mail merge from Excel to Avery® labels? The answer is yes there is.

It might feel like a hectic task to enter each data entry from the spreadsheet to each label individually. If it’s a scenario like the one above or any other similar one where you need the data sorted in your Excel spreadsheet to be arranged in the labels format so it can be printed easily, then continue reading. The next big question which arises here is that how do I mail merge from excel to Avery® labels? Do not worry as this query will explained here in great detail. Well, I am here to tell you that you have taken one step in the right direction with this measure. What you must have already been doing is creating an Excel Spreadsheet where you have entered the name, and addresses of your customers. If you have recently opened up a small business of your own and you have orders piling up and you don’t know how to cope up with all the workload of creating shipping labels and sending stuff out, do not worry.