Written by Allen Wyatt (last updated April 5, 2025)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, 2021, 2024, and Word in Microsoft 365
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, 2010, 2013, 2016, 2019, 2021, 2024, and Word in Microsoft 365. You can find a version of this tip for the older menu interface of Word here: Making Use of Extra Labels.
The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2019. Spend more time working and less time trying to figure it all out! Check out Word 2019 For Dummies today!
Information formatted for one type of label may someday need to be printed on a different type of label. Here are some ...
Discover MoreThere is a whole passel of labels pre-defined in Word. You are not limited to this passel, however; Word allows you to ...
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."
2025-04-05 09:00:03
Ray McAllister
To use up those partially used label forms, temporarily insert blank labels (say, with several spaces on the first line of each) at the beginning of the source file, ahead of the next label print job. For the example given above, you would add 7 blank labels. Then put the partially used form in the printer first. The first real address will print on the next remaining label on that form. Don’t forget to delete those blank labels from the source file when you are done.
This assumes the label stock is peel-off adhesive labels.
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 © 2025 Sharon Parq Associates, Inc.
Comments