Ukuphenya ku-Excel kubhekisela ekuthutheleleni phezulu-phansi noma eceleni komunye umshini ngokusebenzisa ishidi lokuphenya, izinkinobho zemicibisholo ekhibhodi, noma isondo lokupheqa egundwini.
Ngokuzenzakalelayo, i-Excel ibonisa imigoqo yokupheqa enezingqimba futhi eziqondile eceleni kwesokudla nangakwesokudla kwesikrini se- Excel njengoba kuboniswe esithombeni ngenhla.
Ukufihla / Ukubuka Amabhulogi Ebhola
Qaphela : Uma ufihla ibha yokupheqa enezingqimba ukuze ukwandise indawo yokubukwa kwesekhasi lokusebenzela, kuzodingeka ungacubunguli inketho ye- Show sheet namabha yokupheqa oqondile. Lokhu kuzosusa ibha engezansi yesikhwama sewindi le-Excel.
Ukufihla imigqa yokupheqa enezingqimba kanye / noma ezenzakalweni zamuva ze-Excel (kusukela ku-Excel 2010):
- Chofoza kuthebhu yefayela ukuvula imenyu yefayela;
- Chofoza inkinobho yezinketho kwimenyu ukuvula ibhokisi lebhokisi le- Excel Izinketho ;
- Ebhokisini lebhokisi, chofoza ku- Okuthuthukile ngakwesokunxele kwesokunxele ukuze uvule okukhethwa kukho Okukhethwa kukho Okuthuthukile ngakwesokudla kwesokunxele;
- Ezinkethweni ezithuthukisiwe, phenya phansi kuze kufike kuzinketho zokubonisa zalesi sigaba sencwadi yokusebenzela - cishe ingxenye yesigamu;
- Hlola (bonisa) noma ungahloli (fihla) ibha ye - Show Horizontal Scroll kanye / noma Bonisa okukhethwa kukho ibha ye-Scroll Vertical njengoba kudingeka.
- Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.
Shintsha kabusha Ibha yokupheqa egcwele
Uma inani lamashidi encwadini yokusebenzela landa kuze kube sekugcineni ukuthi amagama azo zonke amashidi awakwazi ukufundwa ngesikhathi esisodwa, enye indlela yokulungisa lokhu ukunciphisa usayizi webhebhu yokupheqa enezingqimba.
Ukwenza lokhu:
- Faka i-pointer yegundane phezu kwe- ellipsis eqondile (amachashazi amathathu aqondile) eduze kwebhayli yokupheqa enezingqimba;
- I-pointer yegundane izoshintsha kumcibisholo ohlosiwe kabili - njengoba kuboniswe esithombeni esingenhla uma sikhiwe kahle;
- Cindezela bese ubamba inkinobho yegundane lesokunxele bese uhudula umdwebo ngakwesokudla ukunciphisa ibha yokupheqa enezingqimba noma kwesobunxele ukuze ukwandise ibha yokuphenya.
Ukulungisa uhlangothi lwe-Vertical Scroll Bar Slider Range
I-slider emgqeni wokuzula oqondile-ibhokisi elihamba phezulu nangaphansi kwezinguquko zokuguqulwa kwesigcawu ngosayizi njengenombolo yemigqa kushidi lokusebenzela eliqukethe izinguquko zedatha.
Njengoba inani lemigqa landa, usayizi wesilayidi sinciphisa.
Uma unephepha lokusebenzela elinenani elilinganiselwe lemigqa equkethe idatha, kodwa isilayidi sincane kakhulu futhi siyishukumisela ngisho nemali encane ibangela ishidi lomsebenzi ukuba lifinyelele phezulu noma lihla emakhulu uma kungenjalo izinkulungwane zemigqa, cishe kubangelwa umugqa noma ngisho neseli elilodwa elide kakhulu ngaphansi kwephepha lokusebenzela eliye lasetshenzwa ngandlela-thile.
Ukulungisa inkinga kuhilela ukuthola nokususa umugqa oqukethe iseli lokugcina elisebenziwe.
Amaseli asebenziwe ayinayo idatha-eshintsha ukulungiswa kweseli, engeza umngcele, noma ngisho nokusebenzisa isibindi noma ukugxilisa ukufometha esitokisini esingenalutho kwanele ukwenza kusebenze iseli-futhi lokhu kungenza ukuthole nokususa irowu eliqukethe lelo cingo eliyinkimbinkimbi .
Ukuthola Umzila Wokugcina Osebenzayo
Isinyathelo sokuqala ukwenza ikhophi yokulondoloza yencwadi yokusebenzela. Izinyathelo zamuva zibandakanya ukususa imigqa kushidi lokusebenzela, futhi uma imigqa equkethe idatha enhle isuswa ngengozi, indlela elula yokuyibuyisela ibe nekhophi yokusekelayo.
Ukuze uthole umugqa wokugcina ephepheni lokusebenzela eliqukethe iseli eliye lasetshenzwa:
- Cindezela ukhiye we- Ctrl + Ekhaya ekhibhodi ukuze uthuthele esitokisini A1 kushidi lokusebenzela.
- Cindezela izinkinobho ze- Ctrl + End kukhibhodi ukuze uye esitokisini sokugcina ekhasini lokusebenzela. Leli seli liyoba iphuzu lokuhlangana phakathi komugqa osetshenziselwe kakhulu kanye nekholomu evuliwe esebenzayo.
Ukususa I-Row Last Active Row
Njengoba ungaqiniseki ukuthi enye imigqa ayizange isebenze phakathi komugqa wokugcina wedatha enhle kanye nomugqa wokugcina osebenziwe, inkambo eqinisekisiwe ukususa yonke imigqa engezansi kwedatha yakho kanye nomugqa wokugcina osebenziwe.
Qinisekisa ukuthi ukhethe imigqa yonke yokususwa ngokuchofoza i- header elayini negundane noma ngokucindezela okhiye beShift + Isikhala ekhibhodi.
Uma imigqa ikhethiwe,
- Chofoza ngakwesokudla ehlokweni lomugqa womunye wemigqa ekhethiwe ukuvula imenyu yemongo;
- Chofoza ku- Susa , kwimenyu ukususa imigqa ekhethiwe.
Bheka ngaphambi kokuthi ususe
Ngaphambi kokususa noma yimaphi imigqa, qiniseka ukuthi lokho okukholelwa ukuthi uyigugu lokugcina yedatha ebalulekile, empeleni, umugqa wokugcina wedatha ebalulekile, ikakhulukazi uma ibhuku lokusebenzela lisetshenziswe ngabantu abangaphezu koyedwa.
Kuyinto engavamile ukufihla idatha ngaphandle kwendawo yamanje yomsebenzi, ngakho-ke kuphakanyiswa ukwenza usesho oluphelele futhi ngaphambi kokuqhubeka nokususwa.
Londoloza Ibhuku
Ngemuva kokususa yonke leyo migqa, isinyathelo sokugcina ukugcina ibhuku lokusebenzela. Kuze kube yilapho ibhuku lokusebenzela ligcinwe, ngeke kube khona ushintsho ngobukhulu nokuziphatha kwesilayidi kubha yokuphenya.