Chingwe cholowa mu Microsoft Excel

Pogwira ntchito ndi matebulo, nthawi zina muyenera kusintha kapangidwe kake. Kusintha kwina kwa njirayi ndi concatenation ya chingwe. Nthawi yomweyo, zinthu zophatikizika zimasandulika mzere umodzi. Kuphatikiza apo, pali mwayi wophatikiza zinthu zapafupi kwambiri. Tiyeni tiwone momwe mungachitire izi kuphatikiza mu Microsoft Excel.

Werengani komanso:
Momwe mungaphatikizire mzati mu Excel
Momwe mungaphatikizire maselo ku Excel

Mitundu ya Mgwirizano

Monga tafotokozera pamwambapa, pali mitundu iwiri yayikulu yolumikizana - pomwe mizere ingapo imasinthidwa kukhala imodzi ndikuigawa. Poyambirira, ngati zinthu zamkati zidadzaza ndi chidziwitso, ndiye kuti zonse zimatayika, kupatula zomwe zimapezeka pamwamba. Kachiwiri, mizere imakhalabe chimodzimodzi, imangophatikizidwa m'magulu momwe zinthu zitha kubisidwa mwa kuwonekera pazizindikiro mu mawonekedwe opanda. Pali njira inanso yolumikizira popanda kutaya deta pogwiritsa ntchito fomula, yomwe tikambirana padera. Mwachidziwikire, kuchokera ku mitundu yomwe yasinthidwa, njira zosiyanasiyana zophatikiza zimapangidwa. Tiyeni tizingokhalira kuganizira zambiri za iwo.

Njira 1: kuphatikiza kudzera pazenera

Choyamba, tiyeni tiwone kuthekera kophatikiza mizere pa pepala kudzera pazenera losanja. Koma musanapitirire ndi njira yolumikizira mwachindunji, muyenera kusankha mizere yapafupi yomwe mukufuna kuphatikiza.

1. Kuti muwonetsetse mizere yomwe imafunika kuphatikiza, mutha kugwiritsa ntchito njira ziwiri. Yoyamba mwa izi ndikuti mugwire batani lamanzere lakumanzere ndikukoka magawo azinthuzo pazenera laling'ono lomwe mukufuna kuphatikiza. Adziwitsidwa bwino.

   

   Komanso, chilichonse pazenera zofananira zofananirana zitha kudulizidwa kumanzere kwa manambala oyambira. Kenako dinani pamzere womaliza, koma nthawi yomweyo gwiritsani fungulo Shift pa kiyibodi. Izi zikuwunikira gulu lonse lomwe lili pakati pamagawo awiriwa.



2. Mtundu wofunikira ukasankhidwa, mutha kupitiliza njira yophatikizira. Kuti muchite izi, dinani kumanja kulikonse posankha. Zosankha zam'mawu zimatsegulidwa. Timadutsamo Mtundu Wa Cell.



3. Tsamba losintha likuyambitsidwa. Pitani ku tabu Kuphatikiza. Kenako pagulu lazokonda "Onetsani" onani bokosi pafupi ndi paramayo Cell Union. Pambuyo pake, mutha dinani batani. "Zabwino" pansi pazenera.



4. Kutsatira izi, mizere yosankhidwa iphatikizidwa. Komanso, kuphatikiza kwa maselo kudzachitika mpaka kumapeto kwa pepalalo.

Palinso zosankha zina zosunthira pazenera losanja. Mwachitsanzo, mutasankha mizere, kukhala tabu "Pofikira", mutha kudina chizindikiro "Fomu"ili pa riboni pachombo chida "Maselo". Kuchokera pa mndandanda wotsitsa wa zochita, sankhani "Mtundu wamtundu ...".

Komanso mu tabu yemweyo "Pofikira" mutha kuwonekera pa muvi wapadera, womwe umapezeka kumbali yakumanja kwakumanja kwa chida chobisira Kuphatikiza. Ndipo mu nkhaniyi, kusinthaku kudzapangidwira ku tabu Kuphatikiza kusanja mawindo, ndiye kuti, wogwiritsa ntchito sayenera kusintha pakati pa tabu.

Muyeneranso kupita pazenera losakanikirana ndikanikizira kuphatikiza kwa hotkey Ctrl + 1, mutatsindika zinthu zofunika. Koma mu nkhaniyi, kusinthaku kuchitika mu tsamba la zenera Mtundu Wa Cellkomwe adayendera komaliza.

Ndi mtundu uliwonse wa kusintha kwa zenera la makonzedwe, njira zina zonse zophatikizira zidutswa ziyenera kuchitika molingana ndi algorithm yomwe tafotokozazi.

Njira 2: kugwiritsa ntchito zida za tepi

Mutha kuphatikiza zingwe pogwiritsa ntchito batani pa riboni.

1. Choyamba, timasankha mizere yofunikira ndi imodzi mwazosankha zomwe zidakambidwapo Njira 1. Kenako timasunthira ku tabu "Pofikira" ndipo dinani batani pa riboni "Phatikizani ndi pakati". Ili mu chipangizo. Kuphatikiza.



2. Pambuyo pake, mzere wosankhidwa udzaphatikizidwa mpaka kumapeto kwa pepalalo. Poterepa, zolemba zonse zomwe zidzapangidwe pamzere wophatikizidwa izi zizikhala pakati.

Koma si munthawi zonse zomwe zimafunikira kuti malembawo aikidwe pakati. Zoyenera kuchita ngati zikufunika kuyikidwa muyezo?

1. Timasankha mizere yomwe imafunika kuti ilumikizane. Pitani ku tabu "Pofikira". Timadulira riboni m'mbali mwa makona atatu, omwe ali kumanja kwa batani "Phatikizani ndi pakati". Mndandanda wamachitidwe osiyanasiyana umatsegulidwa. Sankhani dzina Phatikizani Maselo.



2. Pambuyo pake, mizere iphatikizidwa kukhala imodzi, ndipo zomwe zalembedwazo kapena zowerengera ziziikidwa monga momwe zimakhalira ndi mtundu wawo wofikira.

Njira 3: kuphatikiza mizere mkati mwa tebulo

Koma sikofunikira nthawi zonse kuphatikiza mizere mpaka kumapeto kwa pepalalo. Nthawi zambiri, cholumikizira chimapangidwa munthawi ya tebulo. Tiyeni tiwone momwe tingachitire izi.

1. Sankhani maselo onse azithunzi zomwe tikufuna kuphatikiza. Izi zitha kuchitika m'njira ziwiri. Yoyamba ndikuti mugwire batani lakumanzere ndikusuntha chotembezera paliponse kuti lisankhidwe.

   

   Njira yachiwiri idzakhala yosavuta makamaka kuphatikiza dongosolo lalikulu lambiri mu mzere umodzi. Muyenera dinani pomwepo kumtunda kwa dzanja lamanzere lamitundu yonse, kenako, ndikugwira batani Shift - pansi kumanja. Mutha kuchita zosiyana ndi izi: dinani kumanzere akumanzere ndikumanzere masero amanzere. Zotsatira zidzakhala chimodzimodzi.



2. Kusankha kukamalizidwa, pitirizani kugwiritsa ntchito njira zomwe tafotokozazo Njira 1mu fayilo yopanga maselo. Mmenemo timachita zofananira zonse zomwe tidali kukambirana pamwambapa. Pambuyo pake, mizere mkati mwa tebulo iphatikizidwa. Poterepa, ndi data yokha yomwe ili mgulu lamanzere lamanzere lamitundu yonse yopulumutsidwa.

Kulowa mkati mwa malire a tebulo kumatha kuchitika kudzera pazida pa riboni.

1. Timapanga mizere yomwe mukufuna patebulopo ndi chilichonse mwa zinthu ziwiri zomwe tafotokozazi. Kenako mu tabu "Pofikira" dinani batani "Phatikizani ndi pakati".

   

   Kapena dinani patatu mpaka kumanzere kwa batani ili, ndikutsatira ndikudina chinthucho Phatikizani Maselo menyu a pop-mmwamba.



2. Kuphatikizikako kudzapangidwa kutengera mtundu womwe wogwiritsa ntchito wasankha.

Njira 4: kuphatikiza zambiri m'mizere popanda kutaya deta

Njira zonsezi pamwambazi zimatanthawuza kuti njirayi ikamalizidwa, deta yonse yomwe ikuphatikizidwe idzawonongedwa, kupatula yomwe ili mgulu lamanzere lamanzere m'deralo. Koma nthawi zina zimafunikira popanda kutaya kuphatikiza mfundo zina zomwe zili m'mizere yosiyanasiyana ya tebulo. Izi zitha kuchitika pogwiritsa ntchito ntchito yopangidwira cholinga chotere. POPANDA.

Ntchito POPANDA ali m'gulu la olemba ntchito. Ntchito yake ndikuphatikiza mizere ingapo kukhala chinthu chimodzi. Syntax yantchitoyi ndi motere:

= KONANI (zolemba1; zolemba2; ...)

Zotsutsana zamagulu "Zolemba" ikhoza kukhala yopatukana kapena yolumikizana ndi zinthu za pepala momwe ilimo. Ndi chuma chomaliza chomwe tidzagwiritse ntchito kumaliza ntchitoyo. Zonse, mpaka 255 malingaliro ngati awa atha kugwiritsidwa ntchito.

Chifukwa chake, tili ndi tebulo momwe mndandanda wazida zamakompyuta ndi mtengo wake zikuwonetsedwa. Tikukumana ndi ntchito yophatikiza deta yonse yomwe ili mgulu "Chipangizo", pamzere umodzi popanda kutayika.

1. Tikuyika chidziwitso mu pepala lomwe zotsatira zake zakonzedwe zidzawonetsedwa, ndikudina batani "Ikani ntchito".



2. Kuyambira Ogwira Ntchito. Tiyenera kusamukira kumalo ogwiritsira ntchito "Zolemba". Kenako timapeza ndi kusankha dzinalo KONANI. Kenako dinani batani "Zabwino".



3. Windo la zotsutsa za ntchito limawonekera POPANDA. Mwa kuchuluka kwa zotsutsana, mutha kugwiritsa ntchito mpaka magawo 255 okhala ndi dzinalo "Zolemba", koma kukhazikitsa ntchito yomwe timafunikira monga momwe tebulo limakhalira. Muna kuma kiaki, kuna 6. Aneyisaele mu sunda "Lemba1 " ndipo, pogwirizira batani la mbewa yakumanzere, dinani chinthu choyamba chomwe chili ndi dzina la zida zomwe zili mgolo "Chipangizo". Pambuyo pake, adilesi ya chinthu chosankhidwa chiwonetsedwa pazenera. Momwemonso, timalowa ma adilesi a mizere yotsatira ya mzati "Chipangizo", motero, kuminda "Lemba2 ", "Lemba3 ", "Lemba4 ", "Lemba5 " ndi "Lemba6 ". Kenako, ma adilesi a zinthu zonse atawonetsedwa pazenera zenera, dinani batani "Zabwino".



4. Pambuyo pake, ntchitoyo iwonetsa zonse mu mzere umodzi. Koma, monga tikuwona, palibe kusiyana pakati pa mayina a katundu osiyanasiyana, ndipo izi sizitikomera. Kuti muthane ndi vutoli, sankhani mzere womwe uli ndi fomula, kenako dinani batani "Ikani ntchito".



5. Zenera lazokambirana liyambiranso nthawi ino osasinthira koyamba Fotokozerani Wizard. M'gawo lililonse la zenera lomwe limatsegulira, kupatula lomaliza, tsamba latsamba, onjezani mawu awa:

   &" "

   Mawu awa ndi mtundu wa mawonekedwe a ntchito. POPANDA. Ichi ndichifukwa chake sikofunikira kuwonjezera pa gawo lachisanu ndi chimodzi. Akatsiriza njirayi atamaliza, dinani batani "Zabwino".



6. Pambuyo pake, monga momwe tikuonera, zosankha zonse sizimangoyikidwa pamzere umodzi, komanso zimalekanitsidwa ndi malo.

Palinso njira ina yokwaniritsira njira zomwe zapangidwira kuphatikiza deta kuchokera pamizere ingapo kukhala imodzi popanda kutayika. Potere, simudzafunika kugwiritsa ntchito ntchitoyi, koma mutha kuchita ndi zomwe mwachita kale.

1. Khazikitsani chizindikiro "=" pamzere pomwe zotsatira zikuwonetsedwa. Dinani pazinthu zoyambirira za mzati. Pambuyo pomwe adilesi yake yawonetsedwa mu baramu yodutsamo ndi mu cell yanthawi yazotsatira, talemba dzina lotsatira pa kiyibodi:

   &" "&

   Pambuyo pake, dinani pa gawo lachiwiri la chipilalacho ndikulowetsanso mawu omwe ali pamwambapa. Chifukwa chake, timakonza maselo onse momwe deta iyenera kuyikidwa mzere umodzi. Kwa ife, mawu awa:

   = A4 & "" A5 & "" & A6 & "" & A7 & "" & A8 & "" A A9



2. Kuti muwonetse zotsatira pazenera, dinani batani Lowani. Monga mukuwonera, ngakhale kuti njira ina imagwiritsidwa ntchito pamenepa, phindu lomaliza limawonetsedwa chimodzimodzi pofanana ndi ntchito POPANDA.

Phunziro: Ntchito ya EXCEL

Njira 5: Gulu

Kuphatikiza apo, mutha kumasula zingwe popanda kutaya umphumphu wawo. Tiyeni tiwone momwe angachitire.

1. Choyamba, timasankha zinthu zoyandikana ndizosafunikira zomwe zimafunika kuyikidwa m'magulu. Mutha kusankha maselo amodzi m'mizere, osati osati mizere yonse. Pambuyo pake, pitani ku tabu "Zambiri". Dinani batani "Gulu"yomwe ili mgululi "Kapangidwe". Pa mindandanda yaying'ono yazinthu ziwiri, sankhani malo "Gulu ...".



2. Pambuyo pake, zenera laling'ono limatseguka momwe muyenera kusankha zomwe tikugawana: mizere kapena mizati. Popeza tikufunika kugwirizanitsa mizereyo, timakonzanso kusinthaku kukhala koyenera ndikudina batani "Zabwino".



3. Pambuyo pazochita zomaliza, mizere yoyandikana nayo idzalumikizidwa pagulu. Kuti mubise, ingodinani chizindikiro pachimodzimodzi ndi chizindikiro opandayomwe ili kumanzere kwa gulu lounikira.



4. Kuti muwonetse maguluwo kachiwiri, muyenera dinani chikwangwani "+" amapangidwa pamalo omwewo pomwe chizindikirochi chinali "-".

Phunziro: Momwe mungapangire gulu ku Excel

Monga mukuwonera, njira yolumikizira zingwe kukhala imodzi zimatengera mtundu wamomwe angagwirizane ndi wogwiritsa ntchitoyo komanso zomwe akufuna kupeza chifukwa chotsatira. Mutha kuphatikiza mizere mpaka kumapeto kwa pepalalo, mkati mwa tebulo, mumachita izi popanda kutaya deta pogwiritsa ntchito chinthu kapena chilinganizo, ndikugawa mizereyo. Kuphatikiza apo, pali njira zingapo zomwe zingagwiritsidwe ntchito, koma zomwe amakonda ndizomwe zimawalimbikitsa kusankha kwawo.