Ukuze wenze imisebenzi ehlukahlukene ngokuqukethwe ngamaseli e-Excel, kufanele ukhethe kuqala. Ngalezi zinhloso, uhlelo lunamathuluzi ambalwa. Okokuqala, lokhu kwehluka kungenxa yokuthi kunesidingo sokugqamisa amaqembu ahlukahlukene amaseli (amabanga, imigqa, amakholomu), kanye nesidingo sokumaka izinto ezihambisana nesimo esithile. Ake sibheke ukuthi ingayenza kanjani le nqubo ngezindlela ezahlukahlukene.
Inqubo yokukhetha
Ngenqubo yokukhetha, ungasebenzisa zombili igundane nekhibhodi. Kukhona nezindlela lapho la madivayisi wokufaka ahlanganiswa khona nawo.
Indlela yoku-1: Iseli elilodwa
Ukuze ukhethe iseli elilodwa, mane ugoqe phezu kwalo bese uqhafaza kwesokunxele. Futhi, ukukhetha okunjalo kungenziwa usebenzisa izinkinobho ezinkinobho zokuhambisa ikhibhodi "Phansi", Phakama, Kwesokudla, Kwesobunxele.
Indlela 2: khetha ikholamu
Ukuze umaka ikholomu etafuleni, bamba inkinobho yegundane kwesobunxele bese uhudula usuka esitokisini phezulu kakhulu lekholomu uye ezansi, lapho kukhishwa khona inkinobho.
Kukhona enye indlela yokuxazulula le nkinga. Inkinobho yokubamba I-Shift kukhibhodi bese uqhafaza kuseli eliphezulu lekholamu. Ngemuva kwalokho, ngaphandle kokukhipha inkinobho, chofoza ngezansi. Ungenza isenzo ngokuhleleka okuhlukile.
Ngaphezu kwalokho, i-algorithm elandelayo ingasetshenziswa ukugqamisa amakholomu kumatafula. Khetha iseli lokuqala lekholamu, khipha igundane bese ucindezela inhlanganisela yokhiye I-Ctrl + Shift + Arow Down. Kulokhu, ikholomu yonke ikhethiwe kulungu lokugcina lapho imininingwane iqukethwe. Isimo esibalulekile sokwenza le nqubo ukungabikho kwamaseli angenalutho kule kholamu yetafula. Ngaphandle kwalokho, kuphela kwendawo ngaphambi kwento yokuqala engenalutho eyomakwa.
Uma ufuna ukukhetha hhayi ikholomu yetafula kuphela, kepha ikholomu lonke leshidi, khona-ke kuleli cala udinga nje uchofoze kwesobunxele emkhakheni ohambisanayo wephaneli yokuqondisa evundlile, lapho izinhlamvu zamagama zikhomba amagama ezinsika.
Uma kudingekile ukukhetha amakholomu ambalwa eshidi, bese uhudula igundane ngenkinobho yesinxele icindezelwe kanye nemikhakha ehambisanayo yephaneli ehambisanayo.
Kukhona esinye isixazululo. Inkinobho yokubamba I-Shift bese umaka ikholomu yokuqala ngokulandelana okuqokonyisiwe. Ngemuva kwalokho, ngaphandle kokukhipha inkinobho, chofoza emkhakheni wokugcina wephaneli yokuhlanganisa ngokulandelana kwamakholamu.
Uma ufuna ukukhetha amakholomu asakazekile eshidi, bese ubamba inkinobho Ctrl futhi, ngaphandle kokuyikhulula, sichofoza kumkhakha kuphaneli yokuqondisa evundlile yekholomu ngayinye ukuthi imakwe.
Indlela 3: qokomisa umugqa
Ngokufanayo, imigqa ese-Excel yabiwa.
Ukukhetha umugqa owodwa etafuleni, umane udwebe isikhombisi phezu kwawo nenkinobho yegundane elibanjwe phansi.
Uma itafula likhulu, kulula ukubamba inkinobho I-Shift bese ngokuchofoza ngokulandelana kuseli lokuqala nelokugcina lomugqa.
Futhi, imigqa ematafuleni ingaphawulwa ngendlela efanayo namakholomu. Chofoza kwinto yokuqala kwikholamu, bese uthayipha isinqamuleli sekhibhodi I-Ctrl + Shift + Arow Right. Umugqa uqokonyiswa ekugcineni kwetafula. Kepha futhi, okudingeka kuleli cala ukutholakala kwemininingwane kuwo wonke amaseli womugqa.
Ukukhetha wonke umugqa weshidi, chofoza emkhakheni ohambelana wephaneli yokuqondisa mpo, lapho kuboniswa khona izinombolo.
Uma kunesidingo sokukhetha imigqa eminingana elandelana ngale ndlela, bese uhudula inkinobho yesobunxele eqenjini elihambisanayo lemikhakha yephaneli ehlanganayo negundane.
Ungabamba futhi inkinobho I-Shift bese uqhafaza emkhakheni wokuqala nowokugcina kuphaneli yokuhlanganisa yobubanzi bemigqa okufanele kukhethwe.
Uma udinga ukukhetha imigqa ehlukile, bese uchofoza emkhakheni ngamunye kuphaneli yokuqondisa mpo ngenkinobho ecindezelwe Ctrl.
Indlela 4: khetha lonke ishidi
Kunezinketho ezimbili zale nqubo kulo lonke ishidi. Owokuqala ngokuchofoza inkinobho enxande etholakala ekuxhumaneni kwama-vertical kanye nama-usawa aqondile. Ngemuva kwalesi senzo, kuzokhethwa wonke amaseli eshidini.
Ukucindezela inhlanganisela yokhiye kuzoholela kumphumela ofanayo. I-Ctrl + A. Kodwa-ke, uma ngalesi sikhathi ikhesa ikuluhlu lwedatha engenakuqhathaniswa, isibonelo, etafuleni, lapho kuphela le ndawo izokhethwa ekuqaleni. Kungemva kokucindezela inhlanganisela futhi lapho kuzokwazi ukukhetha lonke ishidi.
Indlela yesi-5: Ukuqhakambisa Ububanzi
Manje ake sibheke ukuthi ungazikhetha kanjani amabanga ngamanye wamaseli ephepheni. Ukuze wenze lokhu, kwanele ukugoqa isikhombisi ngokuchofoza kwesobunxele endaweni ethile ephepheni.
Ububanzi bungakhethwa ngokubamba inkinobho I-Shift kukhibhodi bese ngokuchofoza ngokulandelana kumaseli aphezulu angakwesokunxele naphansi aphansi wendawo ekhethiwe. Noma ngokwenza umsebenzi ngokuhleleka okulandelayo: chofoza kuseli elingezansi kwesobunxele nelingenhla kwesokudla lehlu. Ibanga eliphakathi kwalezi zinto lizoqokonyiswa.
Kukhona futhi amathuba okugqamisa amaseli ahlukile noma amabanga. Ukuze wenze lokhu, nganoma yiziphi zalezi zindlela ezingenhla, udinga ukukhetha ngokwahlukana endaweni ngayinye umsebenzisi afuna ukuyikhetha, kodwa inkinombo kufanele ihlanganiswe Ctrl.
Indlela 6: faka ama-hotkeys
Ungakhetha izindawo ngazinye usebenzisa okhiye abashisayo:
- ICtrl + Ikhaya - Ukukhetha kweseli lokuqala elinedatha;
- I-Ctrl + Ekupheleni - Ukukhetha kweseli lokugcina elinedatha;
- I-Ctrl + Shift + End - Ukukhetha amaseli phansi kokugcina okusetshenzisiwe;
- I-Ctrl + Shift + Ikhaya - Ukukhetha amaseli kuze kufike ekuqaleni kweshidi.
Lezi zinketho zingonga kakhulu isikhathi ekusebenzeni.
Isifundo: Izitolo ezishisayo
Njengoba ukwazi ukubona, kukhona inani elikhulu lokukhetha amaseli namaqembu abo ahlukahlukene usebenzisa ikhibhodi noma igundane, nokusebenzisa inhlanganisela yalawa madivayisi amabili. Umsebenzisi ngamunye angakhetha isitayela sokukhetha esivumelana naye ngokwengeziwe esimweni esithile, ngoba kulula kakhulu ukukhetha iseli elilodwa noma amaningana ngendlela eyodwa, nokukhetha umugqa wonke noma lonke ishidi kwelinye.
