Lapho usebenza namatafula, amanani akhonjisiwe kuwo afanele kuqala. Kodwa okubalulekile kubalulekile futhi. Abanye abasebenzisi bacabanga ukuthi lokhu kuyisici sesibili futhi abakunaki kakhulu. Futhi ngeze, ngoba ithebula elenziwe kahle liyisimo esibalulekile sokubona nokuqonda okungcono kwabasebenzisi. Ukubukwa kwedatha kubonisa indima ebaluleke kakhulu kulokhu. Isibonelo, ngosizo lwamathuluzi wokubukwa ungakhipha umbala amaseli etafula ngokuya kokuqukethwe kwawo. Ake sithole ukuthi singakwenza kanjani lokhu ku-Excel.
Inqubo yokushintsha umbala wamaseli kuye ngokuthi okuqukethwe
Yiqiniso, kuyinto ejabulisayo njalo ukuba netafula elenzelwe kahle, lapho amangqamuzana, kuye ngokuthi okuqukethwe, aqoshwe ngemibala ehlukene. Kodwa lesi sici sisebenza ngokukhethekile ematafuleni amakhulu aqukethe idatha ehlukahlukene. Kule ndaba, ukugcwaliswa kombala kwamaseli kuzokwenza kube lula ukuqondisa kwabasebenzisi kulolu lwazi oluningi, ngoba kungashiwo ukuthi seluvele luhlelekile.
Izakhi zomshini zingalingwa ukudweba ngesandla, kodwa futhi, uma itafula likhulu, kuzothatha isikhathi esiningi. Ngaphezu kwalokho, kuleso sizinda sedatha isici somuntu singadlala indima namaphutha azokwenziwa. Ungasho ukuthi ithebula lingaba lishintsha futhi idatha kuyo ishintshashintsha ngezikhathi ezithile, futhi ngobuningi obukhulu. Kulokhu, ukuguqula umbala ngokujwayelekile kuba okungavamile.
Kodwa kukhona indlela yokuphuma. Amaseli anezimiso ezinamandla (ezishintshayo), ukufometha okunemibandela kusetshenziswa, kanye nedatha yezibalo, ungasebenzisa ithuluzi "Thola futhi ushintshe".
Indlela 1: Ukufometha okunemibandela
Ukusebenzisa ukufometha okunemibandela, ungasetha imingcele ethile yamagugu lapho amaseli azodwetshwa komunye nomunye umbala. Umbala uzokwenziwa ngokuzenzakalelayo. Uma kwenzeka inani leseli, ngenxa yenguquko, lidlulela ngaphesheya kwemingcele, khona-ke lesi sici seshidi sizobuyiselwa ngokuzenzakalelayo.
Ake sibone ukuthi le ndlela isebenza kanjani esibonelweni esithile. Sinetafula lemali yebhizinisi, lapho idatha ihlukaniswa njalo ngenyanga. Sidinga ukugqamisa ngemibala ehlukene lezo zakhi lapho inani lemali engenayo lingaphansi kuka 400000 ama-ruble, kusuka 400000 kuze kube 500000 i-ruble futhi idlula 500000 ama-ruble.
- Khetha ikholomu lapho imininingwane engenayo yebhizinisi. Bese uthuthela kuthebhu "Ikhaya". Chofoza inkinobho "Ukufometha okunemibandela"okuyinto itholakala ku-tape ebhodini lamathuluzi "Izitayela". Kulolu hlu oluvula, khetha into "Ukuphathwa Kwemithetho ...".
- Iqala ukulawula imithetho yewindi yokufometha okunemibandela. Ensimini "Bonisa imithetho yokufometha" kufanele isethelwe "Isiqeshana Samanje". Ngokuzenzakalelayo, kufanele kucaciswe lapho, kodwa uma kungenzeka, hlola futhi uma kungavumelani, shintsha izilungiselelo ngokuvumelana nezincomo ezingenhla. Emva kwalokho kufanele ucindezele inkinobho "Dala umthetho ...".
- Iwindi lokudala umthetho wokufometha uvula. Kuhlu lwezinhlobo zokubusa, khetha isikhundla "Fometha amaseli kuphela aqukethe". Ebhokisini echaza umthetho emkhakheni wokuqala, umshini kufanele ube sesikhundleni "Amanani". Ensimini yesibili, setha inkinobho endaweni "Okuncane". Ensimini yesithathu sibonisa ukubaluleka, izakhi zeshidi eliqukethe inani elincane kunalokho okuzobe kunemibala embala othile. Esimweni sethu, le nzuzo izoba 400000. Emva kwalokho, chofoza inkinobho "Fometha ...".
- Iwindi lefomathi yamaseli ivuleka. Hambisa kuthebhu "Gcwalisa". Khetha umbala ogcwalisayo esiwufunayo, ukuze amaseli aqukethe inani elingaphansi kunalo 400000. Emva kwalokho, chofoza inkinobho "Kulungile" phansi kwefasitela.
- Sibuyela efasiteleni ngokudala umthetho wokufometha bese uchofoza inkinobho lapho futhi. "Kulungile".
- Ngemuva kwalesi senzo, sizophinde siqondiswe kabusha Imenenja yeMigomo Yokufometha Emibandela. Njengoba ungabona, umthetho owodwa usuvele useneziwe, kodwa kufanele sengeze amanye amabili. Ngakho-ke, cindezela inkinobho "Dala umthetho ...".
- Futhi siphinde sifike ekubambeni kwindalo yokudala. Hambisa kusigaba "Fometha amaseli kuphela aqukethe". Ensimini yokuqala yalesi sigaba, shiya ipharamitha "I-Cell Value", futhi okwesibini usethe inkinobho endaweni "Phakathi". Emkhakheni wesithathu udinga ukucacisa inani lokuqala lobubanzi lapho izakhi zeshidi zizofometha khona. Esimweni sethu, le nombolo 400000. Okwesine, sibonisa inani lokugcina laleli banga. Kuyoba 500000. Emva kwalokho chofoza inkinobho "Fometha ...".
- Ewindini lokufometha sithuthela emuva kuthebhu. "Gcwalisa", kodwa manje sikhetha omunye umbala, bese uchofoza inkinobho "Kulungile".
- Ngemva kokubuyela ewindini lokudala indalo, chofoza inkinobho futhi. "Kulungile".
- Njengoba sibona, ku Umphathi weMithetho sesivele sidale imithetho emibili. Ngakho-ke, kuqhubeka ukudala ingxenye yesithathu. Chofoza inkinobho "Dala umthetho".
- Esikhathini sokudalwa kwewindi yokubusa, sithuthela esigabeni futhi. "Fometha amaseli kuphela aqukethe". Ensimini yokuqala, shiya inketho "I-Cell Value". Esimeni sesibili, setha inkinobho emaphoyiseni "Okunye". Ensimini yesithathu siyadlulisa ngenombolo 500000. Khona-ke, njengamanye amacala asedlule, chofoza inkinobho "Fometha ...".
- Ewindini "Fometha amaseli" thuthela kuthebhu futhi "Gcwalisa". Ngalesi sikhathi, khetha umbala ohlukile kumacala amabili angaphambilini. Yenza ngokuchofoza inkinobho. "Kulungile".
- Ewindini yokudala i-window, cindezela inkinobho futhi. "Kulungile".
- Ivula Imenenja yokubusa. Njengoba ungabona, yonke imithetho emithathu yadalwa, ngakho-ke chofoza inkinobho "Kulungile".
- Manje izakhi zetafula zimibala ngokuvumelana nemibandela ecacisiwe nemingcele ngezilungiselelo zesimo sokufometha.
- Uma sishintsha okuqukethwe kwelinye lamaseli, ngenkathi sidlulela ngaphesheya kwemingcele yomunye wemithetho ebekiwe, khona-ke lesi sici seshidi sizoshintsha ngokuzenzakalelayo umbala.
Ngaphezu kwalokho, ukufometha okunemibandela kungasetshenziswa ngokungafani nakwezinye izakhi zombala.
- Kulokhu ngemuva Umphathi weMithetho siya endaweni yokudala ifomathi yokufometha, bese uhlala esigabeni "Fometha wonke amaseli ngokususelwa kumanani awo". Ensimini "Umbala" Ungakhetha umbala, i-shades yayo ezogcwalisa izakhi zeshidi. Bese uchofoza inkinobho. "Kulungile".
- Ngaphakathi Umphathi weMithetho inkinobho yokucindezela futhi "Kulungile".
- Njengoba ubona, emva kwalokhu, amaseli ekholomu anemibala ehlukahlukene ye-shades yombala ofanayo. Uma inani elikhulu eliqukethe ishidi lamashidi ngaphezulu, umthunzi ulula, kancane - okumnyama.
Isifundo: Ukufometha okunemibandela ku-Excel
Indlela 2: Sebenzisa Ithuluzi Lokuthola Nokugqamisa
Uma ithebula liqukethe idatha ephathekayo ongacabangi ukushintsha ngokuhamba kwesikhathi, ungasebenzisa ithuluzi lokushintsha umbala wamaseli ngokuqukethwe kwawo, okubizwa ngokuthi "Thola futhi uqokomise". Leli thuluzi lizokuvumela ukuba uthole amanani achaziwe futhi ushintshe umbala kulawa maseli kumsebenzisi oyifunayo. Kodwa kufanele kuqashelwe ukuthi uma ushintsha okuqukethwe ezintweni zeshidi, umbala ngeke ushintshe ngokuzenzakalelayo, kodwa uzohlala ufana. Ukuze ushintshe umbala okwangempela, kuzomele uphinde uphinde wenze inqubo. Ngakho-ke, le ndlela ayihambisani kahle namatafula ngokuqukethwe okunamandla.
Ake sibone ukuthi isebenza kanjani esibonelweni esithile, lapho sithatha khona yonke ithebula elifanayo lemali engenayo yebhizinisi.
- Khetha ikholomu nedatha okufanele ifomelwe ngombala. Bese uye kuthebhu "Ikhaya" bese uchofoza inkinobho "Thola futhi uqokomise"okuyinto efakwe kwi-tape ebhodini lamathuluzi Ukuhlela. Kulolu hlu oluvula, chofoza entweni "Thola".
- Iwindi iqala "Thola futhi ushintshe" kuthebhu "Thola". Okokuqala, ake sithole amanani ku 400000 ama-ruble. Njengoba singenawo amangqamuzana lapho inani lingabe liphansi 300000 ama-ruble, empeleni, kudingeka sikhethe zonke izakhi eziqukethe izinombolo ezivela 300000 kuze kube 400000. Ngeshwa, asikwazi ngokuqondile ukukhombisa lolu hlu, njengokungathi sisebenzisa ukufometha okunemibandela, kule ndlela akunakwenzeka.
Kodwa kukhona ithuba lokwenza okuthile okuhlukile, okuzosinika umphumela ofanayo. Ungasetha iphethini elilandelayo kwibha yokusesha "3?????". Uphawu lombuzo lisho noma yiliphi uhlamvu. Ngakho-ke, lolu hlelo luzofuna zonke izinombolo zamadijithali eziyisithupha eziqala ngedijithi. "3". Okusho ukuthi imiphumela yokusesha izoqukatha amanani ebangeni 300000 - 400000lokho esikudingayo. Uma ithebula linezinombolo ezingaphansi 300000 noma ngaphansi 200000khona-ke uhla ngalunye kuzinkulungwane eziyikhulu ukusesha kuzodingeka kwenziwe ngokwehlukana.
Faka inkulumo "3?????" ensimini "Thola" bese uchofoza inkinobho "Thola konke".
- Emva kwalokho, imiphumela yemiphumela yosesho iboniswa engxenyeni engezansi yewindi. Chofoza inkinobho yegundane lesokunxele kunoma yimuphi wabo. Bese uthayipha inhlanganisela yokhiye Ctrl + A. Ngemuva kwalokho, yonke imiphumela yosesho igcizelelwe futhi, ngesikhathi esifanayo, izinto ezisekholomu lapho le miphumela ibhekisela kuzo zigqanyisiwe.
- Uma izinto ezisekholomu zikhethiwe, ungasheshi ukuvala iwindi. "Thola futhi ushintshe". Ukuba ngaphakathi kuthebhu "Ikhaya" lapho sithuthele khona ngaphambili, hamba ku-block ye amathuluzi "Ifonti". Chofoza kunxantathu ngakwesokudla kwenkinobho Umbala ogcwalisayo. Ukukhethwa kwemibala egcwele yokugcwalisa kuvulwa. Khetha umbala esifuna ukuwasebenzisa ezakhiweni zeshidi elinamanani angaphansi kwe 400000 ama-ruble.
- Njengoba ubona, wonke amaseli ekholomu lapho amanani angaphansi kwe 400000 ama-ruble agcizelelwe kumbala okhethiwe.
- Manje kudingeka sikhombise izakhi, lapho amanani avela khona 400000 kuze kube 500000 ama-ruble. Lolu hlu lubandakanya izinombolo ezifanisa iphethini. "4??????". Siyidlulisela emkhakheni wosesho bese uchofoza inkinobho "Thola konke"ngokukhetha kuqala ikholomu esiyidingayo.
- Ngokufanayo nasesikhathini esidlule emiphumeleni yosesho senza ukukhethwa komphumela wonke owenziwe ngokucindezela inhlanganisela yokhiye oshisayo I-CTRL + A. Ngemva kwalokho kuthutha ekukhethweni kombala wokukhethwa kombala. Sichofoza kuso bese uchofoze ku-pictogram ye-hue esiyidingayo, okuzodweba izakhi zekhasi, lapho amanani aphakathi kobubanzi kusukela 400000 kuze kube 500000.
- Njengoba ubona, ngemuva kwalesi senzo zonke izakhi zetafula nedatha esikhathini sokuphumula 400000 ngu 500000 kuqokonyiswe ngombala okhethiwe.
- Manje sidinga ukukhetha uhla lokugcina lwamanani - ngaphezulu 500000. Lapha nathi sinenhlanhla, ngoba zonke izinombolo ziningi 500000 kusezingeni 500000 kuze kube 600000. Ngakho-ke, enkundleni yokusesha faka inkulumo "5?????" bese uchofoza inkinobho "Thola konke". Uma kunamanani ayedlula 600000, kuzodingeka sengeze ukufuna le nkulumo "6?????" nokunye
- Futhi, khetha imiphumela yokusesha usebenzisa inhlanganisela Ctrl + A. Ngokulandelayo, usebenzisa inkinobho ebhonsini, khetha umbala omusha ukugcwalisa isikhathi sokudlula 500000 ngesifaniso esifanayo njengoba sasenza ngaphambili.
- Njengoba ubona, ngemuva kwalesi senzo, zonke izakhi zekholomu zizobe zidwetshwe ngaphezulu, ngokusho kwenani lezinombolo elibekiwe kuzo. Manje ungagcina iwindi lokusesha ngokuchofoza inkinobho yokuvala evamile ekhoneni elingenhla elingakwesokudla kwewindi, ngoba umsebenzi wethu ungabhekwa njengokuxazululwa.
- Kodwa uma sishintsha inombolo ngenye enye ehamba ngaphesheya kwemingcele ebekwe umbala othile, umbala ngeke ushintshe, njengoba kwakunjalo endleleni eyedlule. Lokhu kubonisa ukuthi le ndlela izokusebenza ngokuthembekile kuphela kulawo amatafula lapho idatha ingashintshi khona.
Isifundo: Indlela yokwenza usesho ku-Excel
Njengoba ubona, kunezindlela ezimbili zokubala umbala amaseli kuye ngokuthi yizinombolo zamanani ezikuzo: ukusebenzisa ukufometha okunemibandela nokusebenzisa ithuluzi "Thola futhi ushintshe". Indlela yokuqala iyathuthuka kakhulu, njengoba ikuvumela ukuba ubeke ngokucacile izimo lapho izakhi zekhasi zizobekwa khona. Ngaphezu kwalokho, ngokufometha okunemibandela, umbala we-element uguqukela ngokuzenzakalelayo uma okuqukethwe okukuyo kuguquka, okuyinto indlela yesibili engakwazi ukuyenza. Kodwa-ke, iseli ligcwalise kuye ngokubaluleka ngokusebenzisa ithuluzi "Thola futhi ushintshe" Kungenzeka futhi ukuthi kungenzeka ukusebenzisa, kodwa kuphela emathebula asezingeni eliphansi.
