Ukusebenza namatafula, abasebenzisi bakhokha kuqala ukufakwa idatha, kwesinye isikhathi bakhohlwa ukubukeka kwedokhumenti. Lokhu kungukunganqumi okucacile, ngoba itafula elihlotshiswe kahle alidingeki kuphela ngokubona okuhle kobuhle, kodwa futhi nokuqonda nokubamba ama-nuances athile kudokhumenti. Okulandelayo, sizohlaziya amanye amathuluzi wokubuka amaseli wokuthulula, nokuthi ungawasebenzisa kanjani.
Ukugcwalisa amaseli ku-Excel: Izindlela eziyisisekelo
Ukugcwalisa amaseli ngombala, ngokuya kokuqukethwe kwangaphakathi, kusiza inqubo yokusebenza nokubona imininingwane edingekayo. Le ndlela ihambelana ikakhulukazi lapho isebenza ngamatafula amakhulu aqukethe idatha eminingi edinga ukuhlunga. Ukusuka kulokhu kulandela ukuthi umbala wombala usiza ukuhlela idokhumenti eliqediwe kwizakhi ezibalulekile.
Ukwenza amadokhumenti osayizi amancane, ungasebenzisa indlela yezandla yamaseli okubala. Uma udinga ukuhlela itafula elihlala lonke ishidi noma ngaphezulu, kulula kakhulu ukusebenzisa amathuluzi akhethekile. Noma ngabe kukhona abasebenzisi abanesibindi abafuna ukwenza wonke umsebenzi ngesandla, amathuba wokuthi iphutha lizovunyelwa kudokhumenti. Ikakhulu ukwenza lula imisebenzi enjalo ku-Excel, amaseli athululelwa ngombala. Ungakwenza kanjani lokhu, cabanga ngokuqhubekayo.
Inombolo 1: Ukugcwalisa okujwayelekile ngombalaUkwenza lo msebenzi, sizodinga ithuluzi lokushintsha ifomethi yamaseli. Ukuze wenze lokhu, landela imiyalo enikeziwe:
- Okokuqala, nquma iseli lapho umbala uzogcwala khona futhi uyisebenzise ngokucindezela i-LKM. Mhlawumbe kuzoba amaseli ambalwa ngasikhathi sinye.
- Ku-Toolbar "Yasekhaya", thola i-Font block. Ezinye izenzo zingenziwa ngenye yezindlela ezihlongozwayo:
- Ukugcwalisa umbala weseli, sebenzisa ithuluzi le- "Fll Colour", elethwe ngendlela yebhakede elenza ukugcwaliswa. Ngokuchofoza isithonjana ngonxantathu, vula ibhokisi lengxoxo lapho ukhetha umbala oyifunayo.
- Uma wehluleka ukukhetha umbala womthunzi wethoni oyifunayo, bese usebenzisa isici esithi "Eminye Imibala". Efasiteleni elivula, khetha enye yezindlela zokukhetha umbala: ngokohlelo lwamaselula oluveziwe noma kwi-spectrum. Inketho yesibili yenza kube nokwenzeka ukukhetha ithoni enembile kakhudlwana.
- Inkinobho ethi "Gcwalisa umbala" isindisa ukukhetha kokugcina. Ngakho-ke, uma uhlela ukusebenzisa ukugcwaliswa ngombala owodwa ezindaweni eziningana, ngemuva kokusebenzisa iseli oyifunayo, ungachofoza inkinobho ngaphandle kokuvula amawindi angezekile.
Ukwenza ukwenziwa kwetafula le-Excel akubukekanga njengalokho okuyisidina kanye ne-monophonic, kungenzeka ukuguqula ukugcwaliswa ngokungeza amaphethini kukho. Cabanga ngenqubo yokwenza lo msebenzi:
- Khetha amaseli owodwa noma amaningi lapho udinga ukubeka khona iphethini yombala.
- Ethebhu yasekhaya, sesha ibhulokhi le- "font" bese uqhafaza inkinobho ethi "Ifomethi Yeselula", etholakala ekhoneni elingezansi kwesokudla futhi limelelwe njengomcibisholo we-diagonal okhombisa i-angle.
- Efasiteleni elivula, iya kuthebhu ethi "Gcwalisa", lapho eqenjini "Umbala wangemuva" Sikhetha ithoni edingekayo yokugcwaliswa.
- Okulandelayo, yenza okukodwa kokulandelayo:
- Ukuze ugcwalise imibala emibili usebenzisa iphethini, iya kwinkambu ethi "iphethini" bese ukhetha imibala edingekayo. Emva kwalokho, iya ensimini ethi "iphethini" bese unquma isitayela sokuklama.
- Ukuze usebenzise imiphumela ekhethekile, udinga ukulandela isixhumanisi "izindlela zokugcwalisa" bese ukhetha amapharamitha adingekayo. Uma amapharamitha akhethiwe ahlelwe, cindezela inkinobho ethi "Kulungile".
Le ndlela ingasetshenziswa uma iseli likhethwe ngaphambi kokuba kufakwe umbala futhi azikho ezinye izenzo ezenziwa. Inqubo yokwenza isenzo: Khetha amaseli adinga ukulungiswa, bese ucindezela izinkinobho ze- "Ctrl + Y".
Uma ukugcwaliswa kwenziwa, futhi ngemuva kwalokho, kwakhiwa okungenani isenzo esisodwa, khona-ke le ndlela ngeke isebenze, ngoba inhlanganisela yokhiye ohlongozwayo isuselwe ekugcwalisekeni kwezenzo zakamuva, ukuba nohlobo lwebhodi yokunameka.
Inombolo 4 Ukudala iMacroLe ndlela idinga uhlelo olukhethekile lweMacrorocorer lapho, okuba ngamakhono athile, ungakha ama-macros ukwenza izenzo ezahlukahlukene. Esithombeni ungabona ikhodi yesibonelo ye-macro eyenziwe.
isishiyagalombiliUkususwa kokugcwaliswa kweseli
Uma udinga ukususa ukugcwaliswa kweseli obekwe phambilini, bese usebenzisa imiyalo engezansi:
- Khetha amaseli agcwala umbala noma iphethini yombala edinga ukulungiswa.
- Kuthebhu yasekhaya, iya ku-block "ifonti". Chofoza isithonjana somcibisholo bese uvula ibhokisi lengxoxo. Iya kunani elithi "Akukho ukugcwaliswa" bese ulisebenzisa ngokucindezela i-LKM.
Ukugcina
Kunezindlela eziningana zokugcwalisa umbala weseli. Ngayinye yazo inezinzuzo zayo nokubi. Kwezinye izimo, kuyamukeleka ukusebenzisa indlela yokuqala, esheshayo yokugcwalisa, kwabanye kuyadingeka ukunaka okukhethekile ekwakhiweni, khona-ke okungeziwe kumaphethini kuyasiza.
Umlayezo ukugcwaliswa kokhiye oshisayo ku-Excel kwavela kuqala kubuchwepheshe bolwazi.