Nthawi zina pamakhala kuti mu chikalata muyenera kusintha mtundu umodzi (kapena gulu la otchulidwa) ndi wina. Pakhoza kukhala zifukwa zambiri, kuyambira kukulakwitsa pang'ono, ndikumaliza ndikusinthanso template kapena kuchotsa malo. Tiyeni tiwone momwe angasinthire msanga zilembo mu Microsoft Excel.
Momwe mungasinthire zilembo mu Excel
Inde, njira yosavuta yosinthira mawonekedwe ndi wina ndikusintha maselo. Koma, monga momwe zowonetserazi zikusonyezera, njirayi si njira yosavuta kwambiri matebulo akuluakulu, momwe kuchuluka kwa zofananira zomwe zimafunikira kusinthika kumatha kufikira ambiri. Ngakhale kupeza maselo oyenera kumatha kutenga nthawi yambiri, osatchulanso nthawi yomwe yatengedwa kuti ikonzedwe.
Mwamwayi, chida cha Excel chili ndi chida cha Pezani ndipo Chichotsereni chomwe chimakuthandizani kuti mupeze maselo omwe mumafunikira ndikuwathandizira kusintha.
Sakani ndi zina
Kusintha kosavuta ndikusaka kumafuna kusintha zilembo zingapo motsatizana komanso zosasinthika (manambala, mawu, zilembo, ndi zina) ndi izi pambuyo pazoti zilembozi zikapezeka pogwiritsa ntchito zida zapadera zopangidwira.
- Dinani batani Pezani ndikuwunikiraili pa tabu "Pofikira" mumazisungidwe "Kusintha". Pa mndandanda womwe uwoneka pambuyo pa izi, pitani ku chinthucho M'malo.
- Zenera limatseguka Pezani ndi Kusintha pa tabu M'malo. M'munda Pezani lembani manambala, mawu kapena zilembo zomwe mukufuna kupeza ndikusintha. M'munda "M'malo ndi" timayika zofunikira pazomwe zidzachitike.
Monga mukuwonera, pansi pazenera pali mabatani olowa m'malo - Sinthani Chilichonse ndi M'malo, ndi mabatani osaka - Pezani Zonse ndi "Pezani chotsatira". Dinani batani "Pezani chotsatira".
- Pambuyo pake, chikalatacho chimasakira mawu osakira. Mwakusintha, njira yakusaka imachitika mzere. Chopata chimayimilira pazotsatira zoyambirira zomwe zikufanana. Kuti musinthe zomwe zili mu foniyo, dinani batani M'malo.
- Kuti mupitilize kufunafuna deta, dinaninso batani "Pezani chotsatira". Momwemonso, timasintha zotsatira zotsatirazi, etc.
Mutha kupeza zotsatira zonse zomwe zakwaniritsa kufunsa kwanu nthawi yomweyo.
- Pambuyo polowera kusaka ndi zilembozo mmalo, dinani batani Pezani Zonse.
- Maselo onse oyenerera amafufuzidwa. Mndandanda wawo, womwe umawonetsa kufunikira ndi adilesi ya selo lililonse, amatsegula pansi pazenera. Tsopano mutha dinani iliyonse yamaselo omwe tikufuna kusintha, ndikudina batani M'malo.
- Mtengo wake udzasinthidwa, ndipo wogwiritsa ntchitoyo akhoza kupitiliza kufufuza zotsatira zakusaka kuti atsimikizire zotsatira zomwe akufuna pobwereza.
Chotsani Magalimoto
Mutha kusintha zokha ndi makina a batani limodzi. Kuti muchite izi, mutalowa mfundo zomwe ziyenera kusintha, ndi zomwe zikusinthidwa, dinani batani Sinthani Zonse.
Ndondomeko amachitidwa nthawi yomweyo.
Ubwino wa njirayi ndi kuthamanga komanso kosavuta. Chachikulu chachikulu ndikuti muwonetsetse kuti zilembo zomwe zalembedwazo zimasinthidwa m'maselo onse. Ngati munjira zam'mbuyomu zinali zotheka kupeza ndikusankha maselo ofunikira kuti musinthe, ndiye mukamagwiritsa ntchito njirayi, mwayi uwu suyikidwa pambali.
Phunziro: momwe mungasinthire mfundo ndi comma ku Excel
Zosankha zina
Kuphatikiza apo, pali kuthekera kwakusaka kwapamwamba ndikusinthidwa ndi magawo owonjezera.
- Kukhala mu "Replace" tabu, pawindo la "Pezani ndi Kusintha", dinani batani la Zosankha.
- Windo la zosankha zapamwamba limatseguka. Chimakhala chofanana ndi zenera lakutsogolo pakusaka. Kusiyanitsa ndiko kukhalapo kwa makina osungira. "M'malo ndi".
Pansi pake pazenera limakhala ndi mwayi wopeza zosowa zomwe ziyenera kusinthidwa. Apa mutha kukhazikitsa pomwe mungasake (patsamba kapena buku lonse) komanso momwe mungasankhire (mzere kapena mzere). Mosiyana ndi kusaka kwanthawi zonse, kusaka kwina kungachitike mwa njira zokha, ndiye kuti, mwa mfundo zomwe zikuwonetsedwa mu formula bar posankha foni. Kuphatikiza apo, poyang'ana kapena kutsitsa mabokosi, mutha kufotokoza ngati mungafufuze zilembo zodziwikiratu kapena ngati mungafune kufanana kwenikweni ndi maselo.
Komanso, muthanso kunena za maselo omwe kusaka kudzachitika. Kuti muchite izi, dinani batani la "Format" moyang'anizana ndi "Pezani" paramu.
Pambuyo pake, zenera lidzatsegulidwa momwe mungatchule mtundu wa maselo kuti mufufuze.
Makonda okhawo omwe phindu liziikidwamo lidzakhala mtundu womwewo. Kuti musankhe mtundu wa mtengo womwe udalowetsedwa, dinani batani lomwe lili ndi dzina lomwelo moyang'anizana ndi chizindikiro "Replace with ...".
Zenera lomweli limatseguka monga momwe zinalili kale. Izi zimayikira momwe maselo adzapangidwira pambuyo pakusintha deta yawo. Mutha kukhazikitsa mayendedwe, mawonekedwe amitundu, mtundu wa khungu, malire, ndi zina zambiri.
Komanso, mwa kuwonekera pa chinthu chofananira kuchokera mndandanda wotsika pansi pa batani "Fomu", mutha kukhazikitsa mtundu wofanana ndi foni iliyonse yosankhidwa papepala, ingosankha.
Chosaka chowonjezera chingakhale chidziwitso cha maselo omwe maselo omwe adzafufuze ndi kulowezedwa akhoza kuchitika. Kuti muchite izi, ingosankha mitundu yomwe mukufuna.
- Musaiwale kuyika mfundo zoyenera m'minda ya "Pezani" ndi "M'malo ndi ...". Pomwe zoikamo zonse zikusonyezedwa, timasankha njira ya njirayi. Ikani dinani batani la "Sinthani Zonse", ndipo malowedwewo amangochitika, malinga ndi zomwe zalowetsedwazo, kapena dinani batani la "Pezani Zonse", ndikusintha maselo ena amtundu uliwonse molingana ndi algorithm yomwe tafotokozazi.
Phunziro: Momwe mungafufuzire ku Excel
Monga mukuwonera, Microsoft Excel imapereka chida chogwira ntchito komanso chothandiza kupeza ndikusintha deta m'matafura. Ngati mukufunikira kusintha mtundu wamitundu yonse ndi mtundu winawake, izi zitha kuchitika ndikukanikiza batani limodzi lokha. Ngati kusankhaku kuyenera kuchitika mwatsatanetsatane, ndiye kuti izi zimaperekedwa kwathunthu mu purosesa iyi.
