Iyini 'i-Active Cell' ne 'Active Sheet' ku-Excel futhi Ngingawutholaphi?
Kuzinhlelo zesipredishithi ezifana ne-Excel noma i-Google Spreadsheets, iseli esebenzayo likhonjwe umngcele onemibala noma uhlaka oluzungezile iseli , njengoba kuboniswe esithombeni.
Iseli elisebenzayo liyaziwa nangokuthi iseli yamanje noma iseli eligxile .
Ngisho noma amaseli amaningi agcizelelwe, okukodwa kuphela okugxilwe kukho, okuyinto, ngokuzenzakalelayo, okhethiwe ukuthola okokufaka.
Isibonelo, idatha efakwe ngekhibhodi noma ifakwe ebhodini lokunamathisela ithunyelwe kuseli eligxile.
Ngokufanayo, ishidi elisebenzayo noma ishidi lamanje liyiphepha lokusebenzela eliqukethe iseli esebenzayo.
Njengoba kuboniswe esithombeni ngenhla, igama leshidi elisebenzayo ku-Excel ngaphansi kwekrini ngumbala ohlukile futhi ugcizelelwe ukwenza kube lula ukubona.
Njengeseli esebenzayo, ishidi elisebenzayo libhekwa njengeligxile uma kuziwa ekwenzeni izenzo ezithinta isisodwa esisodwa noma ngaphezulu - njengokufometha - futhi izinguquko zenzeka ekhasini elisebenzayo ngokuzenzakalelayo.
Iseli elisebenzayo neshidi lingashintshwa kalula. Endabeni yeseli esebenzayo, ukuchofoza kwesinye iseli nge-pointer yegundane noma ukucindezela ukhiye womcibisholo ekhibhodi kuzokwenzela kokubili iseli elisebenzayo elikhethiwe.
Ukushintsha ishidi elisebenzayo lingenziwa ngokuchofoza kuthebhu ehlukile yeshidi ne-mouse pointer noma ngokusebenzisa isinqamuleli sekhibhodi.
Amaseli Amaningana Akhethiwe - Iselikho Elilodwa Elilodwa Elisebenzayo
Uma i-pointer yegundane noma ukhiye wekhibhodi isetshenziselwa ukugqamisa noma ukhethe amaseli amabili noma ngaphezulu angasondelene kwiphepha lokusebenzela ukuze uhlaka olumnyama luzungeza amaseli amaningana, kusekhona iseli elilodwa elisebenzayo - iseli nombala ongemuva omhlophe.
Ngokuvamile, uma idatha ingenwe uma kunezingqimba ezingaphezulu kwesisodwa, idatha ingena esitokisini esisebenzayo kuphela.
Okungafani nalokhu kuzoba lapho umshini wefomula ungena kumaseli amaningi ngesikhathi esifanayo.
Cell esebenzayo neBhokisi Legama
Isithenjwa seli cell for the cell esebenzayo godu kuboniswa ebhokisini legama , elitholakala ngenhla kwekholomu A kushidi lokusebenzela.
Ukungafani nalesi simo kwenzeka uma iseli esebenzayo linikezwe igama - kungaba yedwa noma njengengxenye yamaseli. Kulezi zenzakalo, igama lebanga liboniswa ebhokisini legama.
Ukushintsha i-Cell esebenzayo ngaphakathi kweqembu lezinqamuleli ezigqamile
Uma iqembu noma ububanzi bamaseli bekhethiwe i-cell esebenzayo ingashintshwa ngaphandle kokukhetha kabusha uhla usebenzisa izinkinobho ezilandelayo kwikhibhodi:
- Faka ukhiye: uhambisa isisetshenziswa esisebenzayo sigcizelela phansi iseli elilodwa ebangeni elikhethiwe;
- Shift + Faka : ishukumisela iseli esebenzayo igcizelela iseli elilodwa ebangeni elikhethiwe;
- Ukhiye wethebhu: uhambisa iseli elisebenzayo iseli elilodwa ngakwesokudla ngaphakathi kwebanga elikhethiwe;
- Shift + Faka : ishukumisela iseli esebenzayo iseli eyodwa ngakwesobunxele ngaphakathi kwebanga elikhethiwe;
- Ctrl + . (isikhathi): ishukumisela iseli esebenzayo iwashi ekhoneni elilandelayo ebangeni elikhethiwe.
Ukuhambisa i-Cell Active kuya eqenjini elihlukile lamaseli akhethiwe
Uma ngaphezu kweqembu elilodwa noma ububanzi bezingqamuzana ezingekho eduze kufakwe uphawu ekhasini elifanayo lomsebenzi, ukugqamisa kweselula okusebenzayo kungasuswa phakathi kwala maqembu wamaseli akhethiwe asebenzisa okhiye abalandelayo ekhibhodi:
- Ikhi ye- Ctrl + Alt + Yokwesokudla : ishukumisela ukugqamisa kweseli esebenzayo ebangeni elingalona eliseduze ngakwesokudla kwendawo yamanje
- Ikhi ye- Ctrl + Alt + engakwesokunxele : ishukumisela ukugqamisa kweseli esebenzayo ebangeni elingalona eliseduze ngakwesokunxele kwendawo yamanje
Ukukhetha amaSpredishithi amaningi kanye neshidi elisebenzayo
Ngisho noma kungenzeka ukuba ukhethe noma ugcizelele ishidi lamakhasi angaphezu kwesinye ngesikhathi esisodwa, igama leshidi elisebenzayo kuphela liguquguqukile futhi izinguquko eziningi ezenziwe uma amashidi amaningi akhethiwe azothatha kuphela ishidi elisebenzayo.
Ukushintsha Ishidi Lokusebenza Ngezinqamuleli Zezinqamuleli
Ishidi elisebenzayo lingashintshwa ngokuchofoza ithebhu yesinye ishidi nge-mouse pointer.
Ukushintsha phakathi kwamashidi okusebenza kungenziwa futhi ngezinkinobho zokunqamulela.
Ku-Excel
- Iya kushidi ngakwesobunxele: Ctrl + PgUp (ukhiye wekhasi phezulu)
- Ukuya eshidi ngakwesokudla: Ctrl + PgDn (ukhiye wekhasi phansi)
Ku-Google Spreadsheets
- Iya kushidi ngakwesobunxele: Ctrl + Shift + PgUp (ukhiye wekhasi phezulu)
- Ukuya eshidi ngakwesokudla: Ctrl ukhiye + Shift + PgDn (ukhiye wekhasi phansi)