Haddii aad raadinayso inaad abuurto oo aad daabacdo calaamado^{(create and print labels)} nooc kasta ah, ha ka fogaan Microsoft Word^{(Microsoft Word)} iyo Excel . Waxaad ku kaydin kartaa xogta summadaada Excel^(Excel) ka dibna ku soo qaadan kartaa xogtaas Word si aad u kaydsato ama u daabacdo sumadahaaga.

Hagahan, waxaad ku baran doontaa sida loo sameeyo xaashida xaashida sumadda ee Excel ee ku habboon Word , habayso calaamadahaaga, oo kaydi ama daabac.

1. Geli xogta calaamadahaaga xaashida faafinta ee Excel^{(1. Enter the Data for Your Labels in an Excel Spreadsheet)}

Talaabada ugu horeysa waa inaad abuurto xaashida xaashida ee Excel oo leh xogta summadaada. Waxaad ku meelayn doontaa madax ku habboon goob kasta oo xog ah si aad u soo ceshato madaxyada Word .

Tusaalaha soo socda, waxaanu samayn doonaa xaashi faafin oo leh meelaha soo socda:

• Magaca hore
• Magaca Dambe
• Cinwaanka Waddada
• Magaalada
• Gobolka
• Koodhka sibka

Si aad u bilowdo abuurista xaashida xaashida Excel :

1. Ku billow Microsoft Excel kumbuyuutarkaaga Windows ama Mac oo samee xaashi cusub.
2. Shaashada xaashida xaashida ee Excel, ka dooro unugga koowaad ee safka hore oo ku qor Magaca Koowaad^{(First Name)} .

1. Dooro unugga kowaad ee tiirka B oo ku qor ^(B)Magaca Dambe^{(Last Name)} . Sidoo kale, ku dar Ciwaanka Waddada^{(Street Address)} , Magaalada^(City) , Gobolka^(State) , iyo ZIP codeka^{(ZIP Code)} safafka hore ee C , D , E , iyo F , siday u kala horreeyaan.^(F)
2. Hadda ku dar xogta hoosteeda madax kasta oo aad hadda abuurtay. Xaashida faafintaadu waa inay u ekaataa wax sidan oo kale ah:

1. Markaad dhammayso ku darista xogta, kaydi xaashida faafinta adiga oo dooranaya Faylka^(File) xagga sare.
2. Dooro Keydi^(Save) dhanka bidix.
3. Ka^(Browse) xulo shayga dhinaca midigta ku yaal.

1. Dooro gal si aad u kaydisid xaashida xaashida, geli magaca xaashidaada gudaha meesha magaca faylka^{(File name)} , ka dooro kaydi^(Save) xagga hoose ee daqada.

1. Xir daaqadda Excel.

Xaashiyaha xisaabaadka ee Excel hadda waa diyaar.

2. Ku hagaaji Summadadaha Word^{(2. Configure Labels in Word)}

Talaabada labaad waa in lagu habeeyo cabbirada^{(configure the dimensions)} calaamadahaaga Word . Waxaa jira dhowr jaangooyooyin hore loo sii qeexay oo aad ka dooran karto. Xitaa waxaad samayn kartaa calaamad kuu gaar ah oo leh cabbirada gaarka ah, haddii aad rabto.

1. Ku billow Microsoft Word kumbuyuutarkaaga Windows ama Mac oo bilow dukumeenti cusub oo maran.
2. Shaashadda tafatirka dhokumentiga, ka dooro tabka Boostada^(Mailings) ee ka soo baxa aaladda sare.
3. Tabka diwaangelinta^(Mailings) , dooro Bilaw Isku - dhafka Boostada^{(Start Mail Merge)} ka dibna ka dooro Calaamadaha^(Labels) liiska.

1. Daaqadda furmo, ka dooro iibiyaha summada ee liiska hoos-u-dhaca iibiyaasha^{(Label vendors)} . Kadibna, ka dooro nooca calaamada liiska nambarada alaabta^{(Product number)} , Ugu dambeyntii, dooro OK .

1. Haddii aad jeclaan lahayd inaad samayso calaamad gaar ah, dooro badhanka Summada Cusub^{(New Label)} oo ku qeex cabbirka calaamaddaada daaqadda soo socota.

1. Qaabka summadaada hadda waa la habeeyey, oo dukumeentigan ku hay mid furan oo Word ah^(Word) .

3. Keen xogta Excel Dukumeentiga Word^{(3. Bring the Excel Data Into the Word Document)}

Hadda oo summadaada la habeeyey, soo rar xogta aad^{(import the data you saved)} ku kaydisay xaashida Excel -ka ah dukumeentigaaga Word . Uma baahnid inaad furto Excel si tan loo sameeyo.

Si loo bilaabo:

1. Inta dukumeentigaaga Word weli furan yahay, dooro tabka fariimaha^(Mailings) ee xagga sare.
2. Tabka boostada^(Mailings) , dooro dadka qaata^{(Select Recipients)} oo dooro Isticmaal Liis jira^{(Use an Existing List)} . Waxaad u sheegaysaa Word inaad rabto inaad u isticmaasho liis horay loo sii qeexay calaamadahaaga.

1. Daaqadda File Explorer^{(File Explorer)} ee furmo, u gudub galka uu ku jiro xaashida Excel ee aad kor ku abuurtay. Laba-guji^{(Double-click)} xaashida faafinta si aad ugu soo dejiso dukumeentigaaga Word .

1. Eraygu wuxuu furi doonaa daaqada Select Table . Halkan, dooro xaashida ka kooban xogta summada
2. Sax calaamadee safka kowaad ee xogta waxa uu ka kooban yahay madaxa tiirarka^{(First row of data contains column headers)} oo dooro OK .

4. Kudar Summada Excel Document-ga Word^{(4. Add Labels from Excel to a Word Document)}

Waxaad hadda ku qeexi doontaa meelaha aad rabto inaad ku isticmaasho summadaada.

Si taas loo sameeyo:

1. Hubi inaad weli ku jirto dukumeentiga calaamadaynta ee Word .
2. Ka dooro meesha ugu sareysa ee boostada, ka dibna ka dooro qaybta ^(Mailings)Qor & Gelida Fields^{(Write & Insert Fields)} , dooro ikhtiyaarka ciwaanka^{(Address Block)} .

1. Daaqadda Insert Address Block^{(Insert Address Block)} ee furmo, dooro badhanka Match Fields .

1. Eraygu waxa uu furaa daaqada Match Fields . Halkan, hubi in goob kasta oo ku jirta Ciwaanka Looga Baahanyahay Block^{(Required for Address Block)} ay la mid tahay goobta ku haboon ee xaashidaada ku jirta. Tusaale ahaan, Cinwaanka 1^{(Address 1)} waa in loo dejiyaa inuu isticmaalo Cinwaanka Waddada^{(Street Address)} xaashidaada, iyo wixii la mid ah.

1. Dooro OK si aad u xirto daaqada
2. Dib ugu laabo daaqada xidhidhiyaha Ciwaanka Gelida^{(Insert Address Block)} , waxaad arki kartaa horudhac sumadaada. Hubi in horudhacu uu matalo sumadaha dhabta ah ee aad rabto in aad abuurto. Kadib, dooro OK dhanka hoose ee daaqada.

1. Dukumeentiga Word , waxaad ku ogaan doontaa summada ugu horreysa hadda waxay leedahay <<AddressBlock>> .
2. Dooro tabka fariimaha^(Mailings) ee xagga sare ka dibna dooro Summada Cusbooneysii^{(Update Labels)} .

1. Dhammaan calaamadaha ku jira dukumeentigaaga hadda waa inay dhahaan <<AddressBlock>> .

5. Ka samee Calaamadaha Excel ee Dukumeenti Word ah^{(5. Create Labels From Excel in a Word Document)}

Word hadda waxa uu hayaa dhammaan xogta uu u baahan yahay si uu u soo saaro sumadahaaga. Hadda waxaad dhammayn doontaa nidaamka oo Word wuxuu soo bandhigi doonaa xogta dhabta ah ee calaamad kasta:

1. Tabka boostada^(Mailings) ee Word, ka dooro Finish & Merge option oo ka dooro wax ka beddel Documents Shakhsiyeedka^{(Edit Individual Documents)} menu-ka.

1. Daaqada furmo, dooro Dhammaan^(All) oo dooro OK .

1. Dukumeentigaaga Word^(Word) waa inuu hadda muujiyaa dhammaan sumadahaaga oo wata xogtooda gaarka ah.

Hadda waxaad kaydin kartaa dukumeentiga summadaha, waxaad ka soo saari kartaa PDF , ama si jir ah ayaad u daabacan kartaa dukumeentiga (calaamadaha).

6. Keydi Calaamadaha Erayga laga sameeyay Excel sida PDF^{(Save Word Labels Created from Excel as PDF)}

Uma baahnid inaad isticmaasho qalab dhinac saddexaad ah si aad u kaydsato dukumeenti calaamadeedka Word sida PDF:

1. Dooro tabka File ee sare ee daaqada Word.
2. Laga bilaabo dhinaca bidixda, dooro Keydi Sida^{(Save As)} .
3. Dooro ku baadho shayga^(Browse) saxda ah.

1. Dooro gal si aad u kaydsato PDF kaaga , ku qor magaca PDF - gaaga goobta magaca faylka^{(File name)} , ka dooro PDF ka menu -ka Keydi sida nooca hoos u dhaca, oo dooro ^{(Save as type)}Save .

7. Daabacado Calaamadaha Erayga Laga Sameeyay Excel^{(Print Word Labels Created From Excel)}

Waxaad si toos ah uga daabacan kartaa summadaada Word . Hubi^(Make) in daabacahaagu ku xidhan yahay kombuyuutarkaaga^{(printer is connected to your computer)} marka aad samaynayso daabacaadda:

1. Dooro tabka File ee sare ee daaqada Word.
2. Ka dooro Daabacaadda^(Print) dhanka bidix.

1. Ka dooro daabace ka menu-ka daabacaha ee shaarka^(Printer) midig, ka dibna dooro Daabac^(Print) xagga sare.

Adiguna waad wada diyaarsan tahay.

Sida aad kor ku arki karto, Word iyo Excel waxay kaa caawinayaan inaad ku abuurto ku dhawaad ​​dhammaan noocyada sumadaha kombayutaradaada Windows iyo Mac . Haddii tani ay kaa caawisay inaad abuurto nooca sumadaha ee Excel ee aad rabto, nagu ogeysii faallooyinka hoose.

How to Create Labels in Word from an Excel Spreadsheet

If you’re looking to create and print labels of any kind, look no further than Microsoft Word and Excel. You can store your label data in Excel and then fetch that data in Word to save or print your labels.

In this guide, you’ll learn how to create a label spreadsheet in Excel that’s compatible with Word, configure your labels, and save or print them.

1. Enter the Data for Your Labels in an Excel Spreadsheet

The first step is to create an Excel spreadsheet with your label data. You’ll assign an appropriate header to each data field so you can retrieve the headers in Word.

For the following example, we’ll create a spreadsheet with the following fields:

• First Name
• Last Name
• Street Address
• City
• State
• ZIP Code

To start creating your Excel spreadsheet:

1. Launch Microsoft Excel on your Windows or Mac computer and create a new spreadsheet.
2. On Excel’s spreadsheet screen, select the first cell in the first row and type First Name.

1. Select the first cell in the B column and type Last Name. Similarly, add Street Address, City, State, and ZIP Code to the C, D, E, and F columns’ first rows, respectively.
2. Now add the data beneath each header you just created. Your spreadsheet should look something like this:

1. When you’ve finished adding data, save your spreadsheet by selecting File at the top.
2. Select Save in the left sidebar.
3. Select Browse in the pane on the right.

1. Choose a folder to save your spreadsheet in, enter a name for your spreadsheet in the File name field, and select Save at the bottom of the window.

1. Close the Excel window.

Your Excel spreadsheet is now ready.

2. Configure Labels in Word

The second step is to configure the dimensions of your labels in Word. There are several predefined label layouts that you can choose from. You can even create your own label with custom dimensions, if you want.

1. Launch Microsoft Word on your Windows or Mac computer and start a new blank document.
2. On the document editing screen, select the Mailings tab from the top toolbar.
3. In the Mailings tab, select Start Mail Merge and then choose Labels from the menu.

1. In the window that opens, select a label vendor from the Label vendors dropdown menu. Then, select a label type from the Product number list, Finally, select OK.

1. If you’d like to create a custom label, select the New Label button and specify your label dimensions on the following window.

1. Your label layout is now configured, and keep this document open in Word.

3. Bring the Excel Data Into the Word Document

Now that your labels are configured, import the data you saved in your Excel spreadsheet into your Word document. You don’t need to open Excel to do this.

To start:

1. While your Word document is still open, select the Mailings tab at the top.
2. In the Mailings tab, select Select Recipients and choose Use an Existing List. You’re telling Word you want to use a predefined list for your labels.

1. In the File Explorer window that opens, navigate to the folder containing the Excel spreadsheet you created above. Double-click the spreadsheet to import it into your Word document.

1. Word will open a Select Table window. Here, select the sheet that contains the label data.
2. Tick mark the First row of data contains column headers option and select OK.

4. Add Labels from Excel to a Word Document

You will now specify the fields you’d like to use in your labels.

To do that:

1. Ensure you’re still on the labels document in Word.
2. Select the Mailings tab at the top, and then from the Write & Insert Fields section, select the Address Block option.

1. On the Insert Address Block window that opens, select the Match Fields button.

1. Word opens a Match Fields window. Here, make sure each field in the Required for Address Block matches with the appropriate field in your spreadsheet. For example, Address 1 should be set to use Street Address from your spreadsheet, and so on.

1. Select OK to close the window.
2. Back on the Insert Address Block window, you can see a preview of your label. Ensure this preview represents the actual labels you want to create. Then, select OK at the bottom of the window.

1. In your Word document, you’ll notice the first label now says <<AddressBlock>>.
2. Select the Mailings tab at the top and then select Update Labels.

1. All labels in your document should now say <<AddressBlock>>.

5. Create Labels From Excel in a Word Document

Word now has all the data it needs to generate your labels. You will now finish the process and Word will display the actual data for each label:

1. In the Mailings tab of Word, select the Finish & Merge option and choose Edit Individual Documents from the menu.

1. In the window that opens, choose All and select OK.

1. Your Word document should now display all your labels with their individual data.

You can now save this labels document, generate a PDF out of it, or physically print the document (labels).

6. Save Word Labels Created from Excel as PDF

You don’t have to use a third-party tool to save your Word’s label document as PDF:

1. Select the File tab at the top of the Word window.
2. From the sidebar on the left, select Save As.
3. Choose Browse on the right pane.

1. Select a folder to save your PDF in, enter a name for your PDF in the File name field, choose PDF from the Save as type dropdown menu, and select Save.

7. Print Word Labels Created From Excel

You can print your labels directly from Word. Make sure your printer is connected to your computer when you perform printing:

1. Select the File tab at the top of the Word window.
2. Select Print in the left sidebar.

1. Choose a printer from the Printer menu on the right pane, and then select Print at the top.

And you’re all set.

As you can see above, Word and Excel help you create nearly all kinds of labels on your Windows and Mac computers. If this helped you generate the type of labels in Excel that you wanted, let us know in the comments below.

Related posts

• Sida Loo Isticmaalo Isku-dhafka Boostada ee Erayga si loo Abuuro Warqado, Calaamado, iyo Baqshado

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• Sida loo abuuro oo loo isticmaalo AutoText gudaha Microsoft Word

• Sida loo sameeyo foomamka la buuxin karo Word

• Geli xaashida shaqada ee Excel Word Doc

• Isticmaal Hawlaha Kooban si aad u soo koobto Xogta ku jirta Excel

• Jadwalka xogtaada Excel

• Si degdeg ah ugu dar Tusmada Tusmada Kalmada Doc

• Sida Loo Galiyo Saxeexa Dukumeenti Microsoft Word

• Sida loo Helo Qiimaha Iswaafajinta gudaha Excel

• Sida loo Kooxeeyo Waraaqaha Shaqada ee Excel

• Sida Loo Raad-raaco Isbeddellada Ku Yimaadda Word (Online, Mobile, iyo Desktop)

• Sida Loo Muujiyo Calaamadaha Qaabaynta ee Word

• U rog qoraalka Koofiyadaha Qufulka oo ku celi caadi ahaan MS Word

• Casharrada Aasaasiga ah ee Microsoft Excel - Barashada Sida loo Isticmaalo Excel

• Sida loo shaandheeyo xogta gudaha Excel

• Sida Loo Sameeyo loona Isticmaalo Foomamka Shaxanka ee Word

• Sida loo duubo Macro gudaha Excel

• Sida Si Toos ah Loogu Soo Kabto Dukumeenti Word OneDrive

• Sida loo isticmaalo Sparklines gudaha Excel