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

Referencing the Last Cell in a Column

When developing formulas, you may need to reference the very last value in a particular column. This can seem perplexing, ...

Discover More

Limiting Lines in a Table Cell

When creating tables, Word automatically sets the size of the cells. But what if you want to make sure each cell is a ...

Discover More

Enabling Filters by Default

Filtering can be a powerful way to work with large amounts of data in a worksheet. If you use filtering quite a bit, you ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!

More WordTips (ribbon)

Printing Return Address Labels

Want an easy way to create your own return address labels? Word provides the tool as a feature of the program.

Discover More

Changing Label Printing Order

If you want to change the order in which labels are printed when doing a mail merge, Word doesn't provide many options. ...

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
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 9 + 4?

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.