Faka uphawu kuMicrosoft Excel

Kuhlelo lweMicrosoft Office, umsebenzisi kwesinye isikhathi kudingeka afake uphawu lokuhlola noma, njengoba isici sibizwa ngokuhlukile, uphawu lokuhlola (˅). Lokhu kungenziwa ngezinhloso ezahlukahlukene: ukumaka nje into ethile, ukufaka izimo ezahlukahlukene, njll. Ake sibheke ukuthi singayihlola kanjani ibhokisi eliku-Excel.

Ibhokisi lokuhlola

Kunezindlela eziningana zokuhlola ibhokisi ku-Excel. Ukuze unqume inketho ethile, udinga ukusungula ngokushesha ukuthi yini okudingeka ukuthi uyihlole ebhokisini: ukumaka nje noma ukuhlela izinqubo nemibhalo ethile?

Isifundo: Ungahlola kanjani iMicrosoft Word

Indlela yoku-1: Faka imenyu ye-Symbol

Uma udinga ukubheka ibhokisi kuphela ngezinjongo ezibonakalayo, ukuze umake into, ungamane usebenzise inkinobho ethi "Symbol" ebekwe iribhoni.

1. Sibeka isikhombisi esitokisini lapho kufanele kubekwe khona uphawu lokuhlola. Iya kuthebhu Faka. Chofoza inkinobho "Symbol"etholakala kwibhulokhi yamathuluzi "Izimpawu".



2. Iwindi livuleka ngohlu olukhulu lwezinto ezahlukahlukene. Asiyi ndawo, kepha hlala kuthebhu "Izimpawu". Ensimini Ifonti noma imaphi amafonti ajwayelekile angacaciswa: Isivivinyo, I-Verdana, Izikhathi ezintsha roman njll. Ukuthola ngokushesha uhlamvu olufunayo enkundleni "Setha" setha ipharamitha "Izincwadi zishintsha izikhala". Sifuna uphawu "˅". Khetha bese uchofoza inkinobho. Namathisela.

Ngemuva kwalokho, into ekhethiwe izovela esitokisini esichaziwe ngaphambilini.

Ngendlela efanayo, ungafaka uphawu lokuhlola olwaziwayo ngokwengeziwe ezinhlangothini ezingenakubalwa noma uphawu lokuhlola ebhokisini lokuhlola (ibhokisi elincane elakhelwe ngokukhethekile ukusetha ibhokisi lokuhlola). Kepha ngalokhu, udinga ukwenza inkambu Ifonti chaza ifonti yomlingisi okhethekile esikhundleni senguqulo evamile Amaphiko. Ngemuva kwalokho kufanele uye ezansi kohlu lwabalingiswa bese ukhetha uhlamvu olufunayo. Ngemuva kwalokho chofoza inkinobho Namathisela.

Uhlamvu olukhethiwe lufakwe esitokisini.

Indlela yesi-2: Isici Sokuziphatha

Kukhona futhi abasebenzisi abangabekelwe ukufanisa izinhlamvu ncamashi. Ngakho-ke, esikhundleni sokusetha uphawu lokuhlola olujwayelekile, bamane babhale umlingiswa kukhibhodi "v" ngesakhiwo sesiNgisi. Kwesinye isikhathi kuyavunyelwa, ngoba le nqubo ithatha isikhathi esincane kakhulu. Futhi ngaphandle kwalokhu kucishe kufakwe cishe kungabonakali.

Indlela 3: thikha ibhokisi lokuhlola

Kepha ukuze ukufakwa noma isimo sokungafaki kusebenze imibhalo ethile, udinga ukwenza umsebenzi onzima kakhulu. Okokuqala, kufanele ufake ibhokisi lokuhlola. Leli yibhokisi elincane lapho kubekwa khona ibhokisi. Ukufaka le nto, udinga ukunika amandla imenyu kanjiniyela, ocishiwe ngokuzenzakalelayo ku-Excel.

1. Ukuba kuthebhu Ifayelachofoza entweni "Izinketho", etholakala ohlangothini lwesobunxele lwewindows yamanje.



2. Iwindows ongakhetha iqala. Iya esigabeni Ukusethwa kweRibbon. Engxenyeni engakwesokudla yewindi, hlola ibhokisi (lokhu yikho kanye esizodinga ukukufaka eshidini) elibhekene nepharamitha "Unjiniyela". Engxenyeni engezansi yewindi, chofoza inkinobho "Kulungile". Ngemuva kwalokho kuzovela ithebhu kubambo "Unjiniyela".



3. Iya kuthebhu esanda kuvulwa "Unjiniyela". Ebhokisini lamathuluzi "Izilawuli" kuthebhu chofoza inkinobho Namathisela. Uhlu oluvuleka eqenjini "Izilawuli Zamafomu" khetha Bheka ibhokisi.



4. Ngemuva kwalokho, ikhesa liphenduka isiphambano. Chofoza endaweni eshidini lapho ufuna ukunamathisela khona ifomu.

   

   Kuvela ibhokisi lokuhlola elingenalutho.



5. Ukusetha ifulegi kuyo, udinga nje uchofoze kule nto bese ifulegi lizosethwa.



6. Ukuze ususe okubhaliwe okujwayelekile, okungadingeki kaningi, chofoza kwesobunxele kulokho, khetha okubhaliwe bese uchofoza inkinobho Susa. Esikhundleni segama-ncazo elisusiwe, ungafaka elinye, noma ungakwazi ukufaka noma yini, ushiye ibhokisi lokuhlola ngaphandle kwegama. Lokhu ngokubona komsebenzisi.



7. Uma kunesidingo sokwenza amabhokisi okuhlola amaningi, khona-ke awukwazi ukudala umugqa ohlukile womugqa ngamunye, kodwa ukopishe owenziwe, ozosindisa isikhathi esiningi. Ukuze wenze lokhu, khetha ifomu ngokushesha ngokuchofoza kwegundane, bese ubamba inkinobho yesobunxele bese udonsela lelo fomu kwiseli elifunayo. Ngaphandle kokulahla inkinobho yegundane, bamba ukhiye Ctrlbese ukhipha inkinobho yegundane. Senza umsebenzi ofanayo namanye amaseli lapho udinga ukufaka khona uphawu lokuhlola.

Indlela 4: dala ibhokisi lokuhlola ukusebenza kweskripthi

Ngaphezulu, sifunde ukuthi singalihlola kanjani ibhokisi ngezindlela ezahlukahlukene. Kepha leli thuba ngeke lisetshenziswe hhayi ekubonisweni okubukwayo kuphela, kepha futhi nasekuxazululeni izinkinga ezithile. Ungasetha izimo ezihlukile lapho ushintsha ibhokisi lokuhlola ebhokisini lokuhlola. Sizohlaziya ukuthi kusebenza kanjani lokhu nesibonelo sokushintsha umbala weseli.

1. Sakha ibhokisi lokuhlola ngokuya nge-algorithm echazwe kwindlela yangaphambilini besebenzisa ithebhu kanjiniyela.
2. Sichofoza endaweni ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe, khetha "Ifomethi yento ...".



3. Iwindi lokufometha liyavula. Iya kuthebhu "Ukulawula"uma ivulwe kwenye indawo. Ebhulokini lamapharamitha "Amanani" Isimo samanje kufanele sikhonjiswe. Okusho ukuthi, uma uphawu lokuhlola lufakiwe njengamanje, lapho-ke switch kufanele ibe sesimweni "Kufakiwe"uma kungenjalo - esikhundleni "Shot". Isikhundla Kuhlanganisiwe ukubonisa akunconyiwe. Ngemuva kwalokho chofoza isithonjana esiseduze nenkambu Isixhumanisi Seseli.



4. Iwindi lokufometha liyancishiswa, futhi sidinga ukukhetha iseli eshidi lapho ibhokisi lokuhlola elinophawu lokuhlola liyohlangana khona. Ngemuva kokuthi ukukhetha kwenziwe, chofoza inkinobho efanayo futhi ngesimo sesithonjana, esasixoxwa ngenhla, ukubuyela kuwindi lokufometha.



5. Ewindini lokufometha, chofoza inkinobho "Kulungile" ukuze ulondoloze izinguquko.

   

   Njengoba ukwazi ukubona, ngemuva kokwenza lezi zinto kuseli elixhunyiwe, lapho ibhokisi lokuhlola lihlolwa, inani "IQINISO ". Uma ungahloli inani lizokhonjiswa FALSE. Ukuze sifeze umsebenzi wethu, okungukuthi ushintshe imibala yokugcwalisa, sizodinga ukuhlanganisa la maxabiso esitokisini isenzo esithile.



6. Khetha iseli elixhunyiwe bese uchofoza kukho inkinobho yegundane elifanele, kumenyu evulayo, khetha into "Ifomethi yeseli ...".



7. Iwindi lokufometha iseli liyavula. Kuthebhu "Inombolo" khetha into "Zonke izinhlobo" endaweni yesisekelo "Amafomethi ezinombolo". Insimu "Thayipha", etholakala enkabeni yewindows, sibhala le nkulumo elandelayo ngaphandle kwezilinganiso: ";;;". Chofoza inkinobho "Kulungile" phansi kwewindi. Ngemuva kwalezi zenzo, isihloko esibonakalayo "IQINISO" wanyamalala esitokisini, kepha inani lihlala.



8. Khetha iseli elixhunyiwe futhi bese uye kuthebhu. "Ikhaya". Chofoza inkinobho Ukufomatha okunemibandelaelibekwe endaweni yethuluzi Izitayela. Kuluhlu olubonakala, chofoza entweni "Dala umthetho ...".



9. Iwindi lokwakha umthetho wokufometha liyavula. Engxenyeni engenhla, udinga ukukhetha uhlobo lomthetho. Khetha into yokugcina ohlwini: "Sebenzisa ifomula ukuchaza amaseli afomethwe". Ensimini "Amanani wefomethi lapho ifomula elandelayo iyiqiniso" chaza ikheli leseli elixhunyiwe (lokhu kungenziwa ngesandla noma ngokumane ukhethe), futhi ngemuva kokuthi izixhumanisi zivele emgqeni, singeza isichasiso "= IQINISO". Ukusetha umbala ogqamile, chofoza inkinobho "Ifomathi ...".



10. Iwindi lokufometha iseli liyavula. Khetha umbala ongathanda ukugcwalisa kuwo iseli lapho uphawu lokukhanyisa luvuliwe. Chofoza inkinobho "Kulungile".



11. Ukubuyela ewindini lokudala umthetho, chofoza inkinobho "Kulungile".

Manje, lapho uphawu lokuhlola luvulekile, iseli elihambisana nalo lizopenda ngombala okhethiwe.

Uma uphawu lokususa lisusiwe, iseli lizophinda libe mhlophe futhi.

Isifundo: Ukufomatha okunemibandela ku-Excel

Indlela 5: uphawu lokuhlola usebenzisa amathuluzi e-ActiveX

Umaki ungabekwa futhi usebenzisa amathuluzi we-ActiveX. Lesi sici sitholakala kuphela kumenyu kanjiniyela. Ngakho-ke, uma le thebhu ingavunyelwe, kufanele uyisebenzise, ​​njengoba kuchazwe ngenhla.

1. Iya kuthebhu "Unjiniyela". Chofoza inkinobho Namathiselaelibekwe eqenjini leThuluzi "Izilawuli". Ewindini elivula, ebhlokini Izilawuli ze-ActiveX khetha into Ibhokisi lokuhlola.



2. Njengasesikhathini esidlule, ikhesa lithatha isimo esikhethekile. Sichofoza endaweni eshadini lapho ifomu kufanele libekwe khona.



3. Ukusetha uphawu lokuhlola ebhokisini lokuhlola, udinga ukufaka izakhiwo zento. Sichofoza kukho inkinobho yegundane elifanele nakwimenyu evulayo, khetha into "Izindawo".



4. Ewindini lezinto ezivulayo, funa ipharamitha "Inani". Itholakala ezansi. Melana naye, sishintsha inani nge "Amanga" kuvuliwe "Qiniso". Lokhu sikwenza ngokushayela izinhlamvu kusuka kukhibhodi. Ngemuva kokuba umsebenzi usuqediwe, vala iwindi lezakhiwo ngokuchofoza inkinobho evamile evamile ngendlela yesiphambano esimhlophe esikweleni esibomvu ekhoneni eliphezulu kwesokudla sewindi.

Ngemuva kokuqeda lezi zinyathelo, kuzobekwa uphawu lokuhlola ebhokisini lokuhlola.

Iskripthi ngokusebenzisa izilawuli ze-ActiveX kungenzeka ngokusebenzisa amathuluzi we-VBA, okungukuthi, ngokubhala ama-macros. Vele, lokhu kuyinkimbinkimbi kakhulu kunokusebenzisa amathuluzi wokufometha anemibandela. Ukutadisha le nkinga sisihloko esikhulu esihlukile. I-Macros yemisebenzi ethile ingabhalwa kuphela ngabasebenzisi abanolwazi lwezinhlelo namakhono ku-Excel aphezulu kakhulu kunesilinganiso.

Ukuya kusihleli se-VBA, ongarekhoda ngaso iMacro, udinga uchofoze ku-element, esimeni sethu ibhokisi lokuhlola, nenkinobho yegundane kwesokunxele. Ngemuva kwalokho kuzokwethulwa iwindi lomhleli lapho ungabhala khona ikhodi yomsebenzi owenziwayo.

Isifundo: Ungayakha kanjani iMacro ku-Excel

Njengoba ukwazi ukubona, kunezindlela eziningi zokuhlola ibhokisi ku-Excel. Ngiyiphi indlela yokukhetha kokuqala ngokuya ngeminqopho yokufaka. Uma uvele nje ufuna ukumaka into, ngakho-ke akunangqondo ukuqeda lo msebenzi ngemenyu kanjiniyela, ngoba lokhu kuzothatha isikhathi esiningi. Kulula kakhulu ukusebenzisa ukufakwa kwezinhlamvu noma vele uthayiphe igama lesiNgisi elithi "v" kukhibhodi esikhundleni sokumaka uphawu. Uma ufuna ukusebenzisa uphawu lokuhlola ukuhlela ukwenziwa kwemibhalo ethile ekhasini lokusebenzela, khona-ke kuleli cala le nhloso ingafinyelelwa kuphela ngosizo lamathuluzi wonjiniyela.