Enye yezinqubo ezibaluleke kakhulu uma usebenza ku-Excel kufometha. Ngosizo lwaso, akukhona nje ukubonakala kwetafula okwenziwa, kodwa futhi kukhombisa indlela uhlelo olubona ngayo idatha eseceleni noma ebangeni elithile. Ngaphandle kokuqonda ukuthi leli thuluzi lisebenza kanjani, awukwazi kahle lolu hlelo kahle. Ake sithole ngokuningiliziwe ukuthi ukufometha ku-Excel kungukuthi kufanele kusetshenziswe kanjani.
Isifundo: Ukufometha amatafula ku-Microsoft Word
Amathebula okufometha
Ukufometha kuyinkimbinkimbi enkulu yezinyathelo zokulungisa okuqukethwe okubukwayo kwamathebula nedatha ebalwa. Le ndawo ihlanganisa ukushintsha inombolo enkulu yemingcele: usayizi, uhlobo nombala wefonti, usayizi weseli, ukugcwalisa, imingcele, ifomethi yedatha, ukuvumelanisa nokuningi okuningi. Okunye kulezi zakhiwo kuzoxoxwa ngezansi.
Ukufometha okuzenzakalelayo
Ungasebenzisa ukufometha okuzenzekelayo kunoma yikuphi uhla lweshidi lwedatha. Lolu hlelo luzofometha indawo ecacisiwe njengetafula futhi linikeze inani lezinto ezichazwe ngaphambilini.
- Khetha uhla lwamaseli noma itafula.
- Ukuba ngaphakathi kuthebhu "Ikhaya" chofoza inkinobho "Fometha njengetafula". Le nkinobho ifakwa ebhodini ebhokisini lamathuluzi. "Izitayela". Emva kwalokho, uhlu olukhulu lwezitayela ezinezici ezifakwe ngaphambili, okungazikhethela umsebenzisi ngokuqonda kwakhe. Chofoza nje ngokukhetha okufanele.
- Khona-ke iwindi elincane livuleka lapho udinga khona ukuqinisekisa ukufaneleka kwezixhumanisi zobubanzi obufakiwe. Uma uthola ukuthi angene ngokungalungile, khona-ke ungenza ngokushesha ushintsho. Kubalulekile ukulalela ipharamitha. "Ithebula ngezihloko". Uma kukhona izihloko etafuleni lakho (futhi ezimweni eziningi likhona), khona-ke kufanele kube khona uphawu lokuhlola phambi kwalesi parameter. Uma kungenjalo, kufanele kususwe. Uma zonke izilungiselelo ziphelile, chofoza inkinobho. "Kulungile".
Emva kwalokho, itafula lizoba nefomethi ekhethiwe. Kodwa ungakwazi njalo ukuhlela ngamathuluzi wokufometha okunembile.
Ukuguqulwa kokufometha
Abasebenzisi akuzona zonke izimo ezinelisekile ngesethi yezimpawu ezinikezwe ngokufometha ngokuzenzakalela. Kulokhu, kungenzeka ukufometha itafula ngesandla usebenzisa amathuluzi akhethekile.
Ungashintsha kumatafula okufometha, okungukuthi, ukuguqula ukubukeka kwawo, ngokusebenzisa imenyu yesimo sokwemvelo noma ngokwenza izenzo usebenzisa amathuluzi ku-ribbon.
Ukuze uye ekuboneni ukufometha ngokusebenzisa imenyu yokuqukethwe, udinga ukwenza izinyathelo ezilandelayo.
- Khetha iseli noma ububanzi betafula esifuna ukufometha. Sichofoza kuso ngenkinobho yegundane kwesokudla. Imenyu yomongo ivulwa. Khetha into kuwo "Fometha amaseli ...".
- Emva kwalokhu, iwindi yesakhiwo leseli livula lapho ungaveza izinhlobo ezahlukene zokufometha.
Amathuluzi okufometha kuthebhulethi awamathebhu ahlukahlukene, kepha iningi lawo kuthebhu "Ikhaya". Ukuze uwasebenzise, udinga ukukhetha into ehambelanayo eshadini, bese uchofoza inkinobho yamathuluzi ku-ribbon.
Ukufometha kwedatha
Enye yezinhlobo ezibaluleke kakhulu zokufometha yifomethi yohlobo lwedatha. Lokhu kungenxa yokuthi inquma ukuthi akukho ukubonakala kolwazi olubonisiwe njengoba litshela uhlelo ukuthi lungayilungisa kanjani. I-Excel isebenza ngendlela ehlukile kakhulu yezinombolo, umbhalo, izindleko zemali, amafomethi nosuku nesikhathi. Ungafometha uhlobo lwedatha yebanga elikhethiwe kukho kokubili imenyu yomongo kanye nethuluzi ku-ribbon.
Uma uvula iwindi "Fometha amaseli" ngokusebenzisa imenyu yomongo, izilungiselelo ezidingekayo zizobekwa kuthebhu "Inombolo" ku-parameter block "Amafomu Amanani". Eqinisweni, lena yodwa iyunithi kulethebhu. Lapha ungakhetha eyodwa yamafomethi wedatha:
- Inombolo;
- Umbhalo;
- Isikhathi;
- Usuku;
- Imali;
- Jikelele, njll.
Emva kokukhethwa kwenziwa, udinga ukuchofoza inkinobho. "Kulungile".
Ngaphezu kwalokho, izilungiselelo ezengeziwe ziyatholakala kwezinye izimpendulo. Isibonelo, ngenani lezinombolo ezingxenyeni ezifanele zewindi, ungasetha ukuthi zingaki izindawo zokudumisa ezizoboniswa izinombolo ze-fractional nokuthi ngabe zizobonisa yini ukwahlukanisa phakathi kwamadijithi ngezinombolo.
Ipharamitha "Usuku" Kungenzeka ukusetha ifomu lapho usuku luzoboniswa esikrinini (kuphela ngezinombolo, izinombolo namagama ezinyanga, njll).
Izilungiselelo ezifanayo ziyatholakala kwifomethi "Isikhathi".
Uma ukhetha into "Zonke amafomethi", ke wonke ama-subtypes wokufometha kwedatha azoboniswa ohlwini olulodwa.
Uma ufuna ukufometha idatha nge-tape, bese uhlala kuthebhu "Ikhaya", udinga ukuchofoza ohlwini lokudonsa olusendaweni yamathuluzi "Inombolo". Emva kwalokho uhlu lwamafomethi amakhulu luvezwe. Kuyiqiniso, kusengaphansi okuncane kunalokhu kuchazwe ngaphambilini.
Noma kunjalo, uma ufuna ukufometha ngokunembile, ke kulolu hlu udinga ukuchofoza entweni "Amanye amafomethi ezinombolo ...". Iwindi elingaziwa kakade lizovuleka. "Fometha amaseli" nge uhlu olugcwele lwezilungiselelo zokushintsha.
Isifundo: Ungashintsha kanjani ifomethi yeseli ku-Excel
Ukulungiswa
I-block yonke yamathuluzi ithulwe kuthebhu. "Ukuqondanisa" efasiteleni "Fometha amaseli".
Ngokubeka le nyoni eduze nepharamitha ehambelana nayo, ungahlanganisa amaseli akhethiwe, wenze ukukhethwa okuzenzekelayo kobubanzi bese uhambisa umbhalo ngamagama uma ungahambisani nemingcele yeseli.
Ngaphezu kwalokho, kuthebhu efanayo, ungakwazi ukubeka umbhalo ngaphakathi kweseli ngokuzenzekelayo futhi ngokuqondile.
Kupharamitha "Ukuqonda" ibeka ingqikithi yombhalo esitokisini setafula.
Ithuluzi lesitoreji "Ukuqondanisa" kukhona futhi i-ribbon kuthebhu "Ikhaya". Kukhona zonke izici ezifanayo njengasefasitela "Fometha amaseli", kodwa kunenguqulo engaphezu kwe-truncated.
Ifonti
Kuthebhu "Ifonti" Ukufometha amawindi kunamathuba amaningi okwenza ifonti yebanga elikhethiwe. Lezi zici zihlanganisa ukushintsha imingcele elandelayo:
- uhlobo lwefonti;
- uhlobo lwemibala (imidwebo, isibindi, evamile)
- usayizi;
- umbala;
- ukuguqulwa (okubhaliselwe, okuphezulu, ukushaya).
Itheyipu ine-block yethuluzi elinamakhono afanayo, okubizwa nangokuthiwa "Ifonti".
Umngcele
Kuthebhu "Umngcele" Amafomethi wefomethi angenza ngokwezifiso uhlobo lomugqa nombala walo. Ngokushesha inquma ukuthi imingcele izoba yiphi: yangaphakathi noma yangaphandle. Ungakwazi ngisho ukususa umngcele, noma ngabe usuvele ukhona etafuleni.
Kodwa ku-tape akukho bhokisi elihlukile lamathuluzi wokubeka umngcele. Kule njongo, kuthebhu "Ikhaya" inkinobho eyodwa kuphela ibonakala, ekhona eqenjini lamathuluzi "Ifonti".
Gcwalisa
Kuthebhu "Gcwalisa" Amafomethi wefomethi angasetshenziswa ukwenza ngokwezifiso umbala wamaseli etafula. Ukwengeza, ungafaka amaphethini.
Ebhebheni, kanye nomsebenzi wangaphambilini, inkinobho eyodwa kuphela ekhethiwe ukugcwaliswa. Itholakala futhi ebhokisini lamathuluzi. "Ifonti".
Uma imibala ejwayelekile ekhonjisiwe ayanele ngokwanele futhi ufuna ukufaka ukungena kumbala wetafula, kufanele uhambe "Eminye imibala ...".
Ngemuva kwalokho, iwindi livuleka, lenzelwe ukukhethwa okunembile kwembala namasithunzi.
Ukuvikelwa
Ku-Excel, ngisho nokuvikelwa kungokwensimu yokufometha. Ewindini "Fometha amaseli" Kukhona ithebhu enegama elifanayo. Kulo, ungabonisa ukuthi ibanga elikhethiwe lizovikelwa yini kusuka ekushintsheni noma cha, uma kuvimbela ishidi. Ungakwazi futhi ukuvumela amafomu okufihla.
Ebhebheni, imisebenzi efanayo ingabonakala ngemuva kokuchofoza inkinobho. "Fometha"elitholakala kuthebhu "Ikhaya" ebhodini lamathuluzi "Amaseli". Njengoba ungabona, uhlu luvela lapho kukhona iqembu lezilungiselelo. "Isivikelo". Futhi lapha awukwazi ukwenza ngokwezifiso ukuziphatha kweseli uma kuvinjelwa, njengoba bekusefeneni lokufometha, kodwa futhi ngokushesha uvimbele ishidi ngokuchofoza entweni "Vikela ishidi ...". Ngakho lena ingenye yalezi zimo ezingavamile lapho iqembu lezinketho zokufometha kwi-tape lisebenza ngokubanzi kunamathebhu afanayo efasiteleni. "Fometha amaseli".
.
Isifundo: Indlela yokuvikela iseli kusuka ekushintsheni ku-Excel
Njengoba ubona, i-Excel inomsebenzi obanzi kakhulu wetafula lokufometha. Kulesi simo, ungasebenzisa izinketho eziningana zezitayela ezinezinto ezilungiselelwe. Ungenza futhi izilungiselelo ezicacile usebenzisa isethi yonke yamathuluzi efasiteleni "Fometha amaseli" futhi ku-tape. Ngokungafani okungajwayelekile, ifasitelana lokufometha linikeza amathuba amaningi okushintsha ifomethi kunokuba kuthebhu.
