Wopanga Mapulogalamu 4.0.6

Pali mavoti omwe atatha kukwaniritsa gawo lalikulu la tebulo kapena ngakhale atamaliza kugwira ntchito, amadziwa kuti zidzakhala zomveka bwino kuti azitsatira tebulo 90 kapena 180 madigiri. Inde, ngati tebulo likupangidwira zosowa zawo, osati kwa dongosolo, ndiye kuti nkutheka kuti iye adzabwezeretsanso, koma pitirizani kugwira ntchito pa kale lomwe liripo. Ngati mutembenuza tablespace mukufuna bwana kapena makasitomala, ndiye mu nkhaniyi ayenera thukuta. Koma kwenikweni, pali njira zingapo zosavuta zomwe zingakupangitseni kuti mutenge mwamsanga komanso mosavuta kufalikira kwa tebulo momwe mukufunira, mosasamala kanthu kuti tebulo lapangidwa nokha kapena dongosolo. Tiyeni tiwone momwe tingachitire izi mu Excel.

Kusintha

Monga tanena kale, tebulo ikhoza kusinthidwa 90 kapena 180 madigiri. Pachiyambi choyamba, izi zikutanthauza kuti zipilala ndi mizere zidasindikizidwa, ndipo chachiwiri, tebuloyo imachokera pamwamba mpaka pansi, ndiko kuti, mzere woyamba ukhale wotsiriza. Pomwe ntchitoyi ikukhazikitsidwa pali njira zingapo zovuta kumvetsa. Tiyeni tiphunzire ndondomeko ya ntchito yawo.

Njira 1: tembenuzirani madigiri 90

Choyamba, fufuzani momwe mungasinthire mizere ndi zipilala. Njirayi imatchedwanso kusintha. Njira yosavuta yogwiritsira ntchito ndi kugwiritsa ntchito bokosi lapadera.

1. Lembani mzere wa tebulo umene mukufuna kuutumizira. Dinani pa chidutswa chodziwika ndi botani lamanja la mouse. M'ndandanda yomwe imatsegula, timayima "Kopani".

   

   Ndiponso, mmalo mwachitidwe pamwambapa, mutatha kulemba dera lanu, mukhoza kudina pazithunzi, "Kopani"yomwe ili pa tabu "Kunyumba" m'gulu "Zokongoletsera".

   

   Koma njira yofulumira kwambiri ndiyo kupanga chophatikizira chophatikizidwa mutatha kulemba chidutswa. Ctrl + C. Pankhaniyi, bukulo lidzachitidwanso.

2. Tchulani selo iliyonse yopanda kanthu pa pepala ili ndi malire a malo omasuka. Chigawo ichi chiyenera kukhala chakumapeto kwa selo laseri. Dinani pa chinthu ichi ndi batani lamanja la mouse. Mu chipika "Sakani Mwapadera" pangakhale chithunzi "Kutumiza". Sankhani.

   

   Koma apo simungapeze, chifukwa mndandanda woyamba umasankha njira zoyika zomwe zimagwiritsidwa ntchito nthawi zambiri. Pankhaniyi, sankhani masankhidwe a menyu "Kuika Mwapadera ...". Mndandanda wowonjezera umatsegulidwa. Momwemo ife timatsitsa pazithunzi "Kutumiza"adaikidwa mu chipika "Ikani".

   

   Palinso njira ina. Malinga ndi ndondomeko yake, pambuyo polemba selo ndikuyitanitsa mndandanda wamakono, m'pofunikira kudutsa zinthuzo kawiri "Sakani Mwapadera".

   

   Pambuyo pake, mawindo ena apadera akuwonekera. Zotsutsana "Kutumiza" ikani checkbox. Palibe njira zowonongeka pawindo ili. Timasankha pa batani "Chabwino".

   

   Zochitazi zingathekanso kupyolera mu batani pa riboni. Sankhani selo ndikusakani pa katatu, komwe kuli pansi pa batani Sakanizaniinayikidwa pa tabu "Kunyumba" mu gawo "Zokongoletsera". Mndandanda umatsegulidwa. Monga mukuonera, pali chithunzi mkati mwake. "Kutumiza"ndi chinthu "Kuika Mwapadera ...". Ngati musankha chizindikiro, kusinthako kudzachitika nthawi yomweyo. Mukasuntha pa chinthu "Sakani Mwapadera" zowonjezera zowonjezera zenera zidzakhazikitsa, zomwe takambirana kale. Zochita zina zonse zomwe ziri mmenemo ndi chimodzimodzi.



3. Pambuyo pomaliza zonsezi, zotsatira zake zidzakhala zofanana: tebulo lidzapangidwira, lomwe ndi losiyana kwambiri ndi magawo oyambirira omwe amasinthasintha madigiri 90. Ndiko, poyerekeza ndi tebulo lapachiyambi, m'deralo losinthidwa, mizera ndi zipilala zimasinthidwa.



4. Titha kuchoka m'madera onse awiri pa pepala, ndipo tikhoza kuchotsa chinthu chimodzi ngati sichifunikanso. Kuti tichite izi, timatanthauzira zonse zomwe zikufunika kuchotsedwa pamwamba pa tebulo losandulika. Pambuyo pake mu tab "Kunyumba" Dinani pa katatu komwe kuli kumanja kwa batani "Chotsani" mu gawo "Maselo". M'ndandanda wotsika pansi, sankhani kusankha "Chotsani mizere kuchokera pa pepala".



5. Pambuyo pake, mizere yonse, kuphatikizapo tebulo yoyamba, yomwe ili pamwamba pazithunzi zosinthidwayo idzachotsedwa.



6. Ndiye, kuti mawonekedwe osinthidwa atenge mawonekedwe ophatikizana, ife timatanthauzira zonsezo, ndi kupita ku tabu "Kunyumba", dinani pa batani "Format" mu gawo "Maselo". Mndandanda umene umatsegulira, sankhani kusankha "Kusankhidwa kwasanamira m'kati mwake".



7. Pambuyo pochitapo kanthu chomaliza, zigawo zazithunzizo zinkawoneka bwino. Tsopano tikuwonekeratu kuti mmenemo, poyerekeza ndi zoyambirira, mizere ndi zipilala zasinthidwa.

Kuphatikizanso apo, mukhoza kutsegula tablepace pogwiritsa ntchito ndemanga yapadera ya Excel, yomwe imatchedwa - "TRANSPORT". Ntchito TRANSPORT makamaka kupangidwira kutembenuza mawonekedwe otalikira kumalo osakanikirana ndi mosiyana. Chizindikiro chake ndi:

= TRANSPORT (gulu)

"Mzere" - mtsutso wokha wa ntchitoyi. Ndili mgwirizano wa mitundu yosiyanasiyana imene iyenera kutsekedwa.

1. Timasonyeza maselo opanda kanthu pa pepala. Chiwerengero cha zinthu zomwe zili mu gawo la chidutswa chomwe chikuwonetsedwa chikuyenera kulumikizana ndi chiwerengero cha maselo mu mzere wa tebulo, ndipo chiwerengero cha zinthu mu mizera ya zopanda kanthu ziyenera kulumikizana ndi chiwerengero cha maselo muzithunzi za tablespace. Ndiye ife timangodina pa chithunzi. "Ikani ntchito".



2. Kuchita kumachitika Oyang'anira ntchito. Pitani ku gawoli "Zolumikizana ndi zolemba". Lembani dzina pamenepo "TRANSPORT" ndipo dinani "Chabwino"



3. Festile yotsutsana ya ndemanga yapamwamba imayamba. Ikani cholozera mmunda wake wokha - "Mzere". Gwirani botani lamanzere la mouse ndipo lembani ma tebulo omwe mukufuna kukulitsa. Pankhaniyi, makonzedwe ake akuwonetsedwa m'munda. Pambuyo pake, musafulumire kukanikiza batani "Chabwino"monga mwachizolowezi. Tikulimbana ndi ntchito yambiri, choncho, kuti ndondomekoyi iwonongeke bwino, yesetsani kuphatikiza Ctrl + Shift + Lowani.



4. Gome losandulika, monga momwe tikuwonera, likulowetsedwera muzithunzi zolembedwa.



5. Monga momwe mukuonera, kusokonekera kwa njirayi poyerekeza ndi zomwe zapitazo ndikuti mawonekedwe oyambirira sanapulumutsidwe posintha. Kuwonjezera pamenepo, pamene mukuyesera kusintha deta mu selo iliyonse yamtundu wopangidwa, uthenga ukuwoneka kuti simungasinthe mbali ya mndandanda. Kuphatikizanso, zigawo zosinthidwa zimagwirizanitsidwa ndi zoyambirazo ndipo pamene muthetsa kapena kusintha gwero, lidzachotsedwanso kapena kusinthidwa.



6. Koma ndi zolakwa ziwiri zomalizira zimagwira ntchito mophweka. Lembani mtundu wonse wopangidwa. Timakani pa chithunzi "Kopani"yomwe imaikidwa pa tepi mu gululo "Zokongoletsera".



7. Pambuyo pake, popanda kuchotsa zolembazo, dinani chidutswa chopangidwa ndi bomba lamanja la mouse. M'ndandanda wamakono m'gululi "Njira Zowonjezera" dinani pazithunzi "Makhalidwe". Chithunzichi chimaperekedwa mwa mawonekedwe a malo owerengeka omwe muli nambala.



8. Pambuyo pochita izi, ndondomekoyi idzakhala yosinthika. Tsopano deta yomwe ili mmenemo ingasinthidwe monga momwe mumafunira. Kuwonjezera pamenepo, izi sizinayanjaniranso ndi gome la gwero. Tsopano, ngati mukufuna, tebulo lachitukuko likhoza kuchotsedwa chimodzimodzi monga momwe tafotokozera pamwambapa, ndipo gulu losandulika likhoza kupangidwa moyenera kotero kuti liwoneke kukhala lodziwika bwino komanso looneka bwino.

Phunziro: Kusintha tebulo mu Excel

Njira 2: kutembenuza madigiri 180

Tsopano ndi nthawi yoti mudziwe momwe mungasinthire tebulo 180 madigiri. Izi ndizo, tiyenera kupanga mzere woyamba, ndipo wotsiriza umakwera pamwamba. Pa nthawi yomweyi, mizera yotsala ya tebulo idasinthiranso malo awo oyambirira.

Njira yosavuta yokwaniritsira ntchitoyi ndi kugwiritsa ntchito zigawozo.

1. Kumanja kwa gome, pafupi ndi mzere wake wapamwamba, ikani nambala. "1". Pambuyo pake perekani cholozera kumbali ya kumanja ya selo kumene chiwerengero chayikidwa. Pankhaniyi, malondawa amasinthidwa kukhala chizindikiro chodzaza. Panthawi imodzimodziyo gwiritsani batani lamanzere ndi fungulo Ctrl. Kokani chotchinga pansi pa tebulo.



2. Monga mukuonera, patatha izi, chigawo chonsecho chidzaza ndi nambala mu dongosolo.



3. Lembani ndimeyo ndi chiwerengero. Pitani ku tabu "Kunyumba" ndipo dinani pa batani "Sankhani ndi kusefera"yomwe ili m'deralo pa tepi mu gawolo Kusintha. Kuchokera pandandanda yomwe imatsegulira, asiye kusankha kusankha "Yambani Mwambo".



4. Pambuyo pa izi, bokosi la bokosi likuyamba, kukudziwitsani kuti deta yopanda malireyo yadziwika. Mwachindunji, kusinthana pazenera ili kuikidwa "Yowonjezera mwachangu osankhidwa". Akuyenera kuchoka pamalo omwewo ndikusindikiza pa batani. "Sungani ...".



5. Chizolowezi choyang'ana zenera chikuyamba. Onani kwa chinthu "Deta yanga ili ndi mutu" Chongeretsani chachotsedwa ngakhale ngati mutu ulipo. Apo ayi sangathe kutsika pansi, ndipo adzakhalabe pamwamba pa tebulo. Kumaloko "Sankhani" muyenera kusankha dzina la chigawo chimene chiwerengero chiri. Kumaloko "Sungani" kuchoka kumafunika "Makhalidwe"yomwe imayikidwa ndi chosasintha. Kumaloko "Dongosolo" ayenera kuyimika "Akukwera". Mutatsatira malangizo awa, dinani pa batani. "Chabwino".



6. Pambuyo pake, mndandanda wa tebulo udzasankhidwa motsatira. Chifukwa cha izi, zidzasinthidwa, ndiko kuti, mzere wotsiriza udzakhala mutu, ndipo mutuwo ukhale womaliza.

   

   Chofunika kwambiri! Ngati tebulo liri ndi maonekedwe, ndiye chifukwa cha izi, zotsatira zake sizingasonyezedwe molondola. Choncho, mu nkhaniyi, nkofunikira kuti mungakane kutembenukira konse, kapena kusintha zotsatira za chiwerengero cha malemba kukhala ofunika.

7. Tsopano mutha kuchotsa chigawo choonjezera ndi chiwerengero, popeza sitikusowa. Lembani, dinani pomwepa pa chidutswa chodziwika ndikusankha malo kuchokera mndandanda "Chotsani Chokhutira".



8. Tsopano ntchito yowonjezera tebulo ndi madigiri 180 ikhoza kuganiziridwa kuti yatha.

Koma, monga momwe mukuonera, njirayi yowonjezera tebulo lapachiyambi imangosinthidwa. Gwero lokha silinasungidwe. Koma pali milandu pamene gulu liyenera kutembenuzidwa, koma panthawi imodzimodziyo musunge gwero. Izi zikhoza kuchitika pogwiritsa ntchito ntchitoyi OFFSET. Njira iyi ndi yoyenera pa mzere umodzi umodzi.

1. Lembani selo kumanja komwe mukufuna kuti muzitha kulowa mumzere woyamba. Timasankha pa batani "Ikani ntchito".



2. Iyamba Mlaliki Wachipangizo. Pitani ku gawo "Zolumikizana ndi zolemba" ndipo lembani dzina "MHECHI"ndiye dinani "Chabwino".



3. Fesholo yotsutsana ikuyamba. Ntchito OFFSET Yalinganizidwa kuti ndiyambe kusuntha ndipo ili ndi mawu otsatila awa:

   = OFFSET (zolemba; zosiyana ndi mizere; zosiyana ndi zipilala; kutalika; m'lifupi)

   Kutsutsana "Lumikizanani" imayimira kulumikiza kwa selo lotsiriza kapena mndandanda wamitundu yosinthidwa.

   "Mzere wokhazikika" - iyi ndi mtsutso wosonyeza momwe tebulo likufunira kusinthidwa mzere;

   "Yambani chikhomo" - mtsutso wosonyeza kuti tebulo likufunika kusinthidwa ndi zipilala;

   Mikangano "Kutalika" ndi "M'lifupi" ndizosankha. Amasonyeza kutalika ndi kupitirira kwa maselo a tebulo losinthidwa. Ngati tisiya mfundo izi, zikuwoneka kuti ndizofanana ndi kutalika ndi kukula kwa khodi yachinsinsi.

   Choncho, ikani chotsekeramo kumunda "Lumikizanani" ndipo lembani selo lotsiriza la zovuta zomwe mukufuna kuzimanga. Pankhaniyi, chiyanjano chiyenera kukhala chotheka. Kuti muchite izi, lembani ndi kukanikiza fungulo F4. Chizindikiro cha dola chiyenera kuonekera pafupi ndi zowonjezera zowonjezera ($).

   Chotsatira, ikani cholozera mmunda "Mzere wokhazikika" ndipo kwa ife tikulemba mawu otsatirawa:

   (LINE () - LINE ($ A $ 2)) - 1

   Ngati mwachita zonse zomwezo monga momwe tafotokozera pamwambapa, m'mawu awa, mutha kusiyanitsa pazitsutsano za wopanga wachiwiri LINE. Pano mukuyenera kufotokoza makonzedwe a selo yoyamba ya mawonekedwe osinthidwa mu mawonekedwe athunthu.

   Kumunda "Yambani chikhomo" ikani "0".

   Minda "Kutalika" ndi "M'lifupi" chokani chopanda kanthu. Klaatsay "Chabwino".



4. Monga mukuonera, mtengo umene unali pa selo yotsika kwambiri tsopano ukuwonetsedwa pamwamba pazatsopano.



5. Kuti mutembenuzire zikhulupiliro zina, muyenera kufotokozera ndondomekoyi kuchokera mu selo iyi mpaka kumtunda wonse. Timachita izi ndi chizindikiro chodzaza. Ikani cholozera pansi pamphepete mwachinthucho. Tikudikira kufikira atasandulika mtanda wawung'ono. Gwiritsani batani lamanzere lamanzere ndikukwera mpaka kumadzulo.



6. Monga momwe mukuonera, lonseli ladzaza ndi deta yosinthidwa.



7. Ngati tikufuna kukhala mu maselo ake osapangidwira, koma ndizofunika, ndiye kuti tikulemba malo omwe akuwonetsedwa ndikusindikiza batani "Kopani" pa tepi.



8. Kenaka timadula chidutswa chodindilidwa ndi batani lamanja la mouse komanso muzitsulo "Njira Zowonjezera" sankhani chizindikiro "Makhalidwe".



9. Tsopano chidziwitso chadodometsedwacho chimayikidwa ngati chiyero. Tebulo lapachiyambi lingachotsedwe, koma mukhoza kuchoka momwemo.

Monga mukuonera, pali njira zingapo zosiyana zowonjezera tebulo ndi 90 ndi 180 madigiri. Kusankha njira yapadera, choyamba, kumadalira ntchito yomwe yanagwiritsidwa ntchito.