How to Create Labels From Excel

Next Video:
How to Make a Spreadsheet in Word....5

Labels can be created in Microsoft Word using data from Microsoft Excel by saving the data in Excel and doing a data merge. Open a data source and merge the information with help from an employee of an IT company in this free video on creating labels from Excel in Microsoft Word.

Part of the Video Series: Microsoft Word
Promoted By Zergnet


Video Transcript

Hi my name is Stefanie and I work with CMIT Solutions. Today I am going to show you how to create labels in Microsoft Word using data from Microsoft Excel. In order to create labels in Microsoft Word using data from Microsoft Excel simply open up excel, create a new workbook and file under file new workbook. Setup your data. In this case we are going to create address labels. I'm going to put as my headers in my excel spreadsheet, first name, last name, address, city, state and zip code. Put in an example. You are going to want to save this data. Rename it, save it to your favorite spot on your hard drive. Open up Microsoft Word, create a new blank document. Go to tools, and labels. You can change the font if you wish of your address labels or you can change the options to select a different type of label. Here we are going to select 5160 address labels. Select data merge. Under data source select get data and open data source. Here we are going to open up the addresses excel spreadsheet that we've originally created. Select sheet one which is where our data is and cell range the entire worksheet. Click ok. Insert the merge field of each column. Here we are going to select first name, space, last name, enter, the address, enter, select city, comma space. State, space, zip code and hit ok. This will automatically change the formats of all the labels to the format you just created. You can click on preview or click on merge, select merge to new document. And there are your labels. And there is the data that we put in in our original excel spreadsheet. And it's as easy as that. Simply enter your data for your labels into an excel spreadsheet, use that as the data source in Microsoft Word under tools and labels.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!