Maƙunsar yada bayanai a Microsoft Excel

Akwai wasu lokuta da bayan mai amfani ya riga ya gama aiki mai mahimmanci na teburin ko ma ya kammala aikin akan sa, ya fahimci cewa zai ƙara fadada teburin a sarari 90 ko 180. Tabbas, idan an yi tebur don bukatunku, kuma ba akan tsari ba, to babu makawa zai sake sabunta shi, amma zai ci gaba da aiki akan sigar data kasance. Idan teburin teburin da mai aiki ko abokin ciniki suka juyar da ku, to a wannan yanayin zaku sami gumi. Amma a zahiri, akwai wasu dabaru masu sauƙi waɗanda zasu ba ka damar kusan sauƙaƙe kuma cikin sauri juyar da tebur a cikin hanyar da ake so, ba tare da la'akari da ko an yi teburin don kanka ba ko don oda. Bari mu ga yadda ake yin wannan a Excel.

U-Juyawa

Kamar yadda aka riga aka ambata, za'a iya juya teburin 90 ko digiri 180. A farkon lamari, wannan yana nufin cewa ginshiƙai da layuka za su canza, kuma a karo na biyu, za a tsage teburin daga sama zuwa ƙasa, wato, don haka layin farko ya zama na ƙarshe. Don aiwatar da waɗannan ayyukan, akwai dabaru da yawa na rikitar da rikice-rikice. Bari mu koyi algorithm don aikace-aikacen su.

Hanyar 1: 90 digiri juya

Da farko dai, gano yadda ake musanya layuka tare da ginshikai. Wannan hanya ana kiranta transposition. Hanya mafi sauƙi don aiwatar da ita ita ce ta amfani da saka ta musamman.

1. Yi alama akan tebur ɗin da kake son faɗaɗa. Mun danna kan ɓataccen yanki tare da maɓallin linzamin kwamfuta na dama. A lissafin da zai buɗe, tsayawa akan zaɓin Kwafa.

   

   Hakanan, maimakon aikin da ke sama, bayan ƙirar yankin, zaku iya danna kan gunkin, Kwafawanda yake a cikin shafin "Gida" a cikin rukuni Clipboard.

   

   Amma mafi kyawun zaɓi shine ƙirƙirar keystroke hade bayan ƙirar yanki Ctrl + C. A wannan yanayin, za a kuma yi kwafa.

2. Nuna kowane sel mara komai akan takarda tare da kewayon sarari kyauta. Wannan kashi ya zama babban hagu na hagu na kewayon da aka canza. Mun danna wannan abun tare da maɓallin linzamin kwamfuta na dama. A toshe "Saka ta musamman" na iya zama hoton hoto "Sanya shi". Zaba mata.

   

   Amma a nan ƙila ba ku same shi ba, tunda menu na farko yana nuna waɗancan zaɓin shigar da ake amfani da su galibi. A wannan yanayin, zaɓi zaɓi a menu. "Saka ta musamman ...". Additionalarin jerin yana buɗe. Latsa alamar da ke ciki. "Sanya shi"sanya a cikin toshe Saka bayanai.

   

   Akwai kuma wani zaɓi. Dangane da algorithm dinsa, bayan tsara ƙirar kuma kiran menu na mahallin, kuna buƙatar danna sau biyu akan abubuwan "Saka ta musamman".

   

   Bayan haka, taga shigar ta musamman tana buɗewa. Valueimar adawa "Sanya shi" saita akwati. Babu sauran bukatar yin amfani da wannan taga. Latsa maballin "Ok".

   

   Hakanan za'a iya yin waɗannan ayyukan ta hanyar maɓallin akan kintinkiri. Mun tsara kwayar kuma danna kan alwatika, wanda yake a ƙasa maballin Mannasanya a cikin shafin "Gida" a sashen Clipboard. Jerin yana buɗewa. Kamar yadda kake gani, hoton hoton shima yana a ciki. "Sanya shi", da sakin layi "Saka ta musamman ...". Idan ka zabi gunkin, fasalin zai faru nan take. Lokacin da za'aga "Saka ta musamman" taga na musamman zai fara aiki, wanda muka riga muka yi magana akai. Dukkanin sauran ayyuka a ciki daidai suke.



3. Bayan kammala kowane ɗayan waɗannan zaɓuɓɓuka masu yawa, sakamakon zai zama iri ɗaya: za a kafa yankin tebur, wanda shine sigar 90-digiri na farkon tsararru. Wato, idan aka kwatanta da ainihin tebur, layuka da ginshiƙai na yankin da aka canzawa za'a canza su.



4. Zamu iya barin bangarorin teburin akan takarda, ko kuma zamu iya share na farko idan ba'a buƙata ba. Don yin wannan, muna nuna duka kewayon da dole ne a goge sama da teburin da aka fassara. Bayan haka, a cikin shafin "Gida" danna kan alwatika, wanda yake gefen dama na maɓallin Share a sashen "Kwayoyin". A cikin jerin zaɓi, zaɓi zaɓi "A goge layuka daga takarda".



5. Bayan haka, za a share duk layuka, gami da manyan falle-falle, wanda aka sanya sama da yadda aka tsara.



6. Bayan haka, don ɗaukar kewayon ya ɗauki karamin tsari, mun tsara shi duka kuma, zuwa shafin "Gida"danna maballin "Tsarin" a sashen "Kwayoyin". A cikin jerin da ke buɗe, zaɓi zaɓi Nisa Tsarin Kayan Fit da Fit.



7. Bayan aikin ƙarshe, tebur ɗin ya ɗauka a kan m daidaitaccen bayyanar bayyanar. Yanzu zamu iya gani a fili cewa, a cikin ta, idan aka kwatanta da asali na asali, layuka da ginshiƙai suna juyawa.

Bugu da kari, zaku iya yada yankin tebur ta amfani da ma'aikacin Excel na musamman, wanda ake kira - TRANSP. Aiki TAFIYA An tsara musamman don sauya kewayar a tsaye zuwa ga kwance da sashi. Syntax din sa shine:

= SANARWA (tsararru)

Shirya shine kawai hujja ga wannan aikin. Yana da nasaba da kewayon da za a flipped.

1. Nuna yawan adadin sel marasa kan takarda. Yawan abubuwa a cikin ɓangaren ɓangaren yanki da aka tsara ya dace da adadin ƙwayoyin da ke cikin teburin tebur, da kuma adadin abubuwan da ke cikin layuka na komai na samarwa zuwa lambar sel a cikin ginshiƙan yankin tebur. Saika danna alamar. "Saka aikin".



2. Kunna cigaba Wizards na Aiki. Je zuwa sashin Tunani da Arrays. Muna yiwa sunan alama a can TRANSP kuma danna kan "Ok"



3. Takobin muhawara na bayanin da ke sama ya buɗe. Sanya siginan kwamfuta zuwa filin kawai - Shirya. Riƙe maɓallin linzamin kwamfuta na hagu ka sa alama a kan teburin da kake son faɗaɗa. A wannan yanayin, za a nuna kwastomomin ta a fagen. Bayan haka, kar a ruga don danna maɓallin "Ok"kamar yadda aka saba. Muna ma'amala da tsarin tsararru, don haka don aiwatar da umarnin daidai, danna maɓallin key Ctrl + Shift + Shigar.



4. Tebur mai jujjuyawar, kamar yadda muke gani, an saka shi cikin tsararren saitin.



5. Kamar yadda kake gani, raunin wannan zaɓi idan aka kwatanta da na baya shi ne cewa lokacin jujjuyawar ainihin abin ba shi da ceto. Bugu da kari, lokacin da kayi kokarin canza bayanai a cikin kowace tantanin halitta a cikin zangon da aka tsara, sako ya bayyana cewa baza ku iya sauya bangare ba. Bugu da kari, tsararren watsa da aka watsa yana da alaƙa da babban matakin farko kuma lokacin da kuka share ko canza tushen, hakanan za'a share shi ko canza shi.



6. Amma na karshe biyu drawbacks za a iya abar kulawa quite kawai. Lura da duka zangon da aka tsara. Danna alamar Kwafa, wanda aka lika a jikin tef a cikin rukunin Clipboard.



7. Bayan haka, ba tare da cire bayanin ba, danna kan ɓataccen yanki tare da maɓallin linzamin kwamfuta na dama. A cikin mahallin menu a cikin rukunin Saka Zabi danna alamar "Dabi'u". An gabatar da wannan hoton ta hanyar wani murabba'i wanda a ciki lambobin suke.



8. Bayan aiwatar da wannan matakin, za a canza dabara a cikin kewayon zuwa dabi'un al'ada. Yanzu bayanan da ke ciki zasu iya canzawa kamar yadda kuke so. Kari akan haka, wannan tsarin bashi da nasaba da tebur mai tushe. Yanzu, idan ana so, za a iya share ainihin tebur daidai kamar yadda muka bincika a sama, kuma za a iya tsara tsarin da ya dace ta yadda zai zama mai fa'ida ne kuma mai gabatarwa.

Darasi: Canza tebur a Excel

Hanyar 2: Juyin Juyaya 180

Yanzu lokaci ya yi da za mu tsara yadda za a juya teburin 180 digiri. Wato, dole ne mu tabbatar cewa layin farko ya sauka, kuma ƙarshen ya hau zuwa saman. A lokaci guda, ragowar layuka na tebur ma daidai yadda suke canza matsayin su na farko.

Hanya mafi sauƙi don cim ma wannan aikin ita ce amfani da ikon rarrabewa.

1. A hannun dama na teburin, a saman babban layin, saka lamba "1". Bayan wannan, saita siginan kwamfuta a cikin ƙananan kusurwar dama na wayar inda an saita takamammen lambar. A wannan yanayin, ana canza siginan kwamfuta zuwa alamar mai cikawa. A lokaci guda, riƙe maɓallin linzamin kwamfuta na hagu da maɓallin Ctrl. Mun shimfiɗa siginan kwamfuta a ƙasan tebur.



2. Kamar yadda kake gani, bayan wannan duka shafin yana cike da lambobi don tsari.



3. Yi alama shafi da lamba. Je zuwa shafin "Gida" kuma danna maballin Dadi da kuma Matatarwa, wanda aka sanya shi a kaset a cikin sashin "Gyara". Daga jerin da ke buɗe, zaɓi zaɓi Tsarin Kasuwanci.



4. Bayan haka, akwatin magana yana buɗewa inda aka bayar da rahoton cewa an samo bayanai a waje da iyakar da aka ƙayyade. Ta hanyar tsoho, an saita juyawa a wannan taga zuwa "Ka faɗaɗa zaɓin da aka zaɓa ta atomatik". Kuna buƙatar barin shi a daidai matsayin kuma danna maɓallin "Tacewa ...".



5. Ana fara taga taga al'ada. Tabbatar cewa kusa da abun "My bayanai yana dauke da taken" ba a kulle tambarin ba ko da shugabannin za su kasance a zahiri. In ba haka ba, ba za a saukar da su ba, amma za su kasance a saman tebur. A yankin A ware ta kuna buƙatar zaɓar sunan shafin da aka saita lamba a cikin tsari. A yankin "Tace" dole ne a bar sigogi "Dabi'u"wanda aka shigar ta tsohuwa. A yankin "Oda" yakamata saita "Cancanci". Bayan bin waɗannan umarnin, danna maballin "Ok".



6. Bayan haka, za a jera jerin teburin a cikin tsari mai kyau. A sakamakon wannan rarrabuwa, za a juya shi, wato layin ƙarshe zai zama jigo, kuma taken zai zama layin ƙarshe.

   

   Mahimmin sanarwa! Idan teburin yana kunshe da dabaru, to saboda irin wannan nau'in, za'a iya nuna sakamakon su daidai. Sabili da haka, a wannan yanayin, kuna buƙatar ko dai watsi da ɓarna, ko da farko canza sakamakon lissafin dabarun zuwa dabi'u.

7. Yanzu zamu iya cire ƙarin shafin tare da lambobi, tunda ba mu sake buƙata. Mun yi alama da shi, danna-dama akan guntun da aka zaɓa kuma zaɓi matsayi a cikin jerin Share Abun ciki.



8. Yanzu aiki akan faɗaɗa teburin 180 ana iya ɗauka an kammala.

Amma, kamar yadda zaku iya lura, tare da wannan hanyar fadada, tebur na asali ana canza shi kawai don faɗaɗa. Tushen kanta bashi da ceto. Amma akwai wasu lokuta da yakamata a karkatar da tsararru, amma a lokaci guda, kiyaye tushen. Ana iya yin wannan ta amfani da aikin OFFSET. Wannan zabin ya dace da tsararren shafi ɗaya.

1. Muna yiwa tantanin da ke gefen dama na kewayon da za a fidda shi a layin farko. Latsa maballin "Saka aikin".



2. Ya fara Mayan fasalin. Mun matsa zuwa sashin Tunani da Arrays kuma yi alama sunan "OFFSET", saika danna "Ok".



3. Daga nan sai taga gardamar ta fara. Aiki OFFSET An yi niyya don canzawa jeri kuma yana da daidaituwa kamar haka:

   = OFFSET (tunani; jere_offset; shafi_offset; tsawo; nisa)

   Hujja Haɗi yana wakiltar hanyar haɗi zuwa sel na ƙarshe ko kewayon da aka sauya kayan aikin.

   Kashe layi - Wannan wata mahawara ce mai nuna yadda yawan teburin yake buƙatar jera layin-layi;

   Kashe Harafi - wata takaddama mai nuna adadin teburin da ke buƙatar jujjuya abubuwa a cikin ginshiƙai;

   Muhawara "Height" da Nisa na zaɓi Suna nuna tsawo da fadin sel daga cikin teburin da yake juyawa. Idan ka ƙididdige waɗannan ƙimar, ana ɗauka cewa suna daidai da tsayi da faɗi asalin.

   Don haka, saita siginan kwamfuta a cikin filin Haɗi sannan yi alama na ƙarshe na kewayon da za a harba. A wannan yanayin, hanyar haɗi dole ne ta zama cikakke. Don yin wannan, yi alama da latsa madannin F4. Alamar dala$).

   Na gaba, saita siginan kwamfuta a cikin filin Kashe layi kuma a cikin yanayinmu, rubuta wannan magana:

   (LINE () - LINE ($ 2 $)) * - 1

   Idan kayi komai daidai kamar yadda aka fasalta a sama, a cikin wannan bayanin zaka iya bambanta a cikin gardamar mai aiki na biyu LADA. Anan kuna buƙatar tantance ayyukan daidaitawa na sel na farko na kewayon tsintsiya madaidaici.

   A fagen Kashe Harafi saka "0".

   Filaye "Height" da Nisa bar komai. Danna kan "Ok".



4. Kamar yadda kake gani, kimar da aka samu a cikin mafi ƙarancin tantanin halitta yanzu an nuna ta a saman sabon tsararren abu.



5. Domin jujjuya sauran dabi'un, kuna buƙatar kwafin dabarar daga wannan kwayar zuwa ƙarshen ƙananan kewayon. Muna yin wannan tare da alamar alamar. Saita siginan kwamfuta zuwa ƙananan gefen dama na kashi. Muna jiran lokacin da za a canza shi zuwa karamin gicciye. Riƙe maɓallin linzamin kwamfuta na hagu kuma ja ƙasa zuwa iyakar ƙarar.



6. Kamar yadda kake gani, duk kewayon ya cika da bayanan da ba su dace ba.



7. Idan muna son bamu da dabara, amma dabi'u a cikin kwayoyin jikinta, sannan sai a zabi yankin da aka nuna sannan a latsa maballin Kwafa a kan tef.



8. Sannan mun danna guntun tsattsauran ra'ayi tare da maɓallin linzamin kwamfuta na dama da cikin toshe Saka Zabi zaɓi gunki "Dabi'u".



9. Yanzu bayanan da ke cikin kewayon da ke ciki an saka shi azaman dabi'u. Kuna iya share ainihin tebur ɗin, ko kuna iya barin sa kamar yadda yake.

Kamar yadda kake gani, akwai hanyoyi da yawa daban-daban na haɓaka teburin jadawalin tebur 90 da 180. Zaɓin zaɓi na musamman, da farko, ya dogara da aikin da aka sanya wa mai amfani.