Please Note: This article is written for users of the following Microsoft Word versions: 2007 and 2010. 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: Making Use of Extra Labels.
by Allen Wyatt
(last updated December 11, 2017)
A common use of Word is to print labels on different types of label stock. Many WordTips have focused on how you can do this. It is possible, however, to have "extra" labels left over at the end of a print run. For instance, suppose you run a mail merge for labels to 97 clients, and each sheet of labels has 30 labels on it. This means you will need four sheets of labels, and you would waste 23 labels on the last sheet.
To save those labels, don't merge directly to your printer. Merge to a new document instead. Then, scroll down to the last name in the merged document. Notice the blank cells in the table—these are the blank labels in your print run.
Position the insertion point in one of the blank cells and type your name and return address. You can then copy and paste the return address into all the other blank cells. Now when you print your label sheets you can keep the return-address labels at the end of the print job and use them when you pay your bills. This certainly is a penny-pinching alternative to wasting the last labels on the last sheet.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (11781) applies to Microsoft Word 2007 and 2010. You can find a version of this tip for the older menu interface of Word here: Making Use of Extra Labels.
Do More in Less Time! Are you ready to harness the full power of Word 2013 to create professional documents? In this comprehensive guide you'll learn the skills and techniques for efficiently building the documents you need for your professional and your personal life. Check out Word 2013 In Depth today!
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
Want the text printed on your labels to be centered vertically? It's not that hard, and this tip shows the easiest method.Discover More
When you create a document designed to be printed on a particular type of label stock, it might be helpful if Word ...Discover More
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
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.