Don't forget to add commas and spaces to separate fields For this, just double click or drag and drop them in the text box on your right. This step is optional but highly recommended if your designs look neat. Arrange the fields: Next, arrange the columns and rows in the order they appear in your label. Once done, tap on the 'Next' button on the bottom right side of the popup.ġ1. Remember to uncheck row and column titles in your spreadsheet. Choose the rows you want to print: Uncheck any column or row you don't want to be included in your labels.

Select 'Browse for File'' and upload your spreadsheet from the location you saved it.ġ0.

Next, click on 'Start Import/Merge.' A popup will appear, prompting you to upload your spreadsheet or mail merge data. Click on the 'Start Designing' button as shown below: Start Designing: Once you have selected the preferred shape and design, it's time to start customizing your labels. For this tutorial, we have selected an address label template.Ĥ. Choose your favorite shape and design: Once the webpage has loaded its contents fully, choose the form, type, and format you want your labels to be. Go to Avery’s official website: You could do a quick Google search to find it or use their official address.ģ. Once done, save the document to a directory you can remember as we will use it later in the procedure.Ģ. Fill out all the data you need to be labeled. Create the Spreadsheet: Open your MS Excel and start creating the spreadsheet in question. Hence, be sure to choose your favorite colors or shapes and not the ones captured here.ġ. We have picked random shapes and colors to illustrate how you should make Avery labels from your spreadsheet.

Use the Microsoft Word's Find and Replace formatting tool to replace all the pre-designed template text in each label with your own information.Please note that this is just an illustration for you to understand the procedure.

Continue with Step 3 until all labels are filled with your information.

Position the cursor in the next label, right-click and select Paste.Highlight all the content in the first label, right-click and select Copy.Insert your information on the 1st label.

How to create a sheet of all the same labels: Then click Text Wrapping and select In Front of Text in the drop down list. Select your image in the template and click the Page Layout tab in the Ribbon Toolbar. Highlight the text you entered and use the tools in Microsoft Word to format the text.Ĭlick the Insert tab in the Ribbon Toolbar to insert your own image, clip art, shapes and more. Once the file is open, type your information into the template. If the template looks like a blank page, select Table Tools > Layout > Show Gridlines to view the template layout. Double-click the Avery Word Template file you downloaded and saved to your copmuter.

Avery 5161 template word mac