Zizindikiro zolowa m'malo

Pali zochitika mukakhala mu chikalata chomwe muyenera kusintha mawonekedwe (kapena gulu la otchulidwa) kupita lina. Zifukwa zake zimakhala zokhazikika, kuyambira cholakwika choletsa, ndipo, kutha ndi template yakutali kapena kuchotsa mipata. Tiyeni tiwone momwe mungasinthire zilembozo mu Microsoft Excel.

Njira zosinthira zilembo

Zachidziwikire, njira yosavuta yosinthira munthu wina kupita ku zina ndi ma cell a m'matumbo. Koma, monga momwe zimawonetsera, osati njira nthawi zonse izi ndizosavuta kwambiri pamagome akuluakulu, komwe chiwerengero cha otchulidwa chomwe chikufunika kusinthidwa chimatha kukhala zochuluka kwambiri. Ngakhale kusaka maselo oyenera kumatha nthawi yayitali, osatchula nthawi yogwiritsidwa ntchito pokonza aliyense wa iwo.

Mwamwayi, pulogalamu ya Excel ili ndi "Pezani ndi kusinthana" chida, chomwe chingathandize kupeza bwino maselo ofunikira, ndipo adzalowa m'malo mwake.

Sakani ndi m'malo mwake

Kusintha kosavuta ndikusaka komwe kumapangitsa kuti zilembo chimodzi ndi zilembedwe (manambala, mawu, zizindikiro, zina) zina pambuyo pake zomwe zilembozo zidzapezeka pogwiritsa ntchito pulogalamu yapadera yopangidwa.

1. Dinani pa batani "Pezani ndikuwonetsa", yomwe ili mu "kunyumba" pokonza zosintha. M'ndandanda womwe unawonekera pamndandandawu, timasinthiratu kuti 'tisinthe' kulowa m'malo ".



2. "Pezani ndi kusintha" zenera "limatsegulidwa m'malo mwa tabu. Mu "gawo", timalowa chiwerengerochi, mawu kapena zizindikiritso zomwe mukufuna kupeza ndikusintha. Mu "m'malo mwa" munda, pititsani zolowa za data zomwe zidzasinthidwe.

   Monga mukuwonera, pansi pazenera pali mabatani osintha - "Sinthani chilichonse" ndi "kusintha mabatani", kupeza "zonse" ndi "Pezani lotsatira". Dinani pa batani "Pezani".



3. Pambuyo pake, kusaka chikalatacho kumafunikira. Mwa kusasinthika, malangizo osakira amapangidwa. Cumbero limayima pazotsatira zoyambirira zomwe zinagwirizana. Kusintha zomwe zili mu cell, dinani batani la "Sinthani".



4. Kuti mupitilize kusaka deta, timadina batani "Pezani". Momwemonso, timasintha zotsatirazi, ndi zina.

Mutha kupeza zotsatira zonse zosangalatsa zotsatira nthawi yomweyo.

1. Pambuyo polowa funso lofufuza ndikusintha zilembo, dinani pa batani "Pezani" zonse ".



2. Sakani ma cell onse oyenerera. Mndandanda wawo momwe mtengo umasonyezera ndipo adilesi ya selo iliyonse, imatsegulira pansi pazenera. Tsopano mutha kudina pa maselo aliwonse omwe tikufuna m'malo mwake, ndikudina batani la "Sinthani".



3. Kusintha mtengo wake, ndipo wogwiritsa ntchitoyo akhoza kupitilizabe kupitilizabe kusaka zotsatira zake kuti mukonzenso.

Zosintha zokha

Mutha kusintha makina osindikizira batani limodzi. Kuti muchite izi, atalowa mu mfundo zosinthidwa, ndi zomwe zimayendetsedwa ndi zomwe zimasinthidwa, dinani batani "batani lonse.

Njirayi imachitidwa pafupifupi nthawi yomweyo.

Ubwino wa njirayi - kuthamanga ndi mosavuta. MUNTHU yayikulu ndikuti muyenera kuonetsetsa kuti zilembo zomwe zalowetsedwa zimayenera kusinthidwa m'maselo onse. Ngati m'mbuyomu momwe zidatheka kupeza ndikusankha maselo ofunikira kuti asinthe, ndiye kuti mwayiwu, mwayi suwapatula.

Phunziro: Momwe Mungasinthire mfundoyo pa Comma mu Excel

Zosankha Zowonjezera

Kuphatikiza apo, pamakhala kusaka kowonjezereka ndikusinthanso magawo owonjezera.

1. Kukhala mu "Sinthani" tabu, mu "mu" kupeza ndi kusintha "zenera, dinani batani la magawo.



2. Tsegulani zenera la magawo owonjezera. Zimakhala zofanana ndi zenera lakusaka. Kusiyanitsa kokha ndiko kukhalapo kwa makonda "m'malo".

   

   Pansi lonse lazeneraili ndi udindo wofufuza deta, m'malo mwake iyenera kuchitidwa. Apa mutha kukhala, komwe mungafufuze (pa pepala kapena buku lonse) ndi momwe mungafufuze (ndi mzere kapena mzati). Mosiyana ndi kusaka kwanthawi zonse, kusaka kosinthidwa kumatha kuchitidwa ndi njira zokhazokha, ndiye kuti, zomwe zimafotokozedwa mu mzere wa ma form pakasankhidwa. Kuphatikiza apo, nthawi yomweyo, pokhazikitsa kapena kuchotsa mabokosi, ndingatchule ngati mungaganizire mukafufuza nkhani ya makalata, yang'anani molondola maselo.

   Komanso mutha kutchula pakati pa maselo omwe adzafufuzidwe. Kuti muchite izi, dinani pa batani la "Fomu" moyang'anizana ndi "Pezani".

   

   Pambuyo pake, zenera lidzatseguka pomwe mutha kutchula mtundu wa maselo osakira.

   

   Kukhazikika kokha kwa mtengo wolowera kudzakhala mtundu womwewo. Kuti tisankhe mtundu wa mtengo woyikidwa, timadina batani la dzina lomwelo moyang'anizana ndi "Sinthani ..." Nthamba.

   

   Imatsegulanso zenera lomwelo monga momwe zidayambira kale. Imakhazikitsidwa momwe ma cell amapangidwira pambuyo pokonza deta yawo. Mutha kuyimilira, mitundu ya nomeric, mtundu wa maselo, malire, etc.

   

   Komanso, podina chinthu choyenera kuchokera pamndandanda wotsika pansi pa batani la "Fomu", mutha kukhazikitsa mawonekedwe ndi khungu lililonse losankhidwa papepala, ndikokwanira kufotokoza.

   

   Pulogalamu yowonjezera yofufuzira ikhoza kukhala chizindikiro cha maselo, omwe adzasankhidwa ndikusinthidwa. Mwa izi, ndikokwanira kungowonetsa momwe mungafunire pamanja.

3. Musaiwale m'munda "pezani" ndikuti "m'malo mwake ..." kuti mulowetse zofanana. Makonda onse akatchulidwa, sankhani njira yopulumutsira. Kanikizani batani la "Sinthanitsani batani la" Lowetsani ", ndipo kulowetsedwa kumachitika zokha, molingana ndi data yomwe yalowa, kapena dinani pa batani"

Phunziro: Momwe Mungafufuze pa Excel

Monga mukuwonera, Microsoft Excel imapereka chida chogwirira ntchito bwino komanso chosavuta pakusaka ndi kusinthanitsa deta m'matebulo. Ngati mukufuna kusintha kwathunthu mtundu womwewo ndi mawu enieni, ndiye kuti izi zitha kuchitika potengera batani limodzi lokha. Ngati zitsanzo ziyenera kuchitika mwatsatanetsatane, ndiye kuti izi zimaperekedwa kwathunthu mu processor iyi.