Pali zochitika pamene chikalatacho chiyenera kusintha malo amodzi (kapena gulu la anthu) ndi wina. Zifukwa zikhoza kukhala zambiri, kuyambira pa cholakwika cha banal, ndi kutha ndi kusintha kwa template kapena kuchotsa malo. Tiyeni tiwone momwe tingatengere mwatsatanetsatane malemba mu Microsoft Excel.
Njira zothetsera olemba mu Excel
Inde, njira yosavuta yosinthira chikhalidwe chimodzi ndi wina ndikusintha maselo. Koma, monga momwe chiwonetsero chikuwonetsera, njira iyi ili kutali ndi nthawi zonse zosavuta m'ma tebulo akuluakulu, kumene chiwerengero cha mafananidwe ofanana omwe akufunika kusintha kuti chifike pamtunda chikhoza kufika pa nambala yaikulu kwambiri. Ngakhale kufufuza kwa maselo oyenerera kungathe kukhala nthawi yochuluka, osatchula nthaŵi yomwe yathera pokonza aliyense wa iwo.
Mwamwayi, Excel ali ndi Chida Chopeza ndi Chotsatira mu pulogalamu yomwe idzakuthandizani mwamsanga kupeza maselo omwe mukusowa ndikusintha malemba omwe ali nawo.
Bwerezani kufufuza
Kusintha kosavuta ndi kufufuza kumaphatikizapo kusiya malo amodzi omwe akutsatiridwa ndi osankhidwa (nambala, mawu, zilembo, ndi zina zotero) ndi wina pambuyo pamasewerowa akupezeka pogwiritsa ntchito chida chapadera cha pulogalamuyo.
- Dinani pa batani "Pezani ndi kuonetsa"yomwe ili pa tabu "Kunyumba" mu bokosi lokhalamo Kusintha. Mndandanda umene umapezeka pambuyo pa izi timasintha pa chinthucho "Bwezerani".
- Window ikutsegula "Pezani ndi kusintha" mu tab "Bwezerani". Kumunda "Pezani" lowetsani nambala, mawu kapena zilembo zomwe mukufuna kuzipeza ndikuzilemba. Kumunda "Bwezerani ndi" onetsani deta, yomwe idzalowe m'malo.
Monga mukuonera, pansi pawindo pali mabatani obwezeretsa - "Bwezerani Zonse" ndi "Bwezerani", ndi kufufuza mabatani - "Pezani Zonse" ndi "Pezani zotsatira". Timakanikiza batani "Pezani zotsatira".
- Pambuyo pake, kufufuza kumachitika pa chilemba cha mawu ofunidwa. Mwachindunji, njira yowusaka imayendetsedwa ndi mzere. Tsitsilo likuima pa zotsatira zoyambirira zomwe zikufanana. Kuti mutengere zomwe zili mu selo, dinani pa batani "Bwezerani".
- Kuti mupitirize kufufuza deta, dinani kachiwiri pa batani. "Pezani zotsatira". Mofananamo, timasintha zotsatira zotsatira, ndi zina zotero.
Mukhoza kupeza zotsatira zonse zokhutiritsa mwakamodzi.
- Pambuyo polowera funso lofufuzira ndikusintha malembawo dinani pa batani "Pezani Zonse".
- Kufufuza kwa maselo onse ofunika. Mndandanda wawo, momwe mtengo ndi adiresi ya selo iliyonse amasonyezedwa, imatsegula pansi pazenera. Tsopano mukhoza kutsegula pa selo lililonse limene tikufuna kuti tithetsemo, ndipo dinani pa batani "Bwezerani".
- Kusintha mtengo kudzakwaniritsidwa, ndipo wogwiritsa ntchito akhoza kupitiriza kufufuza zotsatira pofufuza zotsatira zomwe zafunidwa kuti chichitike.
Kusintha kwina
Mukhoza kumangotengeka pokhapokha mutasindikiza batani limodzi. Kuti muchite zimenezi, mutalowa m'malo mwazolowera, ndizolowera m'malo, pindani pakani "Bwezerani Zonse".
Ndondomekoyi imachitidwa pafupifupi nthawi yomweyo.
Ubwino wa njira iyi ndiwowuluma komanso wothandiza. Chosavuta chachikulu ndi chakuti muyenera kutsimikiza kuti zilembo zolembedwera ziyenera kusinthidwa m'ma maselo onse. Ngati mwa njira zam'mbuyomu munali mwayi woti mupeze ndi kusankha maselo ofunika kusintha, ndikugwiritsa ntchito njirayi.
PHUNZIRO: Momwe mungayankhire choyimira chonse ndi comma mu Excel
Zosintha zamakono
Kuonjezerapo, pali kuthekera kwa kufufuza kwapamwamba ndi malo m'malo ena owonjezera.
- Mu "Bwezerani" tab, mu "Tsambulani ndi Kuikapo" mawindo, dinani pa batani la Parameters.
- Mawindo apamwamba apamwamba amatsegulira. Icho chiri pafupifupi chofanana ndi zenera lapamwamba lofufuzira. Kusiyana kokha ndiko kukhalapo kwa zoikidwiratu. "Bwezerani ndi".
Zonse pansi pazenera ndizofunika kupeza deta yomwe ikuyenera kuti ikhale m'malo. Pano mukhoza kukhazikitsa komwe mungayang'ane (pa pepala kapena m'buku lonse) ndi momwe mungafufuzire (ndi mizera kapena ndi ndondomeko). Mosiyana ndi kafukufuku wowonongeka, kufufuza kwa malo osankhidwa kungatheke pokhapokha ndi ma formula, ndiko kuti, ndi zikhalidwe zomwe zimasonyezedwa mu bar barini pamene selo lasankhidwa. Kuonjezera apo, pomwepo, poika kapena kutsegula mabotolo osatsegula, mungathe kufotokozera ngati mukufuna kufufuza mndandanda wa makalata, kaya muyang'ane mndandanda womwewo mu maselo.
Ndiponso, mungathe kufotokoza pakati pa maselo omwe mtunduwo udzafufuzidwa. Kuti muchite izi, dinani pa batani "Format" moyang'anizana ndi "Fufuzani" parameter.
Pambuyo pake mawindo adzatsegulidwa kumene mungathe kufotokozera mtundu wa maselo kuti afufuze.
Chikhazikitso chokha cholowetsa chidzakhala chimodzimodzi selo. Kusankha mtundu wa mtengo woyikidwa, dinani pa batani la dzina lofanana ndi "Patsani ndi ...".
Zimatsegula ndendende yomweyo mawindo monga momwe zinalili kale. Ikuyika momwe maselo adzapangidwira atasintha deta yawo. Mukhoza kukhazikitsa malingaliro, mafomu a nambala, mtundu wa selo, malire, ndi zina zotero.
Ndiponso podalira chinthu chofananacho kuchokera pazitsitsimutso pansi pa batani "Format", mukhoza kuyika mawonekedwe kuti akhale ofanana ndi selo iliyonse yosankhidwa pa pepala, yokwanira kuti muisankhe.
Kuonjezera kwina kosakayika kungakhale chizindikiro cha maselo osiyanasiyana, pakati pawo komwe kufufuza ndi kubwezeretsedwa kudzachitika. Kuti muchite izi, mungosankha zokhazokha.
- Musaiwale kulowetsa zoyenera mu "Fufuzani" ndi "Bweretsani ndi ..." minda. Pamene zochitika zonse zikufotokozedwa, sankhani njira yopangira ndondomekoyi. Koperani pa batani "Bwezerani zonse", ndipo malo omwe amalowekera amachokera mwachindunji, malinga ndi deta yomwe imalowa, kapena dinani pa batani "Pezani zonse", ndipo pokhapokha timapanganso m'malo mu selo lirilonse molingana ndi ndondomeko yomwe inalembedwa pamwambapa.
PHUNZIRO: Mungachite bwanji kufufuza mu Excel
Monga mukuonera, Microsoft Excel imapereka chida chothandiza komanso chothandiza kupeza ndi kusintha deta m'matawuni. Ngati mukufunikira kuti mutenge malo onse omwe ali osagwirizana ndi mawu ena, izi zingatheke pokhapokha mukakanikiza batani limodzi. Ngati chitsanzochi chiyenera kuchitidwa mwatsatanetsatane, ndiye kuti mwayiwu waperekedwa mokonzedweratu.
