But printing mailing labels, envelopes, greeting cards, or anything else could be hard work. Since technology is not going anywhere and does more good than harm, adapting is the best course of action. The Match Fields window will appear. To create labels, you first have to merge the data from Excel to Word. For the Product number, browse through the options and select. But if youre using a specific vendor and product number, feel free to use them instead. You cannot turn off age restriction on Twitter but there are ways around it. You may need to put in some work in the beginning but youll certainly save a lot of time and work in the future . The following examples illustrate the use and print labels from the Excel sheet. Click Finish & Merge in the Finish group on the Mailings tab. Select Mailings > Write & Insert Fields > Update Labels. Create and print mailing labels for an address list in Excel, Prepare your Excel data source for a Word mail merge. How-To Geek is where you turn when you want experts to explain technology. You can even insert images in the mailing labels if you want, but that step would come later in Word. Apple's Mixed Reality Headset Needs These Specs to Win at VR, Meta's New VR Gaming Showcase Featured Tennis, Dungeon-Crawling, and Popular IPs, Meta Quest 3 VR Headset Arrives This Fall and Costs Just $500, Google Announces 7 Android Features Like New Widgets and Shortcuts, No Mans Sky Finally Launches on Mac, Supporting PC Cross-Play and Saves, Is AI an Existential Threat? You can store your label data in Excel and then fetch that data in Word to save or print your labels. You can easily organize a mailing list/address list in Excel. To review your results, choose the Preview Results option from the top bar. Click on the first label on the page and then select Address Block in the Write & Insert Fields section of the Mailings tab. From time to time, I will invite other voices to weigh in on important issues in EdTech. All Rights Reserved. Now the information from your address list will be transferred to your labels and a new document will appear with the mailing labels from your Excel address list. How to Print Labels from Excel - Excel Labels Guide - enKo Products document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. (A Beginner's Guide), 4 Best Apps to Remotely View a Webcam on iOS and Android, 6 Ways To Animate Still Photos Online Or With Apps, 5 Best Apps to Download Music for Free on Android, The 6 Best Online Paraphrasing Tools to Rewrite Text, How To Download Complete YouTube Playlists, What Reverse Image Search Is & How To Use It, How to Add a Discord Widget to Your Website, What Is a Custom Domain and How to Set One Up, 3 Bot Accounts To Help You Save Content From Twitter, The Ultimate List of YouTube Tips, Hacks, and Shortcuts, How To Easily Add Watermarks To Your Online Images Before Uploading, Create a Personal Website Quickly using Google Sites, How to Configure Auto-Login for Windows 10 Domain or Workgroup PC, How to Use Google Authenticator on Windows 10, How to Fix Delay or Lag When Typing in Windows, How to Fix Media Is Write Protected in Windows, Web Pages Loading Slowly? NGYxNmMyOTgxOGJiMDZkMGNhZjQzOWUwY2I0NGJhMTExMjZkZTYxNzc2NTRk If not, click the dropdown button next to the required field and match it up with a column heading on your Excel file. All thats left to do now is print out your labels, cut them up, paste them on mails, and send out your mails. To create and print the mailing labels, you must first prepare the worksheet data in Excel, and then use Word to configure, organize, review, and print the mailing labels. Click https://sqlspreads.com/?pid=barbhenderson to find out how SQL Spreads works best for non-technical end users and download our free 14-day trial. Now, AddressBlock will appear in the first label of your document. Why Does Chrome Have So Many Processes Running? Excel Date Filter Is Not Grouping by Month (3 Solutions), SUMIFS to SUM Values in Date Range in Excel, Formula for Number of Days Between Two Dates, Then, from the drop-down menu select the option, From the dialogue box select the options as shown in the figure and press. When you add mail merge fields to your labels, those fields will become placeholders for the column headers in your worksheet. We are choosing the 3M label manufacturer as our vendor because thats the brand we are using. Our list will include the following headers: This is the standard information youll find on mailing labels. Now its time to add your mail merge fields in Words labels. Can you print labels directly from Excel without Word? Step-1: Insert Data in Excel Worksheet for Labels Step-2: Check the Confirm File Format Conversion Status in Microsoft Word Step-3: Arrange Labels in Word Document to Print Labels in Excel Step-4: Import Excel Data in Microsoft Word Document Step-5: Insert Mail Merge Fields in Microsoft Word Lets take things one at a time . Create and print mailing labels for an address list in Excel Spread the loveChange appears to be the only constant factor in the educational field. You will need to connect the Word document to the Excel worksheet containing a mailing list to print your labels. Related Content: How to Print to PDF in Excel VBA : With Examples and Illustrations. Configure Labels in Word 3. As such, this powerful tool can be used to transform learning. Related Content: How to Print Multiple Sheets in Excel (7 Different Methods). We have thousands of articles and guides to help you get the most out of technology. Your labels are now connected with your worksheet. Related Content: How to Adjust Print Settings in Excel (8 Suitable Tricks). YzRlOGI0MzQzY2IwNmZhNmY0MjkzN2I2NzE0OTYzYzQ4MzI0ZTZiMWMxNTNh Once youre done, click OK. For example, First Name should match with First Name, and so on. Changes or additions to your spreadsheet are completed before it's connected to your mail merge document in Word. In this step, we will arrange labels in word documents to input values from our excel worksheet. 12 Ways to Fix, 7 Best Invisible or Hidden Google Games To Play for Free in 2023, 12 Fixes for YouTube Not Working in Google Chrome, 14 Best Google Chrome Themes You Should Try, Google Search Bar Widget Missing? In fact, this article portrays how to print Avery labels from Excel. If any of them are incorrect, use the drop-down arrow beside it to match up to the correct field. Microsoft Excel provides us the feature to create labels and preview the labels before we print. Tags: How to Print Excel SheetMailing Labels in ExcelPrint Labels in Excel. Election Hacking 101: Is It Safe to Vote Electronically? 11 Ways to Fix, How to See Recently Deleted Apps on iPhone and Android, How to Fix an Android Phone Not Receiving Calls, 9 Ways to Stop the Message Blocking Is Active Error on Android and iPhone, How to Text Someone Who Blocked You (iPhone and Android), Voicemail Not Working On Android: A Troubleshooting Guide, How to Find Out an Unknown Caller's Number, 15 Best Meeting Minutes Templates to Save Time, How Does WhatsApp Work? To print labels in excel with Microsoft Word we need to check the confirm file format conversion option. OWFhZGI1ZDI1MDUzOTIxNmJjZDVkMmZlMTNjNjJmZGFkZDU0NzZmZWUxNmRl Your list from Excel will now be merged into the labels in Word. The Tech Edvocate ZjI3OTlkM2Y1ZDI4YjU1ODcxYjEwMDQxOTIzYmM2MGNiNTNmODc5OGEwMjFh To create and print the mailing labels, first, you need to set up your worksheet properly. NTI3MmVkYmRjNDQxNGY4N2YzZmVjODExZDIzOTA5NWI0OGUxZjFkNjE2NmU0 Your label outlines will now appear in Word. For the following example, well create a spreadsheet with the following fields: To start creating your Excel spreadsheet: The second step is to configure the dimensions of your labels in Word. Thanks in advance. MDNlNzgzMTcyMmQzNjA2OGYzY2NmZDQ1YmU5NjBiYzUzYjM3YWY5YWE0NjVm After that, to design the appearance of labels go to the. Read More: How to Mail Merge Labels from Excel to Word (With Easy Steps). If you dont know how to mass print your labels from Excel, then read this step-by-step guide. So, try to avoid them. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. Related Content: How to Print Data with Excel VBA (A Detailed Guideline). This involves adding your own text or graphics, changing the font or color, and adjusting the spacing or margins. Next, you should to connect the word document to the worksheet containing your mailing/address list to transfer the data to your labels. If youre looking to create and print labels of any kind, look no further than Microsoft Word and Excel. How to Print Labels from Excel - Lifewire Once, you finish formatting the currently previewed label, click Update Labels under the Mailings tab to apply the formatting to all the labels. MWU1ODJkMDhhMGYwZjdhNTc4ZTVhMzU3NTA1ZDAwOTU1OTEyOTNmODYxMjhj Make sure your cursor is on this area of the document. Then, click Open. Does Your Windows Computer Display Turn Off Every 15 Minutes? All data to be merged is present in the first sheet of your spreadsheet. Click on, The above command will open one more dialogue box named. Labeling is essential in terms of marketing a product, the address of a person to deliver a product, and many more. Add mail merge fields: In Word, go to Mailings > in Write & Insert Fields, go to Address Block and add fields. MGEzOWQyOTUzNjk0NTQ3NTUzODcxYjcyYzQ1ODI5OTE5NzEyNDM2NjdhZGQ4 For example, if you are printing address labels, you will need to enter the names and addresses of each recipient in separate cells. 3 ways to manually update the Audio Drivers on your Windows 11 system, A straightforward guide for making your Windows 11 Taskbar transparent, A comprehensive guide to using ChatGPT Plugins and enhancing your AI experience. Answers to Frequently Asked Questions About Google Classroom - The Tech Edvocate - Gossip Buz, 10 Important YouTube Channels For Teachers - Kiiky Wealth, Teaching Learners Digital Content Curation Skills - Fab Lab Connect. Thats what Excel is forto help you complete work while helping you save time doing the work. Hi there! Spread the loveEffective digital learning is the future of education and it is here to stay. Online Tech Tips is part of the AK Internet Consulting publishing family. Explore subscription benefits, browse training courses, learn how to secure your device, and more. Its time to Finish and Merge! Click on "Address Line 1" underneath the "Insert Merge Field" drop-down menu. We can see that the labels are inserted one by one on the page in the format we wanted. They miss the social side of school. It may sound a little challenging but we will be with you every step of the way. However, when you get ready to print mailing labels, youll need to use mail merge to create them in Word from your Excel list. In that, select All under Merge records and click OK to finish. . Titles are always nice, but its important that you know which title a person goes by before creating the labels. Fire TV vs Fire TV Stick: What Are the Differences? Your mailing labels are ready to print , With the borders in place, you will find it easy to cut the printed labels , Printing labels have never been this easy! You can even create your own label with custom dimensions, if you want. Select the one containing your list. Lets see how we can do this. How to print labels from Excel without Word Can you make Avery labels from an Excel spreadsheet? N2IwNzJkMDE3YzU0YjdmY2FmZDk1NmM0ZjhiNDkyZmVkY2RkNWU4MjhmOGYw Lets see how we can do this: Read More: How to Print Excel Sheet with Lines (3 Easy Ways). 1. . Launch Microsoft Word on your Windows or Mac computer and start a new blank document. Address envelopes from lists in Excel. Youll assign an appropriate header to each data field so you can retrieve the headers in Word. 1 How To Print Address Labels From Excel Below are the steps on how to print address labels from excel. But you can also use it to create and print mailing labels for your mailing list , All you need to do is to prepare your label data in Microsoft Excel, use the mail merge feature, and print them in Microsoft Word , In this article, well provide you with an easy-to-follow step-by-step tutorial on how to print labels from Excel. We hope to provide a well-rounded, multi-faceted look at the past, present, the future of EdTech in the US and internationally. 5322 Markel Road, Suite 104 Go to the Mailings tab in the Word document, and select the Select Recipients option. How to Print Avery Labels from Excel (2 Simple Methods) - ExcelDemy In the end, this tutorial was a complete guide about how to print labels in excel. You will get two months free when purchasing an annual subscription using our link.Check out my online training http://www.easyexcelanswers.com/courses.htmlFor more help visit my website http://www.easyexcelanswers.com or email me at easyexcelanswers@gmail.com.https://www.amazon.com/shop/barbhendersonTo purchase more labels click the link belowhttps://amzn.to/2pz0ILCI am able to provide online help on your computer at a reasonable rate.Check out my next one-hour Excel Webinarhttps://www.crowdcast.io/easyexcelanswersCheck out Crowdcast for creating your webinarshttps://app.linkmink.com/a/crowdcast/83If you need to buy Office 2019 followhttps://amzn.to/2VX5dv8Follow me on Facebookhttps://www.facebook.com/easyexcel.answersFollow me on twittereasyexcelanswersIG @barbhendersonconsulting*this description may contain affiliate links. In this step, we will connect our Word file with an Excel worksheet. We plan to cover the PreK-12 and Higher Education EdTech sectors and provide our readers with the latest news and opinion on the subject. ZGE4MjExOTBlMDEzNTVjNWI2Mzc2YzFkZjUwZGFkNzVkN2VkOTlmMDBhODcx On the Mailings tab, click Finish & Merge., From the drop-down menu that appears, select Edit Individual Documents., The Merge to New Document window will appear. Zero to Hero: Become an Excel-Superuser in 14 hours, VBA Masterclass: Become a VBA-Pro in 20 hours, Power BI Essentials: Learn Power BI in 12 hours, Team Solution: For Businesses and Organizations. Make sure each item is in the correct column. When the spreadsheet is ready, store it on your computer. Secondly, from the ribbon select the option, Thirdly, from the drop-down menu select the option, Fourthly, browse and select the excel file. You can edit, print, and save the labels just as you would any other Word document. You can also select New Label if you want to enter custom label dimensions. MzAxYmE4MDZjN2I4NGYzMGVlMTgwMDJiZTg2ZGNiZTc1NmNmODhmMGUyZDJm Also, if your list is for companies and not individual people, you can omit the First Name and Last Name header and just go with Company Name instead. Once you have chosen a label template, you can customize your labels to suit your needs. Once finished, click OK.. To do this we have to import excel data in our Microsoft Word document. Create labels without having to copy your data. Then open Word, and follow the steps to Print labels for your mailing list. Step 5: Print Your Labels. This is default text for notification bar, Changing the Wallpaper and Theme on Your Google Chromebook, Choosing the Right Amp for Your Car or Truck, How to Add Advanced Headers and Footers in Word. The Label Options dialog box will appear. Is this something youve come across before? Place those headers in the first row of each column. Heres how. It's a walk in the park to uninstall ChatGPT Plugins. ZjdiZTdhZDEyMjQwOTI4ODEzY2RlNmQiLCJzaWduYXR1cmUiOiIyN2Y0YWE1 M2U4ZjNjMGU3MmExODE2MDgxNzgxNjZmNjAxMzcxZTA4YTkzMThlZDQ2YzM0 Copyright 2007-2023 Online Tech Tips.com, LLC All Rights Reserved. Select the Excel source file you saved earlier. Spread the loveTechnology is used for many great things in our world. The first time you connect to an Excel worksheet from Word, you must enable a setting that allows you to convert files between the two programs. Address: Smosevej 17, 2740 Skovlunde, Denmark. Spread the loveRemote learning is taking its toll on our students. Get started with Macrosits free and beginner-friendly! How to Print Labels from Excel If you want to print mailing labels from an address list that you maintain in an Excel spreadsheet, you can use Microsoft Word mail merge. Here, you can select your label brand and product number. Before you can transfer the data from Excel to your labels in Word, you must connect the two. Launch Microsoft Excel on your Windows or Mac computer and create a new spreadsheet. To create and print the mailing labels, you must first prepare the worksheet data in Excel, and then use Word to configure, organize, review, and print the mailing labels. Your label layout is now configured, and keep this document open in Word. Now, youre now ready to perform the mail merge. Since we are going to create address labels, lets insert an Address Block merge field. With the file selected, click Open., The Select Table window will appear. With these simple steps, you can easily print labels from Excel. Click on the File tab and select Options at the bottom of the left pane. You can even change the labels font type, font size, font color, etc. Select OK. When you purchase through our links we may earn a commission. Select All and then click OK.. Supercharge Your ChatGPT with this step-by-step guide for enabling the web browsing model for ChatGPT. ZjRmM2UyNWU2N2YxN2I4ZDlmZDA4M2ZhNzJjNzgyY2VmOWVlOWE0MTFmYWZm This will select the whole table where all the address labels are. Fire Stick Lite vs Fire TV Stick: Which Should You Buy? YWEwYWM2ZjE1M2Y2MzM2NTU0N2M4YzU4YzM5MTdmNjRiN2ExMDgzM2IwYzU0 I am Mukesh Dipto. Address envelopes from lists in Excel. How to print mailing labels from Excel - YouTube For example, you might have the following column headings: Type in a heading in the first cell of each column describing the data. To apply filters to a pivot table in Excel, select the Column Labels down-arrow to open the filter's drop-down list, uncheck Select All, then choose your desired filters. Philips Hue Lights Unreachable? How to Print Address Labels From Excel? (with Examples) - WallStreetMojo After you've organized the data, you need to add mail merge fields before you can complete the merge. Now, you can perform the actual mail merge. Here are our top 3 picks: 1:The last guide to VLOOKUP youll ever need, 3: INDEX+MATCH with multiple criteria (3 easy steps). You may be using Microsoft Excel to organize a mailing list neatly. What Match Fields does is that it links up with the Excel file you made. You can now edit, format, print, and save this label document just like any other Word document. Now that your labels are configured, import the data you saved in your Excel spreadsheet into your Word document. How to Print Labels from Excel - All Things How How to Disable the Touchpad on Windows How to Disable the SmartScreen Filter in Windows, 7 Ways Technology Is Impacting Modern Education, 20 Top Virtual Reality Apps that are Changing Education, Why Mobile Technology Enhances Instruction, 7 Roles for Artificial Intelligence in Education, Digital Literacy is the Most Important Lifelong Learning Tool, 11 Must-Have Apps and Tools for Dyslexic Students, How to Integrate Google Classroom with the Power of YouTube, Answers to Frequently Asked Questions About Google Classroom, 10 Incredibly Useful YouTube Channels for Teachers. My favorite sports are football (to watch and play) and Badminton (play). If you havent created the list yet, despite Excels lack of the mailing label function, we still highly recommend you use Excel since its better for organizing and maintaining data than using a Word table. Currently, I am working as a technical content writer in ExcelDemy. YzVkNTc4Y2ExODI5YzJmMGJjMGJkYjcxY2Y3YjMxZWFjZWQ2ODdkYmQ2MjRi It will ask you to Merge to New Document. For more information, see Prepare your Excel data source for a Word mail merge. Yes. It reads the first row of entries and matches them up with the fields required for the Address Block. NTU1YzQ1OGQ4NGZhZGZjYmVjZjdkYTZjY2NiYTI1MjI0MzQ3YTYxNzQxNTk5 How To Print Address Labels From Excel - PC Guide 6. If you have named your address list (Customer_Mailing_List), select it and click OK. All you need to do is to prepare your label data in Microsoft Excel, use the mail merge feature, and print them in Microsoft Word In this article, we'll provide you with an easy-to-follow step-by-step tutorial on how to print labels from Excel. Which headers you include depends on which information you plan to use in the mailing labels. ZWI1ZDE1YjA1MjQ5ZTM1NjZhYTJiNjE0MzNhZGI4NzAxYTM4OGMwOGViYmY4 Creating Labels from a list in Excel - YouTube So, for your convenience to understand easily we will demonstrate this method to you in seven steps. I only recommend products and services that I've used or have experience with. Select the first label, switch to the Mailings tab, and then click Address Block.. Make a column for each element you want to include on the labels. Lets say you want to send a mass mailing to a mailing list that you maintain in an Excel spreadsheet, the best way you can do that is by using the Microsoft Word mail merge feature. Create Labels From Excel in a Word Document 6. Using the combined features of Excel and Word, you can now create, format, and print labels faster. iPhone v. Android: Which Is Best For You? Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge. Its a powerful tool when used correctly. Now, you have to add mail merge fields to the document before you can finish the merge. Spread the loveWhen becoming a leader in the field of education, it is important to consider equity. Note: If your label outlines arent showing, go to Design > Borders, and select View Gridlines.. Type the column header in the first cell of each column and fill the respective information under those column headers. Back in the Mailings tab in the Word document, select the Select Recipients option. A new Word Options window will open up. Ensure youre still on the labels document in Word. Make sure your printer is connected to your computer when you perform printing: As you can see above, Word and Excel help you create nearly all kinds of labels on your Windows and Mac computers. Click the Match Fields button on the Insert Address Block dialog box that appears. Did you enjoy this tip? But if youre using a particular vendor, e.g. MTcxMjE3YTVhY2JkY2YyZDU0MjI2M2Y4Yjg4YmQ0MmNlZWUwMmY1M2QwODM0 Since we launched in 2006, our articles have been read billions of times. Choose brand and product number. The first step is to create an Excel spreadsheet with your label data. NmI4M2Y3ODkwYmVlMjQ3NjBhN2UxYTE3MmEyNDk2Mzk4MGIyOTA0MDkyYzMz Postal code data is correctly formatted in the spreadsheet so that Word can properly read the values. Check the Confirm File Format Conversion on Open option and click OK. Now, click. All you have to do is click the plus (+) icon on the upper-left side of the table. To add borders, click the plus (+) iconon the upper-left side of the texts. To properly illustrate the steps, well go with a personal mailing list in this example. Thanks!https://www.paypal.me/davestechrescue#christmascards*** My gear ***Camera - Canon EOS 700D (Rebel T5i)https://geni.us/mVaLMicrophone - Rode Videomic Prohttps://geni.us/ymKY5RLaptop - HP Spectre x360https://geni.us/OS4dAs an Amazon Associate I earn from qualifying purchases.Music: https://www.bensound.com Spread the loveWith the internet being flooded with a plethora of freeware apps and software, its not easy to differentiate between the genuine and the potentially harmful ones. Select the list of addresses in the Excel sheet, including the headers. Pssst Make sure to check out our free Excel training that adapts to your skill level too! Navigate to the Excel spreadsheet with the mailing list in the Select Data Source window, select the file and click Open. In the drop-down, click the Use an Existing List option. In the following dataset, we have taken the First Name, Last Name, Address, and Country of five presidents. How to Print Labels From Excel: Step-by-Step (2023) - Spreadsheeto Scroll down, and select Options at the bottom of the left pane. Save the worksheet when you have finished. ZDVjNDE1NGNjOGE0YTE4YjEyZDYyOTIzYjYyZTdmMjkyNzE0ZTQyZmYwNWIw My sheet is double spacing the lines, so they do not fit well on my labels. Spread the loveStanding desks have become increasingly popular over the years, with many people choosing to incorporate them into their daily routines. Word now has all the data it needs to generate your labels. ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. Spread the loveToday, I received an email from the middle school principal in Los Angeles. What Is the Latest Version of Microsoft Office? Copyright 2023 Matthew Lynch. Creating Labels from a list in Excel, mail merge, labels from excel. Secondly, a new pop-up box will appear named. You can download this Print Labels From Excel Template here - Print Labels From Excel Template Example #1 - Print Address Labels from Excel with the Help of Word Finally, you are ready to print your labels. N2RjYzQyZmUyY2Y1ZTU3ZmFhMWMxM2ZjNmFlMWY0MTNjMDFlMDEzZmJkNzBk How to Restore It on Android. Make sure: Column names in your spreadsheet match the field names you want to insert in your labels. Join my free online course to learn the basics of Mighty Macros where I teach you how to record and edit a macro, how to write your first macro from scratch, and the basics of the VBA editor. Marshall is a writer with experience in the data storage industry. Create labels without having to copy your data. Before you proceed, check the information again Do not leave any blank cells or empty rows as this might mislead Microsoft Word later when doing the mail merge. First and foremost, in Step-1 we will data in an excel worksheet from which we will create labels to print. Spread the loveRisk management is a systematic process that is aimed at identifying, assessing, and controlling potential risks that may adversely affect the achievement of organizational goals. If you have any questions, please leave a comment in the box below. Spread the loveDigital equity is vital in our schools. Download the practice worksheet that comes with this article to put your skills to the test. The Mail Merge Recipients window will appear listing all the recipients from your address list. ZGI2NDMzNWViNjk0ODg1ZDA4MDU1M2U1YjIzZDU5ODkyOThhY2Q4NjQwYWVl So, we will get a new page like the following image. Spread the loveThe EdTech industry is dominated by white employees, white leaders, and white entrepreneurs. Congrats, Now Add It to LinkedIn, Snapchat Score: How It Works and How to Increase It, 5 Best Bluetooth USB Adapters for Your Playstation 5 (PS5), 10 Best Smartwatches and Fitness Trackers With Oxygen Monitors, The Best Websites for Buying Computer Parts Online, 7 Coolest Wearable Electronics You Need to Have in 2022. YWQzODcxMmE1MjIzZDI3ZDZkMDlhNWRiMzNkZWU3MTI5Y2U5NGJmNDc5YzUx How to Create Mailing Labels in Word from an Excel List We will use input data from the excel worksheet in the final table of Step-5 to create labels. Once you have prepared your data, you need to choose a label template that matches the size of the labels you want to print. Its where Microsoft Word pulls the details for your labels. Now that was done, lets proceed to the next.