Mu Microsoft Office Excel, mutha kuyika bokosi loyang'ana mu selo iliyonse ya tebulo. Ichi ndi chizindikiro chapadera mwa mawonekedwe a cheke, chopangidwa kuti chikongoletse gawo lililonse lazolemba, kuwunikira zinthu zofunika, ndikuyambitsa zolemba. Nkhaniyi ifotokoza njira zokhazikitsira chizindikiro mu Excel pogwiritsa ntchito zida zomwe zidapangidwa mu pulogalamuyi.
Momwe mungayang'anire bokosilo
Kuwona bokosi mu Excel ndikosavuta mokwanira. Ndichizindikirochi, kuwonekera ndi kukongola kwa chikalatacho kudzawonjezeka. Zambiri za izo zidzakambidwa pambuyo pake.
Njira 1: Gwiritsani Ntchito Zizindikiro Zokhazikika za Microsoft Excel
Excel, monga Mawu, ili ndi laibulale yake yazizindikiro zosiyanasiyana zomwe zitha kukhazikitsidwa paliponse patsamba lantchito. Kuti mupeze chizindikiro ndikuchiyika mu cell, muyenera kutsatira izi:
- Sankhani selo komwe mukufuna kuyika bokosi loyang'anira.
- Pitani ku gawo la "Insert" pamwamba pa menyu yayikulu.
- Dinani pa batani la "Zizindikiro" kumapeto kwa mndandanda wa zida.
- Pazenera lomwe limatsegulidwa, dinani pa "Symbol" njira kachiwiri. Menyu ya zithunzi zomangidwa idzatsegulidwa.
- M'munda wa "Set", tchulani njira "Makalata osintha malo", pezani cholembera pamndandanda wa magawo omwe aperekedwa, sankhani ndi LMB ndikudina mawu oti "Ikani" pansi pazenera.
- Onetsetsani kuti cholembera chayikidwa mu selo yolondola.
Tcherani khutu! Pali mitundu ingapo yamabokosi omwe ali m'gulu la zizindikiro. Chizindikirocho chimasankhidwa mwakufuna kwa wogwiritsa ntchito.
Njira 2. Kusintha zilembo
Zomwe zili pamwambazi ndizosankha. Chizindikiro cha bokosi chitha kulowetsedwa pamanja kuchokera pa kiyibodi ya pakompyuta posintha masanjidwe ake kukhala Chingerezi ndikudina batani la "V".
Njira 3. Kuwona bokosi kuti mutsegule bokosilo
Mwa kuyang'ana kapena kusayang'ana bokosi la cheke mu Excel, mutha kuyendetsa zolemba zosiyanasiyana. Choyamba muyenera kuyika bokosi loyang'ana patsamba lantchito poyambitsa makina opangira. Kuti muyike chinthu ichi, muyenera kuchita izi:
- Dinani pa "Fayilo" pakona yakumanzere kwa chinsalu.
- Pitani ku gawo la "Zikhazikiko".
- Pazenera lotsatira, sankhani kagawo ka "Ribbon Customization" kumanzere kwa chinsalu.
- Pamndandanda wa "Main tabu" pamndandanda, pezani mzere wa "Developer" ndikusankha bokosi pafupi ndi njirayi, kenako dinani "Chabwino" kuti mutseke zenera.
- Tsopano, pamndandanda wa zida zomwe zili pamwamba pa mndandanda waukulu wa pulogalamuyo, tabu ya "Developer" idzawonekera. Muyenera kulowamo.
- Pachida chogwirira ntchito, dinani batani la "Insert" ndipo mugawo la "Controls" la fomuyo, dinani chizindikiro cha bokosi.
- Mukamaliza masitepe am'mbuyomu, m'malo mwa cholozera cha mbewa, chithunzi chamtundu wa mtanda chidzawonetsedwa. Pakadali pano, wogwiritsa ntchito akuyenera kudina LMB pamalo pomwe fomuyo idzayikidwe.
- Onetsetsani kuti malo opanda kanthu akuwonekera mu cell mukadina.
- Dinani LMB pabwaloli, ndipo mbendera idzayikidwa mmenemo.
- Pafupi ndi bokosi loyang'ana mu selo padzakhala zolembedwa zokhazikika. Muyenera kusankha izo ndi akanikizire "Chotsani" kiyi pa kiyibodi kuchotsa izo.
Zofunika! Zolemba zokhazikika zomwe zili pafupi ndi chizindikiro chomwe chayikidwamo zitha kusinthidwa ndi zina zilizonse malinga ndi momwe wogwiritsa ntchito angafunire.
Njira 4. Momwe mungapangire bokosi lofufuzira kuti mugwiritse ntchito zolemba
Bokosi loyang'ana mu selo lingagwiritsidwe ntchito kuchitapo kanthu. Iwo. pa tsamba logwirira ntchito, patebulo, zosintha zidzapangidwa mutayang'ana kapena kutsitsa bokosilo. Kuti izi zitheke, muyenera:
- Tsatirani njira zomwe zili mugawo lapitalo kuti mulembe chizindikiro mu selo.
- Dinani LMB pa chinthu chomwe chayikidwa ndikupita ku menyu ya "Format Object".
- Pa "Control" mugawo la "Value", ikani chosinthira moyang'anizana ndi mzere womwe ukuwonetsa momwe bokosi lilili. Iwo. mwina m'munda wa "Installed" kapena mumzere wa "Remod".
- Dinani batani la Link to Cell pansi pa zenera.
- Tchulani selo limene wogwiritsa ntchito akufuna kugwiritsira ntchito malemba potembenuza bokosi loyang'ana ndikudinanso chizindikiro chomwechi.
- Pa menyu ya Format Object, dinani Chabwino kuti mugwiritse ntchito zomwe mwasintha.
- Tsopano, mutayang'ana bokosilo, mawu oti "CHOONADI" adzalembedwa mu selo losankhidwa, ndipo mutachotsa mtengo "FALSE".
- Chochita chilichonse chikhoza kuphatikizidwa ndi selo ili, mwachitsanzo, kusintha mtundu.
Zina Zowonjezera! Kumanga kwamitundu kumachitika mu "Format Cells" menyu pa "Dzazani" tabu.
Njira 5. Kuyika bokosi loyang'ana pogwiritsa ntchito zida za ActiveX
Njirayi ikhoza kukhazikitsidwa pambuyo poyambitsa njira yopangira mapulogalamu. Mwambiri, algorithm yochitira ntchito imatha kuchepetsedwa motere:
- Yambitsani developer mode monga tafotokozera pamwambapa. Malangizo atsatanetsatane anaperekedwa poganizira njira yachitatu yoikira mbendera. Ndi zopanda pake kubwereza.
- Dinani kumanja pa cell yokhala ndi sikweya yopanda kanthu komanso zolembedwa zokhazikika zomwe zidzawonekera mutalowa mu "Developer" mode.
- Sankhani "Properties" kuchokera ku menyu yankhani.
- Zenera latsopano lidzatsegulidwa, pamndandanda wa magawo omwe muyenera kupeza mzere wa "Value" ndikulowetsa pamanja mawu oti "Zowona" m'malo mwa "Zabodza".
- Tsekani zenera ndikuwona zotsatira. Cholembera chiyenera kuwonekera m'bokosilo.
Kutsiliza
Chifukwa chake, mu Excel, bokosi loyang'ana likhoza kukhazikitsidwa m'njira zosiyanasiyana. Kusankha njira yoyika zimadalira zolinga zomwe wogwiritsa ntchito amatsatira. Kungoyika chizindikiro ichi kapena chinthucho papiritsi, ndikwanira kugwiritsa ntchito njira yosinthira chizindikiro.