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
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:
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.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Need your labels to look a certain way? You can save time by formatting them before Word actually creates the sheet of ...
Discover MoreNeed to print more than one copy of mail-merge labels? There are a number of different approaches you can take to getting ...
Discover MoreOnce you create a custom label layout it is a good idea to backup the layout on a different hard drive in the event of a ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-11-23 21:56:06
Scot
just like others comments. does NOT work. format picks up old column format
2021-10-22 10:55:04
A.S.
This absolutely does not work. It copies the formatting as well as the content, so when you paste it into the new document, it changes the formatting back to the original.
2020-06-08 14:04:06
Kelly
This doesn't work because, when you Ctrl+v the content from your old labels into the new labels, the table formatting comes with it, so you end up with the exact same size labels you started with.
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.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2024 Sharon Parq Associates, Inc.
Comments