Chotsani Mpangidwe mu Microsoft Excel

Kugwira ntchito ndi ma formula mu Excel kumakupatsani inu kuchepetsa ndi kupanga zochita zosiyanasiyana. Komabe, sikuti nthawi zonse kuli kofunikira kuti zotsatira zikhale zogwirizana ndi mawuwo. Mwachitsanzo, ngati mutasintha maulendo okhudzana ndi maselo ofanana, zotsatira zake zidzasintha, ndipo nthawi zina izi sizikufunika. Kuwonjezera apo, pamene mutumiza tebulo lokopedwa ndi mayendedwe kumalo ena, ziyeso zingakhale "zotayika". Chifukwa china chozibisa izo ndi momwe inu simukufunira anthu ena kuti awone momwe ziwerengero zikuchitikira patebulo. Tiyeni tiwone njira zomwe mungathe kuchotsera mawonekedwe mu maselo, kusiya zotsatira zokhazokha.

Njira yochotsera

Mwamwayi, mu Excel palibe chida chomwe chingachotsedwe kawirikawiri m'maselo, koma chotsani zokhazokha pamenepo. Choncho ndikofunikira kuyang'ana njira zovuta zothetsera vutoli.

Njira 1: Lembani Mfundo Zogwiritsira Ntchito Zosankha Zolemba

Mukhoza kujambula deta popanda ndondomeko ya dera lina pogwiritsa ntchito zigawo zina.

1. Sankhani tebulo kapena mndandanda, yomwe timayenderera nayo ndi chithunzithunzi ndi batani lamanzere lomwe liri pansi. Kukhala mu tab "Kunyumba", dinani pazithunzi "Kopani"yomwe imayikidwa pa tepi mu block "Zokongoletsera".



2. Sankhani selo limene lidzakhala pamwamba la selo selo la tebulo lolowetsedwa. Dinani pa ilo ndi batani lamanja la mbewa. Menyu ya nkhaniyi idzayambidwa. Mu chipika "Njira Zowonjezera" lekani kusankha pa chinthucho "Makhalidwe". Amaperekedwa mwa mawonekedwe a pictogram ndi chithunzi cha manambala. "123".

Pambuyo pochita ndondomekoyi, mndandandawo udzaikidwa, koma ndizofunika popanda maonekedwe. Zoona, mawonekedwe oyambirira adzatayika. Choncho, m'pofunika kupanga ma tebulo pamanja.

Njira 2: kujambula choyika chapadera

Ngati mukufuna kusunga maonekedwe oyambirira, koma simukufuna kutaya nthawi pokhapokha mutagwiritsa ntchito tebulo, ndiye kuti n'zotheka kuti izi zigwiritsidwe ntchito "Sakani Mwapadera".

1. Timafotokoza mofanana ndi nthawi yowonjezera zomwe zili patebulo kapena mndandanda.
2. Sankhani malo onse otsekera kapena selo lakumwamba. Timapanga ndondomeko yolondola yolumikiza, ndikuyitanitsa mndandanda wamakono. M'ndandanda yomwe imatsegula, sankhani chinthucho "Sakani Mwapadera". Kuwonjezera pa menyu owonjezereka dinani pa batani. "Makhalidwe ndi maonekedwe oyambirira"zomwe zimagwidwa mu gulu "Ikani malonda" ndipo ndi pictogram mu mawonekedwe a lalikulu, zomwe zimasonyeza nambala ndi burashi.

Pambuyo pa opaleshoniyi, deta idzakopedwa opanda maonekedwe, koma maonekedwe oyambirira adzasungidwa.

Njira 3: Chotsani Mpangidwe kuchokera ku Gome la Chitsime

Zisanachitike, tinakambirana za momwe tingachotsere fomuyi pamene tikujambula, ndipo tsopano tiyeni tipeze momwe tingachotsere kuchoka pachiyambi.

1. Timapanga tebulo kutsanzira njira iliyonse, yomwe takambirana pamwambapa, kumalo opanda kanthu a pepala. Kusankhidwa kwa njira yapadera kwa ifeyo sikungakhale kofunikira.
2. Sankhani mtundu wokopera. Dinani pa batani "Kopani" pa tepi.



3. Sankhani mtundu woyambirira. Dinani pa ilo ndi batani lamanja la mouse. Mndandanda wa mndandanda wa gululo "Njira Zowonjezera" sankhani chinthu "Makhalidwe".



4. Deta itatha, mungathe kuchotsa maulendo. Sankhani. Lembani mndandanda wa masewerawa powakweza batani lamanja la mbewa. Sankhani chinthu mmenemo "Chotsani ...".



5. Fasilo yaying'ono imatsegukira kumene muyenera kudziwa chomwe kwenikweni chiyenera kuchotsedwa. Momwe ife timachitira, kutsetsereka kwazomwe kuli pansi pa tebulo lapachiyambi, kotero tikufunika kuchotsa mizere. Koma ngati ili pambali pake, ndiye kuti nkofunika kuchotsa zipilala, ndikofunikira kuti musasokoneze pano, popeza n'zotheka kuwononga tebulo lalikulu. Choncho, sungani zojambula zotsalira ndipo dinani pa batani. "Chabwino".

Pambuyo pochita masitepewa, zinthu zonse zosafunikira zidzachotsedwa, ndipo mayendedwe ochokera pa tebulo loyambira adzatha.

Njira 4: chotsani mafomu popanda kupanga njira yopitako

Mukhoza kuzipanga mosavuta ndipo kawirikawiri simungapange kayendetsedwe koyendetsa. Komabe, panopa, muyenera kuchita mosamala kwambiri, chifukwa zochitika zonse zidzachitika mkati mwa gome, zomwe zikutanthauza kuti vuto lililonse lingasokoneze chidziwitso cha deta.

1. Sankhani mtundu umene mukufuna kuchotsa. Dinani pa batani "Kopani"kuikidwa pa tepi kapena kuyika kuphatikiza kwachinsinsi pa kibokosi Ctrl + C. Zochita izi ndizofanana.



2. Ndiye, popanda kuchotsa kusankha, dinani pomwepo. Yayambitsa mndandanda wamakono. Mu chipika "Njira Zowonjezera" dinani pazithunzi "Makhalidwe".

Motero, deta yonse idzakopedwa ndipo nthawi yomweyo imayikidwa ngati miyezo. Pambuyo pazochitikazi, mayendedwe a malo omwe asankhidwa sadzakhala.

Njira 5: Kugwiritsa Macro

Mukhozanso kugwiritsa ntchito macros kuti muchotse ma formula m'maselo. Koma chifukwa cha ichi, muyenera kuyamba kuyambitsa tabu ya osonkhanitsa, komanso kuwonetsa ntchito ya macros okha, ngati sakugwira ntchito. Mmene mungachitire izi zingapezeke pa mutu wina. Tidzayankhula molunjika pa kuwonjezera ndi kugwiritsa ntchito macro kuchotsa ma fomu.

1. Pitani ku tabu "Wotsambitsa". Dinani pa batani "Visual Basic"anaikidwa pa tepi muzitsulo "Code".



2. Mkonzi wamkulu akuyamba. Ikani code ili mmenemo:

   
Kusuta Mafomu Athu ()
Kusankha.Value = Kusankhidwa.Value
Malizani pang'ono

   Pambuyo pake, tseka mawindo a mkonzi m'njira yoyenera podindira pa batani kumtunda wakumanja.



3. Tibwereranso ku pepala pomwe pali tebulo lomwe lili ndi chidwi. Sankhani chidutswa chomwe mawonekedwe achotsedwa. Mu tab "Wotsambitsa" pressani batani Macrosanayika pa tepi mu gulu "Code".



4. Kuwonekera kuwonekera kwakukulu. Tikuyang'ana chinthu chomwe chimatchedwa "Chotsani Mafomu"sankhani ndipo dinani pa batani Thamangani.

Pambuyo pazimenezi, mayesero onse m'deralo osankhidwa adzachotsedwa, ndipo zotsatira zokha zazomwe zidzakhalapo.

Phunziro: Momwe mungathandizire kapena kulepheretsa macros ku Excel

Phunziro: Momwe mungapangire macro ku Excel

Njira 6: Chotsani njirayi ndi zotsatira

Komabe, pali milandu pamene m'pofunika kuchotsa osati njira yokhayo, komanso zotsatira. Pangani izo mosavuta.

1. Sankhani mtundu umene mawonekedwewo ali. Dinani botani lamanja la mouse. Mu menyu yachidule, lekani kusankha pa chinthucho "Chotsani Chokhutira". Ngati simukufuna kuitanitsa menyu, mukhoza kusindikiza fungulo pambuyo pa kusankha Chotsani pabokosi.



2. Zitatha izi, zonse zomwe zili m'kati mwa maselo, kuphatikizapo maonekedwe ndi zoyenera, zidzachotsedwa.

Monga mukuonera, pali njira zingapo zomwe mungathe kuchotsera mafomu, onse pojambula deta, komanso mwachindunji tebulolo. Zoonadi, chida cha Excel chomwe chidzachotsa mawu pang'onopang'ono, mwatsoka, palibe. Mwa njira iyi, zokhazokha ndi zikhulupiliro zingathe kuchotsedwa. Choncho, muyenera kuchita mwanjira zina kudzera muzolemba kapena kugwiritsa ntchito macros.