Mailing Labels using EXCEL

Mailing Labels using EXCEL


Here is a simple tool for generating mailing labels using EXCEL.

There will be two sheets namely

1. List sheet


(larger images are given below)







2. Labels Sheet


(larger images are given below)







In the List sheet we have to enter the address information.

In the Label sheet, we have to prepare the labels using INDEX function. The following formula is used to generate labels

To bring the name in the first row =INDEX(Address,D1,2)
To bring the addr1 in the second row =INDEX(Address,D1,3)
To bring the addr2 in the third row =INDEX(Address,D1,4)
To bring the city in the fourth row =INDEX(Address,D1,5)
To bring the pincode in the fifth row ="PIN:"&INDEX(Address,D1,6)

for second column, we can add 1 to the D1 cell
for third column, we can add 2 to the D1 cell

for the second row of labels, we can use D7 cell as row reference

We can enter the formula once for first row of the labels.
For subsequent rows, we can copy and paste the formula.

I hope this simple solution will be useful for you all.

Cheers! (mail me your comments)

karthiganesh@yahoo.com

Larger images of the above sheets are given below:

List Sheet



Labels Sheet