Khadi lamalonda la chilemba chirichonse ndilo dzina lake. Kulemba izi kumagwiranso ntchito pa matebulo. Inde, zimakhala zosangalatsa kwambiri kuona chidziwitso chomwe chili ndi chidziwitso chokongoletsedwa bwino. Tiyeni tiwone momwe zinthu zikuyenera kukhalira kuti pamene mukugwira ntchito ndi Excel musankhe nthawi zonse kukhala ndi mayina apamwamba apamwamba.
Pangani dzina
Chinthu chachikulu chomwe mutuwo udzachititse ntchito yake mwamsanga momwe zingathere, ndicho chiwonetsero chake. Dzinali liyenera kunyamula chinthu chachikulu cha zomwe zili mu tebulo, kufotokozera momveka bwino momwe zingathere, koma panthawi imodzimodziyo mukhale achidule ngati momwe mungathere kuti wogwiritsa ntchitoyo amvetse zomwe izi zikuchitika.
Koma mu phunziro ili, tidzakhalabebe zowonjezera pazomwe sizinapangidwe, komabe tizingoganizira za ndondomeko yolemba dzina la tebulo.
Gawo 1: Kupanga malo a dzina
Ngati muli ndi tebulo lokonzekera, koma muyenera kuwongolera, ndiye choyamba, muyenera kupanga malo pa pepala, yomwe inapatsidwa udindo.
- Ngati mzerewu uli ndi mzere woyamba wa pepala ndi malire ake apamwamba, ndiye kofunikira kuchotsa malo a dzina. Kuti muchite izi, ikani cholozera ku gawo lililonse la mzere woyamba wa tebulo ndipo dinani ndibokosi lamanja la mouse. Mu menyu yomwe imatsegulidwa, sankhani kusankha "Sakani ...".
- Pamaso pathu tikuwonekera zenera laling'ono limene muyenera kusankha chomwe mukufuna kuwonjezera: chigawo, mzere kapena maselo omwe ali ndi kusintha komweko. Popeza tili ndi ntchito yowonjezera mzere, timakonzanso kusintha kwa malo oyenera. Klaatsay "Chabwino".
- Mzere wawonjezedwa pamwamba pa tebulo. Koma, ngati muwonjezera mzere umodzi pakati pa dzina ndi tebulo, sipadzakhalanso danga laulere pakati pawo, zomwe zidzatsimikizira kuti mutuwo sudzaonekera mofanana ndi momwe tingafunire. Izi sizikugwirizana ndi ogwiritsa ntchito onse, choncho ndizomveka kuwonjezera mzere umodzi kapena ziwiri zina. Kuti muchite izi, sankhani chinthu chirichonse pamzere wopanda kanthu umene tangowonjezerapo, ndipo dinani batani yoyenera ya mouse. Mu menyu yachidule, sankhani chinthucho kachiwiri. "Sakani ...".
- Zochita zina muzowonjezerapo zenera zimabwerezedwa mofanana monga tafotokozera pamwambapa. Ngati ndi kotheka, momwemo mukhoza kuwonjezera mzere wina.
Koma ngati mukufuna kuwonjezera mzere umodzi pamwamba pa tebulo, ndiye kuti pali njira yoti muthamangire mwatsatanetsatane ndondomekoyi osati kuwonjezera chinthu chimodzi panthawi, koma pangani kuwonjezera nthawi imodzi.
- Sankhani magulu osiyanasiyana omwe ali pamwamba pa tebulo. Ngati mukufuna kuwonjezera mizere iwiri, muyenera kusankha maselo awiri, ngati pali atatu, ndiye atatu, ndi zina zotero. Sakanizani pa chisankho, monga icho chinachitidwa kale. Mu menyu, sankhani "Sakani ...".
- Apanso, zenera zikutsegula kumene muyenera kusankha malo. "Mzere" ndipo dinani "Chabwino".
- Pamwamba pa tebulo zidzawonjezeredwa mzere wa mizera, ndi zinthu zingati zomwe zasankhidwa. Kwa ife, atatu.
Koma palinso njira ina yowonjezera mizere pamwamba pa tebulo kutchula mayina.
- Timasankha pamwamba pa tebulo zinthu zambiri muzowunikira momwe mizere ikuwonjezera. Izi ndizo, monga momwe timayendera kale. Koma nthawi ino, pitani ku tabu "Kunyumba" pa kachipangizo ndipo dinani pa chithunzicho mwa mawonekedwe a katatu kupita kumanja kwa batani Sakanizani mu gulu "Maselo". M'ndandanda, sankhani kusankha "Sakani mzere pa pepala".
- Pali kulembedwa pa pepala pamwamba pazithunzi za mizere, ndi maselo angati omwe adatchulidwa kale.
Pa gawo ili la kukonzekera lingakhale lokwanira.
PHUNZIRO: Momwe mungapangire mzere watsopano ku Excel
Gawo 2: Kutchula dzina
Tsopano tikufunikira kulemba mwachindunji dzina la gome. Cholinga cha mutuwo chiyenera kukhala chiyani, tafotokozeratu mwachidule pamwambapa, kotero kuwonjezera apo sitidzangoganizira za nkhaniyi, koma tidzakhala tcheru pa nkhani zenizeni.
- Mu gawo lililonse la pepala, lomwe lili pamwamba pa malemba omwe timapanga mu sitepe yapitayi, lowetsani dzina lofunika. Ngati pali mizere iwiri pamwamba pa tebulo, ndibwino kuti muzichita chimodzimodzi mwa iwo, ngati pali atatu, ndiye pakati.
- Tsopano tikufunika kuika dzina ili pakati pa tebulo kuti tiwoneke bwino.
Sankhani maselo osiyanasiyana omwe ali pamwamba pa malemba omwe ali pa mzere umene dzina lanu lili. Panthawi imodzimodziyo, malire a kumanzere ndi kumanja sayenera kudutsa malire ofanana a tebulo. Pambuyo pake, dinani pa batani "Gwirizanitsani ndikuyika pakati"yomwe ili pa tabu "Kunyumba" mu block "Kugwirizana".
- Pambuyo pake, zigawo za mzere umene dzina la tebulo lidzaphatikizidwa, ndipo mutu womwewo udzaikidwa pakati.
Pali njira ina yowumikizira maselo mumzere ndi dzina. Kukhazikitsidwa kwake kudzatenga nthawi yayitali, koma, komabe, njirayi iyeneranso kutchulidwa.
- Sankhani zosankha za pepalalo, momwe dzina la chikalatacho chilili. Timasindikiza chidutswa chodindidwa ndi batani lamanja la mouse. Sankhani mtengo kuchokera mndandanda "Sungani maselo ...".
- Muwindo lamapangidwe timasunthira ku gawolo. "Kugwirizana". Mu chipika "Onetsani" onani bokosi pafupi ndi mtengo "Kugwirizanitsa Magulu". Mu chipika "Kugwirizana" kumunda "Mwachilendo" ikani mtengo "Pakati" kuchokera mndandanda wa zochita. Dinani "Chabwino".
- Pachifukwa ichi, maselo a chidutswa chosankhidwa adzaphatikizidwanso, ndipo dzina la chikalatacho liyikidwa pakati pa chinthu chophatikizidwa.
Koma nthawi zina, kuphatikiza kwa maselo ku Excel sikulandiridwa. Mwachitsanzo, mukamagwiritsa ntchito matebulo abwino, ndi bwino kuti musagwiritse ntchito bwino. Ndipo nthawi zina, mayanjano aliwonse amaphwanya dongosolo loyambirira la pepala. Kodi mungatani ngati wosuta sakufuna kusonkhanitsa maselo, koma nthawi yomweyi akufuna kuti dzina likhalepo pakati pa tebulo? Pankhaniyi, palinso njira yotulukira.
- Sankhani mzere wa mzere pamwamba pa tebulo yomwe ili ndi mutu, monga momwe tachitira kale. Timasankha pachisankho kuti tiyitane mndandanda wazomwe timasankha mtengo "Sungani maselo ...".
- Muwindo lamapangidwe timasunthira ku gawolo. "Kugwirizana". Muwindo latsopano mumunda "Mwachilendo" sankhani mtengo kuchokera mndandanda "Kusankha kwa pakati". Klaatsay "Chabwino".
- Tsopano dzina lidzasonyezedwa pakati pa tebulo, koma maselo sangayanjane. Ngakhale kuti zikuoneka kuti dzinali lili pakati, adilesi yake yeniyeni ikufanana ndi adiresi yoyamba ya selo yomwe inalembedwa musanayambe njirayi.
Gawo 3: Kukonza
Tsopano ndi nthawi yopanga mutuwu kuti nthawi yomweyo amugwire diso ndipo amayang'ana ngati yowoneka bwino. Njira yosavuta yochitira izi ndi zipangizo zojambula tepi.
- Lembani mutuwu ponyani pa icho ndi mbewa. Chotsegulacho chiyenera kupangidwa chimodzimodzi kwa selo kumene dzina liripo, ngati kulumikizidwa ndi kusankha kwatchulidwa. Mwachitsanzo, ngati inu mutsegula pamalo omwe ali pa pepala limene dzina lanu likuwonetsedwa, koma simukuliwona mu barra yolozera, izi zikutanthauza kuti kwenikweni sizimene zili mu pepala.
Zingakhale zosiyana, pamene wosuta akuwonetsera selo yopanda kanthu, koma akuwona malemba omwe akuwonetsedwa mu bar. Izi zikutanthauza kuti kugwirizana ndi chisankho chagwiritsidwa ntchito ndipo makamaka dzina liri mu selo ili, ngakhale kuti silikuwonekeratu. Kuti machitidwe apangidwe apangidwe, mfundoyi iyenera kuwonetsedwa.
- Lembani dzinali molimba. Kuti muchite izi, dinani pa batani "Bold" (pictogram monga kalata "F") mu block "Mawu" mu tab "Kunyumba". Kapena mugwiritsire ntchito makina okhwima Ctrl + B.
- Kenaka mukhoza kuwonjezera kukula kwa maonekedwe a mutu womwe uli ndi malemba ena. Kuti muchite izi, sankhaninso selo kumene dzinali likupezeka. Dinani pa chithunzicho mwa mawonekedwe a katatu, komwe kuli kumanja kwa munda "Kukula kwake". Mndandanda wa maonekedwe a mazenera amatsegulidwa. Sankhani mtengo umene iwe mwini umapeza bwino pa tebulo lapadera.
- Ngati mukufuna, mutha kusintha dzina la mtundu wa machitidwe ku mtundu wina woyambirira. Timasintha pa malo a dzina. Dinani pa katatu kupita kumanja kwa munda "Mawu" mumalo omwewo mu tab "Kunyumba". Ikutsegula mndandanda wambiri wa mitundu ya mazenera. Dinani pa zomwe mukuganiza kuti ziri zoyenera.
Koma posankha mtundu wazenera muyenera kusamala. Zina zimangokhala zosayenera kuti zikhale zolemba zapadera.
Ngati mukufuna, mukhoza kupanga dzinali nthawi zonse: likhale lachilendo, lisinthe mtundu, gwiritsani ntchito mzere wozunzikirapo, etc. Timaima kokha pa zinthu zomwe zimagwiritsidwa ntchito mobwerezabwereza pamene mukugwira ntchito ku Excel.
PHUNZIRO: Ma tebulo opangira mu Microsoft Excel
Gawo 4: Kutseka dzina
Nthawi zina pamafunika kuti mutu ukhale wowoneka, ngakhale mutapukuta pansi tebulo lalitali. Izi zikhoza kuchitidwa ndi kusindikiza kapamwamba.
- Ngati dzina liri pamzere wapamwamba pa pepala, ndi kosavuta kuchita zomwe zimamanga. Pitani ku tabu "Onani". Dinani pazithunzi "Dinani m'dera". Mndandanda umene umatsegula, timayima pa chinthucho "Pinani mzere wapamwamba".
- Tsopano mzere wapamwamba wa pepala limene dzina lake liripo lidzakhazikika. Izi zikutanthauza kuti zidzawoneka ngakhale mutapita pansi pa tebulo.
Koma nthawi zonse dzina limayikidwa pamwamba pa pepala. Mwachitsanzo, pamwambapa tinalingalira chitsanzo pamene chinali pamzere wachiwiri. Kuwonjezera pamenepo, ndizosavuta ngati sizinalembedwe, komanso mutu wa tebulo. Izi zimapangitsa wogwiritsa ntchitoyo kuti apite nthawi yomweyo zomwe deta ili muzitsulo zimatanthauza. Kuti mugwirizanitse mgwirizanowu, muyenera kugwiritsa ntchito njira zosiyana.
- Sankhani selo lakumanzere pansi pa dera lomwe liyenera kukhazikitsidwa. Pankhaniyi, tidzakonza mutu ndi mutu wa tebulo nthawi yomweyo. Choncho, sankhani selo yoyamba pansi pa mutu. Pambuyo pake dinani pazithunzi "Dinani m'dera". Panthawi ino m'ndandanda, sankhani malo, omwe amatchedwa "Dinani m'dera".
- Tsopano mizere yokhala ndi dzina la tebulo ndi mutu wake idzaphatikizidwa pa pepala.
Ngati mukufunabe kukonza dzina lokha popanda kapu, ndiye kuti mukusankha selo yoyamba yotsala, yomwe ili pansi pa dzina, musanapite ku chipangizo cha pinning.
Zochitika zina zonse ziyenera kuchitidwa chimodzimodzi ndondomeko yomweyi, yomwe idatchulidwa pamwambapa.
PHUNZIRO: Mmene mungakonzere mutu mu Excel
Khwerero 5: Pangani mutu pa tsamba lirilonse.
Kawirikawiri zimafunika kuti mutu wa zolembedwazo uziwonekera pa masamba ake onse. Mu Excel, ntchitoyi ndi yophweka kwambiri. Pachifukwa ichi, dzina la chikalatacho liyenera kulowa kamodzi kokha, ndipo sikuyenera kulowetsedwa pa tsamba lirilonse. Chida chomwe chimathandiza kuti mwayiwu ukhale weniweni uli ndi dzina "Kupyolera mumzere". Kuti mutsirize mapangidwe a dzina la tebulo, ganizirani momwe mungasindikizire pa tsamba lirilonse.
- Pitani ku tabu "Kuyika". Timakani pa chithunzi "Tsambulani mutu"yomwe ili mu gulu "Makhalidwe a Tsamba".
- Ikugwira ntchito tsamba lokhazikitsa tsambalo mu gawo "Mapepala". Ikani cholozera mmunda "Kupyolera mumzere". Pambuyo pake, sankhani selo iliyonse yomwe ili pamzere umene mutu umayikidwa. Pachifukwa ichi, adiresi ya mzere wonse waperekedwa imagwera pazenera la window window parameters. Dinani "Chabwino".
- Kuti muone momwe mutuwo udzasonyezedwe mukasindikiza, pitani ku tabu "Foni".
- Pitani ku gawo "Sakani" pogwiritsa ntchito zida zoyendetsera kumanzere akumanzere. Mu mbali yolondola yawindo pali malo oyambirira a chilembacho. Tikuyembekezera pa tsamba loyamba tikuwona mutu wowonetsedwa.
- Tsopano tikufunikira kuyang'ana ngati dzina lidzawonetsedwa pamasamba ena osindikizidwa. Pogwiritsa ntchito izi, taya pansi mpukutuwo. Mukhozanso kulowa nambala ya tsamba lofunidwa mu tsamba lowonetsera pepala ndikusindikiza fungulo Lowani. Monga momwe mukuonera, pamapepala osindikizidwa ndi omwe amatsatira pambuyo pake mutuwu umasonyezanso pamwamba pa zomwe zikugwirizana. Izi zikutanthauza kuti ngati tipatula chikalata cholemba, ndiye tsamba lililonse lidzawonetsedwa.
Ntchitoyi popanga mutu wa chikalatacho ikhoza kuonedwa kuti ndi yangwiro.
Phunziro: Kusindikiza mutu pa tsamba lililonse mu Excel
Tsono, tatsata ndondomekoyi yolumikizira mutu wautchulidwe mu Excel. Zoonadi, izi zowonjezereka sizomwe zimaphunzitsidwa bwino, zomwe sizingatheke kusuntha chinthu chimodzi. M'malo mwake, pali zambiri zomwe mungachite kuti muchite. Makamaka njira zambiri zopangira dzina. Mukhoza kugwiritsa ntchito mitundu yosiyanasiyana ya maonekedwe. M'dera lino la ntchito, kuchepetsa malire ndi lingaliro chabe la wogwiritsa ntchito mwiniwake. Komabe, tawonetsa masitepe ofunika pakulemba mutu. Phunziroli, lomwe limatanthawuzira malamulo oyambirira, likusonyeza njira yomwe wogwiritsira ntchito angagwiritsire ntchito malingaliro awo.
