![how do you merge cells in excel to create mailing labels how do you merge cells in excel to create mailing labels](https://www.avantixlearning.ca/wp-content/uploads/2021/01/insert-address-block-dialog-box-for-address-labels-in-word-mail-merge.png)
As can be seen in the example, the first name on the list is in the last cell (on the fourth row) of the page. Sheet 2 contains the table used to print the labels. Because I need to print a few of these labels at a time, I added a second table, "Skip," to record how many labels had already been used on the current label sheet. The list of names is pasted into "List," the single column table on the left. It consists of two sheets containing three tables.
#How do you merge cells in excel to create mailing labels free
This free Word template allows you to easily create as many labels as you need for a specific purpose.I use a Numbers '09 document I created to print names on an 80 label/page Avery sheet. One that comes highly recommended by several WordTips subscribers is Bates Labels from Payne Consulting ( ). Of course, there are third-party solutions that are available for creating sequentially numbered labels. You should now have a document that has all your labels in it, and you can print them as desired.
![how do you merge cells in excel to create mailing labels how do you merge cells in excel to create mailing labels](http://www.gmayor.com/Images_2007/Conver21.jpg)
Press the right arrow, which should place your insertion point immediately after (beneath) the first row of labels.Select the entire first row of labels and press Ctrl+C.Select the other, blank rows of labels and delete them.You should now have a complete row of the labels. Select each of the other labels in the first row in turn, and press Ctrl+V.Copy the first label by selecting it and pressing Ctrl+C.Format the contents of this first label any way you desire.
![how do you merge cells in excel to create mailing labels how do you merge cells in excel to create mailing labels](https://www.howtogeek.com/wp-content/uploads/2007/05/WindowsLiveWriter/CreateMailingLabelsWord2003WithMailMerge_DCE6/labels_1.png)
The field is collapsed and a number appears in your label. Type a name for this sequence of numbers, such as "exhibit" (without the quote marks).Word inserts a pair of field braces in the label.
![how do you merge cells in excel to create mailing labels how do you merge cells in excel to create mailing labels](https://lh3.googleusercontent.com/-NhuJ876bmcY/X65ztt0P_CI/AAAAAAAAAMw/_jMhqHBSZKgTj4mfnaVUOhLsNi11i9JEQCO8EGAYYCw/w1280-h800/2.jpg)