Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365. 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.
Written by Allen Wyatt (last updated September 1, 2023)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365
3
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:
- Open the existing document, the one that contains your labels in the Avery 5162 format.
- Press Ctrl+A to select the entire document.
- Press Ctrl+c to copy the selection to the Clipboard.
- 4Display the Mailings tab.
- Click the Labels tool in the Create group. Word displays the Labels tab of the Envelopes and Labels dialog box. (See Figure 1.)
- Click Options. Word displays the Label Options dialog box. (See Figure 2.)
- Using the Label Vendors drop-down list, choose Avery US Letter.
- In the Product Number list, choose 5163.
- Click OK. Word closes the Label Options dialog box.
- Make sure the Full Page of Same Label radio button is selected.
- Click New Document. Word creates a new document using the label format you specified in steps 7 and 8.
- Press Ctrl+A to select the entire new document.
- Press Ctrl+v to paste the contents of the Clipboard (from step 3) into the new document.
Figure 1. The Labels tab of the Envelopes and Labels dialog box.
Figure 2. The Label Options dialog box.
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:
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, 2016, 2019, and Word in Microsoft 365. 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. Learn more about Allen...
MORE FROM ALLEN
Adding and Using a Combo Box
Combo boxes can be a great way of getting user input in a worksheet. Here's how to add a combo box to your worksheet and...
Discover More
Static Sizes for Comment Boxes
Adding comments to your worksheet can be helpful in documenting what the worksheet contains. If you want to make sure...
Discover More
Nesting IF Worksheet Functions
The IF worksheet function is very handy to make conditional evaluations. You are not limited to a single IF comparison,...
Discover More
More WordTips (ribbon)
Making Use of Extra Labels
Got extra labels left over after printing a mail merge? Here's what you can do to put those labels to good use.
Discover More
Adding Addresses To a Set of Address Labels
Got a bunch of pages of labels and you need to insert a label into the middle of the bunch? This isn't easy to do in...
Discover More
Saving Money on Printing Labels
Labels can be expensive, and a little common sense will help you waste less money as you try to get your labels to appear...
Discover More