Ukukhangela kwi-Excel kubhekisela ekuhambeleni phezulu nakwehla okanye ngapha nangapha ngephepha lokusebenzela usebenzisa iibhola zokuskrola, izitshixo zokucoca kwikhibhodi, okanye isondo lokuskrola kwimouse.
Ngokungagqibekanga, i-Excel ibonisa imivalo engqindileyo kunye nemigca yecroll ejikelezayo kunye nekhohlo kwesikrini sase- Excel njengoko kuboniswe kumfanekiso ongentla.
Ukufihla / Ukubukela iBhayileta yeBhayile
Qaphela : Ukuba ufihla ibha ye-scroll engqinileyo ukwenzela ukwandisa indawo yokubukela kwiphepha lokusebenzela, kuya kufuneka ufune ukuchonga ukhetho lwamaxwebhu okubonisa iphepha kunye nomgca wokuqhafaza ojikelezayo. Oku kuya kususa ibha engezantsi yefowuni yefayile ye Excel.
Ukufihla imivalo engqamleyo kunye / okanye imiqulu yecala kwiinguqulelo zakutshanje ze-Excel (ukususela kwi-Excel 2010):
- Cofa kwifayile yefayile ukuvula imenyu yefayile;
- Cofa kwiQhosha lokukhetha kwimenyu ukuvula ibhokisi yencoko yebhokisi ye - Excel ;
- Kwibhokisi yencoko, nqakraza kwi- Advanced kwi-pane kwindlela yokunene ukuze uvule ikhefu yeenketho eziphambili kwi-pane yesandla;
- Kwiindlela eziphambili, prolela phantsi ukuya kwiinketho zokubonisa kule nxalenye yecandelo lomsebenzi - malunga nesiqingatha indlela ukuya ngaphantsi;
- Hlola (bonisa) okanye ungacima (hlahla) ibha ye - Show Horizontal Scroll kunye / okanye Bonisa i-Bar Vertical Scroll options njengoko kufuneka.
- Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.
Nciphisa iBrawontal Scroll Bar
Ukuba inani leemakhishithi kwincwadi yokusebenzela landa kwinqanaba lokuba amagama azo onke amaxwebhu akakwazi ukufundwa ngexesha elinye, enye indlela yokulungisa le nto kukunciphisa ubukhulu bebhayisili yokucoca.
Ukwenza oku:
- Beka isikhombisi semouse phezu kwe- ellipsis ebonakalayo (amachaphaza amathathu).
- I-pointer ye mouse izakuguqula kwisicatshulwa esiphezulu esiphambili-njengoko kuboniswe kumfanekiso ongentla xa uchanekile ngokufanelekileyo;
- Cindezela kwaye ubambe iqhosha lasekhomeni kwaye uhudule i-pointer ngakwesokudla ukucima ibha ye-scroll engqinileyo okanye ngakwesobunxele ukuze ukwandise ibha yokuhambisa.
Ukulungiswa kweBanga leSahlulo sokuBala kwiBar scroll
I-slider kwi-scroll scroll bar-ibhokisi ehamba phezulu nehla phantsi utshintsho lwebhayibhile kwisayizi njengoko inani lemigca kwiphepha lokusebenzela eliqulethe utshintsho lwedatha.
Njengoko inani lemivuzo landa, ubukhulu besilayidi buyancipha.
Ukuba unayo iphepha lokusebenzela kunye nenani elincinci lemigca equkethe idatha, kodwa isilayidi sincinci kwaye ishukumisela yona nokuba inani elincinci lenza ukuba iphepha lokusebenzela lixhomekeke phezulu okanye lihlahle ngamakhulu ukuba kungengamakhulu emigca, mhlawumbi ibangelwa ngumqolo okanye enye iseli ephantsi kwephepha lokusebenzela eliye lenziwe ngandlela-thile.
Ukulungiswa kwengxaki kubandakanya ukufumana nokususa umqolo oqulethwe ngeseli yokugqibela.
Iiseli ezisebenzayo aziququzeleli idatha-ukuguqula ukulungelelaniswa kweseli, ukongeza umda, okanye nokuba wenze isicelo esibindileyo okanye ugxininisa ukufomathiza kwisitenki esingenanto kukho ngokwaneleyo ukuze kusebenze iseli-kwaye oku kunokwenza ukufumana nokususa umgca ophethe i-cell cell .
Ukufumana iRow Active Active
Isinyathelo sokuqala ukwenza ikhophi yokugcinwa kwincwadi yokusebenzela. Amanyathelo alandelayo aquka ukucima imigca kwiphepha lokusebenzela, kwaye ukuba imigqa equkethe idatha efanelekileyo ichithwe ngephutha, indlela elula yokuyibuyisela kukufumana ikopi yokugcina.
Ukufumana umgca wokugqibela kwiphepha lokusebenzela eliqulethe iseli esebenziwe:
- Cinezela iifayile zeKtrl + zaseKhaya kwibhobhobhoyi ukuba uhambe kwiseli A1 kwiphepha lokusebenzela.
- Cinezela iifayile zeCtrl + zokuphela kwibhodibhodi ukuze uthumele kwisisele sokugqibela kwiphepha lokusebenzela. Le seli iya kuba yindlela yokuphambana phakathi komgca ophantsi osebenziweyo kunye nekholamu esebenzayo.
Ukususa iRow Active Active Row
Ekubeni ungeke uqiniseke ukuba enye imigqa ayizange isebenze phakathi komgca wokugqibela weedatha ezilungileyo kunye nomgca wokugqibela osebenziweyo, inkambo eqinisekileyo ukususa yonke imigca engezantsi kwedatha yakho kunye nomgca wokugqibela osebenziweyo.
Qiniseka ukuba ukhethe yonke imigqa yokucima ngokuchofoza kwi- header yomqolo kunye nemouse okanye ngokucinezela izitshixo zeShift + zendawo kwikhibhodi.
Emva kokuba imigqa ikhethiwe,
- Ukucofa ngakwesokudla kwintloko yomqolo omnye wemigca ekhethiweyo ukuvula imenyu yomongo;
- Cofa kuCima , kwimenyu ukucima imigqa ekhethiweyo.
Hlola ngaphambi kokuba ususe
Ngaphambi kokususa nayiphi na imigqa, qiniseka ukuba oko ukholelwa ukuba ngumqolo wokugqibela weenkcukacha ezibalulekileyo, ngokwenene, umgca wokugqibela weenkcukacha ezibalulekileyo, ngakumbi ukuba incwadi yokusebenzela isetyenziswe ngumntu omnye.
Akuqhelekanga ukufihla idatha ngaphandle komsebenzi wamanje, ngoko kuyacetyiswa ukuba wenze uphando olunzulu kwaye ngaphambi kokuba uqhubeke nokucinywa.
Gcina iWindows Workbook
Emva kokususa yonke loo miqolo, isinyathelo sokugqibela kukugcina incwadi. Kuze kube yincwadi yokusebenzela igcinwe, ayiyi kuba yinguqu kwisayizi kunye nokuziphatha kwesilayidi kwibha yokudlula.