How to Turn Excel Cells Into Mailing Labels

1. Open Excel 2010 and click the 'File' tab. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook will open.
2. Review the workbook and make sure the data that will be used in the mailing labels contains column headers. Click the 'Save' icon on the Quick Access Toolbar.
3. Open Word 2010 and click the 'Mailings' tab. Click the 'Start Mail Merge' button. A drop down list appears. Select 'Labels.' The Labels Option dialog box appears. Select the 'Label Vendor' drop down list and select the type of labels you are creating. Select the label product number in the 'Product Number' scroll list. Click 'Ok.'
4. Click the 'Select Recipients' button on the ribbon. Select 'Use Existing List.' The Select Data Source dialog box appears. Browse the files and locate the Excel workbook containing the data for the mail merge. Click the workbook then click the 'Open' button.
5. Add fields to the label by clicking the 'Insert Merge Field' button. Select one of the options in the drop down list. It will appear on the first label. If necessary, add formatting, spacing, or press the enter key. Add another field by clicking the 'Insert Merge Field' button. If necessary, add formatting, spacing, or press 'Enter.'
6. Press the 'Preview Results' button to see a preview of the labels. Click 'Finish And Merge' to finalize the mail merge. Select 'Edit Print Documents.' Click 'All' in the Merge To New Document dialog box. Select 'Ok' to see the labels prior to printing.