How do i print mailing labels from excel 2013

Printing mailing labels from Excel 2013 is a straightforward process. Here's a step-by-step guide:

Method 1: Using the "Mailings" Tab

1. Open your Excel spreadsheet and select the cells that contain the mailing information (e.g., names, addresses, etc.).
2. Go to the "Mailings" tab in the ribbon.
3. Click on "Labels" in the "Create" group.
4. In the "Labels" dialog box, select the label vendor and the label size you want to use (e.g., Avery 5160).
5. Click "OK" to create the labels.
6. In the "Label Options" dialog box, you can choose the label layout, font, and other settings.
7. Click "OK" to print the labels.

Method 2: Using the "Print" Dialog Box

1. Open your Excel spreadsheet and select the cells that contain the mailing information.
2. Go to the "File" menu and click on "Print" (or press Ctrl+P).
3. In the "Print" dialog box, select "Labels" as the printer type.
4. Choose the label vendor and label size you want to use (e.g., Avery 5160).
5. Click "OK" to print the labels.

Tips and Variations

• Make sure you have the correct label size and layout selected to ensure that your labels print correctly.
• You can also use the "Mailings" tab to merge data from multiple cells into a single label.
• If you want to print labels with a specific font or font size, you can do so in the "Label Options" dialog box.
• You can also use third-party add-ins or software to print mailing labels from Excel, such as Avery Label Maker or Labeljoy.