Mwa kusakhazikika, Microsoft Excel siyikutulutsa ma sheet. Nthawi yomweyo, nthawi zambiri, makamaka ngati chikalatacho chimatumizidwa kuti chisindikize, ayenera kuwerengedwa. Excel imakulolani kuchita ndi oyenda maulendo. Tiyeni tiwone njira zosiyanasiyana monga manambala mu pulogalamuyi.
Kulemba mu Excel
Masamba a Excel atha kukhala akugwiritsa ntchito zowunikira. Amabisika mwachinsinsi, omwe ali m'munsi ndi apamwamba a pepalalo. Mbali zawo ndichakuti zolemba zomwe zalembedwa m'derali zadutsa, ndiye kuti, zikuwonetsedwa patsamba lonse la chikalatacho.Njira 1: Kuwerengera
Kuwerenga bwino kumaphatikizapo kuchuluka kwa chikalatacho.
- Choyamba, muyenera kuyatsa mutu wa wotsatsa. Pitani ku "kuyika" tabu.
- Pa tepi mu "zolemba" zomwe timadina pa batani la "wopatsa".
- Pambuyo pake, kusinthanitsa kwa mtundu wa chizindikiro, ndipo oyenda maulendo akuwonetsedwa pama sheet. Amapezeka kumtunda ndi kutsika. Kuphatikiza apo, aliyense wa iwo amagawidwa magawo atatu. Sankhani, momwe mulitsi, komanso momwe muliri, manambala adzapangidwa. Nthawi zambiri, gawo lamanzere la oyenda pamwamba amasankhidwa. Dinani mbali yomwe mukufuna kuyika chipinda.
- Mu constroctor tabu ya chizindikiro chowonjezera cha "ntchito ndi oyenda maulendo" podina batani la nambala, lomwe limayikidwa pa tepi m'magulu a Togbin.
- Monga mukuwonera, Tag yapadera "& [tsamba] limawonekera. Kuti asinthidwe kukhala nambala yofananira, dinani pa gawo lililonse la chikalata.
- Tsopano nambala yotsatirayi idawonekera patsamba lililonse la chikalata cha Exel. Kotero zimawoneka ngati zowoneka bwino ndikuziyimira maziko, zitha kupangidwa. Kuti muchite izi, sonyezani kujambula muondolo ndi kubweretsa chotemberero kwa icho. Zolemba zopangidwa zimawonekera momwe mungapangire izi:
- sinthani mtundu wa font;
- panga kapena molimba mtima;
- Sinthani;
- Sinthani mtundu.
Sankhani zochita zomwe mukufuna kusintha mawonekedwe a chiwerengero mpaka zotsatira zake zikutsimikizidwa.
Njira 2: Kuwerengera kuwonetsa kuchuluka kwa ma sheet
Kuphatikiza apo, mutha kuwerengera masamba ambiri, kuwonetsa kuchuluka kwawo pa pepala lililonse.
- Yambitsani chiwonetsero cha manambala, monga momwe zalembedwera.
- Musanayambe, lembani mawu oti "tsamba", ndipo zitatha izi 'kunja ".
- Ikani chotemberero m'munda wapansi pambuyo pa liwu loti "kunja". Dinani pa batani la batani la batani ", lomwe lili pa tepi mu" kunyumba "tabu.
- Dinani pa malo aliwonse a chikalatacho kuti m'malo mwa ma tag, zomwe zimawonekera.
Tsopano tili ndi zambiri osati nambala yamakono yokha, komanso za kuchuluka kwathunthu kwa iwo.
Njira 3: Kuwerengera kuchokera patsamba lachiwiri
Pali milandu kuti chikalata chonse chikufunika kuwerengedwa, koma chongoyambira malo ena. Tiyeni tiwone momwe mungachitire.
Pofuna kukhazikitsa zolemba patsamba lachiwiri, ndipo izi ndizoyenera, mwachitsanzo, polemba zotsatsa, kasisitala ndi mapepala asayansi salola kuti kupezeka kwa manambala, muyenera kupanga zomwe zikuchitika pansipa.
- Pitani ku mafayilo oyenda. Kenako, timasamukira ku "wam'munsi" tabu ", yomwe ili mu" ntchito ndi oyenda maulendo "tabu.
- Mu "magawo" a zida pa tepi, lembani zigawo za "zojambulajambula patsamba loyamba".
- Timakhazikitsa nambala yogwiritsa ntchito batani la "Tsamba", monga tawonetsedwa pamwambapa, koma chitani patsamba lililonse, kupatula kaye.
Monga momwe tikuonera, mapepala onse amawerengedwa, kupatula woyamba. Komanso, tsamba loyamba limafunsidwa mu njira yowerengera ma sket ena, koma, komabe, siziwonetsedwa payokha.
Njira 4: Kuwerengera kuchokera patsamba lomwe latchulidwa
Nthawi yomweyo, pamakhala zochitika ngati zofunikira kuti chikalatacho chikayamba kuchokera patsamba loyamba, koma, mwachitsanzo, ndi chachitatu kapena chachisanu ndi chiwiri. Kufunika kotereku sikochulukirapo, koma, komabe, funsoli limafunikiranso yankho.
- Timachita chiwerengero chanthawi zonse, pogwiritsa ntchito batani lolingana pa tepi, malongosoledwe atsatanetsatane omwe adaperekedwa pamwambapa.
- Pitani ku tsamba la tabu ".
- Pa tepi pakona yakumanzere kwa "masamba okhazikika" pali chithunzi chophatikizika muvi. Dinani pa Iwo.
- Panja la pazenera limatseguka, pitani ku "Tsamba" Tab, ngati itatsegulidwa mu tabu ina. Tidayika m'munda wa "Tsamba loyamba la Tsamba" Lachitatu ", nambala yake, nambala yomwe muyenera kuchitidwa. Dinani pa batani la "OK".
Monga mukuwonera, zitatha izi, kuchuluka kwa tsamba loyamba mu chikalatacho kwasintha kwa omwe adafotokozedwa ku magawo. Chifukwa chake, kuchuluka kwa mapepala otsatira kumasinthidwanso.
Phunziro: Momwe Mungachotsere Mafayilo Abwino
Masamba a nambala ya tebulo yopambana ndi yosavuta. Njirayi imachitidwa ndi mulu wamutu. Kuphatikiza apo, wosuta amatha kuwongolera zodzilembera nokha: mawonekedwe owonetsera chiwerengerocho, onjezani chisonyezo cha chiwerengero chonse cha ma sheet, kuti awerenge ku malo ena, etc.