how to do a mail merge in excel for labels

As you hold it, also press the Ctrl key, and drag straight down to the bottom of the page. To fill in the column, hold a right click on the lower right hand corner of the cell you just typed in. Now when you type the number 1 in cell A2, it’ll show as 000001. In the Type field, we just type 6 zeros, 000000. Then choose the Number tab, and click on the Category ‘Custom’. Once it’s selected, right click on the column, and chose Format Cells from the dialog menu. Select the entire first column by clicking on the column heading A.

First name the column A by typing the word NUMBER into cell A1. We’ll also want to pad the numbers on the left with zeros. Lets say for instance you want to number your labels from 1 to 2000. The first step is to create the Excel file with consecutive numbers. If you have a need to print cells with consecutively numbers, using Excel together with Word works great. They’re used to insert all kinds of data into various types of documents. Mail merges are not used exclusively for mailings. We’ve used the 80 labels per sheet ML-8100 template as the primary document and created an Excel file as data file in our mail merge. However, some customers use them simply as a numbering or coding label. The 80 labels per sheet ML-8100 is normally used as a return address label.

How to do a mail merge in excel for labels