Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, and 2013. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Changing Label Sizes.

Changing Label Sizes

by Allen Wyatt
(last updated January 23, 2017)

Veronica has a document that contains labels, with names already in place. The document is intended to be printed using Avery 5162 labels, but Veronica wants to change the document so it uses Avery 5163 labels. She wonders if there is a way to change label size without the requirement of recreating the entire document.

There are a couple of ways you can approach this problem. It is important, though, to remember that a label document is nothing but a large table that is formatted to match the dimensions of your labels. Understanding this, you could easily examine the table settings used in creating Avery 5163 labels and then change the table settings in your old document to match them. Because you change the table settings to match what is required for the new labels, you should be able to print on them with no problems.

Another idea is to create a new document consisting of empty Avery 5163 labels and then copy the data from the old Avery 5162 document to the new document. As long as you don't copy the table structure—just the data—you should have no problem.

If your labels are all the same, then the easiest method of converting to the desired label format is simply to use much of the same process you used to create the labels in the first place. Follow these steps:

  1. Open the existing document, the one that contains your labels in the Avery 5162 format.
  2. Press Ctrl+A to select the entire document.
  3. 3 Display the Mailings tab.
  4. Click the Labels tool in the Create group. Word displays the Labels tab of the Envelopes and Labels dialog box. (See Figure 1.)
  5. Figure 1. The Labels tab of the Envelopes and Labels dialog box.

  6. Click Options. Word displays the Label Options dialog box. (See Figure 2.)
  7. Figure 2. The Label Options dialog box.

  8. Using the Label Vendors drop-down list, choose Avery US Letter.
  9. In the Product Number list, choose 5163.
  10. Click OK. Word closes the Label Options dialog box.
  11. Make sure the Full Page of Same Label radio button is selected.
  12. Click New Document. Word creates a new document using the label format you specified in steps 6 and 7.

At this point you should have two documents—one that is your original (Avery 5162 format) and one that is your new document (Avery 5163 format). The new document contains a full set of labels based on the first label in your original document.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (6276) applies to Microsoft Word 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Word here: Changing Label Sizes.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Embedding TrueType Fonts

If you need to make sure that the fonts in your document can be used by another person or on a different system, you'll need ...

Discover More

Counting Cells Containing a Formula

Cells in a worksheet can contain different types of information, such as numbers, text, and formulas. If you want to ...

Discover More

Breaking a Document Link

Word allows you to link external information into your documents. If you no longer need to maintain the active link, you can ...

Discover More

Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!

MORE WORDTIPS (RIBBON)

Formatting Labels

Need your labels to look a certain way? You can save time by formatting them before Word actually creates the sheet of ...

Discover More

Creating Custom Labels

There is a whole passel of labels pre-defined in Word. You are not limited to this passel, however; Word allows you to define ...

Discover More

Creating One-time Labels

Need to create a set of labels for a specific purpose? The easiest way is to let Word create a set of blank labels and then ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share