Mtundu wa cell mu Excel simalongosola maonekedwe a ziwonetserozo zokha, komanso umadziwitsanso pulogalamuyi momwe ziyenera kukonzedwa: monga malembedwe, manambala, tsiku, ndi zina zambiri. Chifukwa chake, ndikofunikira kukhazikitsa mwatsatanetsatane mkhalidwe womwe data ikalowe. Kupanda kutero, kuwerengetsa konse kungakhale kolakwika. Tiyeni tiwone momwe angasinthire mawonekedwe a maselo mu Microsoft Excel.
Phunziro: Kupanga zolemba mu Microsoft Mawu
Mitundu yayikulu yosinthira ndi kusintha kwawo
Nthawi yomweyo dziwani zamomwe mafomu amapanga. Pulogalamuyi ikuwonetsa kusankha imodzi mwanjira zazikulu zotsatirazi:
- General;
- Cash;
- Chiwerengero
- Zachuma;
- Zolemba
- Tsiku
- Nthawi;
- Zachifwamba;
- Chidwi;
- Zosankha.
Kuphatikiza apo, pali magawidwe m'magawo ang'onoang'ono amitundu iyi. Mwachitsanzo, mawonekedwe ndi nthawi yamafotokozedwe ake ali ndi masanjidwe angapo (DD.MM.YY., DD.months. YY, DD.M, Ch.MM PM, HH.MM, etc.).
Mutha kusintha masanjidwe amtundu mu Excel m'njira zingapo. Tilankhula za iwo mwatsatanetsatane pansipa.
Njira 1: mndandanda wanthawi zonse
Njira yodziwika kwambiri yosinthira mafayilo osiyanasiyana ndikugwiritsa ntchito menyu.
- Sankhani maselo omwe amafunika kupangidwe molondola. Dinani kumanja. Zotsatira zake, mndandanda wazikhalidwe umatsegulidwa. Mukuyenera kuyimitsa kusankha "Mtundu wamtundu ...".
- Tsamba losintha limayambitsa. Pitani ku tabu "Chiwerengero"ngati zenera lidatsegulidwa kwina. Ili m'parata "Mawerengero Amanambala" pali zosankha zonsezi pakusintha zomwe zidakambidwa pamwambapa. Sankhani chinthu chomwe chikugwirizana ndi zomwe zili mumtundu wosankhidwa. Ngati ndi kotheka, mbali yoyenera ya zenera ndi yomwe timazindikira zomwe zidasungidwa. Dinani batani "Zabwino".
Pambuyo pa izi, mawonekedwe amaselo amasinthidwa.
Njira yachiwiri: chida cha zida pa riboni
Makomedwe amatha kusinthidwa pogwiritsa ntchito zida zomwe zili pa tepi. Njira imeneyi ndi yachangu kwambiri kuposa yoyamba ija.
- Pitani ku tabu "Pofikira". Pankhaniyi, muyenera kusankha maselo oyenera pa pepalalo, ndi pazosintha "Chiwerengero" tsegulani bokosi losankha pa riboni.
- Ingopangani kusankha komwe mungakonde. Gawo pambuyo pake lisintha mawonekedwe ake.
- Koma mndandanda wokhazikitsidwa ndi mafomu akulu okha omwe amaperekedwa. Ngati mukufuna kufotokozera mitundu moyenera, sankhani "Makonda ena manambala".
- Pambuyo pazochita izi, zenera la kusanja mtunduwo lidzatsegulidwa, zomwe zidakambidwa kale pamwambapa. Wogwiritsa ntchito amatha kusankha mtundu uliwonse wamtundu waukulu kapena wowonjezera wa data.
Njira 3: Bokosi la Zida
Njira ina yokhazikitsira mawonekedwe amtunduwu ndikugwiritsa ntchito chida pazenera "Maselo".
- Sankhani masanjidwewo kuti alembedwe. Ali pa tabu "Pofikira"dinani pachizindikiro "Fomu"yomwe ili mgulu la chida "Maselo". Pamndandanda wazinthu zomwe zimatsegulira, sankhani "Mtundu wamtundu ...".
- Pambuyo pake, zenera lodziwika kale limayamba. Njira zina zonse ndizofanana ndendende zomwe tafotokozazi.
Njira 4: Otsuka
Pomaliza, zenera losintha losiyanasiyana limatha kuyitanidwa pogwiritsa ntchito makiyi otentha. Kuti muchite izi, sankhani malo osinthika pepalalo, kenako lembani zophatikizika pazikope Ctrl + 1. Pambuyo pake, zenera lojambula labwino lidzatsegulidwa. Timasintha machitidwe chimodzimodzi monga tanena pamwambapa.
Kuphatikiza apo, kuphatikiza kwa hotkey payokha kumakupatsani mwayi kusintha maselo mutasankha masheya popanda kuitana zenera lapadera:
- Ctrl + Shift + - - mawonekedwe onse;
- Ctrl + Shift + 1 manambala okhala ndi olekanitsa;
- Ctrl + Shift + 2 - nthawi (maola. mphindi);
- Ctrl + Shift + 3 - masiku (DD.MM.YY);
- Ctrl + Shift + 4 - ndalama;
- Ctrl + Shift + 5 - chidwi;
- Ctrl + Shift + 6 - mawonekedwe O.OOE + 00.
Phunziro: Ogula otentha
Monga mukuwonera, pali njira zingapo zosinthira magawo a worksheet ya Excel nthawi imodzi. Njirayi itha kuchitika pogwiritsa ntchito zida zomwe zili pa tepi, kuyimba fayilo ya fayilo, kapena kugwiritsa ntchito mafungulo otentha. Wogwiritsa aliyense amasankha yekha njira yomwe ingamuvute kuti athetse ntchito zinazake, chifukwa nthawi zina kugwiritsa ntchito mawonekedwe wamba kumakhala kokwanira, ndipo kwa ena, chizindikiritso chofunikira ndicholembetsedwa.
