Uma ithebula ku-Excel lilide futhi kunedatha eningi kulo, ungasebenzisa umsebenzi owakhelwe ohlelweni obonisa izihloko zetafula ekhasini ngalinye. Lokhu kuyiqiniso ikakhulukazi lapho kunyatheliswa amanani amakhulu olwazi. Umsebenzi onjalo ubizwa ngemigqa.
Uyini umugqa wokudlula?
Uma udinga ukuphrinta inombolo enkulu yamashidi, ngokuvamile kunesidingo sesihloko esifanayo noma unhlokweni ekhasini ngalinye. Ukulungisa le datha kusipredishithi se-Excel kuwumugqa wokudlula. Lesi sici asinciphisi nje kuphela inani lomsebenzi, kodwa futhi sisiza ukwenza ukwakheka kwekhasi kube kuhle kakhulu.. Ngaphandle kwalokho, ngenxa yemigqa kungenzeka ukumaka amashidi kalula.
Indlela yokwenza ngemigqa?
Ukuze ungenzi mathupha umsebenzi onzima onjengokufaka ulwazi olufanayo ezingxenyeni ezihlukene zedokhumenti, kuye kwadalwa umsebenzi okahle - umugqa wokudlulisa. Manje, ngokuchofoza okukodwa nje, ungakha unhlokweni owodwa nesihloko, isiginesha noma ukumakwa kwekhasi kudokhumenti ngayinye, njalo njalo.
Nakani! Kukhona okuhlukile kokuthi ngokusebenzisa imigqa, okugxilile esikrinini, kodwa ngokuphrinta kukhiqizwa kanye kuphela ekhasini ngalinye. Kulokhu, idokhumenti esohlelweni ingaskrolwa. Futhi kukhona umsebenzi ngokusebenzisa imigqa, okungase ukuboniswa ekhasini ngalinye ngendlela unhlokweni inombolo ekhethiwe izikhathi. Lesi sihloko sizocabangela inketho yokugcina.
Izinzuzo ngokusebenzisa imigqa zisobala, ngoba ngosizo lwabo ungakwazi ukunciphisa inani lamahora okusebenza kukhompyutha, kuyilapho uzuza umphumela oyifunayo. Ukwenza umugqa usuke uye ekupheleni, kubalulekile ukulandela ukulandelana kwezenzo ezithile, okuyilezi:
- Iya enhlokweni ye-Excel engxenyeni ethi “Isakhiwo Sekhasi”, khetha “Izihloko Zokuphrinta” kanye “Nesethaphu Yekhasi”.
Kubalulekile ukwazi! Uma ingekho iphrinta futhi ngesikhathi sokuhlela amaseli, lesi silungiselelo ngeke size sitholakale.
- Ngemuva kokuthi into ethi "Ukusethwa Kwekhasi" ibonakala ekusebenzeni, udinga ukuya kuyo bese uchofoza ithebhu ethi "Ishidi" ngegundane, njengoba kuboniswe esithombeni. Kuleli windi, umsebenzi othi “Ngemigqa” usuvele ubonakala. Chofoza inkambu yokufaka.
- Khona-ke kufanele ukhethe leyo migqa epuletini okudingeka ilungiswe. Udinga ukukhetha umugqa wokudlula ngokuvundlile. Ungakwazi futhi ukufaka izinombolo zolayini mathupha.
- Ekupheleni kokukhetha, chofoza inkinobho ethi "OK".
Ungahlola kanjani imigqa?
Ukuhlola lesi sici kumathebula nakho kubalulekile. Ukuze singoni imiqulu emikhulu yamadokhumenti, sizokwenza isheke lokugcina. Ukuze wenze lokhu, landela lezi zinyathelo ezilandelayo:
- Okokuqala, yiya engxenyeni ethi “Ifayela”, etholakala kunhlokweni yethebula ekhoneni elingakwesokunxele. Bese uchofoza inkinobho ethi “Phrinta”, engabonwa kuMfanekiso 2.
- Ukubuka kuqala kwedokhumenti kuzovuleka ngakwesokudla, lapho ungabheka ukuhambisana nemingcele ecacisiwe. Skrola kuwo wonke amakhasi bese uqinisekisa ukuthi imigqa edalwe ngaphambili inembile.
- Ukuze uye eshidini elilandelayo, mane uchofoze esondweni lokuskrola ngakwesokudla. Ungakwenza futhi lokhu ngesondo legundane.
Njengokwemigqa, ungafriza amakholomu athile kudokhumenti. Le parameter isethwe esigabeni esifanayo nesomugqa wokunqamula, iphuzu elilodwa kuphela phansi, njengoba kukhonjisiwe kuMfanekiso 2.
Isiphetho
Kuphrosesa yespredishithi se-Excel, inkimbinkimbi iba lula, futhi umsebenzi omude njengokukopisha isihloko noma unhlokweni wekhasi bese uwudlulisela kwabanye uzenzakalela kalula. Ukudlulisa imigqa kuyashesha futhi kulula, vele ulandele imiyalelo engenhla.