Nthawi zina mukamagwira ntchito ndi matebulo, mumayenera kuyika mawu mu foni molunjika, m'malo mozungulira, monga momwe zimakhalira. Izi zimaperekedwa ndi Excel. Koma sikuti wogwiritsa ntchito aliyense amadziwa momwe angagwiritsire ntchito. Tiyeni tiwone njira zomwe mu Excel mungalembe mawu molunjika.
Phunziro: Momwe mungalembe molunjika pa Microsoft Mawu
Kulemba mbiri molondola
Nkhani yakuthandizira kujambula kwa vertiki mu Excel yathetsedwa pogwiritsa ntchito zida zopangira. Koma, ngakhale izi, pali njira zosiyanasiyana zochitira izi.
Njira 1: kugwirizanitsa kudzera pazosankha
Nthawi zambiri, ogwiritsa ntchito amakonda kupangidwira matchulidwe ndi kuwonekera pazenera. Mtundu Wa Cellkomwe mungathe kudutsa pazosankha.
- Timadina kumanja komwe kuli komwe kuli, komwe tiyenera kumasulira molunjika. Pazosankha zomwe zikutsegulidwa, sankhani Mtundu Wa Cell.
- Zenera limatseguka Mtundu Wa Cell. Pitani ku tabu Kuphatikiza. Gawo lamanja la zenera lotseguka pali cholepheretsa Zochita. M'munda "Zochita" mtengo wokhazikika ndi "0". Izi zikutanthauza kulunjika kwa malembawo mu maselo. Sungani mtengo "90" m'munda uno pogwiritsa ntchito kiyibodi.
Muthanso kuchita zosiyana pang'ono. Mu "zilembo" zaku blockpo pali mawu "Zolemba". Dinani pa icho, gwiritsani batani lakumanzere ndikulikoka mpaka liwu litatenga malo ofukula. Ndiye kumasula batani la mbewa.
- Pambuyo mawonekedwe omwe afotokozedwa pamwambapa apangidwa pazenera, dinani batani "Zabwino".
Monga mukuwonera, zitatha izi, mbiri mu foni yosankhidwa yakhala yoima.
Njira 2: zochita pa tepi
Ndikosavuta kupangitsa mawu kukhala omasukirapo - gwiritsani ntchito batani lapadera pa riboni, lomwe ogwiritsa ntchito ambiri amadziwa kupatula pazenera.
- Sankhani khungu kapena mtundu womwe tikukonzekera kuyikapo chidziwitso.
- Pitani ku tabu "Pofikira"ngati pakadali pano tili pawebusayiti ina. Pa nthiti yomwe ili m'bokosi la chida Kuphatikiza dinani batani Zochita. Pamndandanda womwe umatsegulira, sankhani Kwezani mawu.
Pambuyo pa izi, malembedwe omwe ali mu khungu losankhidwa kapena mtundu amawonetsedwa.
Monga mukuwonera, njirayi ndiyabwino kwambiri kuposa yoyamba, koma, imagwiritsidwa ntchito kangapo. Aliyense amene amakonda kuchita njirayi kudzera pazenera lopangidwe, ndiye kuti mutha kupita ku tsamba lolingana kuchokera pa tepi. Kuti tichite izi, kukhala tabu "Pofikira", ingodinani chizindikiro pachimodzimodzi muvi wopindika, womwe umapezeka pakona yakumanja kwa gulu la zida Kuphatikiza.
Pambuyo pake zenera lidzatsegulidwa Mtundu Wa Cell ndi zina zonse zomwe ogwiritsa ntchito akuyenera kukhala zofanana ndendende ndi njira yoyamba. Ndiye kuti, ndikofunikira kuwongolera zida zomwe zili mu block Zochita pa tabu Kuphatikiza.
Ngati mukufuna kuti masanjidwewo akhale okhazikika, pomwe zilembozo zili pamalo oyenera, izi zimachitidwanso pogwiritsa ntchito batani Zochita pa tepi. Dinani batani ili ndikusankha zomwe zili mndandanda zomwe zikuwoneka. Zolemba kumbuyo.
Pambuyo pa izi, malembawo amakhala m'malo oyenera.
Phunziro: Kukhazikitsa matebulo ku Excel
Monga mukuwonera, pali njira ziwiri zikuluzikulu zosinthira makonda anu: kudzera pazenera Mtundu Wa Cell komanso kudzera batani Kuphatikiza pa tepi. Kuphatikiza apo, njira zonsezi zimagwiritsa ntchito makina ofanana. Kuphatikiza apo, muyenera kudziwa kuti pali njira ziwiri zakusanja kwa zinthu zomwe zili m'selo: makulidwe amakalata ndi makonzedwe ofananawo amawu. M'mawu omaliza, zilembozi zimalembedwa m'malo omwe amakhala, koma mzere.
