Spreadsheet spreadsheet mu Microsoft Excel

Pali nthawi zina pomwe wogwiritsa ntchito atamaliza kale gawo lalikulu la tebulo kapena ngakhale kumaliza ntchito pa iye, akumvetsetsa kuti ikulitsa tebulo la 90 kapena 180 madigiri. Zachidziwikire, ngati tebulo limapangidwira zosowa zanu zokha, osati mwadongosolo, ndiye kuti sizingatheke kuti angazikonzenso, koma apitilizabe ku mtundu womwe ulipo. Ngati tebulo limasinthidwa ndi olemba anzawo ntchito kapena makasitomala, ndiye kuti muyenera kutuluka thukuta. Koma, pali malingaliro angapo osavuta omwe angakupatseni mwayi wosavuta komanso kutembenuzira msangawo tebulo momwe mungafunire, ngakhale tebulo linapangidwire nokha kapena dongosolo. Tiyeni tiwone momwe angachitire izi ku Excel.

U-Turn

Monga tanena kale, tebulo limatha kuzungulira madigiri 90 kapena 180. Poyambirira, izi zikutanthauza kuti mzati ndi mizere zisinthidwa, ndipo chachiwiri, tebulo lidzatsitsidwa kuchokera pamwamba mpaka pansi, ndiye kuti mzere woyamba umakhala womaliza. Kuchita izi, pali njira zingapo zosinthira zosiyanasiyana. Tiyeni tiphunzire algorithm pakugwiritsa ntchito kwawo.

Njira 1: 90 degree degree

Choyamba, pezani momwe mungasinthire mizere ndi mizati. Njirayi imatchulidwanso kuti transposition. Njira yosavuta yochitira izi ndikutsatira kuphatikiza kwapadera.

1. Chongani ndandanda ya tebulo yomwe mukufuna kuwonjezera. Timadina chidutswa chosankhidwa ndi batani loyenera la mbewa. Pamndandanda womwe umatseguka, siyani kusankha Copy.

   

   Komanso, m'malo mwa zomwe tafotokozazi, mutasankha malowa, mutha kudina chizindikiro. Copyyomwe ili pa tabu "Pofikira" m'gulu Clipboard.

   

   Koma njira yothamanga kwambiri ndikupanga kiyi yophatikizira mutapanga chidutswa Ctrl + C. Pankhaniyi, kukopera kudzachitidwanso.

2. Gwiritsani ntchito cell iliyonse yopanda pepala ndi malire omasuka. Ichi chizikhala gawo lamanzere kumanzere kwa mitundu yosinthidwa. Timadulira chinthu ichi ndi batani loyenera la mbewa. Mu block "Lowetsani mwapadera" atha kukhala chithunzi "Transpose". Sankhani iye.

   

   Koma mwina simungazipeze, chifukwa menyu oyamba amawonetsa zosankha zomwe zimagwiritsidwa ntchito nthawi zambiri. Poterepa, sankhani njira mumenyu. "Ikani mwapadera ...". Mndandanda wowonjezera umatseguka. Dinani pazithunzi mkati mwake. "Transpose"itayikidwa Ikani.

   

   Palinso njira ina. Malinga ndi algorithm yake, mutatha kupanga foni ndikuyitanitsa menyu yazonse, muyenera dinani kawiri pazinthuzo "Lowetsani mwapadera".

   

   Pambuyo pake, zenera loyika lapadera limatseguka. Mtengo wotsutsa "Transpose" ikani bokosi. Palibenso zowonetsera pazenera ili zomwe zikuyenera kuchitika. Dinani batani "Zabwino".

   

   Zochita izi zitha kuchitika kudzera pa batani la riboni. Timasankha khungu ndikudina patatu, yomwe ili pansi pa batani Ikanikuyikidwa tabu "Pofikira" mu gawo Clipboard. Mndandanda umatseguka. Monga mukuwonera, chithunzicho chilinso mu icho. "Transpose", ndi ndime "Ikani mwapadera ...". Mukasankha chizindikirocho, kusinthaku kudzachitika nthawi yomweyo. Mukamadutsa "Lowetsani mwapadera" zenera loyika lofunikira lidzayamba, lomwe takhala tikulankhula kale pamwambapa. Zochita zina zonse mmenemo ndizofanana.



3. Mukamaliza kusankha zonsezi, zotsatira zake zidzakhala zofanana: malo a tebulo apangidwe, omwe ndi mtundu wa 90-degree of the array yoyamba. Ndiye kuti, poyerekeza ndi tebulo loyambirira, mizere ndi mizati ya malo omwe atumizidwayi asinthidwa.



4. Titha kusiya magawo onse awiri patebulopo, kapena titha kuchotsa loyambalo ngati silifunikanso. Kuti tichite izi, tikutanthauza gawo lonse lomwe liyenera kuchotsedwa pamwamba pa tebulo lomwe linasinthidwa. Pambuyo pake, mu tabu "Pofikira" dinani patatu, yomwe ili kumanja kwa batani Chotsani mu gawo "Maselo". Pamndandanda wotsitsa, sankhani njira Chotsani mizera ".



5. Pambuyo pake, mizere yonse, kuphatikiza malo oikapo tebulo, omwe amapezeka pamwamba pa magulu omwe adatsitsidwa, adzachotsedwa.



6. Kenako, kuti mtundu wololekedwawu utenge mawonekedwe owoneka bwino, timapanga zonsezo, ndikupita ku tabu "Pofikira"dinani batani "Fomu" mu gawo "Maselo". Pamndandanda womwe umatsegulira, sankhani njira Auto Fit Chingwe Chachikulu.



7. Pambuyo pomaliza kuchita, patebulo la tebulo lidawoneka lowoneka bwino. Tsopano titha kuwona bwino kuti m'menemo, poyerekeza ndi choyambirira, mizere ndi mizati zimasinthidwa.

Kuphatikiza apo, mutha kudutsa pamalo patebulopo pogwiritsa ntchito pulogalamu ya Excel, yomwe imatchedwa - TRANSP. Ntchito KUTENGA Zopangidwa mwapadera kuti zisinthe mawonekedwe ofukula kuti akhale olondola komanso osinthika. Kapangidwe kake ndi:

= TRANSPOSE (mndandanda)

Menya Ndi mkangano wokhawokha pa ntchitoyi. Zikutanthauza mtundu kuti utsegulidwe.

1. Onjezani maselo opanda kanthu papepala. Kuchuluka kwa zinthu zomwe zili mgulu la zomwe zidasankhidwa kuyenerane ndi kuchuluka kwa maselo omwe ali pamzere wa tebulo, komanso kuchuluka kwa zinthu zomwe zili m'mizere yopanda kanthu mpaka kuchuluka kwa maselo m'mizati ya tebulo. Kenako dinani chizindikiro. "Ikani ntchito".



2. Kachitidwe kakuchitika Ogwira Ntchito. Pitani ku gawo Malingaliro ndi Kufika. Timayika dzina pamenepo TRANSP ndipo dinani "Zabwino"



3. Tsamba lokangana pamawu ali pamwambapa likutseguka. Khazikitsani chotengera pamunda wake wokha - Menya. Gwirani batani lamanzere lakumanzere ndikuyang'ana malo omwe mukufuna kuti muwonjezere. Kasikil’owu, e ntangwa zawonso zasonekeswa mu sunda. Pambuyo pake, musathamangire kukanikiza batani "Zabwino"monga chizolowezi. Tikugwira ntchito yosiyanasiyana, motero kuti njirayi ipangidwe moyenera, akanikizire kuphatikiza kiyi Ctrl + Shift + Lowani.



4. Gome lolowererapo, monga momwe tikuonera, layikidwira m'gulu lolemba.



5. Monga mukuwonera, vuto la njirayi poyerekeza ndi lomaliza ndikuti polemba zosintha sizisungidwe. Kuphatikiza apo, mukayesa kusintha zomwe zili mu foni iliyonse pamtundu wosinthidwa, mauthenga akuwoneka kuti simungasinthe gawo lawolo. Kuphatikiza apo, mndandanda womwe wadutsawu umalumikizidwa ndi gawo loyambirira ndipo mukachotsa kapena kusintha gwero, lidzachotsedwanso kapena kusinthidwa.



6. Koma zovuta ziwiri zomaliza zitha kusinthidwa mosavuta. Onani mtundu wonse wosinthidwa. Dinani pachizindikiro Copy, yomwe imayikidwa pa tepi mgululi Clipboard.



7. Pambuyo pake, osachotsa mawuwo, dinani kachidutswa komwe kali kale ndi batani loyenera la mbewa. Pazosankha zam'maguluwo Ikani Zosankha dinani pachizindikiro "Makhalidwe". Chithunzichi chikuwonetsedwa mu mawonekedwe a lalikulu komwe manambala amapezeka.



8. Mukatha kuchita izi, mawonekedwe mumtunduwo asinthidwa kukhala zofunikira. Tsopano zosowa zomwe zili momwemo zimatha kusinthidwa momwe mumafunira. Kuphatikiza apo, mndandandawu sugwirizananso ndi gwero la magwero. Tsopano, ngati tingafune, tebulo loyambirira litha kufufutidwa monga momwe tidaphunzirira pamwambapa, ndipo mawonekedwe omwe adalowetsedwa akhoza kuikidwa bwino kuti awoneke kuti ndi othandiza komanso ooneka bwino.

Phunziro: Kusamutsa tebulo ku Excel

Njira 2: 180 Degree Turn

Tsopano ndi nthawi yoti muganize momwe mungasinthanitsire tebulo 180 madigiri. Ndiye kuti, tiyenera kuwonetsetsa kuti mzere woyamba ukutsika, ndipo wotsiriza ukukwera pamwamba kwambiri. Nthawi yomweyo, mizere yotsalira ya thebulo nawonso idasintha momwe adayambira.

Njira yosavuta yokwaniritsira ntchitoyi ndikugwiritsa ntchito zaluso zosanja.

1. Kumanja kwa thebulo, pamzere wapamwamba, ikani nambala "1". Pambuyo pake, ikani cholozera mu ngodya ya kumunsi kwa cell komwe nambala yomwe yakonzedwayo idayikidwa. Pankhaniyi, cholozera chimasinthidwa kukhala chikhomo chodzaza. Nthawi yomweyo gwiritsani batani lakumanzere ndi kiyi Ctrl. Timatambasulira chofikira pansi pa tebulo.



2. Monga mukuwonera, pambuyo poti gawo lonse ladzazidwa ndi manambala kuti akwaniritse.



3. Lembani mzere ndi manambala. Pitani ku tabu "Pofikira" ndipo dinani batani Sanjani ndi Fyuluta, yomwe yamasulidwa pamatepi pagawo "Kusintha". Kuchokera pamndandanda womwe umatsegulira, sankhani njira Makonda.



4. Pambuyo pake, bokosi la zokambirana limatsegulidwa pomwe amati deta imapezeka kunja kwa mtundu womwe wafotokozedwayo. Mwachisawawa, kusinthana kwawindo ili kwakhazikitsidwa "Onjezera mtundu wosankhidwa". Muyenera kusiya izi momwemo ndikudina batani "Zosintha ...".



5. Tsamba losintha mwambo likuyamba. Onetsetsani kuti pafupi ndi chinthucho "Zambiri zanga zimakhala ndi mutu" chizindikirocho sichinatsegulidwe ngakhale mutu wake ulipodi. Kupanda kutero, sadzatsitsidwa, koma adzakhala pamwamba pa tebulo. M'deralo Longosolani muyenera kusankha dzina la mzere momwe manambala awerengera. M'deralo "Sinthani" gawo liyenera kusiyidwa "Makhalidwe"yomwe imayikidwa ndi kusakhazikika. M'deralo "Order" ziyenera kukhazikika "Kuchotsa". Pambuyo kutsatira malangizowa, dinani batani "Zabwino".



6. Pambuyo pake, patebulo la tebulo lidzasanjidwa mosiyanasiyana. Zotsatira zamtunduwu, zidzasinthidwa mozungulira, ndiye kuti mzere wotsiriza udzakhala mutu, ndipo mutuwo ndiye mzere womaliza.

   

   Chidziwitso chofunikira! Ngati tebulo linali ndi njira, ndiye chifukwa cha kusanja, zotulukapo zawo sizingawonekere bwino. Chifukwa chake, motere, muyenera kusiya kotheratu zakusalo, kapena musinthe zotsatira za kuwerengera kwamawonekedwe kukhala mfundo.

7. Tsopano titha kuchotsa mzere wowerengera ndi manambala, chifukwa sitikufunanso. Timayika chizindikiro, dinani kumanja pa chidutswa chosankhidwa ndikusankha mawonekedwe omwe ali mndandandandawo Chotsani Zolemba.



8. Tsopano yambirani kukulitsa tebulo magawo a 180 akhoza kuonedwa kuti mwamalizidwa.

Koma, monga mungazindikire, ndi njira iyi yakukulira, gome loyambilira limangosinthidwa kuti likukulidwe. Gwero lokha silipulumutsidwa. Koma pali nthawi zina zomwe zingakhale zovuta kuzisintha mozungulira, koma nthawi yomweyo, sungani zomwe zili. Izi zitha kuchitika pogwiritsa ntchito ntchitoyo OFFSET. Izi ndizoyenera kukhala ndi mzere umodzi.

1. Tikuyika chizindikiro cholembera kudzanja lamtundu kuti titsegulidwe mumizere yake yoyamba. Dinani batani "Ikani ntchito".



2. Iyamba Fotokozerani Wizard. Timasunthira ku gawo Malingaliro ndi Kufika lembani dzina "OFFSET", kenako dinani "Zabwino".



3. Windo la mkangano liyamba. Ntchito OFFSET Amapangidwira masamu osunthira ndipo ali ndi syntax otsatirawa:

   = OFFSET (kalozera; mzere_nkhokwe; nsanja_offset; kutalika; m'lifupi)

   Kukangana Lumikizani chikuyimira cholumikizana ndi foni yotsiriza kapena mtundu wazosintha.

   Chingwe Kutulutsa Uwu ndi mkangano wowonetsa kuchuluka kwa tebulo lomwe likufunika kusintha mzere ndi mzere;

   Chotsitsa - mkangano wowonetsa kuchuluka kwa tebulo lomwe likufunika kusintha pamagawo;

   Mikangano "Msodzi" ndi Kufikira kusankha. Zikuwonetsa kutalika ndi kupingasa kwa maselo a tebulo lolowererapo. Ngati mumasiyira izi, zimaganiziridwa kuti ndi ofanana kutalika ndi mulingo wa gwero.

   Chifukwa chake, ikani cholozera m'munda Lumikizani ndipo yikani gawo lomaliza la masanjidwewo. Pankhaniyi, ulalo uyenera kukhala wamphumphu. Kuti muchite izi, lembani chizindikiro ndikudina kiyi F4. Chizindikiro cha dollar ($).

   Kenako, ikani cholozera m'munda Chingwe Kutulutsa ndipo ife, lembani mawu otsatirawa:

   (LERO () - LERO ($ A $ 2)) * - 1

   Ngati mudachita zonse monga momwe tafotokozera pamwambapa, m'mawu awa mutha kusiyanitsa pazotsutsana ndi wothandizira wachiwiriyo LERO. Apa muyenera kufotokozera zolumikizana za selo loyambirira la mawonekedwe osangalatsa.

   M'munda Chotsitsa kuyika "0".

   Minda "Msodzi" ndi Kufikira siyani opanda kanthu. Dinani "Zabwino".



4. Monga mukuwonera, mtengo womwe umapezeka mu chipinda chotsika kwambiri ukuwonetsedwa pamwamba pazatsopanozi.



5. Kuti muwone zolakwika zina, muyenera kutengera kachipangizidwe kamene kamakhala mu cell kupita kumizere yonse. Timachita izi ndi chikhomo chomaliza. Khazikitsani choloweza kumunsi chakumanzere kwa chinthucho. Tikudikirira kuti asinthidwe kukhala mtanda wawung'ono. Gwirani batani lamanzere lakumanzere ndikusunthira kumalire autali.



6. Monga mukuwonera, lonse lonse limadzaza ndi data yolemba.



7. Ngati tikufuna kukhala opanda mafomula, koma mfundo mu maselo ake, ndikusankha dera lomwe lawonetsedwa ndikudina batani Copy pa tepi.



8. Kenako timadina kachidutswa kolembetsedwa ndi batani loyenera la mbewa komanso chipika Ikani Zosankha sankhani chizindikirocho "Makhalidwe".



9. Tsopano deta yomwe ili mumtundu wokhazikitsidwa imayikidwa ngati mtengo. Mutha kufufuta tebulo loyambirira, kapena mutha kusiya momwe lilili.

Monga mukuwonera, pali njira zingapo zosiyanitsira zokulitsira tebulo 90 ndi 180 madigiri. Kusankha mwanjira inayake, choyambirira, zimatengera ntchito yomwe wapatsidwa wogwiritsa ntchito.