Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, and 2016. 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 August 4, 2018)

6

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. Press Ctrl+c to copy the selection to the Clipboard.
  4. 4 Display the Mailings tab.
  5. Click the Labels tool in the Create group. Word displays the Labels tab of the Envelopes and Labels dialog box. (See Figure 1.)
  6. Figure 1. The Labels tab of the Envelopes and Labels dialog box.

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

  9. Using the Label Vendors drop-down list, choose Avery US Letter.
  10. In the Product Number list, choose 5163.
  11. Click OK. Word closes the Label Options dialog box.
  12. Make sure the Full Page of Same Label radio button is selected.
  13. Click New Document. Word creates a new document using the label format you specified in steps 7 and 8.
  14. 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. Continue with the following steps to complete the process of creating the new document with your original labels in the new Avery 5163 format:

  15. Press Ctrl+A to select the entire new document.
  16. Press Ctrl+v to paste the contents of the Clipboard (from step 3) into the new 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, 2013, and 2016. 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

Replacing a Dimmer Switch

Dimmer switches can be very helpful in creating a soothing atmosphere or an alert atmosphere, all at the twist of a knob. ...

Discover More

Formatting a Cover Page

Formal reports look better when they are set up with an introductory cover page. Here's how you can add a cover page in a ...

Discover More

Text Truncated in PivotTable

When you create a PivotTable based on data that contains lots of text, you may be surprised to find that your text is ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More WordTips (ribbon)

Sequentially Numbered Labels

A common task in Word is to create labels. This tip presents two approaches you can use when you need to create labels ...

Discover More

Creating Labels

Using Word to create and print labels is a snap. All you need to do is provide the text you want on the labels, pick a ...

Discover More

Printing Multiple Label Copies when Merging

Need to print more than one copy of mail-merge labels? There are a number of different approaches you can take to getting ...

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

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 6 - 4?

2017-07-18 11:04:01

dis gruntled

Anissa was right. This tip was completely useless!


2017-01-30 20:49:19

Elizabeth

I have to agree with Anissa, having a new document made up of only the first label is impractical for my needs. Has anyone come up with a different solution?


2017-01-23 17:59:58

Rob

If the width of the labels changes you may need to check the paragraph's width setting - it could end beyond the width of the table cell.


2014-12-15 09:47:42

Anissa Zellman

Yes, of course I tried it before I commented, but thank you! Your site is very helpful!


2014-12-04 07:40:29

Thomas Redd

Thanks so much for the tip! Anissa, did you try it out before you responded? I bet it will work. Test and then complain later!


2014-12-03 16:06:34

Anissa Zellman

This is great, but when you have 25 pages of labels you want to convert to 25 pages of new labels, only having the FIRST original label copy over is pretty useless. Any ideas?


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.

Newest Tips
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.