Ukuze wenze izenzo ezehlukene kokuqukethwe kwamaseli e-Excel, kumele kuqala akhethwe. Kule njongo, lolu hlelo lunamathuluzi amaningana. Okokuqala, lokhu kuhlukahluka kungenxa yokuthi kunesidingo sokukhetha amaqembu ahlukene wamaseli (amabanga, imigqa, amakholomu), kanye nesidingo sokumaka izinto ezihambisana nesimo esithile. Ake sithole indlela yokwenza le nqubo ngezindlela ezehlukene.
Inqubo yokwabiwa
Inqubo yokukhetha, ungasebenzisa kokubili igundane nekhibhodi. Kukhona nezindlela lapho la madivayisi wokufaka ahlangene nomunye.
Indlela 1: Iseli Elilodwa
Ukuze ukhethe iseli elihlukile, vele uhambise isikhombisi kuso futhi uchofoze inkinobho yegundane lesokunxele. Lokhu kukhetha kungenziwa futhi ngokusebenzisa izinkinobho zokuhamba ngekhibhodi. "Phansi", "Up", "Kulungile", "Kwesobunxele".
Indlela 2: Khetha ikholomu
Ukuze ubhale ikholomu etafuleni, udinga ukubamba inkinobho yegundane lesokunxele bese uhamba ukusuka esitokisini esiphezulu sekholomu kuya phansi, lapho inkinobho kufanele ikhishwe khona.
Kukhona esinye isisombululo sale nkinga. Cisha inkinobho Shift kwikhibhodi bese uchofoza esitokisini esiphezulu sekholomu. Khona-ke, ngaphandle kokukhulula inkinobho, chofoza ngezansi. Ungenza izenzo ngokulandelana okulandelanayo.
Ngaphezu kwalokho, ukukhetha amakholomu kumatafula, ungasebenzisa i-algorithm elandelayo. Khetha iseli lokuqala lekholomu, ukukhulula igundane bese ucindezela inhlanganisela yokhiye Ctrl + Shift + Ephansi Umcibisholo. Lokhu kuzogqamisa yonke ikholomu kuze kube yinto yokugcina lapho idatha iqukethe khona. Isimo esibalulekile sokwenza le nqubo ukungabikho kwamaseli angenalutho kule kholomu yetafula. Esimweni esiphikisanayo, kuphela indawo ngaphambi kokuqala kokungenalutho okuzobekwa uphawu.
Uma udinga ukukhetha hhayi nje ikholomu yetafula, kodwa lonke ikholomu leshidi, khona-ke kulokhu udinga nje ukuchofoza inkinobho yegundane lesobunxele emkhakheni ohambelana wephaneli yokuxhumanisa enezingqimba, lapho izinhlamvu zezinhlamvu zesiLatini zibeka amagama amakholomu.
Uma udinga ukukhetha amakholomu amaningana wekhasi, bese ubamba igundane inkinobho yesobunxele egcinwe phansi emikhakheni ehambelanayo yephaneli yokuxhumanisa.
Kunesinye isixazululo. Cisha inkinobho Shift bese ubhala ikholomu yokuqala ekulandeleni okukhethiwe. Khona-ke, ngaphandle kokukhulula inkinobho, chofoza kumkhakha wokugcina wephaneli yokuxhumanisa ngokulandelana kwamakholomu.
Uma udinga ukukhetha amakholomu ahlukene weshidi, bese ubamba inkinobho Ctrl futhi, ngaphandle kokuyikhulula, chofoza kumkhakha kwiphaneli enezingqimba zezixhumanisi zekholomu ngayinye ofuna ukuyibhala.
Indlela 3: ukukhethwa komugqa
Imigqa e-Excel nayo ihlukaniswa nomgomo ofanayo.
Ukuze ukhethe umugqa owodwa etafuleni, vele uhudule isikhombisi phezu kwayo nenki yegundane egcinwe phansi.
Uma itafula likhulu, kulula ukubamba inkinobho. Shift futhi uchofoze ngokulandelana esitokisini sokuqala nesokugcina emgqeni.
Futhi, imigqa emathebula ingamakwa ngendlela efanayo namakholomu. Chofoza entweni yokuqala kukholomu, bese uthayipha inhlanganisela yokhiye Ctrl + Shift + Umcibisholo Ongakwesokudla. Umugqa ugcizelelwe ekupheleni kwetafula. Kodwa futhi, okudingekayo kulokhu kutholakala kwedatha kuwo wonke amaseli womugqa.
Ukuze ukhethe wonke umugqa weshidi, chofoza kumkhakha ohambelana wephaneli yokuxhumanisa oqondile, lapho ukubala kubonakala khona.
Uma udinga ukukhetha imigqa eminingana ehambisana nalendlela, bese uhudula igundane ngenkinobho yesokunxele ebanjwe phezu kweqembu elihambelana nemikhakha yephaneli yokuxhumanisa.
Ungabamba futhi inkinobho Shift bese uchofoza kumkhakha wokuqala nowokugcina kule iphaneli yokuxhumanisa yobubanzi bomugqa okufanele ukhethwe.
Uma udinga ukukhetha imigqa ehlukene, bese uchofoza kuminye imikhakha iphaneli yokuxhumanisa eqondile nebhokisi eligcinwe phansi Ctrl.
Indlela 4: ukukhethwa kwephepha lonke
Kunezinhlobonhlobo ezimbili kule nqubo yeshidi lonke. Okokuqala kwalokhu ukuchofoza inkinobho ye-rectangular etholakala ngasemkhatsini wezixhumanisi eziqondile nezingazungezile. Ngemuva kwalokhu isenzo sizokhethwa ngokuphelele wonke amaseli eshidi.
Ukucindezela inhlanganisela yezihluthulelo kuzoholela emhubheni ofanayo. Ctrl + A. Kuyiqiniso, uma ngalesi sikhathi isikhombisi sisezintweni ezingezona zokuphulwa, isibonelo, etafuleni, okokuqala kuphela le ndawo izogqanyiswa. Kuphela ngemva kokucindezela kabusha inhlanganisela kuzokwazi ukukhetha lonke ishidi.
Indlela 5: Ukwabiwa Kwemali
Manje sithola ukuthi singakhetha kanjani amabanga ngamanye amaseli kushidi. Ukuze wenze lokhu, kwanele ukujikeleza isikhombisi ngenkinobho yegundane lesokunxele egcinwe endaweni ethile eshidi.
Ungakhetha ibanga ngokubamba inkinobho. Shift kwikhibhodi bese uchofoza ngokuzenzekelayo kuseli eliphezulu nangakwesokunxele kweselula kwendawo ekhethiwe. Noma ngokusebenza ngokulandelana okulandelayo: chofoza ezingxenyeni ezingezansi ezingakwesokunxele nakwesokudla kwesigaba. Ububanzi phakathi kwalezi zakhi kuzoqokonyiswa.
Kukhona futhi amathuba okuhlukanisa amaseli noma amabanga ahlakazekile. Ukuze wenze lokhu, kunoma iyiphi yezindlela ezingenhla, udinga ukukhetha ngokwehlukile indawo ngayinye umsebenzisi ofuna ukuyikhetha, kodwa inkinobho kufanele icindezelwe. Ctrl.
Indlela 6: sebenzisa ama-hotkeys
Ungakhetha izindawo ezithile usebenzisa ama-hotkeys:
- Ikhaya le-Ctrl - ukukhethwa kweseli yokuqala nedatha;
- Ctrl + Ukuphela - ukukhethwa kweseli lokugcina nedatha;
- Ctrl + Shift + Ekupheleni - ukukhethwa kwamaseli kuze kube sekugcineni okusetshenzisiwe;
- Ctrl + Shift + Ikhaya - ukukhethwa kwamaseli kuze kube sekuqaleni kweshidi.
Lezi zinketho zizosiza ukulondoloza isikhathi ekusebenzeni.
Isifundo: Amakhadi ashisayo ku-Excel
Njengoba ungabona, kunenombolo enkulu yokukhethwa kukho kokukhetha amaseli namaqembu abo ahlukahlukene usebenzisa ikhibhodi noma igundane, kanye nokusebenzisa inhlanganisela yalezi zidivayisi ezimbili. Umsebenzisi ngamunye angakhetha isitayela sokukhetha esilungele yena esimweni esithile, ngoba kulula ukukhetha eyodwa noma amaseli amaningi ngendlela eyodwa, bese ukhetha umugqa wonke noma ishidi lonke kwenye.
