Halkan waxaa ah tabobar si aad u abuurto barcode gudaha Microsoft Excel^{(generate a barcode in Microsoft Excel)} . Waxaa laga yaabaa inaad rabto inaad ku abuurto barcode gudaha Excel si aad u samayso buug-gacmeedka alaabta ama aad ula socoto alaabta kaydsan ee Excel ama sabab kale. Hagahan ayaa ku tusi doona tillaabooyinka aad u baahan tahay si aad u abuurto barcode-ka caadiga ah iyo kuwa random xaashiyahaaga Excel .

In kasta oo aysan jirin ikhtiyaar u dhashay, waxaad weli si fudud u abuuri kartaa barcode buugaagta shaqada ee Excel . Si aad sidaas u sameyso, kaliya waxaad u baahan tahay inaad isticmaasho farta barcode caadadii^{(use a custom barcode font)} si aad u abuurto nooc gaar ah oo barcode ah, sida Code 39 , Code 128 , Codes Universal Product Codes^{(Universal Product Codes)} ( UPC ), Lambarka Maqaalka Caalamiga ah^{(International Article Number)} ( EAN ), iwm. internet-ka. Waxaad si fudud u soo dejisan kartaa oo ku rakibi kartaa farta aad rabto xafiiska^(Office) ka dibna waxaad ku abuuri kartaa barcode gudaha Excel . Aynu eegno hab-socod-tallaabo isku mid ah.

Sida loo sameeyo Barcode gudaha Excel

Halkan, waxaan ka soo saari doonaa barcodes nooca Code 39 . Markaa, waxaan isticmaali doonaa xaraf code 39^{(Code 39 font)} oo bilaash ah si aan u soo saarno barcode. Si kastaba ha ahaatee, waxaad dooran kartaa far kasta oo barcode kale oo ku salaysan nooca oo aad u isticmaasho si aad u abuurto barcode gudaha buugaaga shaqada ee Excel . Waa kuwan tillaabooyinka aasaasiga ah si aad u abuurto barcode gudaha Excel :

1. Soo deji oo ku dheji font code 39 gudaha ^{(Code 39)}Xafiiska^(Office) .
2. Fur Excel oo samee xaashi cusub oo maran.
3. Samee laba^{(Create two)} tiir oo leh magacyo Qoraal^(Text) iyo Barcode .
4. U qaabeeya unugyada tiirka qoraalka .^(Text)
5. Geli qaacido tiirka Barcode .
6. U dooro font barcode unugyada ku jira tiirka Barcode .
7. Geli^(Enter) xogta alfanumeric ee tiirka qoraalka^(Text) kaas oo aad rabto in aad u abuurto barcode.

Aynu si faahfaahsan u eegno tillaabooyinkan abuurista barcode!

Marka hore, waxaad u baahan tahay inaad ku rakibto font code 39 gudaha ^{(Code 39)}Xafiiska^(Office) . Waa inaad ka soo dejisan doontaa fartan internetka. Waxaa jira shabakado soo dejiyaha farta oo kala duwan oo lacag la'aan ah^{(free font downloader websites)} si aad fartan uga hesho.

Ka dib markaad soo dejiso faylka font, ku dheji font code 39 gudaha Xafiiska . Waxaan ka isticmaalnay farta Code 39 halkan^(here) . Si fudud^(Simply) u fur galka farta la soo dejiyay, laba jeer guji faylka font TTF , ka dibna daaqada furan, dhagsii badhanka Ku rakib^(Install) .

Kadib rakibida font Code 39 , billow arjiga ^{(Code 39)}Excel oo samee buug cusub oo maran. Hadda, samee laba tiir oo leh magacyada Qoraal^(Text) iyo Barcode .

Marka xigta, waa inaad qaabaysaa unugyada tiirka qoraalka . ^(Text)Taas awgeed, dooro dhammaan tiirka qoraalka^(Text) oo ku dhufo midig. Laga soo bilaabo liiska macnaha guud, dooro Qaabka Unugyada^{(Format Cells)} ikhtiyaarka ah.

Intaa ka dib, laga bilaabo tab Number , guji qaybta ^(Number)qoraalka^(Text) oo taabo badhanka OK . Tani waxay asal ahaan ilaalin doontaa eber horseedka ah iyo sidoo kale, tirooyinka waaweyn laguma soo bandhigi doono qoraal cilmiyeed.

Hadda, waxaad u baahan tahay inaad geliso ="*"&A2&"*"qaacidada unugga koowaad ee tiirka Barcode . Waxaan u maleyneynaa in A2 ay tahay unugga koowaad ee tiirka Qoraalka . ^(Text)Haddii ay tahay tiir ka duwan tiir iyo nambar unug, tusaale, C2, D2, iwm., waxaad u habeyn kartaa qaacidada si waafaqsan. Haddii aysan jirin wax qoraal ah oo ku jira Tiirka Qoraalka^{(Text Column)} , waxay soo bandhigi doontaa laba calaamadood.

Hadda waa inaad nuqul ka sameysaa qaacidada sare dhammaan unugyada ku jira tiirka Barcode . Kaliya^(Just) dooro unugga koowaad ka dibna ka jiid cursorka geeska hoose-midig ee dhanka dhamaadka tiirka. Tani waxay khusayn doontaa qaacidada la geliyey dhammaan unugyada tiirka Barcode .

Marka xigta, dooro dhammaan unugyada tiirka Barcode oo tag Home > Font Xulashada xarfaha. Halkan, ka dooro xarfaha code 39 ee rakiban oo waxaad arki doontaa barcode unugyada kala duwan. Sidoo kale, ku dar qoraalka aad rabto inaad u abuurto barcode tiirka qoraalka .^(Text)

Isla marka aad doorato farta barcode, waxaad arki doontaa barcode tiirka Barcode ee qoraalka ku jira tiirka qoraalka^(Text) .

Sida loo Abuuro Barcode Random^{(Random Barcodes)} gudaha Excel

Waxa kale oo aad ku soo saari kartaa barcode bakhtiyaa nasiib ah gudaha Excel . Tan waxa lagu samayn karaa iyada oo la isticmaalayo shaqada RANDBETWEEN . Isticmaalka shaqadan, waxaad abuuri kartaa nambaro random ah, furaha sirta ah ee adag ee random^{(random strong passwords)} , iyo xitaa barcode-ka random. Marka lagu daro tillaabooyinka aan kor ku soo sheegnay, waxaad raaci kartaa tillaabooyinka hoose si aad u abuurto barcode-ka aan tooska ahayn ee Excel:

Taas ka dib xulashada farta barcode ee tiirka Barcode (tixraac habka jiilka barcode guud ee sare), tag tiirarka qoraalka . ^(Text)Dooro tiirka oo dhan oo ku dhufo midig. Guji^(Click) ikhtiyaarka Qaabka unugga^{(Format Cell)} oo aad tag lambarka^(Number) tabka oo hubi in loo dhigay Guud^(General) .

Hadda, dooro unugga koowaad ee tiirka qoraalka . ^(Text)Barta shaqada, ku qor qaacidada soo socota =RANDBETWEEN(X,Y): X waa qiimaha ugu hooseeya Y waa qiimaha ugu sarreeya. Asal ahaan waxay qeexaysaa kala duwanaanshaha si loo abuuro tiro. Tusaale ahaan, =RANDBETWEEN(5000,11000). Tani waxay dhalin doontaa tiro aan toos ahayn oo u dhaxaysa 5000 ilaa 11000.

Marka xigta, nuqul ka mid ah qaaciidadan dhammaan unugyada ku jira tiirka qoraalka^(Text) adiga oo ka soo jiidaya cursor unugga koowaad una soo jiido unugga u dambeeya. Haddii aad sidaa sameysid waxay soo saari doontaa tirooyinka aan tooska ahayn ee dhammaan tiirarka qoraalka^(Text) waxaadna awoodi doontaa inaad ku aragto barcode-ka gaarka ah ee tiirka Barcode .

Taasi waa ku saabsan! Waxaan rajeynayaa^(Hope) inaad maqaalkan u heli doonto mid waxtar leh!

Hadda akhri: ^{(Now read:)} Sida loo sameeyo Barcode gudaha Microsoft Word.^{(How to Create a Barcode in Microsoft Word.)}

How to create Barcode in Excel

Here is a tutorial to generate a barcode in Microsoft Excel. You might want to generate barcodes in Excel to make a product catalog or to track stocked items in Excel or for any other reason. This guide will show you the steps you need to use to create normal and random barcodes in your Excel spreadsheets.

Although there is no native option, you can still easily create a barcode in your Excel workbooks. To do so, you just need to use a custom barcode font to generate a particular type of barcode, such as Code 39, Code 128, Universal Product Codes (UPC), International Article Number (EAN), etc. These fonts are freely available on the internet. You can simply download and install the font you want in Office and then create barcodes in Excel. Let us check out a step-by-step procedure for the same.

How to create Barcode in Excel

Here, we will generate barcodes of Code 39 type. So, we will be using a free Code 39 font to generate the barcode. However, you can pick any other barcode font based on the type and use it to create a barcode in your Excel workbook. Here are the basic steps to create a barcode in Excel:

1. Download and install Code 39 font in Office.
2. Launch Excel and create a new blank spreadsheet.
3. Create two columns with Text and Barcode names.
4. Format the cells in the Text column.
5. Enter a formula in the Barcode column.
6. Select the barcode font for the cells in the Barcode column.
7. Enter alphanumeric data in the Text column for which you want to generate a barcode.

Let us check out these barcode creation steps in detail!

Firstly, you need to install a Code 39 font in Office. You will have to download this font from the internet. There are various free font downloader websites to get this font from.

After downloading the font file, install the Code 39 font in Office. We have used a Code 39 font from here. Simply unzip the downloaded font folder, double click on the TTF font file, and then in the opened window, click on the Install button.

After installing the Code 39 font, launch the Excel application and create a new blank workbook. Now, create two columns with the names Text and Barcode.

Next, you have to format the cells in the Text column. For that, select the entire Text column and right-click on it. From the context menu, select the Format Cells option.

After that, from the Number tab, click on the Text category and press the OK button. This will basically preserve leading zeroes and also, larger numbers won’t be displayed in scientific notation.

Now, you need to enter the ="*"&A2&"*" formula in the first cell of the Barcode column. We suppose A2 is the first cell of the Text column. If it’s a different column and cell number, e.g., C2, D2, etc., you can adjust the formula accordingly. In case there is no text in the Text Column, it will display two asterisks.

You now have to copy the above formula to all the cells in the Barcode column. Just select the first cell and then drag the cursor from the bottom-right corner toward the end of the column. This will apply the entered formula to all the cells in the Barcode column.

Next, select all the cells in the Barcode column and go to the Home > Font option. From here, choose the installed Code 39 font and you will see a barcode in the respective cells. Also, add the text for which you want to generate a barcode in the Text column.

As soon as you select the barcode font, you will see a barcode in the Barcode column for the text in the Text column.

How to Generate Random Barcodes in Excel

You can also generate a random barcode in Excel. This can be done using the RANDBETWEEN function. Using this function, you can generate random numbers, random strong passwords, and even random barcodes. In addition to the above-discussed steps, you can follow the below steps to create random barcodes in Excel:

After that selecting the barcode font for the Barcode column (refer to general barcode generation method above), go to the Text column. Select the entire column and right-click on it. Click on the Format Cell option and go to the Number tab and make sure it is set to General.

Now, select the first cell in the Text column. In the function bar, type the following formula: =RANDBETWEEN(X,Y). The X is the lowest value and Y is the highest value. It basically defines the range to generate a number. For example, =RANDBETWEEN(5000,11000). This will generate a random number between 5000 to 11000.

Next, copy this formula to all cells in the Text column by dragging the cursor from the first cell to the last cell. Doing so will generate random numbers in the entire Text column and you will be able to view respective random barcodes in the Barcode column.

That’s about it! Hope you find this article helpful!

Now read: How to Create a Barcode in Microsoft Word.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo isticmaalo shaqada Mode ee Excel

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo isticmaalo Find and FindB functional in Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel