Yiyiphi 'i-Active Cell' ne 'Active Sheet' kwi-Excel kwaye Ndingayifumanaphi?
Kwiiprogram ze-spreadsheet ezifana ne-Excel okanye i-Google Spreadsheets, iseli esisebenzayo lichongiwe ngumda onemibala okanye umgca ojikeleze iseli , njengoko kuboniswe kumfanekiso.
Iseli esebenzayo yaziwa ngokuba yiseli yangoku okanye iseli ejolise kuyo .
Nangona iiseli ezininzi zigqityiwe, yinto enye evame ukugxila kuyo, ekhethiweyo, ekhethiweyo, ekhethiweyo ukufumana igalelo.
Ngokomzekelo, idatha efakwe ngebhodibhodi okanye idutywe kwibhodi yokunamathisela ithunyelwa kwiseli ejolise kuyo.
Ngokufanayo, iphepha elisebenzayo okanye iphepha langoku liphepha lokusebenzela eliqukethe iseli esebenzayo.
Njengoko kuboniswe kumfanekiso ongentla, igama lephepha elisebenzayo kwi-Excel ngaphantsi kwesikrini ngumbala ohlukileyo kwaye ugxininiswe ukwenza kube lula ukuchonga.
Njengomnxeba osebenzayo, iphepha elisebenzayo libhekiselwe ekubeni lijolise ekusebenzeni izenzo ezithintela omnye okanye ezinye iiseli - ezifana nokufometha - kwaye utshintsho luvela kwiphepha elisebenzayo ngokuzenzekelayo.
Iseli esebenzayo kunye nephepha kungatshintshwa lula. Kwimeko yeseli esebenzayo, ukucofa kwelinye iseli kunye ne-pointer ye mouse okanye ucinezela izitshixo zitshixo kwikhibhodi ziza kubangela ukuba kusetyenziswe iseli elisebenzayo elitsha.
Ukutshintsha iphepha elisebenzayo linga kwenziwa ngokuchofoza kwiphepha elihlukileyo lephepha kunye ne-pointer ye mouse okanye ngokusebenzisa i-shortcut keyboard.
Iinqununu eziliqela ezikhethiweyo - Isisodwa esinye seSeli esisebenzayo
Ukuba isalathisi se mouse okanye isitshixo sekhibhodi sisetyenziselwa ukugqamisa okanye ukhethe iiseli ezimbini okanye ngaphezulu ezikufutshane kwiphepha lokusebenzela ukwenzela ukuba umgca omnyama ujikeleze iiseli eziliqela, kusekho enye iseli esebenzayo - iseli nombala ongasemva.
Ngokuqhelekileyo, ukuba idatha ingeniswa xa kusetyenziswa uphawu olungaphezulu kwelilodwa, idatha ingena kwiseli esebenzayo kuphela.
Okungavumelekanga kule nto kuza kuba xa ifomula yomhlathi ingena kwiiseli ezininzi ngexesha elinye.
Cell esebenzayo kunye neBhokisi legama
Iselferensi yeseli yesisele esisebenzayo iphinda iboniswe kwiBhokisi legama , elisezantsi kwekholomu A kwiphepha lokusebenzela.
Ukungaxhomekeke kule meko kwenzeka ukuba iseli esebenzayo linikezwe igama- nokuba lilodwa okanye njengenxalenye yeelitha. Kulezi zihlandlo, igama legama liboniswa kwiBhokisi legama.
Ukutshintsha i-Cell esebenzayo ngaphakathi kweqela leeNgcaciso zeCells
Ukuba iqela okanye uluhlu lwamaseli lukhethiweyo iseli esebenzayo lunokutshintshwa ngaphandle kokukhetha kwakhona uluhlu usebenzisa ezi zinto zilandelayo kwikhibhodi:
- Faka ukhiye: uhambisa isalathisi esebenzayo esekwe phantsi kwelinye iseli kwibala elikhethiweyo;
- Shift + Ngena : ishukumisela isalathisi esisebenzayo iphakamisa iseli enye kwibanga elikhethiweyo;
- Ukhiye weTeb: ususa iseli esisebenzayo iseli enye ngakwesokudla ngaphakathi kwebala elikhethiweyo;
- Shift + Ngena : ishukumisela isisele esisebenzayo enye iseli ngakwesobunxele kwibala elikhethiweyo;
- Ctrl + . (ixesha): ishukumisela isalathisi esebenzayo kwiwashi elandelayo kwikota ekhethiweyo.
Ukuhambisa i-Cell esebenzayo kwiqela elithile leenketho ezikhethiweyo
Ukuba ngaphezulu kweqela elinye okanye uluhlu lwamaseli angaqhelekanga lugqityiwe kwiphepha elifanayo lomsebenzi, ukugqithiswa kweeseli ezisebenzayo kunokushukunyiswa phakathi kwala maqela eeseli ezikhethiweyo usebenzisa ezi zinto zilandelayo kwikhibhodi:
- I-Ctrl + Alt + I-key ye- Arrow key: ishukumisela ukugqithiswa kweeseli esebenzayo kwibala elilandelayo elingenakufuphi ukuya kwindawo elungileyo kwindawo
- I-Ctrl + I- Alt + ye- Etshi yokhiye wesobunxele: ushukumisela ukugqithisa kweeseli esebenzayo kwibala elingalindelekanga elingasondelene naloo ndawo.
Ukukhetha Amaphepha amaninzi kunye neSheet Active
Nangona kunokwenzeka ukukhetha okanye ukugqamisa ngaphezulu kwephepha elilodwa lomsebenzi ngexesha elinye, igama elilodwa lomsebenzi elisebenzayo lichanekileyo kwaye utshintsho oluninzi olwenziweyo xa iithayibhile ezikhethiweyo ziya kuphazamisa kuphela iphepha elisebenzayo.
Ukutshintsha i-Active Sheet ne-Shortcut Keys
Iphepha elisebenzayo linokutshintshwa ngokuchofoza kwithebhu lenye iphepha kunye ne-mouse pointer.
Ukutshintsha phakathi kwamaphepha okusebenzela kunokukwenziwa kunye nezitshixo zokufutshane.
Kwi Excel
- Ukuhambisa kwiphepha ngakwesobunxele: Ctrl + PgUp ( ukhiye wekhasi phezulu)
- Ukuhambisa kwiphepha langakwesokudla : Ctrl + PgDn (iphepha eliphantsi kwekhi )
Kwi Google Spreadsheets
- Ukuhambisa kwiphepha ngakwesobunxele: Ctrl + Shift + PgUp ( ukhiye wekhasi phezulu)
- Ukuhambisa kwiphepha langakwesokudla : Ctrl ukhiye + Shift + PgDn (kwikhasi elingundoqo)