Excel chikumbiro chine huwandu husingaperi hwemabasa akakosha, ayo dzimwe nguva atisingazive, sezvazviri Gadzira barcode muExcel. Kana iwe uchida kuziva maitiro ekutsanangura iwo nhanho nhanho, tinokukoka iwe kuti uverenge chinyorwa chinotevera uye dzidza zvimwe pamusoro penyaya iyi.
Bar Code yakagadzirirwa muExcel
Gadzira barcode muExcel: Ndeapi macode aya nezve?
Tisati tarisisa nhanho dzatinofanirwa kuisa kugadzirira barcode, tinofanirwa kuziva kuti aya madiki maseti emitsara ane ruzivo rwakadzama nezvechinhu kana chigadzirwa, zvichiita kuti zvive nyore kuiziva kana uchigadzira heseti kana kubvunza hunhu.
Maitiro ekugadzira aya macode kuburikidza nezvirongwa zvakaita seExcel, zvinowanzoita kunge basa risingakwanise kuita, zvisinei, zviri nyore kwazvo.
Matanho ekugadzira barcode muExcel
- Dhawunirodha barcode font pack yeExcel.
- Tungamira kuExcel uye uvhure pepa rekushandisa idzva.
- Nyora fomu yebhakhodhi muchikamu A. (Inofanira kungove nemavara kana nhamba uye nzvimbo pakati pazvo).
- Inowedzera chikamu B, kuti iwe ugone kupinda iyo barcode mufananidzo.
- Dzvanya pikicha kuti uise pakati mifananidzo iri muchikamu B.
- Dzvanya-kurudyi fomura iwe yawaimboisa mukoramu A uye woikopa.
- Wobva wanama fomula mukoramu B.
- Enda kumenyu uye sarudza "font", ipapo unofanirwa kutsvaga uye sarudza font yaunoda mune barcode.
- Iwe uchaona kuti fomula inoitika sei kugadzira barcode.
- Sarudza iyo uye gadzirisa saizi iwe yaunoda kuti ive.
- Tarisa zvinyatso tarisa kuti iri bharibhodhi chaiyo zvinoenderana nefomula, sezvo ichiita kuti ibudise zvikanganiso.
Tricks ekupinda barcode muExcel
Wedzera mufananidzo sebarcode kuExcel
Inogona kutariswa seyakareruka kupinza barcode paspredishiti yako, kubvira mushure mekushandisa nhanho dzatakagovana pamusoro kugadzira barcode, iwe unozokwanisa kuzviwana iwe mukoramu iwe yaunoda kuisa uye kuisa mufananidzo. Izvi zvinofanirwa kudzokororwa neimwe yekodhi kusvikira waisa ese aunoda.
Chinyorwa chemabhodhi ekutora kuverenga
Shandisa kodhi yekodhi kuburikidza neExcel bar
Kuti ushandise hunyengeri uhu, unofanirwa kurodha pasi Bar-Code 39 kana Code 39 pane rimwe remapeji akakurudzirwa neinjini yekutsvaga. Excel ine sarudzo yekugona kuisa iyo typography kana font sarudzo mune menyu uye wedzera iyo barcode kune yekushandisa yekuverenga.
Kana iyo font yaiswa, zvinokurudzirwa kutangazve komputa yako kuona kuti inoshanda nemazvo. Mushure mekutanga komputa zvakare, unofanirwa kuvhura gwaro idzva muExcel kuti utange kugadzira hesera nematafura anotevera:
- Chigadzirwa nhamba, iyo inofanirwa kuenderana nebarcode.
- Barcode.
- Huwandu kana zvikamu.
- Mutengo wechidimbu chimwe nechimwe.
- Yakazara mutengo wechigadzirwa, zvinoenderana nehuwandu kana zvikamu zvakaratidzwa.
Paunenge uchinge uine rese data rechimwe nechimwe chezvigadzirwa, enda kukoramu B uye shandisa font yawakaisa pakutanga, ingave Bar-Code 39 kana Code 39.
Pinda barcode muExcel nerubatsiro rwemacros
Iwe unogona kunge usati wanzwa nezveExcel macros, asi aya ndiwo mamwe mapurogiramu echirongwa ayo anoshandiswa kugadzirisa mabasa pane pepa reichi chishandiso. Kubudikidza nemutauro weVBA mutauro, zvinokwanisika kugadzira rairo dzakasiyana kana mashandiro muspredishiti, uchizviita otomatiki.
Uku kunyengera kunowanzo kuve kwakaomarara pane zvese, asi kazhinji kunonyanya kushanda kana zvasvika pakushandisa. Kutanga, iwe unofanirwa kushandura iyo yekuvandudza sarudzo muExpcel menyu, uchishandisa anotevera matanho:
- Enda ku "Faira" tab.
- Wobva wasarudza "sarudzo", uchiteverwa ne "Gadzirisa iribhoni".
- Dzvanya pa "Developer". Nenzira iyi ichave yatoitwa kare.
Kana chinyorwa ichi chakakubatsira, tinokukoka iwe kuti udzidze zvakawanda nezve Sei Tumira data kubva kuPDF kuenda kuExcel zvakachengeteka uye nekukurumidza?, kwaunogona kuwana rese data kuti uzviite.