How to Format Address Labels Using Excel

Save time by formatting address labels.

Microsoft Excel is an application created to help analyze and manage data. You can use it to create reports, pie charts and pivot tables. You can also use it to display data three-dimensionally. It was also created to work together with the Microsoft suite. Formatting address labels with Excel requires steps to match it to the labels you're printing them on as well as creating and entering your data. Additionally, you can save your data for future use.

Instructions

1. Organize your data in list format. Label "First Names" in one column and enter names in the rows beneath and label "Last Names" in the next column. Type the address in the next column and the zip code in the next column. Put the coordinating information beneath the labels. Leave no spaces between columns. Save and close your workbook.

2. Open Microsoft Word. Click on the "Tools" menu and hover over "Letters and Mailings." Click on "Mail Merge." Wait for the mail merge wizard to load.

3. Click on "Labels" in step 1, then "Label Options" in step 2. Decide on the type and size of labels you wish to print. Click on "Select Recipients" in the third step. Choose "Use existing list" and click on "Browse."

4. Locate your Excel workbook. Click on it in the "Select table" dialog box. Check the box next to "First row of data contains column headers." Click on "OK."

5. Click column labels in your data that match the items listed in the "Mail merge recipients" dialog box. Click "OK" and print your labels.

References

• Microsoft Office: Print labels by using Excel data in a Word mail merge