Ngokuvamile, uma usebenzisa ama-spreadsheet e-Excel, kufanele ushintshe amasayizi weseli. Kuvela ukuthi kukhona izakhi zamasayizi ahlukene kushidi. Yiqiniso, lokhu akulona njalo kulungiswa imigomo ewusizo futhi ngokuvamile akusijabulisi kumsebenzisi. Ngakho-ke, lo mbuzo uvela kanjani ukwenza amaseli anesayizi ofanayo. Ake sithole ukuthi zingalungiswa kanjani ku-Excel.
Ukulungiswa kwamasayizi
Ukuze uvumelanise amasayizi eseli kushidi, udinga ukwenza izinqubo ezimbili: shintsha usayizi wamakholomu nemigqa.
Ububanzi bekholomu buyahlukahluka kusuka ku-0 kuya ku-255 amayunithi (8.43 amaphuzu asethwe ngokuzenzakalelayo), ukuphakama komugqa kuvela kumaphoyinti angu-0 kuya ku-409 (ngokuzenzakalelayo amayunithi angu-12.75). Iphuzu elilodwa lokuphakama lilinganiselwa ku-0.035 amentimitha.
Uma befisa, izingxenye zokuphakama nobubanzi zingasuswa ezinye izinketho.
- Ukuba ngaphakathi kuthebhu "Ifayela"chofoza entweni "Izinketho".
- Ewindini yezinketho ze-Excel evula, iya entweni "Okuthuthukisiwe". Ezingxenyeni eziphakathi kwefasitela sithola i-parameter block "Isikrini". Sivula uhlu mayelana nepharamitha "Izinyathelo emgqeni" bese ukhetha enye yezinketho ezine:
- Amentimitha;
- Amasentimitha;
- Izigidi;
- Amanyunithi (asethwe ngokuzenzakalelayo).
Uma usuqumile ngenani, chofoza inkinobho "Kulungile".
Ngakho-ke, kungenzeka ukubeka isilinganiso lapho umsebenzisi engcono khona. Yileyunithi yesistimu ezoguqulwa ngokuqhubekayo lapho icacisa ukuphakama kwemigqa nobubanzi bekholomu yedokhumenti.
Indlela 1: Ukulungiswa kwamaseli ebangeni elikhethiwe
Okokuqala, ake sibone indlela yokuvumelanisa amaseli ebanga elithile, isibonelo, itafula.
- Khetha ibanga kushidi esilungiselela ukwenza usayizi weseli lilingane.
- Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza i-Ribbon kusithonjana "Fometha"esitholakala kwibhulogi yamathuluzi "Amaseli". Uhla lwezilungiselelo luvuleka. Ku-block "Usayizi Weselula" khetha into "Ukuphakama komugqa ...".
- Iwindi elincane livuleka. "Ukuphakama komugqa". Sifika ensimini kuphela enayo, ubukhulu kumayunithi afunwa ukufakwa kuwo wonke imigqa yebanga elikhethiwe. Bese uchofoza inkinobho "Kulungile".
- Njengoba ubona, ubukhulu bamaseli ebangeni elikhethiwe lilingana nokuphakama. Manje sidinga ukuyihlukanisa ngobubanzi. Ukwenza lokhu, ngaphandle kokukhipha ukhetho, uphinde ushayele imenyu nge-inkinobho "Fometha" kwi-tape. Lesi sikhathi ku-block "Usayizi Weselula" khetha into "Ububanzi bekholomu ...".
- Ifasitela iqala ngokufana nalokho okwakunjalo lapho ibeka ukuphakama komugqa. Faka ububanzi bekholomu kumayunithi ensimini, okuzosetshenziswa ebangeni elikhethiwe. Sicindezela inkinobho "Kulungile".
Njengoba ubona, ngemuva kokusebenzisa ukukhwabanisa, amaseli wendawo ekhethiwe abe ngubukhulu obufanayo obukhulu.
Kukhona inguqulo ehlukile yale ndlela. Ungakhetha ku-panel yokuxhumanisa enezingqimba lezo zikholomu ezizokwenza ububanzi obufanayo. Bese uchofoze kule phaneli ene inkinobho yesokudla yegundane. Emenyu evula, khetha into "Ububanzi bekholomu ...". Ngemuva kwalokho, ifasitela ivula ukungena ububanzi bekholomu ebangeni elikhethiwe, esiyikhulume mayelana nokuphakama okuncane.
Ngokufanayo, kwiplanethi eqondile yezixhumanisi, khetha imigqa ebangeni lapho sifuna ukwenza khona ukulungiswa. Sokuchofoza ngakwesokudla kwiphaneli, kwimenyu evuliwe sikhetha into "Ukuphakama komugqa ...". Ngemuva kwalokhu, iwindi livula lapho ipharamitha yokuphakama kufanele ifakwe khona.
Indlela 2: ukuvumelanisa amaseli eshidi lonke
Kodwa kunezimo lapho kudingekile ukuvumelanisa amangqamuzana hhayi kuphela ububanzi obufunayo, kodwa lonke ishidi lonke. Ukuzikhetha ngokuzenzakalelayo yisikhathi eside kakhulu, kodwa kunethuba lokukhetha ngokuchofoza okukodwa.
- Chofoza kwirexeni eliphakathi kwepaneli eziqondile neziqondile zezixhumanisi. Njengoba ungabona, emva kwalokhu, lonke ishidi lamanje linikezwe ngokuphelele. Kunenye indlela yokukhetha lonke ishidi. Ukwenza lokhu, mane uthayiphe isinqamuleli sekhibhodi Ctrl + A.
- Ngemuva kokuthi yonke indawo yeshidi ikhethiwe, sishintsha ububanzi bekholomu nokuphakama kwemigqa ebukhulu besifenqo ngokusebenzisa i-algorithm efanayo echazwe ekutadisheni indlela yokuqala.
Indlela 3: Ukuthutha
Ngaphezu kwalokho, ungakwazi ukuvumelanisa ngesandla usayizi weseli ngokuhudula imingcele.
- Khetha ishidi lonke noma ububanzi bamaseli kuphaneli yokuxhumanisa enezingqimba usebenzisa izindlela ezichazwe ngenhla. Beka isikhombisi emngceleni wamakholomu kuphaneli yokuxhumanisa enezingqimba. Kulesi simo, esikhundleni se-cursor kufanele sibonakale isiphambano, lapho kukhona khona imicibisholo emibili eqondiswa izinkomba ezahlukene. Cisha inkinobho yegundane lesokunxele bese uhudula imingcele ngakwesokudla noma kwesobunxele kuncike ukuthi ngabe sidinga ukunweba noma ukunciphisa. Lokhu kushintsha ububanzi hhayi kuphela kweseli nemingcele oyisebenzisayo, kodwa futhi nayo yonke enye amaseli webanga elikhethiwe.
Ngemuva kokuthi usuqedile ukuhudula nokukhulula inkinobho yegundane, amaseli akhethiwe azoba nobubanzi obufanayo kanye nobubanzi obufanayo nalokho owawubamba khona.
- Uma ungakhethi lonke ishidi, bese ukhetha amaseli ephaneli yokuxhumanisa eqondile. Ngokufanayo kwento yangaphambilini, donsela imingcele yomunye wemigqa ngenkinobho yegundane egcinwe phansi kuze amaseli alesi sigaba afinyelele ukuphakama okwanelisayo. Bese ukhulule inkinobho yegundane.
Ngemva kwalezi zenzo, zonke izakhi zohlu olukhethiwe zizoba nokuphakama okufanayo njengeseli owenza ngalo ukuxhaphazwa.
Indlela 4: faka ithebula
Uma unamathisela itafula elikopishiwe kwishidi ngendlela evamile, ngokuvamile kaningi amakholomu we-variant efakwe azoba nosayizi ohlukile. Kodwa kunamaqhinga okugwema lokhu.
- Khetha ithebula ofuna ukulikopisha. Chofoza kusithonjana "Kopisha"okuyinto efakwe kwi riboni kuthebhu "Ikhaya" ebhodini lamathuluzi "Ibhodi lokunamathisela". Ungase futhi esikhundleni salezi zenzo ngemuva kokukhethwa ukuthayipha ekunqamulelweni kwekhibhodi Ctrl + C.
- Khetha iseli kushidi elifanayo, kwelinye ishidi noma kwenye incwadi. Leli seli kufanele libe yinto ephezulu kwesokunxele kwetafula elifakiwe. Chofoza inkinobho yegundane ngakwesokudla into ekhethiwe. Imenyu yomongo ivela. Kuyo siyaya kuleyo nto "Faka okukhethekile ...". Emenyu eyengeziwe evela emva kwalokhu, chofoza, futhi, entweni ngegama elifanayo elifanayo.
- Iwindi ekhethekile yokufaka iwindi ivuleka. Ebhokisini lesethingi Namathisela shintsha ushintsho endaweni "Ububanzi bekholomu ". Sicindezela inkinobho "Kulungile".
- Ngemuva kwalokho, endizeni yeshidi, amaseli wesayizi ofanayo azofakwa nalawo asetafuleni langempela.
Njengoba ubona, ku-Excel, kunezindlela eziningana ezifanayo zokusungula usayizi weseli ofanayo, njengebanga elithile noma itafula, kanye nekhasi eliphelele. Into ebaluleke kakhulu uma wenza le nqubo ukukhetha kahle ibanga, ubungako ofuna ukushintsha nokuletha inani elilodwa. Imingcele yokufaka yokuphakama nobubanzi bamaseli ingahlukaniswa zibe izinhlobo ezimbili: ukubeka inani elithile kumayunithi aboniswe ngezinombolo kanye nemingcele yokudonsa amabhuku. Umsebenzisi ngokwayo ukhetha indlela elula kakhulu yesenzo, ku-algorithm engcono kakhulu.
