Excel cikakken kayan aikin tebur ne, wanda kafinnan masu amfani suke gabatar da ayyuka iri-iri. Ofaya daga cikin waɗannan ayyuka shine ƙirƙirar maɓallin a kan takardar, danna kan wanda zai fara wani aiki. An warware wannan matsalar gaba ɗaya tare da taimakon kayan aikin Excel. Bari mu ga yadda zaku iya ƙirƙirar abu makamancin wannan a cikin wannan shirin.
Tsarin halitta
A matsayinka na mai mulki, irin wannan maɓallin ana nufin aiki azaman hanyar haɗi, kayan aiki don fara aiwatarwa, macro, da sauransu. Kodayake a wasu lokuta, wannan abun zai iya zama adadi na lissafi kawai, kuma baya ga maƙasudin gani ba zai haifar da fa'ida ba. Wannan zabin, duk da haka, yana da ɗan wuya.
Hanyar 1: Auto
Da farko dai, yi la’akari da yadda ake ƙirƙirar maɓallin daga saiti mai kyau-in-sawu.
- Matsa zuwa shafin Saka bayanai. Danna alamar "Shafuna"wanda aka sanya akan kintinkiri a cikin akwatin kayan aiki "Misalai". An bayyana jerin kowane nau'ikan lambobi. Zaɓi sifar da kuke ganin ya fi dacewa da aikin maɓallin. Misali, wannan adadi zai iya zama murabba'i mai kusurwa tare da kusurwoyi masu laushi.
- Bayan dannawa, muna tura shi zuwa yankin takarda (tantanin) inda muke son mabuɗin ya kasance, kuma matsar da iyakokin cikin don abin ya ɗauki girman da muke buƙata.
- Yanzu ya kamata ku ƙara takamaiman aiki. Bari ya kasance sauyawa zuwa wani takarda lokacin da danna kan maballin. Don yin wannan, danna kan shi tare da maɓallin linzamin kwamfuta na dama. A cikin menu na mahallin da aka kunna bayan wannan, zaɓi matsayin "Shafin yanar gizo".
- A cikin bude taga don ƙirƙirar hanyoyin sadarwa, je zuwa shafin "Sanya cikin takarda". Zaɓi takardar da muke la'akari da zama dole kuma danna maɓallin "Ok".
Yanzu, lokacin da ka danna abu da muka halitta, za a tura shi zuwa takaddar takaddar da aka zaɓa.
Darasi: Yadda ake yin ko cire hyperlinks a cikin Excel
Hanyar 2: hoton ɓangare na uku
Hakanan zaka iya amfani da hoton ɓangare na uku azaman maɓallin.
- Mun sami hoto na uku, misali, akan Intanet, kuma zazzage shi a kwamfutar mu.
- Bude takaddar Excel wanda muke so mu sanya abin. Je zuwa shafin Saka bayanai kuma danna kan gunkin "Zane"wacce take akan kintinkiri a cikin akwatin kayan aiki "Misalai".
- Ana buɗe hoton zaɓi na hoto. Za mu tafi tare da shi zuwa ga jagorar rumbun kwamfutarka inda hoton yake, wanda aka tsara don aiki azaman maɓallin. Zaɓi sunan shi kuma danna maɓallin Manna a kasan taga.
- Bayan haka, ana kara hoton a cikin jirgin saman takardar aiki. Kamar yadda ya gabata, ana iya matsa shi ta hanyar jan iyakokin. Muna motsa zane zuwa wurin da muke son sanya abin.
- Bayan haka, zaku iya haɗa hanyar haɗin hyperlink zuwa digger a cikin hanyar kamar yadda aka nuna a hanyar da ta gabata, ko zaku iya ƙara macro. A ƙarshen magana, danna-dama akan hoton. A cikin menu na mahallin da ya bayyana, zaɓi "Sanya Macro ...".
- Taga taga Macro yana budewa. A ciki, kuna buƙatar zaɓar macro ɗin da kuke son amfani dashi lokacin da kuka danna maballin. Wannan macro yakamata a rubuta wannan littafin. Zaɓi sunan shi kuma danna maɓallin "Ok".
Yanzu, lokacin da ka danna abu, za a ƙaddamar da macro da aka zaɓa.
Darasi: Yadda ake ƙirƙirar macro a cikin Excel
Hanyar 3: Gudanar da ActiveX
Zai yuwu a ƙirƙiri mafi maɓallin aiki idan kun ɗauki kashi na ActiveX don ƙaƙƙarfan ƙa'idar ta. Bari mu ga yadda ake yin hakan a aikace.
- Domin ku sami damar yin aiki tare da sarrafawar ActiveX, da farko, kuna buƙatar kunna shafin mai haɓakawa. Gaskiyar ita ce ta hanyar tsoho yana da rauni. Sabili da haka, idan baku kunna shi ba, to ku tafi zuwa shafin Fayiloli, sannan kuma matsa zuwa sashin "Zaɓuɓɓuka".
- A cikin taga sigogi masu kunnawa, matsa zuwa sashin Saitin Ribbon. A cikin hannun dama na taga, duba akwatin kusa da "Mai Haɓakawa"idan bata nan. Bayan haka, danna maballin "Ok" a kasan taga. Yanzu za a kunna shafin mai haɓakawa a cikin fasalin ku na Excel.
- Bayan haka, matsa zuwa shafin "Mai Haɓakawa". Latsa maballin Mannawacce take akan kintinkiri a cikin akwatin kayan aiki "Gudanarwa". A cikin rukunin Gudanar da ActiveX danna kan ainihin farkon, wanda yake kama da maɓallin.
- Bayan haka, mun danna kowane wuri akan takardar da muke ganin ya zama dole. Nan da nan bayan wannan, za a nuna kashi a wurin. Kamar yadda a cikin hanyoyin da suka gabata, muna daidaita wurin sa da girman sa.
- Mun danna kan sakamakon da aka samo ta danna maɓallin linzamin kwamfuta na hagu.
- Taga taga edita yana budewa. Anan zaka iya ɗaukar kowane macro da kake son kashewa idan ka danna wannan abun. Misali, zaku iya yin rikodin macro don sauya bayanin rubutu zuwa tsarin lamba, kamar yadda yake a hoton da ke ƙasa. Bayan da aka yi rikodin macro, danna maballin don rufe taga a kusurwar dama na sama.
Yanzu macro za a haɗe shi da abin.
Hanyar 4: sarrafawar tsari
Hanyar da ta biyo baya tana da kama sosai a cikin fasahar aiwatarwa zuwa sigar da ta gabata. Yana wakiltar ƙara maɓallin ta hanyar sarrafa tsari. Don amfani da wannan hanyar, dole ne ku taimaka yanayin mai haɓaka.
- Je zuwa shafin "Mai Haɓakawa" kuma danna maɓallin da muka sani Mannaan shirya shi a kan tef a cikin rukuni "Gudanarwa". Jerin yana buɗewa. A ciki, kuna buƙatar zaɓar sashin farko da aka sanya cikin rukuni "Tsarin sarrafawa". Wannan abun a zahiri yayi kama da wanda yake kama da wani abu mai kama da ActiveX, wanda mukayi magana game da dan kadan kadan.
- Abubuwan yana bayyana akan takardar. Gyara girmansa da inda yake, kamar yadda akayi fiye da sau ɗaya.
- Bayan haka, mun sanya wani macro ga abin da aka halitta, kamar yadda aka nuna a ciki Hanyar 2 ko sanya wata hanyar tattaunawa kamar yadda aka bayyana a ciki Hanyar 1.
Kamar yadda kake gani, a cikin Excel, ƙirƙirar maɓallin aiki ba shi da wahala kamar yadda yake iya ɗauka ga mai amfani da ƙwarewa. Kari akan wannan, ana iya aiwatar da wannan hanyar ta amfani da hanyoyi daban-daban guda huɗu a wajan hankalinku.
