In this video tutorial we will show you how to create excel spreadsheet for labels.
In order to create excel spreadsheet for labels, you must have an excel document with the addresses. Open the Microsoft Word. Go to the “Mailings” tab. Click “Labels”.
![Open the Labels dialogue](https://howtech.tv/wp-content/images/001365/1.jpg)
In the following window select “New document”. In a “new document” window, go to the “mailings” tab. Click “Use Existing List”. In the next window select your excel data as source. In the following window choose “Sheet1” and press “ok”. In the “Mailings” tab, click “Insert Merge Field” and add data.
![Add data](https://howtech.tv/wp-content/images/001365/2.jpg)
Click “Preview Results”.
![Look on the results](https://howtech.tv/wp-content/images/001365/3.jpg)
Press “Finish&Merge” and choose “Edit Individual Documents”.
![Open Edit Individual Documents dialogue](https://howtech.tv/wp-content/images/001365/4.jpg)
In the following window select “all” merge records and click “ok”. Now you know how to use excel spreadsheet for labels.