Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, 2016, 2019, 2021, 2024, 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: Making Use of Extra Labels.

Making Use of Extra Labels

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


1

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.

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

Weird Mouse Shortcut

If you like to use the mouse in your worksheet navigation efforts, you'll want to pay attention to this tip. Here you ...

Discover More

Fixing the Decimal Point

Don't want to always type the decimal point as you enter information in a worksheet? If you are entering information that ...

Discover More

Using Message Boxes

If your macro needs to communicate with a user, one simple way to do it is to use a message box. Here's how to use this ...

Discover More

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!

More WordTips (ribbon)

Changing Label Sizes

Information formatted for one type of label may someday need to be printed on a different type of label. Here are some ...

Discover More

Creating Custom Labels

There is a whole passel of labels pre-defined in Word. You are not limited to this passel, however; Word allows you to ...

Discover More

Backing Up Label Layouts

Once 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 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}] (all 7 characters, in the sequence shown) 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 three less than 5?

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.


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.

Videos
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.