Imvamisa, lapho usebenza namatafula i-Excel, kufanele ukhulise amaseli. Kuyavela ukuthi ephepheni kunezinto ezinamasayizi ahlukene. Kuliqiniso, lokhu akuvunyelwa ngaso sonke isikhathi ngezinhloso ezisebenzayo futhi ngokuvamile i-aesthetically ayenelisi umsebenzisi. Ngakho-ke, kuphakama umbuzo wokuthi ungenza kanjani amaseli afane ngosayizi. Ake sibheke ukuthi zingaqondaniswa kanjani ku-Excel.
Ukuqondanisa kosayizi
Ukuze uvumelanise usayizi weseli ephepheni, udinga ukwenza izinqubo ezimbili: shintsha usayizi wamakholomu nemigqa.
Ububanzi bekholomu buhlukahluka kusuka kumayunithi angama-0 kuye kwangama-255 (amaphuzu angu-8,40 asethelwe ngokuzenzakalelayo), ukuphakama komugqa kungasuka kumaphuzu angama-0 kuye kwangama-409 (amayunithi ayi-12.75 ngokwakhona). Iphuzu elilodwa lokuphakama cishe ngamasentimitha angama-0.035.
Uma kufiswa, amayunithi wokulinganisa ukuphakama nobubanzi angathathelwa indawo ngezinye izinketho.
- Ukuba kuthebhu Ifayelachofoza entweni "Izinketho".
- Ewindini le-Excel Options elivuliwe, iya ku "Kuthuthukile". Engxenyeni ephakathi yewindows sithola ibhulokhi yepharamitha Isikrini. Nweba uhlu oluseduze kwepharamitha "Amayunithi kulayini" bese ukhetha okukodwa kokukodwa okungenzeka:
- Amasentimitha
- Amayintshi
- Amamilimitha
- Amayunithi (asethwe ngokuzenzakalela).
Uma usenqume ngenani, chofoza inkinobho "Kulungile".
Ngakho-ke, kungenzeka ukusungula isilinganiso lapho umsebenzisi asuselwa khona kangcono. Yile yunithi yesistimu ezolawulwa ngokuzayo ngokukhombisa ukuphakama kwemigqa nobubanzi bamakholomu wedokhumenti.
Indlela yoku-1: hlela amaseli ebangeni elikhethiwe
Okokuqala, sizobheka ukuthi zingalinganiswa kanjani amaseli ebangeni elithile, isibonelo, itafula.
- Khetha ibanga eshidini esihlela kulo ukwenza usayizi wamaseli alingane.
- Ukuba kuthebhu "Ikhaya"chofoza ubambo kwisithonjana "Ifomathi"elibekwe endaweni yethuluzi "Amaseli". Uhlu lwezilungiselelo luyavula. Ebhlokini "Usayizi weseli" khetha into "Ukuphakama kolayini ...".
- Kuvuleka iwindi elincane Ukuphakama komugqa. Sifaka inkambu kuphela enayo, usayizi amayunithi, efiseleka ukufakwa kuyo yonke imigqa yebanga elikhethiwe. Bese uchofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, usayizi weseli wobubanzi obukhethiwe selulingana. Manje sizodinga ukusinciphisa ngobubanzi. Ukuze wenze lokhu, ngaphandle kokususa ukukhetha, siphinda sibize imenyu ngenkinobho "Ifomathi" ekhasethini. Kulokhu ku-block "Usayizi weseli" khetha into "Ububanzi bekholamu ...".
- Iwindi liqala ngokufanayo njengoba lalinjalo lapho linikezela ukuphakama komugqa. Faka ububanzi bekholomu amayunithi enkambu, azosetshenziswa ebangeni elikhethiwe. Chofoza inkinobho "Kulungile".
Njengoba ukwazi ukubona, ngemuva kokukhohlisa okwenziwe, amaseli endawo ekhethiwe avele alingana ngokuphelele ngosayizi.
Kukhona enye indlela kule ndlela. Ungakhetha kuphaneli yokuqondisa evundlile leyo makholomu obubanzi bawo ofuna ukufana nawo. Ngemuva kwalokho sichofoza kule paneli ngenkinobho yegundane elifanele. Kumenyu evulayo, khetha "Ububanzi bekholamu ...". Ngemuva kwalokho, kuvulwa iwindi ukufaka ububanzi bekholamu ebangeni elikhethiwe, ebelikhuluma ngalo eliphakeme kancane.
Ngokufanayo, khetha imigqa yebanga esifuna ukuqondanisa kwiphaneli yokuma mpo yezixhumanisi. Sichofoza ngakwesokudla kuphaneli, kumenyu evulayo, khetha intwana "Ukuphakama kolayini ...". Ngemuva kwalokho, kuvulwa iwindi lapho ipharamitha yokuphakama kufanele ifakwe khona.
Indlela 2: hlanganisa amaseli kulo lonke iphepha
Kepha kunezikhathi lapho udinga ukuvumelanisa amaseli hhayi uhla olufunayo, kodwa lonke ishidi lilonke. Ukuzikhetha zonke ngesandla kungumsebenzi omude kakhulu, kodwa kungenzeka ukuzikhetha ngokuchofoza okukodwa nje.
- Chofoza kusikwele esikhona phakathi kwamaphaneli aqondile naphezulu aqondile. Njengoba ukwazi ukubona, emva kwalokho lonke ishidi lamanje likhethwe ngokuphelele. Kukhona enye indlela yokukhetha lonke ishidi. Ukuze wenze lokhu, vele uthayiphe isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + A.
- Ngemuva kokuba kukhethwe yonke indawo eshidi, siguqula ububanzi bekholomu nokuphakama kwemigqa kube usayizi owodwa ngokusho kwe-algorithm efanayo neyachazwa lapho kufundwa indlela yokuqala.
Indlela 3: Hudula imingcele
Ngaphezu kwalokho, ungaqondanisa nosayizi wamaseli ngokuhudula ngesandla imingcele.
- SIKhetha lonke ishidi noma uhla lwamaseli kwiphaneli yokuqondisa evundlile ngezindlela ezichazwe ngenhla. Setha isikhombisi emngceleni wamakholamu kuphaneli yokuqondisa evundlile. Ngaso leso sikhathi, esikhundleni sesikhombisi, kufanele kuqhamuke isiphambano, lapho kukhona imicibisholo emibili ekhomba izinkomba ezihlukile. Bamba inkinobho yegundane kwesobunxele bese udonsela imingcele kwesokudla noma kwesobunxele, kuya ngokuthi siyayidinga yini ukuyikhulisa noma siyinciphise. Lokhu kushintsha ububanzi hhayi kuphela beseli nemingcele oyikhohlisayo, kodwa nangawo wonke amanye amaseli ebanga elikhethiwe.
Ngemuva kokuthi uqede ukuhudula nokukhulula inkinobho yegundane, amaseli akhethiwe ngobubanzi azoba nobukhulu obufanayo, afane ngokuphelele nobubanzi balokho okwenziwe khona ukukhwabanisa.
- Uma ungazange ukhethe lonke ishidi, bese ukhetha amaseli kuphaneli yokuqondisa mpo. Ngendlela efanayo nasesigabeni esedlule, Hudula imingcele yomunye wemigqa inkinobho yenkinobho icindezelwe kuze kube yilapho amaseli kuloluhlu efinyelela ukuphakama okwanelisa. Bese ukhipha inkinobho yegundane.
Ngemuva kwalezi zenzo, zonke izinto zohla olukhethiwe zizoba nokuphakama okufana nokweseli oye walisebenzisa ngamawala.
Indlela 4: faka itafula
Uma unamathisela itafula elikopishiwe eshidini ngendlela evamile, lapho iningi lamakholomu lenguqulo eyedlule liba nosayizi abahlukahlukene. Kepha kunendlela ezovikela lokhu.
- Khetha ithebula ofuna ukulilingisa. Chofoza isithonjana Kopisha, ebekwe kubambo kuthebhu "Ikhaya" ebhokisini lamathuluzi Ibhodi yokunamathisela. Ungakwazi futhi esikhundleni salezi zenzo, ngemuva kokugqamisa, thayipha isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + C.
- Khetha iseli ekhasini elilodwa, kwelinye iphepha noma kwenye incwadi. Lesi seli liba yinto ephezulu kwesobunxele yetafula elifakiwe. Qhafaza kwesokudla entweni ekhethiwe. Imenyu yokuqukethwe iyavela. Kuyo sidlula isigaba "Faka okhethekile ...". Kumenyu eyengeziwe evela ngemuva kwalokho, chofoza, futhi, entweni enegama elifanayo.
- Kuvulwa iwindi elikhethekile lokufaka. Ebhuthini yezilungiselelo Namathisela hambisa ukushintshela esimweni "Amakholomu Ububanzi. Chofoza inkinobho "Kulungile".
- Ngemuva kwalokho, amaseli asayizi ofanayo nalawo ethebula lasekuqaleni azofakwa endizeni eshidi.
Njengoba ukwazi ukubona, e-Excel kunezindlela eziningana ezifanayo zokusetha usayizi ofanayo weseli, njengobubanzi obuqondile noma itafula, nebala lonke. Into ebaluleke kakhulu lapho wenza le nqubo ukukhetha kahle ibanga osayizi ofuna ukuluguqula futhi ulethe inani elilodwa. Okokufaka kwamapharamitha wokuphakama nobubanzi bamaseli kungahlukaniswa kube izinhlobo ezimbili: ukusetha inani elithile kumayunithi kuvezwe ngamanani bese kudonswa ngesandla imingcele. Umsebenzisi ngokwakhe ukhetha indlela elula yokwenza, ku-algorithm lapho ethambekele khona kangcono.
