Canza matrix a cikin Microsoft Excel

Lokacin aiki tare da matrices, wani lokacin kuna buƙatar ɗaukar su, wato, a cikin kalmomi masu sauƙi, juya su. Tabbas, zaku iya kashe bayanan da hannu, amma Excel tana ba da hanyoyi da yawa don sauƙaƙewa da sauri. Bari mu bincika su daki-daki.

Canja wurin aiwatarwa

Canjin matrix shine aiwatar da swapping ginshikan da layuka. Excel yana da zaɓuɓɓuka biyu don canja wurin: ta amfani da aikin TAFIYA da amfani da kayan aiki na musamman. Yi la'akari da kowane ɗayan waɗannan zaɓuɓɓuka daki-daki.

Hanyar 1: Ma'aikacin TRANSPOSE

Aiki TAFIYA ɓangare na masu aiki Tunani da Arrays. The c is functions is is that is ar isc is Ginin kalma yana da sauƙi kuma yayi kama da wannan:

= SANARWA (tsararru)

Wannan shine, hujja kawai ga wannan ma'aikaci shine kwatankwacin tsararru, a cikin yanayinmu, matrix ɗin da za a canza.

Bari mu ga yadda za a iya amfani da wannan aikin ta amfani da misali tare da matrix na ainihi.

1. Mun zaɓi wani sel mara komai a kan takardar, wanda aka shirya shi daga matsanancin hagu na sama na matrix ɗin da aka canza. Bayan haka, danna kan gunkin "Saka aikin"wanda yake kusa da layin tsari.



2. Farawa Wizards na Aiki. Mun bude wani rukuni a ciki Tunani da Arrays ko "Cikakken jerin haruffa". Bayan nemo sunan TRANSP, zaɓi shi kuma danna maballin "Ok".



3. Farashin muhawara na aiki fara. TAFIYA. Hujjar wannan mai aiki ita ce filin Shirya. Wajibi ne a shiga cikin ayyukan daidaita matrix, waɗanda ya kamata a juya su. Don yin wannan, saita siginan kwamfuta a cikin filin kuma, riƙe maɓallin linzamin kwamfuta na hagu, zaɓi duk kewayon matrix akan takardar. Bayan da adireshin yankin ya bayyana a cikin muhawara taga, danna kan maɓallin "Ok".



4. Amma, kamar yadda kake gani, a cikin tantanin da aka tsara don nuna sakamakon, an nuna ƙimar da ba daidai ba a cikin hanyar kuskure. "#VALUE!". Wannan ya faru ne saboda daidaiton ayyukan kwastomomi. Don gyara wannan kuskuren, mun zaɓi kewayon sel waɗanda adadin layuka ya kamata daidai da adadin ginshiƙai na matrix na asali, da kuma adadin ginshiƙai zuwa lambar layuka. Irin wannan wasa yana da matukar mahimmanci ga sakamakon don a nuna shi daidai. A wannan yanayin, tantanin da ke dauke da magana "#VALUE!" yakamata ya kasance babbar hagu na hagu na zaren da aka zaɓa kuma daga ita ne tsarin zaɓi ya kamata a fara ta riƙe maɓallin linzamin kwamfuta na hagu. Bayan kun gama zabi, sanya siginar siginar a cikin masarar dabara nan da nan bayan bayyanar mai aiki TAFIYAwanda yakamata a bayyanashi a ciki. Bayan haka, don yin lissafin, kuna buƙatar danna ba maɓallin ba Shigarkamar yadda aka saba a cikin tsarin da aka saba, da kuma buga haɗin hade Ctrl + Shift + Shigar.



5. Bayan waɗannan ayyuka, an nuna matrix kamar yadda muke buƙata, wato, a cikin tsari. Amma akwai ƙarin matsala. Gaskiyar ita ce yanzu sabon matrix wani shiri ne wanda aka haɗa ta hanyar da ba za'a iya canza ta ba. Lokacin da kake ƙoƙarin yin kowane canji tare da abinda ke ciki na matrix, kuskure ya tashi. Wannan halin yana da gamsarwa ga wasu masu amfani, tunda ba zasu yi canje-canje a tsarin ba, amma wasu suna buƙatar matrix wanda za'a iya aiki dashi da kyau.

   Don magance wannan matsalar, zaɓi duk zangon da aka tura. Ta matsawa zuwa shafin "Gida" danna alamar Kwafadake kan tef a cikin rukunin Clipboard. Madadin aikin da aka ƙayyade, zaku iya zaɓar daidaitaccen maɓallin keyboard don kwafa bayan zaɓi Ctrl + C.



6. To, ba tare da cire zaɓi daga kewayon da aka watsa ba, danna kan shi tare da maɓallin linzamin kwamfuta na dama. A cikin mahallin menu a cikin rukuni Saka Zabi danna alamar "Dabi'u", wanda ke da nau'in hoton hoto tare da hoton lambobi.

   

   Biye da wannan shine tsararren tsari TAFIYA za a goge, kuma ƙimar guda ɗaya kawai zai rage a cikin sel, wanda zaku iya aiki tare kamar yadda tare da matrix na asali.

Darasi: Mayan Maɗaukaki

Hanyar 2: watsa matrix ta amfani da saiti na musamman

Bugu da kari, za a iya yada matrix ta amfani da kashi ɗaya daga cikin mahallin mahallin, wanda ake kira "Saka ta musamman".

1. Zaɓi matrix na asali tare da siginan kwamfuta, riƙe maɓallin linzamin kwamfuta na hagu. Na gaba, zuwa shafin "Gida"danna alamar Kwafalocated a cikin saitin toshewa Clipboard.

   

   Madadin haka, ana iya aiwatarwa daban. Bayan mun zaɓi yankin, mun danna shi tare da maɓallin linzamin kwamfuta na dama. Ana kunna menu na mahallin, wanda ya kamata ka zaɓi Kwafa.

   

   Azaman madadin zaɓi biyu na zaɓin da suka gabata, bayan nuna alama, zaku iya yin sait ɗin haɗarin hotkey Ctrl + C.

2. Muna zaɓar wani sel mara komai a kan takardar, wanda zai zama matsanancin hagu na hagu na matrix da aka canza. Danna shi tare da maɓallin linzamin kwamfuta na dama. Bayan wannan, ana kunna menu na mahallin. A ciki, muna motsa abu "Saka ta musamman". Wani ƙaramin menu ya bayyana. Hakanan yana da wani abu da ake kira "Saka ta musamman ...". Danna shi. Hakanan zaka iya, yayin da kayi zaɓi, maimakon kiran menu na mahallin, buga a hade a kan keyboard Ctrl + Alt + V.



3. Ana kunna taga na musamman. Akwai zaɓuɓɓuka da yawa don zaɓar yadda zaka liƙa bayanan da aka kwafa a baya. A cikin yanayinmu, kuna buƙatar barin kusan duk saitunan tsoho. Kawai game da siga "Sanya shi" Duba akwatin. Sannan kuna buƙatar danna maballin "Ok", wanda yake a kasan wannan taga.



4. Bayan waɗannan ayyukan, an nuna matrix ɗin da aka ɓoye a cikin ɓangaren da aka riga aka zaɓa. Ba kamar hanyar da ta gabata ba, mun riga mun sami cikakken matrix wanda za'a iya canzawa, kamar asalin. Ba a buƙatar ƙarin tsaftacewa ko juyawa ba.



5. Amma idan kuna so, idan baku buƙatar matrix na asali ba, zaku iya share shi. Don yin wannan, zaɓi shi tare da siginan kwamfuta, riƙe maɓallin linzamin kwamfuta na hagu. Sannan danna kan abin da aka zaɓa tare da maɓallin dama. A cikin menu na mahallin da zai buɗe bayan wannan, zaɓi Share Abun ciki.

Bayan waɗannan ayyukan, kawai matrix ɗin da aka canza zai kasance akan takardar.

A cikin hanyoyi guda biyun, waɗanda aka tattauna a sama, yana yiwuwa a zartar a cikin Excel ba matrices kawai ba, har ma kammala alluna. Hanyar zai kusan zama iri ɗaya.

Darasi: Yadda za a jefa tebur a Excel

Don haka, mun gano cewa a cikin Excel ana iya juyar da matrix, wato, tsage ta hanyar sauya ginshiƙai da layuka ta hanyoyi biyu. Zabi na farko ya hada da amfani da aikin TAFIYAna biyun kuma kayan aikin shigar na musamman ne. Gabaɗaɗa, ƙarshen sakamakon da aka samu ta amfani da waɗannan hanyoyin biyu ba bambanci bane. Duk hanyoyin biyu suna aiki a kusan kowane yanayi. Don haka yayin zaɓin zaɓi na juyawa, zaɓin na musamman na wani mai amfani yazo gaba. Wato, wanne ne daga cikin waɗannan hanyoyin da kuka dace da kanku, yi amfani da wancan.