how to print address labels from excel to avery labels

Click in the first label, at the end of the last data source address field in the first line of the label.As the suppression of blank address fields depends on hiding paragraphs, not lines, you need to replace line breaks with paragraphs as follows. You will now see that address field separation is created by line breaks, rather than paragraphs. If these are not already visible, select View > Nonprinting Characters from the menu bar, or press Ctrl+F10, or click on the paragraph icon in the Standard toolbar. Next, ensure that you can see non‑printing characters, such as paragraph marks, line breaks and so on.If this is not the case, then either press Ctrl+F9 or select View>Field Names to toggle the view. First ensure that the label frames are showing the field contents (data source headings), rather than their underlying field names.If this is not important, you can skip the next few paragraphs and go straight to Step 7, otherwise continue as described here. Quite often some of the fields in your address data source will be unused, leading to blank lines in your labels. You now have a new, single‑page document containing a series of frames, one for each label of the selected type and filled with the data source address fields that you selected.

Check out the labels available in Avery’s WePrint feature. To have Avery print your address labels, click Let Us Print and have the company print and deliver the printed address labels to your home or office.

To customize your address labels using the Printer options, click Print It Yourself.

Use Edit All to make changes on all the labels or Edit One to make changes on an individual label.

Click Finish once you have finalized the format of your address label. If you want to delete a wrongly-placed field, delete the field.

Arrange your data by dragging the selected field on the left to the right bar.

Uncheck the data you do not want to include in your address label.

Choose the spreadsheet file which contains the address list you want to import to Avery.

Click the edge of the text box and click Import Data from the menu bar.

Click the text box and customize its size to fit the address you want to print.

Choose from the available templates by clicking Select this Design.Start a new project by typing the Avery product number.

How to print address labels from excel to avery labels