Excel aikace -aikace ne wanda ke da adadi mara iyaka na ayyuka na musamman, wanda wani lokacin ba mu sani ba, kamar yadda lamarin yake Haɓaka lambar lambar a cikin Excel. Idan kuna son sanin yadda ake fayyace su mataki -mataki, muna gayyatar ku don karanta labarin da ke tafe da ƙarin koyo game da batun.
Bar Code da aka shirya a Excel
Haɓaka lambar wucewa a cikin Excel: Menene waɗannan lambobin?
Kafin mu lura da matakan da dole ne mu bi don shirya lambar wucewa, dole ne mu san cewa waɗannan ƙananan layin suna ƙunshe da cikakkun bayanai game da abu ko samfur, yana sauƙaƙa gano shi yayin shirya kaya ko tuntuɓar halayen da ya mallaka.
Tsarin ƙirƙirar waɗannan lambobin ta hanyar shirye -shirye kamar Excel, yawanci alama aiki ne da ba zai yiwu ba, duk da haka, abu ne mai sauqi.
Matakai don samar da lambar wucewa a cikin Excel
- Zazzage fakitin alamar lambar lambar don Excel.
- Shugaban kan Excel kuma buɗe sabon maƙunsar rubutu.
- Rubuta dabarun barcode a cikin shafi na A. (Yakamata kawai yana da haruffa ko lambobi da sarari tsakanin su).
- Yana faɗaɗa shafi B, don ku iya shigar da hoton lambar.
- Danna gunkin don daidaita hotuna a shafi na B.
- Danna madaidaicin dabarar da kuka sanya a baya a shafi na A kuma kwafe ta.
- Sannan manna dabarar a shafi na B.
- Je zuwa menu kuma zaɓi "font", a can za ku nemo kuma zaɓi font ɗin da kuke so a cikin lambar mashaya.
- Za ku ga yadda dabarar ke faruwa don yin barcode.
- Zaɓi shi kuma daidaita girman da kuke so ya kasance.
- Bincika a hankali cewa madaidaicin lambar ƙirar ce bisa tsarin, saboda yana haifar da kurakurai.
Dabara don shigar da barcode a Excel
Ƙara hoto azaman barcode zuwa Excel
Ana iya ɗaukar dabarar mafi sauƙi don shigar da lambar wucewa zuwa maƙunsar ku, tunda bayan amfani da matakan da muka raba a sama don ƙirƙirar lambar wucewa, za ku iya gano kanku a cikin ginshiƙi inda kuke son sanya shi kuma saka hoton. Dole ne a maimaita wannan tare da kowane lambobin har sai kun shigar da duk waɗanda kuke buƙata.
Jerin lambobin barcode don ɗaukar kaya
Yi amfani da lambar tushe ta mashaya Excel
Don amfani da wannan dabarar, dole ne ku saukar da Bar-Code 39 ko Code 39 a ɗayan shafukan da injin binciken ya ba da shawarar. Excel yana da zaɓi na samun damar shigar da rubutu ko zaɓin font a cikin menu kuma ƙara lambar mashaya zuwa lissafin aikace -aikacen.
Da zarar an shigar da font, ana ba da shawarar sake kunna kwamfutarka don tabbatar da cewa tana aiki yadda yakamata. Bayan fara kwamfutar, dole ne ku buɗe sabon takaddar a cikin Excel don fara ƙirƙirar kaya tare da tebura masu zuwa:
- Lambar samfur, wacce dole ta dace da lambar lambar.
- Barcode.
- Yawan ko raka'a.
- Farashin kowane yanki.
- Jimlar farashin samfurin, gwargwadon yawa ko raka'a da aka nuna.
Da zarar kun sami duk bayanan kowane samfuran, je zuwa shafi na B kuma yi amfani da font ɗin da kuka shigar a baya, ya zama Bar-Code 39 ko Code 39.
Shigar da lambar wucewa a cikin Excel tare da taimakon macros
Wataƙila ba ku taɓa jin macros na Excel ba, amma waɗannan wasu lambobin shirye -shirye ne waɗanda ake amfani da su don sarrafa ayyukan a kan takardar wannan aikace -aikacen. Ta hanyar yaren shirye -shiryen VBA, yana yiwuwa a ƙirƙiri umarni ko ayyuka daban -daban a cikin maƙunsar bayanai, aiwatar da shi ta atomatik.
Wannan dabarar galibi ita ce mafi rikitarwa, amma galibi tana da tasiri sosai idan aka zo amfani da ita. Don farawa, dole ne ku kunna zaɓin mai haɓakawa a cikin menu na Excel, yin amfani da matakai masu zuwa:
- Je zuwa shafin "Fayil".
- Sannan zaɓi "zaɓuɓɓuka", sannan "Kirkira kintinkiri".
- Danna kan "Mai haɓakawa". Wannan hanyar tuni an kunna ta.
Idan wannan labarin ya taimaka muku, muna gayyatar ku don ƙarin koyo game da Yadda Shigo da bayanai daga PDF zuwa Excel lafiya da sauri?, inda zaku iya samun duk bayanan da kuke yi.