Momwe mungayikitsire bokosi mu Excel

Nthawi zambiri, pogwira ntchito ndi zikalata za spreadsheet, zimakhala zofunikira kukhazikitsa cholembera pamalo enaake pamalo ogwirira ntchito. Njirayi imachitidwa pazifukwa zosiyanasiyana: kusankha kwa chidziwitso chilichonse, kuphatikizapo ntchito zowonjezera, ndi zina zotero. M'nkhaniyi tiona mwatsatanetsatane njira zingapo zochitira izi.

Kukhazikitsa bokosi lofufuzira mu chikalata cha spreadsheet

Pali njira zambiri zomwe zimakulolani kuti mugwiritse ntchito choyika bokosi mu chikalata cha spreadsheet. Musanakhazikitse bokosi lokhalo, muyenera kusankha zomwe chizindikirocho chidzagwiritsidwe ntchito.

Njira Yoyamba: Kuyika Chizindikiro Pogwiritsa Ntchito Chida cha Chizindikiro

Ngati wogwiritsa ntchito akufuna kugwiritsa ntchito bokosi loyang'anira kuti alembe zidziwitso zina, ndiye kuti akhoza kugwiritsa ntchito batani la "Symbol" lomwe lili pamwamba pa cholembera chaspredishiti. Malangizo atsatanetsatane amawoneka motere:

1. Sunthani cholozera kumalo omwe mukufuna ndikudina ndi batani lakumanzere. Timapita ku gawo la "Insert". Timapeza chipika cha malamulo "Zizindikiro" ndikudina "Symbol" LMB.

2. Zenera lokhala ndi dzina "Symbol" lidawonekera pachiwonetsero. Nawu mndandanda wa zida zosiyanasiyana. Timafunikira gawo la "Symbol". Wonjezerani mndandanda pafupi ndi mawu akuti "Font:" ndikusankha font yoyenera. Wonjezerani mndandanda pafupi ndi mawu akuti "Ikani:" ndikusankha "Makalata osintha malo" pogwiritsa ntchito batani lakumanzere. Pano tikupeza chizindikiro “˅”. Timasankha chizindikiro ichi. Pagawo lomaliza, dinani kumanzere pa batani la "Insert" lomwe lili pansi pa zenera la "Symbol".

3. Okonzeka! Tawonjeza cholembera kumalo osankhidwa kale.

Mwa njira yofananira, mutha kugwiritsa ntchito kuwonjezera zizindikiro zina zomwe zimakhala ndi mawonekedwe osiyanasiyana. Kupeza nkhupakupa zina ndikosavuta. Kuti muchite izi, tsegulani mndandanda womwe uli pafupi ndi mawu akuti "Font:" ndikusankha mawonekedwe a Wingdings. Mitundu yambiri yazizindikiro idzawonekera pazenera. Timapita pansi kwambiri ndikupeza mitundu ingapo ya ma jackdaw. Sankhani mmodzi wa iwo, ndiyeno dinani kumanzere mbewa batani "Pata".

Chizindikiro chosankhidwa chawonjezedwa kumalo osankhidwa kale.

Njira yachiwiri: kusintha zilembo mumkonzi wa spreadsheet

Kwa ogwiritsa ntchito ena, zilibe kanthu kaya chikalatacho chimagwiritsa ntchito cheke chenicheni kapena chizindikiro chofanana ndi chomwe chimagwiritsidwa ntchito m'malo mwake. M'malo mowonjezera daw nthawi zonse kumalo ogwirira ntchito, amaika chilembo "v", chomwe chili pamakina a Chingerezi. Izi ndizothandiza kwambiri, chifukwa njira iyi yokhazikitsira bokosilo imatenga nthawi yochepa. Kunja, kusintha kwa chizindikiro koteroko kumakhala kovuta kuzindikira.

Njira Yachitatu: Kuonjezera Bokosi Loyang'ana pa Bokosi

Kuti mugwiritse ntchito zolemba zina mu chikalata cha spreadsheet pogwiritsa ntchito cheke, njira zovuta kwambiri zimagwiritsidwa ntchito. Poyamba, muyenera kukhazikitsa checkbox. Kuti muwonjezere chinthu ichi, muyenera kuyambitsa menyu yotsitsa. Malangizo atsatanetsatane amawoneka motere:

1. Pitani ku chinthu "Fayilo". Dinani pa "Zikhazikiko" chinthu ili m'munsi kumanzere kwa zenera.

2. Pazenera lomwe limatchedwa "Excel Option". Timasunthira ku gawo la "Riboni zoikamo" Kumanja kwa zenera, ikani cholembera pafupi ndi mawu akuti "Developer". Mukamaliza njira zonse, dinani batani lakumanzere pa "Chabwino".
3. Okonzeka! Pa riboni ya zida, gawo lotchedwa "Developer" linatsegulidwa.

4. Timapita ku gawo lomwe lawonekera "Developer". Mu chipika cha malamulo "Controls" timapeza batani "Ikani" ndikudina ndi batani lakumanzere. Mndandanda wawung'ono wa zithunzi wawululidwa. Timapeza chipika "Form Controls" ndikusankha chinthu chotchedwa "Checkbox".

5. Cholozera chathu chatenga mawonekedwe ang'onoang'ono kuphatikiza chizindikiro cha mthunzi wakuda. Timasindikiza chizindikiro ichi pa malo a pepala lomwe tikufuna kuwonjezera fomu.

6. Bokosi lopanda kanthu lawonekera pamalo ogwirira ntchito.

7. Kuti muyike cholembera mkati mwa bokosilo, muyenera kungodina batani lakumanzere pa chinthuchi.

8. Zimachitika kuti wogwiritsa ntchito ayenera kuchotsa zolembedwa zomwe zili pafupi ndi bokosi loyang'anira. Mwachikhazikitso, zolembedwazi zimawoneka ngati: "Mbendera_nambala". Kuti mugwiritse ntchito kufufuta, dinani kumanzere pa chinthucho, sankhani zolembedwa zosafunikira, kenako dinani "Chotsani". M'malo molemba zomwe zachotsedwa, mutha kuwonjezera zina kapena kusiya malo opanda kanthu.

9. Pali nthawi zina pamene, pogwira ntchito ndi chikalata cha spreadsheet, m'pofunika kuwonjezera mabokosi ambiri. Simufunikanso kuyika bokosi lanulanu pamzere uliwonse. Njira yabwino ndikutengera bokosi lomalizidwa. Timasankha bokosi lomalizidwa, ndiyeno, pogwiritsa ntchito batani lakumanzere, timakokera chinthucho kumunda womwe tikufuna. Popanda kumasula batani la mbewa, gwirani "Ctrl", ndikumasula mbewa. Timagwiritsa ntchito njira yomweyo ndi ma cell ena omwe tikufuna kuwonjezera chizindikiro.

Njira Yachinayi: Kuwonjezera Bokosi Loyang'anira Kuti Muyambitse Script

Mabokosi amawu akhoza kuwonjezeredwa kuti mutsegule zochitika zosiyanasiyana. Malangizo atsatanetsatane amawoneka motere:

1. Timagwiritsa ntchito kupanga bokosi loyang'anira pogwiritsa ntchito malangizo omwe ali pamwambapa.
2. Timatcha menyu yankhani ndikudina chinthucho "Format Object ...".

3. Pazenera lomwe likuwoneka, pitani ku gawo la "Control". Timayika chizindikiro pafupi ndi mawu akuti "kuikidwa". Timadina LMB pachithunzi chomwe chili pafupi ndi mawu akuti "Kulumikizana ndi cell."

4. Timasankha selo pa tsamba la ntchito lomwe tikukonzekera kulumikiza bokosi loyang'anira ndi bokosi loyang'anira. Mukamaliza kusankha, dinani batani ngati chithunzi.

5. Pazenera lomwe likuwoneka, dinani "Chabwino".

6. Okonzeka! Ngati pali cholembera mubokosi loyang'anira, ndiye kuti mtengo wa "CHOONADI" ukuwonetsedwa mu cell yolumikizidwa. Ngati bokosi loyang'ana silinatsatidwe, ndiye kuti mtengo wa "FALSE" udzawonetsedwa mu selo.

Njira Yachisanu: Kugwiritsa Ntchito Zida Za ActiveX

Malangizo atsatanetsatane amawoneka motere:

1. Timapita ku gawo la "Developer". Mu chipika cha malamulo "Controls" timapeza batani "Ikani" ndikudina ndi batani lakumanzere. Mndandanda wawung'ono wa zithunzi wawululidwa. Timapeza chipika "ActiveX Controls" ndikusankha chinthu chotchedwa "Checkbox".

2. Cholozera chathu chatenga mawonekedwe ang'onoang'ono kuphatikiza chizindikiro cha mthunzi wakuda. Timasindikiza chizindikiro ichi pa malo a pepala lomwe tikufuna kuwonjezera fomu.

3. Dinani pa cheke cha RMB ndikusankha chinthu cha "Properties".

4. Timapeza chizindikiro "Value". Sinthani chizindikiro "Zabodza" kukhala "Zowona". Dinani pamtanda pamwamba pa zenera.

5. Okonzeka! Bokosilo lawonjezedwa kubokosilo.

Kutsiliza

Tinapeza kuti pali njira zambiri zogwiritsira ntchito kuwonjezera chizindikiro kumalo ogwirira ntchito a spreadsheet. Wogwiritsa ntchito aliyense azitha kusankha njira yabwino kwambiri kwa iye yekha. Zonse zimadalira zolinga ndi zolinga zomwe wogwiritsa ntchito amagwiritsa ntchito polemba spreadsheet.