Ungawalungisa kanjani amakholomu ku-Excel

I-Excel wuhlelo lomhlaba wonke oluklanyelwe ukwenza ngokuzenzakalelayo ukucutshungulwa kolwazi oluyinkimbinkimbi nokudala imininingwane egciniwe yochwepheshe. Ibanga lokusetshenziswa kwalo likhulu ngendlela emangalisayo, liqala ngokwakhiwa kwamathebula okuqhubeka nokuphrinta futhi ligcine ngokuqoqwa kolwazi lokumaketha, ukucutshungulwa kwedatha yezibalo. Uhlelo lokusebenza oluthakaselekayo lwalolu hlelo lubhala izinhlelo zokusebenza ezigcwele ezisebenza nedatha efakwe umsebenzisi. Abizwa ngokuthi ama-macros.

Nokho, kuthatha isikhathi ukuthola i-hang yakho yonke. Futhi ukuze ube uchwepheshe, udinga ukuqala endaweni ethile. Ngokucacile, indlela yokwenza idatha yesipredishithi ifundwe kalula ngumuntu ongazange ayidale. Kulokhu, kusetshenziswa izinto zokufometha, njengombala weseli, umbala wombhalo, imingcele, nobubanzi bekholomu.

Abasebenzisi abaningi be-Excel sebefundile kakade ukuthi bangawakha kanjani amaspredishithi kulolu hlelo, ukwenza ngokuzenzakalelayo ukucutshungulwa kwedatha elula, nokwenza ezinye izinto eziningi eziyisisekelo. Kodwa ngaphandle kokufometha, ukusebenza nge-spreadsheet ngeke kuphelele. Futhi ishidi ngokwalo lizonikeza umbono wokungaqediwe. Ngakho-ke, udinga ukwazi ukufometha.

Kuyini Ukufometha ku-Excel

Ukufometha akukona nje ukusetha ukubonakala, kodwa futhi ukuhlela idatha equkethwe kudokhumenti. Leli thuluzi lingathatha ubuciko obuningi, njengoba ungakwazi ukugcizelela amaphuzu ayinhloko ngenkathi usebenza ne-spreadsheet, yenza ithebula lifundeke kalula futhi lijabulise iso ngezindlela ezihlukahlukene.

Umbandela oyinhloko wetafula elihle ukuthi ulwazi oludingekayo kulo kufanele lufundwe ngokuzenzakalelayo, ngaphandle kokusesha isikhathi eside kombhalo odingekayo. Uma umsebenzisi efunda ifayela le-Excel lekhwalithi, akudingekile ukuthi adlule kuwo wonke amaseli ukuze athole ulwazi aludingayo. Uma lokhu kwenzeka, khona-ke ukufometha kwenziwa kunembeza. Lapha kuphakama umbuzo: yini okufanele yenziwe ukuze kufomethwe ispredishithi se-Excel? Ukwenza lokhu, kukhona isethi yamathuluzi angatholakala kumathebhu wokudizayina kanye nesakhiwo.

Kungani uthethelela amakholomu ku-Excel

Okokuqala, njengoba kubhaliwe ngenhla, ukuze ithebula libukeke lihle futhi ulwazi oludingekayo lufundwa ngokushesha. Okwesibili, ukulingana wonke umbhalo kuseli ngaphandle kwezinguquko ezengeziwe. Isibonelo, uma umugqa ubanzi kakhulu, khona-ke uvele ukhase ngaphandle kweseli, noma ingxenye ivele ingabonakali. Zombili lezi zinkinga zingaxazululwa ngokuthethelela amakholomu.

Ungawalungisa kanjani amakholomu ku-Excel

Kunezindlela ezimbalwa umsebenzisi angashintsha ngazo ububanzi bekholomu. Okokuqala ukuhambisa ikhesa ngendlela yokukhulisa noma ukunciphisa ikholomu ehambisanayo. Okwesibili ukusetshenziswa kwezimpawu ezikhethekile kuphaneli yokuxhumanisa, ebizwa ngokuthi omaka. Futhi ekugcineni, ungasebenzisa imenyu kasayizi Weseli, etholakala kuthebhu "Isakhiwo". Ake sibheke ngayinye yalezi zindlela ngokuningiliziwe. Izindlela zokuqondanisa amakholomu ngobubanzi nazo ziyehluka.

Ukushintsha ububanzi bekholomu eyodwa

Ukusetshenziswa okujwayelekile kwalesi simiso isidingo sokwenza ikholomu kanhlokweni ibe nkulu. Ihambisana kahle kakhulu namanye amathuluzi okufometha. Isibonelo, uma wenza ikholomu kanhlokweni ibe nkulu futhi uyenze ibebomvu ngefonti ekhethekile, umuntu ovula isipredishithi uqala ukuqonda ngokunembile ukuthi aqale kuphi. Ngakho-ke, indlela "yokuhudula igundane" iyisibonelo esijwayelekile salesi simiso. Kodwa empeleni, lokhu kuhlukaniswa okuhlukile, ngakho-ke ziningi izindlela ezengeziwe.

Isibonelo senye inketho ukusebenzisa imenyu yokuqukethwe. Ngingashintsha kanjani ububanzi bekholomu ethile ngale ndlela?

1. Khetha ikholomu esidinga ukuyikhulisa noma ukunciphisa emugqeni wokuxhumanisa bese uchofoza kwesokudla kuyo.
2. Kumenyu evelayo, chofoza entweni yesithathu ukusuka ngezansi “Ububanzi bekholomu …”. Amachashazi amathathu ekupheleni kwesigaba abonisa ukuthi kufanele sivule isilungiselelo esengeziwe. Empeleni, yilokho okwenzekayo. Ngemva kokuchofoza le nto yemenyu, ibhokisi lengxoxo liyavela lapho udinga ukucacisa ububanzi bekholomu emaphoyintini athile.

Njengoba ubona, amathuluzi amaningana ahambisana nalesi simiso ngesikhathi esisodwa.

Ukushintsha ububanzi bamakholomu amaningi

Isimiso sesibili sokuthethelela amakholomu ngobubanzi sishintsha ububanzi bamakholomu amaningana ngesikhathi esisodwa. Lokhu, yiqiniso, kungenziwa ngokushintshanisa usayizi wamakholomu, kodwa le ndlela ayilula kakhulu futhi ithatha isikhathi esiningi. Kodwa kulula kakhulu ukwenza kanjalo. Kamuva sizokhuluma ngokuningiliziwe ngalokho okudingekayo kulokhu.

Ukushintsha ububanzi bawo wonke amakholomu

Uma ushintsha ububanzi bawo wonke amakholomu ngendlela evamile, kungase kuthathe isikhathi esiningi ukwenza lokhu. Ungakwazi, yiqiniso, ukuguqula ububanzi bawo ngendlela efanayo nabaningana, kodwa lapha futhi kufanele uchithe isikhathi esengeziwe. I-Excel inendlela ehlukile ekuvumela ukuthi ukhuphule noma wehlise ububanzi bawo wonke amakholomu eshidi.

Ukuze wenze lokhu, kufanele uqale ukhethe zonke, bese ushintsha ububanzi. Ukuze wenze lokhu, ungasebenzisa isithonjana esikhethekile sikanxande, esisempambanweni ye-axis yokuxhumanisa irowu kanye nekholomu yokuxhumanisa i-eksisi. Ngemva kwalokho, udinga ukuhlela ububanzi banoma iyiphi yazo. Ngemva kwalokho, ububanzi buzoshintshwa ngokuzenzakalelayo.

Indlela yesibili yokukhetha ngokuphelele wonke amakholomu nemigqa ukucindezela inhlanganisela yokhiye u-Ctrl + A. Umsebenzisi ngamunye angazinqumela ukuthi yini engcono kakhulu kuye: sebenzisa okhiye abashisayo noma igundane.

Shintsha ububanzi bekholomu ngokuqukethwe

Kunezimo lapho kungenzeki khona ukulingana ngokuphelele umbhalo kuseli. Ngenxa yalokho, idlula amanye amaseli. Uma benombhalo wabo siqu noma izincazelo, ingxenye yombhalo iyafihlwa ukuba ingabonakali. Okungenani, kuyaphazamisa. Ukuze uxazulule inkinga, udinga ukwenza ububanzi bekholomu ngendlela yokuthi bulingane nombhalo wonke.

Lokhu kungenziwa ngezindlela ezichazwe ngenhla, kunjalo. Kodwa yinde kakhulu. Kunendlela esheshayo yokwenza lokhu. Ukuze wenze lokhu, udinga ukuhambisa ikhesa yegundane phezu komngcele ofanayo ofuna ukuwuhudula, kodwa esikhundleni sokuyihambisa, udinga ukuchofoza kabili kuyo ngenkinobho yegundane kwesokunxele. Ngemva kwalokho, ubude bekholomu buzoqondaniswa ngokuzenzakalelayo nobude obukhulu beyunithi yezinhlamvu efakwe kuyo.

Indlela 1: Hudula isikhombi segundane

Uma ufuna ukusebenzisa indlela yokuqala, akukho lutho oluyinkimbinkimbi ngakho. Kwanele ukulandela izinyathelo ezichazwe kulo myalelo, futhi umphumela ngeke uphuze ukufika:

1. Beka ikhesa emugqeni wekholomu ukuze iphenduke ibe umcibisholo, umkhawulo ngamunye okhomba ohlangothini oluhlukile. Ikhesa izothola ukubukeka okunjalo uma ihanjiswa phezu kwesihlukanisi esihlukanisa ikholomu eyodwa kwenye.
2. Ngemva kwalokho, chofoza inkinobho yegundane kwesokunxele bese uyibamba. Hudula ikhesa endaweni lapho kufanele ubekwe khona lo mngcele. Siyabona ukuthi ububanzi obuphelele betafula abulungiswanga kulesi simo. Okungukuthi, ngokwandisa ikholomu eyodwa, sinciphisa ngokuzenzakalelayo enye.

Kulesi sithombe-skrini, singabona ngokucacile ukuthi singayibeka kuphi ikhesa yegundane ukuze siguqule ububanzi bekholomu ku-Excel. Lesi simiso siyefana, kungakhathaliseki ukuthi iyiphi inguqulo ye-office suite esetshenzisiwe.

Ungaphinda ubambe ukhiye we-Shift ngenkathi uhudula umugqa wekholomu endaweni ehlukile. Kulokhu, ububanzi betafula buzoshintshwa ngokuzenzakalela ngokuya ngobude bekholomu entsha. Le ndlela yenza kube nokwenzeka ukugcina osayizi abakhona bamanye amakholomu.

Isibonelo, uma unweba ikholomu kwesokunxele ngenkathi ubambe ukhiye we-Shift, khona-ke ikholomu yesokunxele, encikene ngqo neyethu, ngeke inciphe. Okufanayo kusebenza kukholomu engakwesokudla, kuphela kulesi simo ubukhulu bekholomu yesokudla ngeke bushintshwe. Uma ukhulula lo khiye kukhibhodi, lapho-ke uhlela usayizi, ikholomu eseduze izoncipha ngokuzenzakalelayo.

Njengoba ububanzi bekholomu bushintsha, ithiphu elikhethekile lizoboniswa ukuze likutshele ubude bamanje. Lokhu kuvumela ukulawula okunembe kakhudlwana. 

Indlela 2. Ukuhudula omaka eruleni lokuxhumanisa

Ukuhlela usayizi wethebula usebenzisa omaka abakhethekile eruleni akuyona inkimbinkimbi kunendlela yangaphambilini. Ukuze wenze lokhu, landela le miyalo:

1. Khetha iseli noma ububanzi lapho sidinga ukwenza izinguquko khona.
2. Ukuze uhlele ububanzi betafula noma uhambise ubuso bamakholomu, udinga ukususa omaka abahambisanayo kuphaneli evundlile.

Ngendlela, le ndlela ingasetshenziswa futhi ukuhlela ubude bomugqa. Udinga kuphela ukususa omaka abakurula eqondile.

Indlela yesi-3: Sebenzisa imenyu kasayizi weseli kuthebhu ethi Isakhiwo

Ngokuvamile, ukusetha ububanzi bekholomu kwanele ngeso. Asikho isidingo sokucacisa kakhulu ngalolu daba. Uma amakholomu ebonakala enosayizi ofanayo, cishe cishe ayafana. Kodwa kwezinye izimo, udinga ukusetha osayizi abaqondile bamakholomu. Esimeni esinjalo, izinyathelo ezilandelayo kufanele zithathwe:

1. Chofoza inkinobho yegundane kwesokunxele kukholamu okuzohlelwa ubukhulu bayo. I-Excel iphinde inikeze ikhono lokusetha ububanzi bekholomu obufunekayo bezinto ezimbalwa ngesikhathi esisodwa. Ungakhetha amakholomu amaningana ngesikhathi esisodwa ngendlela efanayo nokukhetha ububanzi bamanani, imisebenzi kuphela eyenziwa kuphaneli yokuxhumanisa ephezulu. Ungakwazi futhi ukwenza ngendlela oyifisayo amakholomu adinga ukulinganiswa ngokunembile usebenzisa okhiye u-Ctrl kanye no-Shift. Eyokuqala yenza kube nokwenzeka ukugqamisa amakholomu athile, ngisho nalawo angekho eduze. Ngokusebenzisa ukhiye we-Shift, umsebenzisi angakhetha ngokushesha inombolo ayifunayo yamakholomu aseduze. Ukuze wenze lokhu, cindezela le nkinobho, yenza uchofoze igundane kukholamu yokuqala, bese ngaphandle kokukhulula ikhibhodi, cindezela ikholomu yokugcina yesibili. Uhlelo lokukhetha lungashintsha luye kolunye uhlangothi.
2. Ngemuva kwalokho, sithola iqembu elithi "Usayizi Weseli", elitholakala kuthebhu ethi "Isakhiwo". Kunezinkambu zokufaka ezimbili - ububanzi nobude. Lapho udinga ukucacisa izinombolo ezihambisana nobubanzi bekholomu ofuna ukuyibona. Ukuze uqinisekise izinguquko, udinga ukuchofoza noma yikuphi kuthebula noma umane ucindezele ukhiye wokufaka kukhibhodi. Ukulungiswa kobubanzi obuncane nakho kungenzeka. Ukuze wenze lokhu, sebenzisa imicibisholo. Ngaso sonke isikhathi uma uchofoza kuzo, inani lizokhula noma lehle ngemilimitha eyodwa. Ngakho-ke, uma inani langempela lidinga ukulungiswa okuncane, kwanele ukumane ulithinte kancane kukhibhodi ngaphandle kokulibhala kabusha ngokuphelele.

Isiphetho

Ngakho-ke, kunenombolo enkulu yezindlela zokuhlela ububanzi bekholomu noma iseli. Umgomo ofanayo ungasetshenziswa ekushintsheni ubude bomugqa. Sicabangele izindlela ezimbalwa ngesikhathi esisodwa, kodwa ziningi ezinye, njengoba sesivele saqonda. Ngendlela efanayo, ungakwazi ukuhlukanisa izindlela hhayi ngamathuluzi asetshenzisiwe, kodwa ngezimiso lapho ububanzi bekholomu bushintshwa khona. Futhi njengoba sesivele saqonda, kukhona okufana nalokhu:

1. Ukushintsha ububanzi bekholomu ethile.
2. Ukushintsha ububanzi bamakholomu amaningi.
3. Ukushintsha ububanzi bawo wonke amakholomu eshidi.
4. Ukuhlela ububanzi bekholomu ngokusekelwe ekutheni iqukethe muphi umbhalo.

Kuye ngesimo esikhona, indlela esetshenziswayo izohluka. Sonke siyazi ukuthi ngaphezu kwe-Excel ngokwayo, kunezinye izinhlelo eziningana ezifanayo, njenge-Google AmaSpredishithi, i-Libre Office, i-WPS Office nezinye. Zonke zinokusebenza okujwayelekile okufanayo, ngakho yonke imigomo nezindlela okuxoxwe ngazo kulesi sihloko zingasetshenziswa kwezinye izinhlelo ezifanayo. Kodwa uma kwenzeka, kungcono ukuhlola ukuthi umsebenzi othile usebenza lapho, ngoba umehluko othile ungenzeka, ikakhulukazi uma lezi zinhlelo zokusebenza zisebenza kumasistimu wokusebenza ahlukene.