Ukuguqula imatriki kwi-Excel

Xa usebenza namatriki, ngamanye amaxesha kufuneka uzitshintshe, oko kukuthi, ukuthetha ngamazwi alula, jika. Ewe kunjalo, unokuguqula idatha ngesandla, kodwa i-Excel ibonelela ngeendlela ezininzi zokwenza lula kwaye ngokukhawuleza. Masihlaluke ngokweenkcukacha.

Inkqubo yokuvula

Ukudluliselwa kweMatrix yinkqubo yokutshintsha iikholamu kunye nemigca kwiindawo. Inkqubo ye-Excel ineempawu ezimbini ezinokubakho: usebenzisa umsebenzi we-TRAC kwaye usebenzisa isixhobo esikhethekileyo sokufaka. Qwalasela nganye yezi ndlela zikhethiweyo ngakumbi.

Indlela yoku-1: I-Transprerator

Umsebenzi we-Trac ubhekisa kudidi lwe "Amakhonkco kwaye udwelise" abaqhubi. Inkalo kukuba unayo, njengakweminye imisebenzi esebenza ngokusebenza, isiphumo sokukhupha ayisiyo yomxholo weseli, kodwa luluhlu lwedatha yonke. I-syntax yomsebenzi ilula kwaye ijongeka ngathi:

= Tracp (uluhlu)

Oko kukuthi, ekuphela kwengxoxo yalo msebenzi kubhekiswa kuluhlu, kwimeko yethu iMatrix ekufuneka iguqulwe.

Makhe sibone ukuba umsebenzi lo ungenziwa njani ngomzekelo one-matrix yokwenyani.

1. Sibonisa isisele esingenanto ephepheni, siceba ukwenza isisele esiphezulu seMatrix eguqulweyo. Okulandelayo, cofa kwi "Faka umsebenzi" i-icon, ethathwa kufutshane nefomula.



2. Ukuqhuba i-wizard yemisebenzi. Vula kuyo udidi "Amakhonkco kwaye udwelise" okanye "uluhlu olupheleleyo lwe-alfabhethi". Emva kwegama "iphecana" lafunyanwa, lavelisa iqhosha laso kwaye licinezela iqhosha "Kulungile".



3. I-Trace Umsebenzi we-windows windows uqala. Ekuphela kwengxoxo yomsebenzi ihambelana nentsimi ye "Array". Kuyimfuneko ukwenza ukulungelelaniswa kweMatrix, ekufuneka iguqulwe. Ukwenza oku, setha isikhombisi ebaleni kwaye, ngokubamba iqhosha lemouse lasekhohlo, sibalaselisa lonke uluhlu lweMatrix ephekiweni. Emva kokuba idilesi yendawo iboniswe kwiwindows yempikiswano, cofa kwiqhosha "Kulungile".



4. Kodwa, njengoko sibona, kwiseli, enzelwe ukubonisa iziphumo, ixabiso elingalunganga liboniswe njengempazamo "# #. Oku kungenxa yeempawu zomsebenzi woluhlu. Ukulungisa le mpazamo, khetha uluhlu lweeseli apho inani lemigca kufuneka lilingane nenani leekholamu zeMatrix yokuqala, kunye nenani lemigca. Umdlalo onjalo ubaluleke kakhulu kwisiphumo sokuboniswa ngokuchanekileyo. Kwangelo xesha, iseli enamagama "# ithetha!" Imele ukuba sisisele esisekunene se-norray sabelwe kwaye sivela kuwo ukuba kufuneka uqale inkqubo yokukhetha ngokuvalela iqhosha lemouse lasekhohlo. Emva kokuba ukhethe, setha isikhombisi kwi-formoular umtya kwangoko emva kokuba intetho yomsebenzi woTransp, ekufuneka iboniswe kuyo. Emva koko, ukubalwa, kufuneka ucofe iqhosha le-ENTER, njengoko lusiko kwifomula eqhelekileyo, kunye nokucofa i-CTRL + Shift + Ngenisa indibaniselwano.



5. Emva kwezi zenzo, iMatrix yaboniswa njengoko sifuna, oko kukuthi, kwifom edlulisiweyo. Kodwa ikho enye ingxaki. Inyani yile yokuba ngoku i-matrix entsha yifommu ehambelana nayo engafumanekiyo. Xa uzama ukwenza naluphi na utshintsho kunye neziqulatho zeMatrix ziya kupapasha impazamo. Abanye abasebenzisi imeko yemicimbi yanelisa ngakumbi, njengoko bengazukwenza utshintsho kuluhlu, kodwa abanye bafuna iMatrix apho unokusebenza ngokupheleleyo.

   Ukusombulula le ngxaki, sibala lonke uluhlu oludwelisiweyo. Ngokuya kwi-TAB "yekhaya", cofa kwi-Icon "Khuphela" i-icon, ekhoyo kwiRibbon kwiqela leklipboard. Endaweni yesenzo esichaziweyo, unako, emva kokhetho, yenza iseti yendlela emfutshane yekhibhodi ukukopa ukukopa i-CTRL + C.



6. Emva koko, ngaphandle kokususa ukhetho kudidi olupheleleyo, yenza ukuba icofe kuyo ngeqhosha lasekunene lemouse. Kwimenyu yenguqu kwiqela leparamitha, cofa kwi icon "yexabiso", enombono wePictomGram ngomfanekiso wamanani.

   

   Ukulandela le nto, ifomula ye-masf iya kususwa, kwaye kwiiseli kuphela amaxabiso anokuhlala apho unokusebenza khona ngendlela efanayo neMatrix yoqobo.

Isifundo: Inkosi yeMisebenzi kwi-Excele

Indlela 2: Ukudlulisa iMatrix usebenzisa ukufakelwa okhethekileyo

Ukongeza, iMatrix inokuthathwa kusetyenziswa imenyu enye yemenyu ebizwa ngokuba yi "Khowffient".

1. Khetha i-Matrix yomthombo kunye nesikhombisi ngokubamba iqhosha lemouse lasekhohlo. Okulandelayo, ngokunqakraza kwithebhu "yasekhaya", cofa kwi-icon "cop", ekwiphepha le-Buffer "ibhloko" ye-Buffer ".

   

   Endaweni yoko, unokwenza ngokwahlukileyo. Ukukhetha indawo ngokucofa kuyo kwiqhosha le mouse. Imenyu yemeko ivuliwe, apho kufuneka ukhethe "Khuphela".

   

   Ngohlobo lwendlela enye kwiikopi ezimbini zangaphambili, unako, emva kokukhetha, yenza iseti yendibaniselwano ye-ctrl + c.

2. Sikhetha iseli engenanto ephepheni, ekufuneka sibe yindawo ephezulu yekhohlo yematrix eyodwa. Sicofa kuyo ngoku ngasekunene. Ukulandela oku, Imenyu yemeko iyasebenza. Ihamba kwinto "yokufakwa okhethekileyo". Enye imenyu encinci iyavela. Ikwanomhlathi obizwa ngokuba "kwibhokisi ekhethekileyo ...". Cofa kuyo. Unokukhetha ukukhetha, endaweni yokubiza imenyu yemeko, ucofe i-CTRL + Alt + v Contration kwikhibhodi.



3. Ifestile ekhethekileyo ekhethekileyo isebenze. Zininzi iindlela zokukhetha, ngokuchanekileyo indlela yokufaka idatha ekhutshwe ngaphambili. Kwimeko yethu, kufuneka ushiye phantse kuzo zonke iisetingi ezingapheliyo. Kufanelekile ukuba ifakwe iparamitha kuphela. Emva koko kufuneka ucofe iqhosha u "Kulungile", elikwezantsi kwifestile.



4. Emva kwezi zenzo, i-matrix yodwa iya kuboniswa kwinxalenye emiselweyo yephepha. Ngokungafaniyo nendlela edlulileyo, sele sifumene iMatrix epheleleyo, enokutshintshwa, njengomthombo. Ayikho ukuphuculwa okanye ukutshintsha okufunekayo.



5. Kodwa ukuba unqwenela, ukuba iMatrix yokuqala awuyifuni, ungayicima. Ukwenza oku, khawuxabise ngesikhombisi sayo ngokubamba iqhosha lemouse lasekhohlo. Emva koko nqakraza kwinto leyo yokuchonga indawo ekunikezelweni. Kwimenyu yemeko, eya kuvulwa emva koku, khetha into ecacileyo ".

Emva kwezi zenzo, kuphela iMatrix eguqulweyo kuphela iya kuhlala ephepheni.

Ezi ndlela zimbini, ezixutyushwe apha ngasentla, ungayitshintsha nge-Excel kungekuphela nje imatriki, kodwa neetafile ezinamatyala apheleleyo. Inkqubo iya kuphantse.

Isifundo: Ungayifaka njani itafile ekuthinjweni

Ke, safumanisa ukuba kwiNkqubo ye-Excel, iMatrix inokudluliselwa, oko kukuthi, jika, tshintsha ikholam kunye nemigca yeendawo, ngeendlela ezimbini. Inketho yokuqala ibandakanya ukusetyenziswa komsebenzi wetracp, kunye nelesibini - izixhobo zokufakwa okhethekileyo. Kwaye enkulu, isiphumo sokugqibela, esifunyenweyo xa usebenzisa zombini ezi ndlela, akukho kwahlukile. Zombini iindlela zisebenza phantse kuyo nayiphi na imeko. Ke xa ukhetha ukhetho lwenguqu, ukhetho lobuqu lomsebenzisi oluthile luphakathi. Oko kukuthi, zeziphi kwezi ndlela zilungele wena ngokulula, kwaye uzisebenzise.