How to Use the Avery Template 5160 in Word: A Step by Step Guide

How to Use the Avery Template 5160 in Word: A Step by Step Guide

Avery 5160 is one of the most widely used label templates in the world, and if you have ever needed to print address labels, name badges, or filing labels, you have almost certainly come across it. The Avery 5160 template gives you thirty labels per sheet, arranged in three columns of ten rows, and each label measures one inch high by two and five-eighths inches wide.

That size fits a standard address label perfectly, with room for a name, a street address, and a city, state, and postcode on three or four lines. Microsoft Word has the Avery 5160 template built in, so you do not need to download anything or buy special software, and this guide shows you exactly how to use it, step by step, from opening the template to printing a finished sheet.

The reason the 5160 template is so popular is that it matches a physical product you can buy in almost any office supply shop. Avery 5160 labels are sold in boxes of hundreds or thousands of sheets, and because the size has been standard for decades, printers, label makers, and mailing software all recognise it.

If you print your labels on the wrong template, the text will drift out of alignment, and you will waste a sheet of labels with every attempt. Getting the template right is therefore the single most important step, and once you have it, everything else is straightforward.

Whether you are mailing Christmas cards, labelling files for a new office, or printing name badges for an event, the 5160 template will handle the job.

What Is the Avery 5160 Template?

A sheet of Avery 5160 labels is a standard US Letter size sheet, eight and a half inches wide by eleven inches tall. The labels are arranged with a small margin around the edge of the sheet, and the gaps between the labels are narrow but consistent.

Word knows all of these measurements, and when you choose the 5160 template, it sets up a table with thirty cells, each one exactly the size of a label. What you type into each cell is what prints on that label, and what you see on screen is very close to what will come out of the printer, as long as your printer is set to the correct paper size.

Here are the key facts about the 5160 template.

  • Thirty labels per sheet, in three columns of ten rows.
  • Each label is one inch high by two and five-eighths inches wide.
  • The sheet is US Letter size, eight and a half inches by eleven inches.
  • Word builds it as a table with thirty cells, one per label.

How to Set Up the Avery 5160 Template in Word

Setting up the template takes only a few clicks. Follow the steps below in order, and check the product number carefully before you print.

Step 1: Open Microsoft Word and Start a New Blank Document

Open Word on your computer and create a new blank document. It does not matter whether you are using Word on Windows or Word on a Mac, because the mailings tools work in the same way on both.

Before you do anything else, check that your printer is switched on and loaded with plain paper for a test print, because you will want to print a test sheet before you use your expensive label sheets.

If you already have a list of addresses in Excel, keep that file open in the background, because you will use it later in the mail merge section of this guide. If you only need a few labels, you do not need a list at all, and you can type the addresses straight into the template.

Step 2: Go to the Mailings Tab and Click Labels

Click the Mailings tab on the ribbon at the top of the Word window. On the left side of the Mailings tab, you will see a button labelled Labels, and clicking it opens the Envelopes and Labels dialog box.

This dialog has two tabs, Envelopes and Labels, and you want the Labels tab. At the bottom of the dialog, you will see the label information, which tells you which label product is currently selected.

If it already says Avery US Letter 5160, you are ready to go, but if it says anything else, you need to change it, which is the next step. The dialog also has a box where you can type a single address, which is useful when you only need one label, but for a full sheet, you will use the New Document button instead.

Step 3: Choose Avery US Letter 5160 as Your Label Product

In the Envelopes and Labels dialog, click the Options button near the bottom right. This opens the Label Options dialog, where you choose the label vendor and the product number.

In the Label vendors drop-down list, select Avery US Letter, and then scroll down the Product number list until you find 5160, which is described as Address, and click it to select it. The Label information box will update to show the label size, one inch by two and five-eighths inches, and the number of labels per sheet, which is thirty.

Click OK to confirm your choice, and you will return to the Envelopes and Labels dialog with 5160 selected. This step is the one that people get wrong most often, so take a moment to check that the number really is 5160, because Avery makes dozens of similar labels, and a single wrong digit will ruin your alignment.

Step 4: Click New Document to Create a Full Sheet of Blank Labels

Back in the Envelopes and Labels dialog, click the New Document button. Word will create a new document that contains a table with thirty empty cells, one for each label on the sheet.

Each cell is exactly the size of a 5160 label, and the table borders are hidden by default, so the page may look blank at first glance. That is normal, and the labels are there even though you cannot see their edges.

To make the grid visible while you work, go to the Table Design tab or the Layout tab, and click View Gridlines, which shows faint dotted lines around each label on screen without printing them. These gridlines are your best friend while you are typing, because they show you exactly where each label starts and ends.

How Do You Type and Fill in the Labels?

Step 5: Type Your First Address into the Top Left Label

Click inside the top left cell of the table, which is the first label on the sheet, and type the first address. Press Enter after each line to move to the next line within the same label, and keep the address to three or four lines so that it fits comfortably inside the label.

A typical address has the person's name on the first line, the street address on the second line, and the city, state, and postcode on the third line. If you want the text centred, select it and click the Centre button on the Home tab, or use the paragraph alignment buttons in the table cell.

You can also change the font size here: most addresses look best at ten or eleven points, and anything larger than twelve points risks overflowing the label.

94 body1

Step 6: Fill the Rest of the Sheet by Copying and Pasting, or by Typing Each Address

If every label on the sheet should have the same address, which is common for return address labels, select the text you just typed, copy it with Ctrl and C, click in the next cell, and paste it with Ctrl and V. Repeat this for all thirty cells, or select the whole table and paste repeatedly until every cell is filled.

If each label needs a different address, click into each cell in turn and type the address for that label, using the Tab key to move quickly from one cell to the next. Pressing Tab in the last cell of the table will add a new row, which you do not want, so use the mouse to click back to the top when you reach the end.

This manual method works well for a handful of labels, but if you have more than twenty addresses, the mail merge method described later in this guide will save you a great deal of time and typing errors.

Step 7: Format Your Labels So They Look Professional

Once your addresses are typed in, select the whole table by clicking the small cross icon at the top left corner of the table, and then set the font for everything at once. A clean sans-serif font such as Calibri or Arial looks modern and is easy to read, while a serif font such as Times New Roman looks more formal.

Set the font size to ten or eleven points, and check that no address spills over the edges of its label. If a line is too long, shorten it, reduce the font size for that cell, or split the address across an extra line.

You can also add bold to the name on the first line of each label, which makes the sheet easier to scan. If you are printing a company logo on return address labels, insert the image into the first cell, resize it to fit, and then copy it into every cell, but keep the image small so that it does not push the address text out of the label.

Should You Print a Test Sheet First?

Yes, always. Before you print on your expensive Avery sheets, print the document on a sheet of plain paper. Hold the printed test sheet up against a blank sheet of labels, or hold both up to a light, and check that the text lines up with the label outlines.

If the text is too high, too low, or shifted to one side, the problem is usually a printer setting rather than the template. Open the print dialog and check that the paper size is set to Letter, that the scaling is set to one hundred percent or Actual size, and that the printer is not set to fit the page to the paper.

The Fit to page option shrinks your document slightly, which is enough to throw every label out of alignment. If the test sheet lines up, load a sheet of Avery 5160 labels into the printer, print one sheet, and check it before printing the rest.

Use this quick test checklist every time you print labels.

  1. Print on plain paper first and hold it against a blank label sheet.
  2. Check that the paper size is Letter and the scaling is 100 percent.
  3. Check that Fit to page is switched off.
  4. Print one label sheet, check it, and only then print the rest.

How to Use Mail Merge to Print Labels from an Excel Address List

If you have a long list of addresses, mail merge is the right tool, because it fills all thirty labels from your list automatically and moves on to a second sheet when the first one is full. It is the fastest way to print labels for a large mailing list, and it avoids the typing errors that come with entering addresses by hand.

Step 8: Prepare Your Excel List and Connect It to Word

Start by making sure your Excel list has one row per person, with columns for first name, last name, street address, city, state, and postcode, and a header row at the top naming each column.

In Word, go to the Mailings tab, click Start Mail Merge, and choose Labels. Select Avery US Letter 5160 in the Label Options dialog, and Word will create a blank label sheet. Then click Select Recipients, choose Use an Existing List, and open your Excel file.

Word will ask you to confirm which sheet and which range holds your data, and then your list is connected to the document.

Step 9: Insert the Merge Fields into the First Label and Update All Labels

With your address list connected, click in the first label cell, then click Insert Merge Field on the Mailings tab and choose the first name field. Press the spacebar, insert the last name field, press Enter, and then insert the street address field.

Press Enter again and insert the city field, type a comma and a space, insert the state field, press the spacebar, and insert the postcode field. Your first label should now show the field names in angle brackets, such as the first name, the last name, the address, the city, the state, and the postcode, arranged over three lines.

Now click the Update Labels button on the Mailings tab, and Word will copy that layout into all thirty labels on the sheet. This is the step people forget most often, and without it, only the first label will have any fields in it, so make sure you click Update Labels before you preview.

Step 10: Preview the Results and Finish the Merge

Click Preview Results on the Mailings tab to see your real addresses in place of the field names. Use the arrow buttons to step through the records and check that the addresses look right, that no fields are blank, and that no address is too long for its label.

If a record has a missing postcode or a very long street name, you can fix the data in Excel, save it, and refresh the merge, or you can edit the individual label after the merge is finished.

When you are happy with the preview, click Finish and Merge, and choose Print Documents to send the labels straight to the printer, or choose Edit Individual Documents if you want to save the merged labels as a new Word file that you can check and edit before printing. Saving the merged file first is the safer choice, because it lets you spot any problems before you use your label sheets.

94 body2

Why Do My Labels Not Line Up?

If your printed labels drift out of alignment, work through the causes one at a time. The most common causes are listed below, in the order you should check them.

Cause 1: The Wrong Product Number

Check that you chose the right product number, because 5160 is easily confused with 5161, 5162, and 5163, which have different sizes. Reopen the Label Options dialog and confirm that 5160 is selected.

Cause 2: The Wrong Printer Settings

Check your printer settings, and make sure the paper size is Letter, the scaling is one hundred percent, and the paper type is set to Labels if your printer offers that option. If the drift gets worse towards the bottom of the sheet, the problem is almost always scaling or paper size, so fix those settings first.

Cause 3: The Paper Feed

Check the paper feed, because labels that are loaded upside down or back to front will print on the wrong side, and a sheet that is curled or damp can feed through crookedly.

Cause 4: The Wrong Label Sheets

Check that you are using genuine Avery 5160 sheets or a compatible brand that states it matches the 5160 size, because cheaper sheets sometimes differ by a millimetre or two, which is enough to cause drift by the bottom of the page.

Problem Likely Cause Fix
Text drifts down the sheet Scaling is not 100 percent Set scaling to Actual size
Text is shifted sideways Wrong paper size Set paper size to Letter
Labels print on the wrong side Sheets loaded the wrong way Reload the sheets correctly
Only the first label has fields Update Labels was skipped Click Update Labels before previewing

What Else Can You Use the 5160 Template For?

The 5160 template is not only for mailing addresses. The same size works well for name badges at conferences, training days, and school events, because the label is large enough for a name in a big font and a job title underneath, and it sticks neatly onto a shirt or a lanyard card.

It also works for filing labels, product labels, and inventory labels, because you can fit two or three lines of clear text on each one. For name badges, increase the font size of the name to fourteen or sixteen points, centre the text, and add the event name in a smaller font underneath.

For filing labels, use a bold heading on the first line and a short description on the second line. The same mail merge process works for all of these uses, so once you have learned it for addresses, you can reuse it for any list of names or items.

Related: How to Add a Sqrt Symbol in Word

Word is full of small formatting jobs that come up alongside label printing, and adding a special symbol such as a square root sign is a common one. If your labels or documents need mathematical symbols, this guide shows you the quickest way to insert them.

Can You Save Your Label Document as a Reusable Template?

Yes, and it is well worth doing. Once you have a label sheet set up the way you like it, save it so that you never have to set it up again. Go to File, then Save As, and choose Word Template as the file type, which saves the file with a .dotx extension.

Give it a clear name, such as Avery 5160 Address Labels, and save it in your templates folder. The next time you need labels, open the template, type your new addresses, and print, without going through the Label Options dialog again.

If you use mail merge, save a copy of the merged document as a template too, with the field layout in place, so that next time you only need to connect a new address list. This small habit saves ten minutes every time you print labels, and it means your labels look consistent from one mailing to the next.

What Is Avery Design and Print?

If Word gives you trouble, or if you want fancier designs with colours, images, and borders, Avery offers a free online tool called Design and Print that works in your browser. You choose the 5160 product, pick a design or start from a blank sheet, type or import your addresses, and print from the browser or save the project as a PDF.

The tool is free and does not need an account for basic use, although creating an account lets you save your projects. It is a good option if you want decorative labels for a party or a small business, because it has ready-made designs that would take much longer to build in Word.

For plain address labels, though, Word is usually quicker, and your addresses stay on your own computer rather than being uploaded to a website.

94 body3

Related: How to Switch from Centimeters to Inches for Word Margins

Label alignment depends on your measurements being right, and Word sometimes shows margins in centimetres when you are thinking in inches. If your rulers or margin settings do not match the units you expect, this guide shows you how to switch them so your label sizes make sense.

Frequently Asked Questions

1. What size is the 5160 label?

One inch high by two and five-eighths inches wide, with thirty labels per US Letter sheet, arranged in three columns of ten rows.

2. Where do I find the template in Word?

On the Mailings tab, under Labels, in the Label Options dialog, where you choose Avery US Letter and product number 5160.

3. Why does the text not line up with the labels?

Usually the printer is set to fit the page to the paper, or the paper size is not Letter, so check those settings first and always print a test sheet on plain paper.

4. Can I use the template on a Mac?

Yes, Word for Mac has the same Mailings tab and the same label options, and the steps in this guide work the same way on both systems.

5. Can I print only one label instead of a full sheet?

Yes, you can type a single address in the Envelopes and Labels dialog and choose to print a single label, or you can fill just one cell in the full sheet and print it.

Conclusion: Pick the Right Template and Test Before You Print

The Avery 5160 template gives you thirty address labels per sheet, each one inch by two and five-eighths inches, and Word has it built in. Go to the Mailings tab, click Labels, choose Avery US Letter 5160 in the Label Options dialog, and click New Document to create your sheet.

Type your addresses into the cells, format them at ten or eleven points, and always print a test sheet on plain paper before you use your label sheets. For long lists, use mail merge to pull addresses from Excel, insert the merge fields into the first label, click Update Labels, and preview before you print.

Check your printer settings if the labels drift, save your finished sheet as a template for next time, and remember that the same template works for name badges and filing labels too. With these steps, your next mailing will be printed, stuck, and posted without a single wasted sheet.

Key Takeaways

  • Avery 5160 means thirty labels per sheet, each one inch by two and five-eighths inches.
  • Choose Avery US Letter 5160 in the Label Options dialog, and double-check the number.
  • Always print a test sheet on plain paper with scaling at 100 percent and paper size set to Letter.
  • For long lists, use mail merge, insert the fields in the first label, and click Update Labels.
  • Save your finished sheet as a .dotx template so you never set it up twice.
  • The same template works for name badges, filing labels, and product labels.