Indlela Yokuhambisa Konke Nama Phakathi Amathebhu Wokusebenza E-Excel

Ukuhambisa ezindaweni ezahlukene kwedatha kulula kunalokho ucabanga

I-Excel inezindlela eziningi zokuthuthela ezindaweni ezihlukene zedatha kushidi lokusebenzela noma phakathi kwamaphepha okusebenzela ahlukene encwadini efanayo.

Ezinye izindlela - ezifana ne- Go To Command - zingatholakala ngokusebenzisa inhlanganisela yekhibhodi yokunqamulela ikhibhodi, okuyizinye izikhathi okungaba lula - futhi okusheshayo-ukusebenzisa ngaphandle kwegundane.

Sebenzisa ama-Keys Keys ukuze ushintshe ama-Worksheets ku-Excel

Ukushintshanisa phakathi kwamaphepha okusebenzela kubhuku le-Excel kwenziwa ngokwanele ngokuchofoza amathebhu ezansi kwamakhasi, kodwa kuyindlela encane yokwenza lokhu - okungenani kunombono walabo abakhetha ukusebenzisa izinqamuleli zekhibhodi noma isinqamuleli okhiye lapho kunokwenzeka.

Futhi, njengoba kwenzeka, kunezinkinobho zokunqamulela zokushintsha phakathi kwamashidi okusebenza ku-Excel.

Izihluthulelo ezisetshenzisiwe ziyi:

Ctrl + PgUp (ikhasi phezulu) - thuthela ishidi elilodwa ngakwesokunxele Ctrl + PgDn (ikhasi phansi) - thumela ishidi elilodwa ngakwesokudla

Ungashintsha kanjani phakathi kwamaphepha okusebenzela usebenzisa ama-keycut Keys

Ukuya ngakwesokudla:

1. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
2. Cindezela bese ukhulula ukhiye we- PgDn kukhibhodi.
3. Ukuhambisa elinye ishidi kwesokudla bese ukhulula ukhiye we- PgDn okwesibili.

Ukuhambisa ngakwesokunxele:

1. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
2. Cindezela bese ukhulula ukhiye we- PgUp ekhibhodi.
3. Ukuhambisa elinye ishidi kumshini wesokunxele bese ukhulula ukhiye we- PgUp okwesibili.

Ukusebenzisa Ukuhamba Kokufinyeza Izinkinobho Zokuhamba Emakhakheni Okusebenza E-Excel

I- Go Ukuya ku-Excel ingasetshenziselwa ukusheshisa kumaseli ahlukene kushidi lokusebenzela.

Nakuba ukusebenzisa i- Go kuwona akusizi okusemakhasini okusebenza okuqukethe amakholomu namarowu ambalwa kuphela, kodwa ukuze uthole ama-worksheet amakhulu, enye indlela elula yokusuka kwenye indawo yephepha lakho lokusebenzela kwelinye.

Hamba Ukusebenza ngu:

1. Ukuvula ibhokisi lokubhalela;
2. Ukuthayipha endaweni yereferensi yesithenjwa esendaweni ekhoneni lokubhekisela ngaphansi kwebhokisi lebhokisi;
3. Ukuchofoza OK noma ukucindezela ukhiye we- Enter kukhibhodi.

Umphumela wukugqama kweselula okusebenzayo kuqhubekela esitokisini sefoni esangenwe ebhokisini lengxoxo.

Isebenza ku- Go To

I- Go Ukuyala ingaqaliswa izindlela ezintathu:

• Ngokuchofoza Ikhaya > Thola & Khetha > Yiya Kumenyu yebhebhoni negundane.
• Ngokucindezela ukhiye we- F5 ekhibhodi.
• Ngokucindezela izinkinobho ze- Ctrl + g ngokuhlanganiswa kwikhibhodi.

Ukugcina amareferensi weselula ukuze asetshenziswe kabusha

Isici esengeziwe ukuthi i- Go has has it stores previously referenced cell reference in the big Go window nakwesokunxele ebhokisini lengxoxo.

Ngakho uma uqaqa emuva naphakathi kwezindawo ezimbili noma ngaphezulu kwiphepha lokusebenzela, Iya Kuzokugcina isikhathi esengeziwe ngokuphinda usethe kabusha izinkomba ezigciniwe ezigcinwe ebhokisini lengxoxo.

Izinkomba zeselula zigcinwa ebhokisini lengxoxo uma nje ibhuku lokusebenzela lihlala livulekile. Uma ivaliwe, uhlu olulondoloziwe lwezingqamuzana zamangqamuzana ku-Ibhokisi lokungena liya kususwa.

Ukuhamba nge- Go To Isibonelo

1. Cindezela u- F5 noma i- Ctrl + g ekhibhodi ukuze ulethe ibhokisi lokungena ku- Go .
2. Thayipha ireferensi yeseli yendawo oyifunayo endaweni yokubhekisela ebhokisini lengxoxo. Kulokhu: HQ567 .
3. Chofoza inkinobho ye- OK noma ucindezela ukhiye we- Enter ekhibhodi.
4. Ibhokisi elimnyama elizungezile iseli esebenzayo kufanele lifinyelele esitokisini i- HQ567 ukwenza kube iseli elisha elisebenzayo.
5. Ukuhambisa kwenye iseli, phinda izinyathelo 1 kuya ku-3.

Ukuzulazula Phakathi Kwama-Worksheet nge- Go

Hamba Ungasetshenziswa futhi ukuhamba kumashidi okusebenza ahlukene kubhuku elifanayo ngokufaka igama leshidi kanye nereferensi yeseli.

Qaphela: iphuzu lokumemeza ( ! ) - elitholakala ngenombolo 1 kukhibhodi - isetshenziswa ngaso sonke isikhathi njengehlukanisi phakathi kwegama lomsebenzi kanye nereferensi yeseli - izikhala azivunyelwe.

Isibonelo, ukushiya kusuka kuSheet 1 kuya kweselula HQ567 kwiShidi 3, faka iShidi #! HQ567 emgqeni wokubhekisela webhokisi lebhokisi le-Go uye cindezela ukhiye we- Enter .

Ukusebenzisa Ibhokisi Legama Ukuze Uhambise I-Excel Worksheets

Njengoba kuboniswe esithombeni esingenhla, Ibhokisi Legama litholakala ngenhla kwekholomu A kwiphepha lokusebenzela lase-Excel futhi lingasetshenziswa ukuya ezindaweni ezahlukene zalolu shicilelo usebenzisa amakholi weselula .

Njenge- Go Ukuyala, Ibhokisi Legama lingase lingabi usizo emakhasini okusebenza aqukethe amakholomu ambalwa kuphela nemigqa yedatha, kodwa ngamakhasi amakhulu okusebenzela, noma kulabo abanezindawo ezihlukene zedatha esebenzisa iBhokisi Legama ukuze bagxume kalula kusuka endaweni eyodwa kuya okulandelayo kungaba yindlela ephumelelayo kakhulu yokusebenza.

Ngeshwa, ayikho indlela yokufinyelela ibhokisi legama usebenzisa ikhibhodi ngaphandle kokwakha i-VBA macro. Ukusebenza okuvamile kudinga ukuchofoza iBhokisi Legama negundane.

I-Active Cell Reference Reference ebhokisini legama

Ngokuvamile, Ibhokisi Legama libonisa ireferensi yeseli noma ububanzi obubizwa ngokuthi i-cell yamanje noma esebenzayo - iseli kumsebenzi wamanje wamanje ochazwe umngcele omnyama noma ibhokisi.

Uma incwadi yokusebenzela ye-Excel ivuliwe, ngokuzenzakalelayo, iseli A1 ekhoneni eliphezulu lesokunxele lephepha lokusebenzela iyiselula esebenzayo.

Ukufaka i-reference yeselula noma igama lebanga ebhokisini legama futhi ucindezela ukhiye we- Enter ushintshe iseli esebenzayo bese ushintsha ibhokisi elimnyama - nokuthi yini ebonakalayo esibukweni kanye nalo - endaweni entsha.

Ukuhamba Ngebhokisi Legama

1. Chofoza ebhokisini legama ngaphezulu kwekholomu A ukuze uqokomise ireferensi yeseli yeseli esebenzayo.
2. Thayipha ireferensi yeseli yendawo oyifunayo - njengeHQ567.
3. Cindezela ukhiye wokungena kwikhibhodi.
4. Ibhokisi elimnyama elizungezile iseli esebenzayo kufanele lifinyelele esitokisini i- HQ567 ukwenza kube iseli elisha elisebenzayo.
5. Ukuze uthuthelele kwelinye iseli, thayipha enye ireferensi yeseli ebhokisini legama bese ucindezela ukhiye wokungena kwikhibhodi.

Ukuzulazula Phakathi Kwama-Worksheets Ngebhokisi Legama

Njengaye Kuya , Ibhokisi Legama lingasetshenziswa futhi ukuhamba kumashidi okusebenza ahlukene kubhuku elifanayo ngokufaka igama leshidi kanye nereferensi yeseli.

Qaphela: iphuzu lokumemeza ( ! ) - elitholakala ngenombolo 1 kukhibhodi - isetshenziswa ngaso sonke isikhathi njengehlukanisi phakathi kwegama lomsebenzi kanye nereferensi yeseli - izikhala azivunyelwe.

Isibonelo, ukuhambisa kusuka kuSheet 1 kuya esitokisini HQ567 kwiShidi 3, faka iSheet3! HQ567 ebhokisini legama bese ucindezela ukhiye wokungena .