Okuqukethwe
Abanye abasebenzisi be-Excel banenkinga yokuthi igridi eseshidini iyanyamalala kungazelelwe. Lokhu okungenani kubukeka kukubi, futhi kubuye kwengeze ukuphazamiseka okuningi. Phela, le migqa isiza ukuzulazula okuqukethwe kwethebula. Yiqiniso, kwezinye izimo kunengqondo ukushiya igridi. Kodwa lokhu kuwusizo kuphela uma umsebenzisi ngokwakhe eludinga. Manje awudingi ukufunda i-e-books ekhethekile yokuthi ungayixazulula kanjani le nkinga. Funda futhi uzobona ukuthi konke kulula kakhulu kunalokho kubonakala.
Indlela Yokufihla Nokubuyisela Igridi Eshidini Lonke le-Excel
Ukulandelana kwezenzo ezenziwa umsebenzisi kungahluka kuye ngenguqulo ye-office suite. Incazelo ebalulekile: lokhu akukhona mayelana nemingcele yamaseli, kodwa mayelana nemigqa yesithenjwa ehlukanisa amaseli kuyo yonke idokhumenti.
Inguqulo ye-Excel 2007-2016
Ngaphambi kokuba siqonde indlela yokubuyisela igridi kulo lonke ishidi, okokuqala sidinga ukuthola ukuthi kwenzeka kanjani ukuthi inyamalale. Inketho ekhethekile kuthebhu ethi "Buka", ebizwa ngokuthi "Igridi", inesibopho salokhu. Uma ususa ukumaka le nto, igridi izokhishwa ngokuzenzakalelayo. Ngokufanelekile, ukuze ubuyisele igridi yedokhumenti, kufanele uqoke leli bhokisi.
Kukhona enye indlela. Udinga ukuya kuzilungiselelo ze-Excel. Atholakala kumenyu ethi “Ifayela” kubhulokhi elithi “Izinketho”. Okulandelayo, vula imenyu ethi "Okuthuthukisiwe", bese ungahloli ibhokisi lokuhlola elithi "Bonisa igridi" uma sifuna ukuvala isibonisi segridi noma siyihlole uma sifuna ukuyibuyisela.
Kukhona enye indlela yokufihla igridi. Ukuze wenze lokhu, udinga ukwenza umbala wayo ube mhlophe noma ufane nombala wamaseli. Akuyona indlela engcono kakhulu yokwenza lokhu, kodwa ingase isebenze. Ngokulandelayo, uma umbala wemigqa usuvele umhlophe, ngakho-ke kuyadingeka ukulungisa noma yikuphi okunye okuzobonakala ngokucacile.
Ngendlela, bheka. Kungenzeka ukuthi kunombala ohlukile wemingcele yegridi, kuphela ungabonakali ngenxa yokuthi kunemithunzi eminingi emhlophe.
Inguqulo ye-Excel 2000-2003
Ezinguqulweni ezindala ze-Excel, ukufihla nokubonisa igridi kuyinkimbinkimbi kakhulu kunezinguqulo ezintsha. Ukuze wenze lokhu, landela lezi zinyathelo:
- Vula imenyu "yesevisi".
- Iya kokuthi "Izilungiselelo".
- Iwindi lizovela lapho sidinga ukuvula ithebhu ethi "Buka".
- Okulandelayo, sibheka isigaba esinamapharamitha efasitela, lapho singahloli khona ibhokisi eduze kwento ethi "Gridi".
Futhi, njengezinguqulo ezintsha ze-Excel, umsebenzisi angakhetha okumhlophe ukuze afihle igridi, noma emnyama (noma yini ephambana kahle nengemuva) ukuze ayibonise.
I-Excel inikeza ikhono, phakathi kwezinye izinto, lokufihla igridi emashidini amaningana noma kuwo wonke umbhalo. Ukuze wenze lokhu, kufanele uqale ukhethe amashidi afanelekile, bese wenza imisebenzi echazwe ngenhla. Ungakwazi futhi ukusetha umbala womugqa uthi “Okuzenzakalelayo” ukuze ubonise igridi.
Ungafihla kanjani futhi uphinde ubonise igridi yebanga lamaseli
Imigqa yegridi ayisetshenziselwa ukumaka imingcele yamaseli kuphela, kodwa futhi nokuqondanisa izinto ezihlukene. Isibonelo, ukwenza kube lula ukubeka igrafu ngokuhlobene netafula. Ngakho ungakwazi ukufeza umphumela wobuhle owengeziwe. Ku-Excel, ngokungafani nezinye izinhlelo zehhovisi, kungenzeka ukuphrinta imigqa yegridi. Ngakho, ungakwazi ukwenza ngokwezifiso ukubonisa kwabo hhayi kuphela esikrinini, kodwa futhi ekuphrintiwe.
Njengoba sesivele sazi, ukuze ubonise imigqa yegridi esikrinini, udinga nje ukuya kuthebhu ethi "Buka" bese uhlola ibhokisi elihambisanayo.
Ngokufanelekile, ukufihla le migqa, vele ususe ukumaka ibhokisi elihambisanayo.
Ukuboniswa Kwegridi Kubanga Eligcwele
Ungaphinda ubonise noma ufihle igridi ngokushintsha inani Lombala Wokugcwalisa. Ngokuzenzakalelayo, uma ingasethiwe, igridi iyavezwa. Kodwa ngokushesha lapho iguqulwa ibe mhlophe, imingcele yegridi ifihliwe ngokuzenzakalelayo. Futhi ungazibuyisela ngokukhetha into ethi "Akukho kugcwalisa".
Ukuphrinta kwegridi
Kodwa yini okudingeka uyenze ukuze uphrinte le migqa ephepheni? Kulokhu, udinga ukwenza kusebenze inketho ethi "Phrinta". Ukuze wenze lokhu, kufanele ulandele imiyalo elandelayo:
- Okokuqala, khetha amashidi azothintwa izinguquko. Ungathola ukuthi amashidi amaningana akhethwe ngesikhathi esisodwa wuphawu [lweQembu], oluzovela kusihloko seshidi. Uma kungazelelwe amashidi akhethwe ngokungalungile, ungakhansela ukukhetha ngokuchofoza kwesokunxele kunoma yimaphi amashidi akhona.
- Vula ithebhu "Isakhiwo Sekhasi", lapho sifuna khona iqembu elithi "Izinketho Zeshidi". Kuzoba nomsebenzi ohambisanayo. Thola iqembu elithi "Igridi" bese uqoka ibhokisi eduze kwento ethi "Phrinta".
Ngokuvamile abasebenzisi bahlangabezana nale nkinga: bavula imenyu Yesakhiwo Sekhasi, kodwa amabhokisi okuhlola adinga ukwenziwa asebenze awasebenzi. Ngamagama alula, akwenzeki ukwenza kusebenze noma ukuvala imisebenzi ehambisanayo.
Ukuze uxazulule lokhu, udinga ukushintsha ukugxila kwenye into. Isizathu sale nkinga ukuthi ukukhetha kwamanje akulona ishidi, kodwa igrafu noma isithombe. Futhi, amabhokisi okuhlola adingekayo avela uma uyeka ukukhetha le nto. Ngemva kwalokho, sibeka idokhumenti ukuphrinta futhi sihlole. Lokhu kungenziwa kusetshenziswa inhlanganisela yokhiye Ctrl + P noma usebenzisa into yemenyu ehambisanayo “Ifayela”.
Ungakwazi futhi ukusebenzisa ukubuka kuqala futhi ubone ukuthi imigqa yegridi izophrintwa kanjani ngaphambi kokuba ivele ephepheni. Ukuze wenze lokhu, cindezela inhlanganisela Ctrl + F2. Lapho ungakwazi futhi ukushintsha amaseli azophrintwa. Isibonelo, umuntu angase afune ukuphrinta imigqa yegridi kumaseli angenawo amanani. Esimeni esinjalo, amakheli afanelekile kufanele engezwe ebangeni elizonyatheliswa.
Kodwa kwabanye abasebenzisi, ngemva kokwenza lezi zinyathelo, imigqa yegridi namanje ayiveli. Lokhu kungenxa yokuthi imodi yokusalungiswa ivuliwe. Udinga ukuvula iwindi elithi "Ukusethwa Kwekhasi" futhi ususe ukumaka ibhokisi elihambisanayo kuthebhu ethi "Ishidi". Uma lezi zinyathelo zingazange zisize, khona-ke isizathu singase silele kumshayeli wephrinta. Khona-ke isisombululo esihle kungaba ukufaka umshayeli wefekthri, ongalandwa kuwebhusayithi esemthethweni yomkhiqizi wale divayisi. Iqiniso liwukuthi abashayeli abafakwa yisistimu yokusebenza ngokuzenzakalelayo abasebenzi kahle ngaso sonke isikhathi.