17th October 2019

office
13

How do I print Avery labels from Excel?

To configure the label main document, you match its dimensions with the dimensions of the labels on the worksheets that you plan to use.
  1. Start Word, and open a blank document.
  2. On the Mailings tab, in the Start Mail Merge group, click Start Mail Merge.
  3. Click Labels.

Keeping this in consideration, how do I change my printer settings to print labels?

Printer settings. When you click Print, look in the Properties options in the print dialog box. Adjust Paper Type to Labels and Print Quality to Best. If your printer doesn't have a Labels setting, choose Heavyweight or Cardstock.

How do I print Avery 5160 labels?

To format Avery-compatible labels, go to the Mailings tab, and choose Labels. Click Options, and in the Label vendors box, choose Avery US Letter (or Avery A4/A5 for A4/A5-size paper). Then, choose from the list of products. For details about making labels in Word, see Create and print labels.

How do I print labels?

Create and print a page of different labels
  1. Start Word.
  2. On the Mailings tab, in the Create group, click Labels.
  3. Leave the Address box blank.
  4. To change the formatting, select and right-click the text, and then click Font or Paragraph on the shortcut menu.
  5. To select the label type and other options, click Options.
Write Your Answer

Rate

100% people found this answer useful, click to cast your vote.

5 / 5 based on 2 votes.

Bookmark

Press Ctrl + D to add this site to your favorites!

Share