Lapho usebenza namatafula e-Excel, kaningi awudingi ukufaka amaseli kuphela, kodwa futhi uwasuse. Inqubo yokususa imvamisa inembile, kepha kunezindlela eziningi ongazisebenzisa kulo msebenzi, okungebona bonke abasebenzisi abezwe ngakho. Masifunde kabanzi ngazo zonke izindlela zokususa amangqamuzana athile kuspredishithi se-Excel.
Funda futhi: Ungasusa kanjani umugqa ku-Excel
Inqubo yokususa amaseli
Empeleni, inqubo yokususa amaseli ku-Excel iwukubuyela emuva kokusebenza kokuwengeza. Ingahlukaniswa ngamaqembu amakhulu amakhulu: ukususa amaseli agcwele futhi angenalutho. Ukubuka kokugcina, ngaphezu kwalokho, kungenziwa ngokuzenzakalela.
Kubalulekile ukwazi ukuthi uma ususa amaseli noma amaqembu awo, kunokuba imigqa eqinile namakholomu, imininingwane idluliselwa etafuleni. Ngakho-ke, ukuqaliswa kwale nqubo kumele ukwazi.
Indlela yoku-1: imenyu yokuqukethwe
Okokuqala, ake sibheke ukwenziwa kwale nqubo ngemenyu yokuqukethwe. Lokhu kungenye yezinhlobo ezaziwa kakhulu zokwenza lo msebenzi. Ingasetshenziswa ezintweni ezigcwalisiwe kanye nezingenalutho.
- Khetha into eyodwa noma iqembu esifuna ukusisusa. Chofoza ekukhetheni ngenkinobho yegundane elifanele. Imenyu yokuqukethwe yethulwe. Kuyo sikhetha isikhundla "Susa ...".
- Kuvulwa iwindi elincane lokususa amaseli. Kuyo udinga ukukhetha ukuthi yini ngempela esifuna ukuyisusa. Izinketho ezilandelayo ziyatholakala:
- Amaseli Shift Kwesobunxele;
- Amaseli ngokushintsha phezulu;
- Ulayini;
- Ikholomu.
Njengoba sidinga ukususa amaseli, hhayi yonke imigqa noma amakholomu, asizinaki izinketho ezimbili zokugcina. Khetha isenzo esikufanele ezinketho ezimbili zokuqala, bese usetha ukushintshela esimweni esifanele. Bese uchofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, ngemuva kwalesi senzo zonke izinto ezikhethiwe zizosuswa, uma into yokuqala kusuka kuhlu okwaxoxwa ngalo ngenhla ikhethiwe, bese kuba noshintsho phezulu.
Futhi, uma into yesibili ikhethiwe, kufanele kube nokushintsha kwesobunxele.
Indlela yesi-2: amathuluzi wetheyiphu
Ungasusa namaseli ku-Excel usebenzisa amathuluzi avezwe kubambo.
- Khetha into ezosuswa. Hambisa kuthebhu "Ikhaya" bese uchofoza inkinobho Susaetholakala kubambo kubhokisi lamathuluzi "Amaseli".
- Ngemuva kwalokho, into ekhethiwe izosuswa ngokushintsha phezulu. Ngakho-ke, lokhu kuhluka kwale ndlela akunikeli umsebenzisi ukukhetha kokuya kwe-shear.
Uma ufuna ukususa iqembu elivundlile lamaseli ngale ndlela, khona-ke imithetho elandelayo izosebenza.
- Sikhipha leli qembu lezinto eziqondile. Chofoza inkinobho Susaibekwe kuthebhu "Ikhaya".
- Njengakuhlobo lwangaphambilini, izinto ezikhethiwe ziyasuswa ngokushintsha phezulu.
Uma sizama ukususa iqembu eliqonde mpo lezinto, khona-ke ukuguquka kuzokwenzeka kolunye uhlangothi.
- Khetha iqembu lezinto ezime mpo. Chofoza inkinobho. Susa ekhasethini.
- Njengoba ukwazi ukubona, ekugcineni kwale nqubo, izinto ezikhethiwe zasuswa ngokushintshela kwesokunxele.
Futhi manje ake sizame ukususa uhlu olunamamilimidi amaningi usebenzisa le ndlela, equkethe izinto zombhalo oqondile nongaphezulu.
- Khetha le array bese uchofoza inkinobho. Susa ekhasethini.
- Njengoba ukwazi ukubona, kuleli cala zonke izinto ezikhethiwe zazisuswa ngokushintsha kwesobunxele.
Kukholelwa ukuthi ukusetshenziswa kwamathuluzi kwetheyiphu akusebenzi kancane kunokukhishwa ngemenyu yokuqukethwe, njengoba le ndlela inganikeli umsebenzisi ukukhetha kokuya ngasetheni. Kepha lokhu akunjalo. Usebenzisa amathuluzi esetheyipini, ungasusa namaseli ngokukhetha indlela ye-shift ngokwakho. Ake sibheke ukuthi izobukeka kanjani esibonelweni sezinto ezifanayo etafuleni.
- Khetha uhlu lwezinhlaka eziningi okufanele zisuswe. Ngemuva kwalokho chofoza inkinobho uqobo Susa, kepha kukunxantathu, otholakala ngokushesha ngakwesokunene sawo. Uhlu lwezenzo ezikhona lusetshenzisiwe. Kufanele ukhethe inketho "Susa amaseli ...".
- Ukulandela lokhu, iwindi lokususa liqala, esivele sazi ukusuka kunketho yokuqala. Uma sidinga ukususa i-multidimensional array nge-shift ehlukile kunaleyo eyenzekayo lapho kuchofoza inkinobho Susa Etheyipini, kufanele uhambise switch uye esikhundleni "Amaseli ngokushintshela phezulu". Bese uchofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, ngemuva kwalokho ukuhlehliswa kususwe njengoba izilungiselelo zazisethwe ewindini lokususa, okuwukuthi, ngotshintsho phezulu.
Indlela 3: sebenzisa ama-hotkeys
Kepha indlela esheshayo yokuqedela inqubo efundwayo ngosizo lweqoqo lenhlanganisela ye-hotkey.
- Khetha ibanga eshidini esifuna ukulisusa. Ngemuva kwalokho, cindezela inhlanganisela yokhiye "Ctrl" + "-" kwikhibhodi.
- Iwindi lokususa izinto esezijwayele kithi liqala. Khetha indlela oyifunayo yokushintsha bese uchofoza inkinobho "Kulungile".
- Njengoba ubona, ngemuva kwalokho izinto ezikhethiwe zasuswa ngokuqondisa ukuhamba, okwakhonjiswa esigabeni esedlule.
Isifundo: I-Excel Hotkeys
Indlela 4: susa izinto ezihlukanisayo
Kunezimo lapho udinga ukususa amabanga athile angahambelani, okungukuthi, asezindaweni ezihlukene zethebula. Vele, zingasuswa nganoma yiziphi izindlela ezingenhla, zenze inqubo ngokuhlukile ngesici ngasinye. Kepha kungathatha isikhathi esiningi. Kungenzeka ususe izinto ezihlukanayo ekhasini ishidi ngokushesha okukhulu. Kepha kulokhu kufanele, okokuqala, bahlulwe.
- Into yokuqala ikhethiwe ngendlela ejwayelekile, ibambe inkinobho yegundane kwesobunxele futhi uyijikeleze ngesikhombisi. Ngemuva kwalokho kufanele ubambe inkinobho phansi Ctrl bese uqhafaza kumaseli ahlukile ahlukanisayo noma ubiyele amabanga ngesikhombisi ngenkathi uphethe inkinobho yegundane kwesobunxele.
- Ngemuva kokuthi ukukhethwa kuqediwe, ungakususa usebenzisa noma yiziphi izindlela ezintathu esizichaze ngenhla. Zonke izinto ezikhethiwe zizosuswa.
Indlela yesi-5: susa amaseli angenalutho
Uma udinga ukususa izinto ezingenalutho etafuleni, khona-ke le nqubo ingazenzakalelayo futhi ungakhethi ngayinye yayo ngokwehlukana. Kunezindlela eziningi zokuxazulula le nkinga, kepha indlela elula yokwenza lokhu ukusebenzisa ithuluzi lokukhetha iqembu.
- Khetha itafula noma olunye uhla eshidini lapho ufuna ukusula khona. Bese uchofoza ukhiye wokusebenza kukhibhodi F5.
- Iwindi lokugxuma liqala. Kuyo, chofoza inkinobho "Khetha ..."etholakala ekhoneni layo elingaphansi kwesobunxele.
- Ngemuva kwalokho, iwindi lokukhetha amaqembu amaseli liyavula. Kuyo, setha ukushintshela kuyo Amaseli angenaluthobese uchofoza inkinobho "Kulungile" ekhoneni elingezansi kwesokudla sale iwindi.
- Njengoba ukwazi ukubona, ngemuva kwesenzo sokugcina, zonke izinto ezingenalutho ebangeni elishiwoyo zikhethiwe.
- Manje sesingasusa lezi zinto kuphela nganoma yikuphi ukukhetha okukhonjisiwe ezindleleni ezintathu zokuqala zalesi sifundo.
Kukhona ezinye izindlela zokukhipha izinto ezingenalutho, ezixoxwa ngemininingwane ethe xaxa endabeni ehlukile.
Isifundo: Ungasusa kanjani amaseli angenalutho ku-Excel
Njengoba ukwazi ukubona, kunezindlela eziningi zokususa amaseli ku-Excel. Indlela yokusebenza iningi labo iyafana, ngakho-ke, lapho ukhetha inketho ethile, umsebenzisi ugxila kokuthandayo. Kodwa kusamele ukuqaphela ukuthi indlela esheshayo yokwenza le nqubo ngosizo lwenhlanganisela yezinkinobho ezishisayo. Ukwahlukanisa ukususwa kwezinto ezingenalutho. Lo msebenzi ungazenzekela usebenzisa ithuluzi lokukhetha iseli, kepha-ke ukuze ususwe ngokuqondile kusamele usebenzise okukodwa kokujwayelekile.
