Lapho usebenza matrices, ngesinye isikhathi udinga ukuwashintsha, okungukuthi ngamagama alula, uwaguqule. Vele, ungayibulala imininingwane ngesandla, kepha i-Excel inikeza izindlela ezimbalwa zokwenza kube lula futhi kusheshe. Asihlaziye ngokuningiliziwe.
Inqubo yokuhambisa
Ukuguqulwa kweMatrix inqubo yokushintshanisa amakholomu kanye nezintambo. I-Excel inezinketho ezimbili zokufaka: ukusebenzisa umsebenzi UKUTHENGA kanye nokusebenzisa ithuluzi elikhethekile lokufaka. Cabanga ngalezi zinto ngazinye ngemininingwane eminingi.
Indlela yoku-1: Osebenza nge-TRANSPOSE
Umsebenzi UKUTHENGA kungokwesigaba sabasebenzi Izinkomba kanye nokufika. Isimo esiyingqayizivele ukuthi, njengeminye imisebenzi esebenza ngama-arrays, umphumela wokukhishwa akuyona okuqukethwe esitokisini, kepha uhlu lonke ledatha. I-syntax yomsebenzi isebenza ilula futhi ibukeka kanjena:
= TRANSPOSE (uhlu)
Okusho ukuthi, okuwukuphela kokuphikisana kwalokhu ku-opharetha kubhekiselwa kumalungu afanayo, kithi, matrix okufanele aguqulwe.
Ake sibheke ukuthi lo msebenzi ungasetshenziswa kanjani usebenzisa isibonelo nge-matrix yangempela.
- Sikhetha iseli elingenalutho eshidini, elihlelelwe ukwenziwa iseli elingaphezulu kakhulu kwesokunxele se-matrix eguquliwe. Okulandelayo, chofoza isithonjana "Faka umsebenzi"etholakala eduze nomugqa wamafomula.
- Ukuqala Umsebenzi Wizards. Sivula isigaba kuwo Izinkomba kanye nokufika noma "Uhlu oluphelele lwe-alfabhethi". Ngemuva kokuthola igama I-TRANSP, ikhethe bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana komsebenzi liyaqala. UKUTHENGA. Ukuphikisana kuphela kwalokhu kusebenzisa insimu Array. Kuyadingeka ukufaka izixhumanisi ze-matrix, okufanele ziguqulwe. Ukuze wenze lokhu, setha ikhesa endle futhi, ubambe inkinobho yegundane kwesobunxele, ukhethe lonke uhla lwe-matrix eshidi. Ngemuva kokuthi ikheli lesifunda seliboniswe ewindini lokuphikisana, chofoza inkinobho "Kulungile".
- Kepha, njengoba ubona, esitokisini esakhelwe ukubonisa umphumela, inani elingalungile liboniswa ngendlela yephutha "#VALUE!". Lokhu kungenxa yobuchopho bokusebenza kwabasebenza ngama-array. Ukulungisa leli phutha, sikhetha ibanga lamaseli lapho inani lemigqa kufanele lilingane nenani lamakholomu we-matrix yasekuqaleni, nenombolo yamakholomu kunombolo yemigqa. Umeshi onjalo ubaluleke kakhulu ukuze umphumela ukhonjiswe kahle. Kulokhu, iseli eliqukethe isisho "#VALUE!" kufanele kube yiseli ephezulu kwesokunxele yezinhlu ezikhethiwe futhi kususela kuyo ukuthi inqubo yokukhetha kufanele iqalwe ngokubamba phansi inkinobho yegundane kwesobunxele. Ngemuva kokukhetha, faka isikhombisi kubha yefomula ngokushesha ngemuva kwenkulumo opharetha UKUTHENGAokufanele iboniswe kuyo. Ngemuva kwalokho, ukwenza ukubala, kudingeka ungachofozi enkingeni Ngenanjengokujwayelekile kufomula ejwayelekile, bese ushayela inhlanganisela I-Ctrl + Shift + Faka.
- Ngemuva kwalezi zenzo, i-matrix iboniswe njengoba besikudinga, okungukuthi, ngefomu elidlulisiwe. Kepha kunenye inkinga. Iqiniso ngukuthi manje i-matrix entsha iyi-array exhunywe yifomula engenakushintshwa. Lapho uzama ukwenza noma yiluphi ushintsho ngokuqukethwe kwe-matrix, kuvela iphutha. Lesi simo sinelise ngempela kwabanye abasebenzisi, ngoba ngeke benze izinguquko emhlolweni, kepha abanye badinga i-matrix engasetshenziswa ngokugcwele nayo.
Ukuxazulula le nkinga, khetha lonke uhla oludlulisiwe. Ngokuhambisa kuthebhu "Ikhaya" chofoza isithonjana Kopishaetholakala ethepheni eqenjini Ibhodi yokunamathisela. Esikhundleni sesenzo esichaziwe, ungakhetha isinqamuleli sekhibhodi ejwayelekile sokukopisha ngemuva kokukhethwa I-Ctrl + C.
- Ngemuva kwalokho, ngaphandle kokususa ukukhetha kusuka ebangeni elihanjisiwe, chofoza kukho inkinobho yegundane elifanele. Kumenyu yokuqukethwe eqenjini Faka Izinketho chofoza isithonjana "Amanani", enesimo se-pictograph enomfanekiso wezinombolo.
Ukulandela le ndlela ifomula UKUTHENGA izosuswa, futhi inani elilodwa kuphela lizohlala kumaseli, ongasebenza ngalo ngendlela efanayo nange-matrix yangempela.
Isifundo: I-Excel Feature Wizard
Indlela 2: dlulisa matrix usebenzisa okokufaka okukhethekile
Ngaphezu kwalokho, i-matrix ingashintshwa kusetshenziswa into eyodwa yemenyu yokuqukethwe, ebizwa ngokuthi "Faka okhethekile".
- Khetha matrix yoqobo nesikhombisi, ubambe inkinobho yegundane kwesobunxele. Okulandelayo, ukuya kuthebhu "Ikhaya"chofoza isithonjana Kopishaetholakala kubhulokhi yezilungiselelo Ibhodi yokunamathisela.
Esikhundleni salokho, kungenziwa ngokuhlukile. Ngemuva kokukhetha indawo, siyachofoza kukho inkinobho yegundane elifanele. Imenyu yokuqukethwe icushiwe, lapho kufanele ukhethe khona Kopisha.
Njengokungafani nezinketho ezimbili zekhophi edlule, ngemuva kokugqamisa, ungenza iqoqo lezinhlanganisela ze-hotkey I-Ctrl + C.
- Sikhetha iseli elingenalutho eshidini, okufanele libe yinto ephezulu kakhulu kwesobunxele ye-matrix edlulisiwe. Chofoza kuso ngenkinobho yegundane elifanele. Ukulandela lokhu, imenyu yokuqukethwe icushiwe. Kuyo, sihamba sizungeza into "Faka okhethekile". Kuvela enye imenyu encane. Inayo nento ebizwa ngokuthi "Faka okhethekile ...". Qhafaza kuwo. Futhi, ngemuva kokwenza ukukhetha, esikhundleni sokubiza imenyu yokuqukethwe, thayipha inhlanganisela kukhibhodi I-Ctrl + Alt + V.
- Iwindi elikhethekile lokufaka liyasebenza. Kunezindlela eziningi zokukhetha indlela yokunamathisela idatha ekopishwe ngaphambili. Esimweni sethu, udinga ukushiya cishe zonke izilungiselelo ezizenzakalelayo. Mayelana nepharamitha kuphela "Transpose" Bheka ibhokisi. Ngemuva kwalokho kufanele uchofoze inkinobho "Kulungile", etholakala ngaphansi kwale windi.
- Ngemuva kwalezi zenzo, i-matrix edlulisiwe iboniswa engxenyeni ekhethwe ngaphambili yeshidi. Ngokungafani nendlela yangaphambilini, sesithole i-matrix egcwele ngokuphelele engashintshwa, njengomthombo. Akusekho ukucolisiswa noma ukuguqulwa okuqhubekayo.
- Kepha uma ufisa, uma ungayidingi i-matrix yasekuqaleni, ungayisusa. Ukuze wenze lokhu, yikhethe ngesikhombisi, ubambe inkinobho yegundane kwesobunxele. Bese uchofoza entweni ekhethiwe ngenkinobho efanele. Kumenyu yokuqukethwe evula ngemuva kwalokhu, khetha Sula okuqukethwe.
Ngemuva kwalezi zenzo, yi-matrix eguquliwe kuphela ezosala ephepheni.
Ngezindlela ezimbili ezifanayo, obekuxoxwa ngazo ngenhla, kuyenzeka ukuthi udlulise ku-Excel hhayi kuphela matrices, kodwa futhi namatafula aphelele. Inqubo izocishe ifane.
Isifundo: Ungaphendulela kanjani itafula ku-Excel
Ngakho-ke, sithole ukuthi ku-Excel amatrix angahanjiswa, okungukuthi, akhonjwe ngokuswayipha amakholomu nezintambo ngezindlela ezimbili. Inketho yokuqala ibandakanya ukusebenzisa umsebenzi UKUTHENGAkanti okwesibili amathuluzi wokufaka okhethekile. Ngokuvamile, umphumela wokugcina otholakala usebenzisa zombili lezi zindlela awufani. Zombili izindlela zisebenza cishe kunoma yisiphi isimo. Ngakho-ke lapho ukhetha inketho yokuguqula, lokho okuthandwa ngumsebenzisi othile kuyabonakala. Okusho ukuthi, iyiphi kulezi zindlela elungele wena uqobo, sebenzisa yona.
