Uma usebenza nama-spreadsheets e-Excel, kuvame ukudingeka hhayi kuphela ukufaka amaseli, kodwa futhi ukuwasusa. Inqubo yokukhipha ngokuvamile inembile, kodwa kunezinketho eziningi zokwenza lo msebenzi, okungezona bonke abasebenzisi abaye bakuzwa. Masifunde kabanzi mayelana nazo zonke izindlela zokususa amaseli athile avela kuspredishithi se-Excel.
Bheka futhi: Ungasusa kanjani umugqa ku-Excel
Inqubo Yokususwa Kwamaselula
Eqinisweni, inqubo yokususa amaseli ku-Excel iyaphazamisa ukusebenza kokungezela. Ingahlukaniswa ngamaqembu amakhulu amabili: ukususwa kwamaseli agcwele futhi angenalutho. Uhlobo lokugcina, ngaphandle kwalokho, lungenziwa ngokuzenzakalelayo.
Kubalulekile ukwazi ukuthi uma ususa amaseli noma amaqembu, futhi hhayi imigqa eqondile namakholomu, idatha etafuleni ishintshiwe. Ngakho-ke, ukusetshenziswa kwalolu hlelo kufanele kube ngamabomu.
Indlela 1: imenyu yokuqukethwe
Okokuqala, ake sicabangele ukukhishwa kwalenqubo ngokusebenzisa imenyu yesimo. Lena enye yezinhlobo ezidume kakhulu zokwenza lo msebenzi. Kungasetshenziswa kokubili izinto ezigcwele nezingenalutho.
- Khetha into eyodwa noma iqembu esifuna ukususa. Yenza ngokuchofoza ekukhetheni inkinobho yegundane efanele. Imenyu yenkomfa iqaliswa. Kuyo sikhetha isikhundla "Susa ...".
- Isebenzisa iwindi elincane lokususa iseli. Kuyo kudingeka ukhethe ukuthi sifuna ukususa. Zikhona izinketho ezilandelayo:
- Amaseli, ukushiya kwesokunxele;
- Ama-Shift Up Amaseli;
- Umzila;
- Ikholomu.
Njengoba nje sidinga ukususa amaseli, hhayi yonke imigqa noma amakholomu, asilaleli izinketho ezimbili zokugcina. Khetha isenzo esifanelana nawe kusukela kokubili okukhethwa kukho, bese usetha ukushintshela endaweni efanele. Bese uchofoza inkinobho. "Kulungile".
- Njengoba ubona, ngemuva kwalesi senzo, zonke izinto ezikhethiwe zizosuswa; uma into yokuqala ohlwini olubalulwe ngenhla ikhethiwe, bese ushintsha phezulu.
Futhi, uma into yesibili ikhethiwe, ke ngokushintshela ngakwesokunxele.
Indlela 2: amathuluzi amateyipu
Ukususwa kwamaseli ku-Excel kungenziwa futhi ngokusebenzisa amathuluzi akhululwe kuthebhu.
- Khetha into okufanele isuswe. Hambisa kuthebhu "Ikhaya" bese uchofoza inkinobho "Susa"okuyinto itholakala ku-tape ebhodini lamathuluzi "Amaseli".
- Emva kwalokho, into ekhethiwe izosuswa nge-shift up. Ngakho-ke, le nguqulo yale ndlela ayivumeli umsebenzisi ukuthi akhethe isiqondiso sokushintsha.
Uma ufuna ukususa iqembu elizungezile lamaseli ngale ndlela, khona-ke imithetho elandelayo izosebenza.
- Khetha leli qembu lezici ze-orientation enezingqimba. Chofoza inkinobho "Susa"kufakwe kuthebhu "Ikhaya".
- Njengenguqulo yangaphambilini, izakhi ezikhethiwe zisusiwe ngokushintsha okuphezulu.
Uma sizama ukususa iqembu eliqondile lamazakhi, khona-ke ukushintshwa kuzokwenzeka kwesinye isiqondiso.
- Khetha iqembu lezici zokuma okuqondile. Chofoza inkinobho. "Susa" kwi-tape.
- Njengoba ubona, ekupheleni kwalenqubo, izakhi ezikhethiwe zisusiwe ngokushintshela kwesobunxele.
Futhi manje sizozama ukwenza ukususwa ngale ndlela ye-multidimensional array equkethe izinto zombili eziqondisayo eziqondile neziqondile.
- Khetha lolu hlu bese uchofoza inkinobho. "Susa" kwi-tape.
- Njengoba ubona, kulokhu, zonke izinto ezikhethiwe zisusiwe ngokushintshela ngakwesobunxele.
Kukholelwa ukuthi ukusetshenziswa kwamathuluzi ku-Ribbon kungasebenzi kakhulu kunokuba ususe kwimenyu yokuqukethwe, ngoba le ndlela ayihlinzeki umsebenzisi ngokuzikhethela kokuqondiswa kweshintsho. Kodwa akunjalo. Ukusebenzisa amathuluzi ku-Ribbon, ungaphinda ususe amaseli ngokukhetha isiqondiso sokushintsha kwakho. Ake sibone ukuthi kuzobukeka kanjani esibonelweni esifanayo etafuleni.
- Khetha i-multidimensional array, okufanele isuswe. Emva kwalokho, chofoza inkinobho ngokwayo. "Susa", nasesigxathu, esitholakala ngokushesha ngakwesokunene sayo. Ivuselela uhlu lwezenzo ezitholakalayo. Kufanele ukhethe okukhethwa kukho "Susa amaseli ...".
- Lokhu kulandelwa ukuqaliswa kwewindi lokususa, esivele sijwayele kithi ekubuyiseleni kokuqala. Uma sidinga ukususa i-multidimensional array ne-shift ehlukile kulokho okwenzekayo uma ucindezela inkinobho "Susa" kwi-tape, kufanele uhambise umshini wokuma "Amaseli, ane-shift up". Bese uchofoza inkinobho. "Kulungile".
- Njengoba ungabona, emva kwalokhu, uhlu luyisusiwe njengoba izilungiselelo zicacisiwe efasiteleni lokususa, okungukuthi, ngokushintshwa.
Indlela yesithathu: sebenzisa ama-hotkeys
Kodwa indlela esheshayo yokwenza inqubo ngaphansi kokucwaninga ingasebenzisa iqoqo lezinhlanganisela zamakhi ashisayo.
- Khetha ububanzi esifuna ukususa kushidi. Emva kwalokho, cindezela inhlanganisela yokhiye "Ctrl" + "-" kwikhibhodi.
- Iwindi elingaziwa kakade lokususa izinto liqalisiwe. Khetha isinqamuleli sokushintsha kwesifiso bese uchofoza inkinobho. "Kulungile".
- Njengoba ubona, emva kwalokhu, izakhi ezikhethiwe zisusiwe ngokuqondiswa kokushintsha, okukhonjisiwe esigabeni esandulele.
Isifundo: Amakhidi Eshisayo ku-Excel
Indlela 4: Susa Izinto Ezikhethiwe
Kukhona amacala uma udinga ukususa amabanga ambalwa angasondelene, okungukuthi, asezindaweni ezihlukene zetafula. Yiqiniso, zingasuswa nganoma iyiphi yezindlela ezichazwe ngenhla, ukwenza inqubo ngokuhlukile ngento ngayinye. Kodwa kungathatha isikhathi esiningi kakhulu. Kungenzeka ukususa izakhi ezingafani ukusuka kushidi ngokushesha kakhulu. Kodwa ngenxa yalokhu kufanele, ngokugqamile konke, kugcizelelwe.
- Sakhetha isici sokuqala ngendlela evamile, ubambe phansi inkinobho yegundane lesokunxele bese upheqa nxazonke ngesikhombisi. Khona-ke kufanele ubambe inkinobho Ctrl bese uchofoza kumaseli asele ahlakazekile noma ujikeleze amabanga ngesikhala esicindezelwe inkinobho yegundane lesokunxele.
- Emva kokukhethwa kwenzelwe, ungayisusa usebenzisa enye yezindlela ezintathu esichazwe ngenhla. Zonke izinto ezikhethiwe zizosuswa.
Indlela 5: Susa Amaseli angenalutho
Uma udinga ukususa izinto ezingenalutho etafuleni, le nqubo ingahle ibe yenzeke futhi ingahlukanisi ngamunye wabo ngokwehlukana. Kunezinketho eziningana zokuxazulula le nkinga, kodwa indlela elula yokwenza lokhu yikho ithuluzi lokukhetha iqembu leseli.
- Khetha ithebula noma yiluphi olunye uhla eshadini lapho ufuna ukususa khona. Bese uchofoza ukhiye womsebenzi kwikhibhodi. F5.
- Iwindi lokushintsha liqala. Kufanele uchofoze inkinobho "Qinisekisa ..."efakwe ekhoneni layo elingakwesokunxele.
- Emva kwalokho iwindi lokukhethwa kweqembu leselula livuleka. Kufanele usethe ukushintsha ukuma "Amaseli angenalutho"bese uchofoza inkinobho "Kulungile" ekhoneni elingezansi elingezansi laleli festile.
- Njengoba ubona, ngemuva kwesenzo sokugcina, zonke izakhi ezingenalutho ebangeni elicacisiwe zikhethiwe.
- Manje singasusa kuphela lezi zakhi nganoma yiziphi izinketho ezibalwe ngezindlela ezintathu zokuqala zalesi sifundo.
Kunezinye izinketho zokususa izinto ezingenalutho, ezixoxwa ngokuningiliziwe ngendaba ehlukile.
Isifundo: Ungasusa kanjani amaseli angenalutho ku-Excel
Njengoba ubona, kunezindlela eziningana zokususa amaseli ku-Excel. Izindlela eziningi zazo zifana, ngakho uma ukhetha inkambo ethile yesenzo, umsebenzisi uqondiswa izintandokazi zakhe. Kodwa kusadingeka uqaphele ukuthi indlela esheshayo yokwenza le nqubo isebenzisa inhlanganisela yamakhi ashisayo. Kutholakale ukususwa kwezakhi ezingenalutho. Ungakwazi ukuzenzelela lo msebenzi usebenzisa ithuluzi lokukhetha cell, kodwa uzobe usadingeka ukusebenzisa enye yezindlela ezijwayelekile zokususwa ngokuqondile.
