I-Excel iyi-processor ephelele yetafula, ngaphambi kwalokho abasebenzisi bakhona benza imisebenzi ehlukahlukene. Omunye wale misebenzi ukudala inkinobho ekhasini, ngokuchofoza lapho kuzoqala inqubo ethile. Le nkinga ixazululwe ngokuphelele ngosizo lwamathuluzi e-Excel. Ake sibheke ukuthi ungayakha kanjani into efanayo kulolu hlelo.
Inqubo yokudalwa
Njengomthetho, inkinobho enjalo ihloselwe ukusebenza njengesixhumanisi, ithuluzi lokuqala inqubo, i-macro, njll. Noma kwezinye izimo, le nto ingaba yisibalo sejometri kuphela, futhi ngaphandle kwezinjongo ezibukwayo ayinazo izinzuzo. Le ndlela, noma kunjalo, iyivelakancane.
Indlela yoku-1: I-Auto
Okokuqala, cabanga ukuthi ungakha kanjani inkinobho kusuka kusethi yezimo ezakhelwe ngaphakathi kwa-Excel.
- Hambisa kuthebhu Faka. Chofoza isithonjana "Izimo"ebekwe kubambo kubhokisi lamathuluzi "Imifanekiso". Kwembulwa uhlu lwazo zonke izinhlobo zezibalo. Khetha ijamo ocabanga ukuthi liyilungele kakhulu indima yenkinobho. Isibonelo, isibalo esinjalo singaba isikwele esinamakhona abushelelezi.
- Ngemuva kokuchofoza, siyidlulisela endaweni yeshidi (iseli) lapho sifuna ukuthi khona inkinobho ibekwe, bese sihambisa imingcele ngaphakathi ukuze into ithathe usayizi esiwudingayo.
- Manje kufanele ungeze isenzo esithile. Mayibe wukushintshela kwelinye ishidi lapho uchofoza inkinobho. Ukuze wenze lokhu, chofoza kukho inkinobho yegundane elifanele. Kumenyu yokuqukethwe esetshenziswe ngemuva kwalokhu, khetha isikhundla "Ihyperlink".
- Ewindini elivuliwe lokwenza izixhumanisi, yiya kuthebhu "Beka kudokhumenti". Khetha ishidi esilibona lidingekile bese uchofoza inkinobho "Kulungile".
Manje, uma uchofoza entweni esiyidalile, izohanjiswa ekhasini elikhethiwe ledokhumenti.
Isifundo: Ungenza noma ususe izixhumanisi kanjani ku-Excel
Indlela 2: isithombe seqembu lesithathu
Ungasebenzisa futhi isithombe senkampani yangaphandle njengenkinobho.
- Sithola isithombe senkampani yesithathu, ngokwesibonelo, kwi-Intanethi, bese siyikhipha kwikhompyutha yethu.
- Vula idokhumenti le-Excel lapho sifuna ukubeka khona into. Iya kuthebhu Faka bese uchofoza isithonjana "Umdwebo"etholakala kubambo kubhokisi lamathuluzi "Imifanekiso".
- Iwindi lokukhetha isithombe liyavula. Sihamba nalo kusiqondisi se-hard drive lapho sitholakala khona isithombe, esenzelwe ukusebenza njengenkinobho. Khetha igama laso bese uchofoza inkinobho Namathisela phansi kwewindi.
- Ngemuva kwalokho, isithombe singezelwa endizeni yephepha lokusebenza. Njengasesimweni esedlule, kungacindezelwa ngokuhudula imingcele. Sihambisa umdwebo endaweni lapho sifuna ukuthi into ibekwe khona.
- Ngemuva kwalokho, unganamathisa i-hyperlink ku-digger ngendlela efanayo njengoba ikhonjiswe indlela yangaphambilini, noma ungangeza i-macro. Uma kunjalo, chofoza kwesokudla esithombeni. Kumenyu yokuqukethwe evela, khetha "Nikeza iMacro ...".
- Kuvuleka iwindi lokulawulwa kwe-macro. Kuyo, udinga ukukhetha i-macro ofuna ukuyisebenzisa lapho uchofoza inkinobho. Le macro kufanele ngabe isibhalelwe incwadi. Khetha igama laso bese ucindezela inkinobho "Kulungile".
Manje, uma uqhafaza entweni, kuzothulwa i-macro ekhethiwe.
Isifundo: Ungayakha kanjani iMacro ku-Excel
Indlela 3: Ukulawulwa kwe-ActiveX
Kuzokwazi ukudala inkinobho esebenzayo kakhulu uma uthatha into ye-ActiveX ngomgomo wayo oyinhloko. Ake sibheke ukuthi kwenziwa kanjani kulokhu.
- Ukuze ukwazi ukusebenza ngezilawuli ze-ActiveX, okokuqala, udinga ukuvula ithebhu kanjiniyela. Iqiniso ngukuthi ngokuzenzakalelayo likhutshaziwe. Ngakho-ke, uma ungakayinikeli amandla, yiya kuthebhu Ifayela, bese udlulela esigabeni "Izinketho".
- Kuwindi lamapharamitha asebenzisiwe, iya esigabeni Ukusethwa kweRibbon. Engxenyeni engakwesokudla yewindi, hlola ibhokisi eliseduze "Unjiniyela"uma ingekho. Okulandelayo, chofoza inkinobho "Kulungile" phansi kwewindi. Manje ithebhu kanjiniyela lizosetshenziswa kuhlobo lwakho lwe-Excel.
- Ngemuva kwalokho, iya kuthebhu "Unjiniyela". Chofoza inkinobho Namathiselaetholakala kubambo kubhokisi lamathuluzi "Izilawuli". Eqenjini Izilawuli ze-ActiveX chofoza into yokuqala, ebukeka njengenkinobho.
- Ngemuva kwalokho, sichofoza kunoma iyiphi indawo ephepheni esicabanga ukuthi idingekile. Ngokushesha emva kwalokhu, kuzokhonjiswa into ethile lapho. Njengokwezindlela ezedlule, silungisa indawo nosayizi wayo.
- Sichofoza into ephumela ngokuchofoza kabili inkinobho yegundane kwesobunxele.
- Kuvulwa iwindi lomhleli we-macro. Lapha ungaqopha noma iyiphi i-macro ofuna ukubulawa kuyo uma uqhafaza kule nto. Isibonelo, ungaqopha i-macro ukuguqula isabizwana sombhalo ube ngefomethi yenombolo, njengasesithombeni esingezansi. Ngemuva kokuthi i-macro iqoshwe, chofoza inkinobho ukuvala iwindi ekhoneni layo elingakwesokudla.
Manje iMacro izonamathiselwa entweni.
Indlela 4: ukulawulwa kwamafomu
Indlela elandelayo ifana kakhulu kubuchwepheshe bokwenza inguqulo yangaphambilini. Imelela ukungeza inkinobho ngokulawula ifomu. Ukuze usebenzise le ndlela, kufanele futhi unike amandla imodi yonjiniyela.
- Iya kuthebhu "Unjiniyela" bese uchofoza inkinobho esiyaziyo Namathiselaisingathwe ethepheni eqenjini "Izilawuli". Uhlu luyavula. Kuyo, udinga ukukhetha into yokuqala ebekwe eqenjini "Izilawuli Zamafomu". Le nto ibonakala ngokufana ncamashi nento efanayo ye-ActiveX, esikhulume ngayo ngaphezulu okuphakeme.
- Into ivela ephepheni. Lungisa usayizi wayo nendawo yayo, njengoba kuye kwenziwa kaningi kunangaphambili.
- Ngemuva kwalokho, sinika ama-macro entweni edaliwe, njengoba kukhonjisiwe Indlela yesi-2 noma yabela oxhumano lwenhliziyo njengoba kuchazwe ku Indlela 1.
Njengoba ukwazi ukubona, e-Excel, ukudala inkinobho yokusebenza akunzima njengoba kungabonakala kumsebenzisi ongenalwazi. Ngaphezu kwalokho, le nqubo ingenziwa kusetshenziswa izindlela ezine ezihlukile ngokubona kwakho.
