Kuchotsa Malo Owonjezera mu Microsoft Excel

Malo ena owonjezera sawlemba utoto uliwonse. Makamaka sayenera kuloledwa pama tebulo omwe amaperekedwa kwa oyang'anira kapena anthu. Koma ngakhale mutangogwiritsa ntchito zomwezo pazokha, malo owonjezera amatha kuwonjezera kuchuluka kwa chikalatacho, zomwe ndi zoipa. Kuphatikiza apo, kupezeka kwa zinthu zowonjezerazi kumapangitsa kuti zikhale zovuta kusaka fayilo, kugwiritsa ntchito zosefera, kugwiritsa ntchito mitundu ndi zida zina. Tiyeni tiwone kuti ndi njira ziti zomwe zimapezeka kuti zimapezeka mwachangu ndikuchotsedwa.

Phunziro: Kuchotsa Malo Akuluakulu mu Microsoft Mawu

Teknoloji yochotsa kusiyana

Muyenera kunenanso kuti malo omwe ali mu Excel akhoza kukhala amitundu yosiyanasiyana. Itha kukhala malo pakati pa mawu, danga koyambirira kwa mtengo ndi kumapeto, olekanitsidwa pakati pa manambala a manambala, etc. Momwemo, ma algorithm amomwe amachotsera milanduzi ndizosiyana.

Njira 1: gwiritsani ntchito chida cha Replace

Chipangizocho chimagwira ntchito yabwino kwambiri ndikusintha malo awiri pakati pa mawu okhala ndi malo amodzi mu Excel M'malo.

1. Kukhala mu tabu "Pofikira"dinani batani Pezani ndikuwunikirayomwe ili mgululi "Kusintha" pa tepi. Pamndandanda wotsitsa, sankhani M'malo. Mutha kuthanso m'malo mwachithunzichi pamwambapa kungolemba tatchuliko Ctrl + H.



2. Mwanjira zilizonse zomwe mungasankhe, zenera la Pezani ndi Kusintha limatsegulira tabu M'malo. M'munda Pezani ikani cholozera ndikudina kawiri pa batani Malo omanga pa kiyibodi. M'munda "M'malo ndi" ikani malo amodzi. Kenako dinani batani Sinthani Zonse.



3. Pulogalamuyi imalowetsa malo awiri ndikuyika malo amodzi. Pambuyo pake, zenera limawonekera lili ndi lipoti la ntchito yomwe yachitika. Dinani batani "Zabwino".



4. Kenako, zenera limawonekeranso Pezani ndi Kusintha. Timachitanso chimodzimodzi zenera monga zafotokozedwera m'ndime yachiwiri ya malangizowa mpaka uthenga utawoneka womwe ukunena kuti zomwe mukufuna sizinapezeke.

Chifukwa chake, tidachotsa malo owonjezera awiri pakati pa mawu omwe alembedwa.

Phunziro: M'malo mwa Khalidwe ku Excel

Njira 2: chotsani malo pakati pa manambala

Nthawi zina, malo amapezeka pakati pa manambala. Izi sizolakwika, chifukwa chongowerengera anthu ambiri motere. Komabe, izi ndizovomerezeka nthawi zonse. Mwachitsanzo, ngati khungu silikupangidwira mtundu wa manambala, kuwonjezera gawo kungasokoneze molondola kuwerengetsa kwamawonekedwe. Chifukwa chake, nkhani yochotsa olekanitsa amenewa imakhala yoyenera. Ntchitoyi ikhoza kuchitika pogwiritsa ntchito chida chomwechi. Pezani ndi Kusintha.

1. Sankhani mzere kapena mtundu womwe mukufuna kuchotsa olekanitsa pakati pa manambala. Izi ndizofunikira kwambiri, chifukwa ngati mtunduwo sunasankhidwe, chida chimachotsa malo onse pazipangidwazi, kuphatikiza pakati pa mawu, ndiye kuti, komwe zimafunikira. Chotsatira, monga kale, dinani batani Pezani ndikuwunikira mu bokosi la zida "Kusintha" pa riboni pa tabu "Pofikira". Pazowonjezera, sankhani M'malo.



2. Zenera limayambiranso Pezani ndi Kusintha pa tabu M'malo. Koma nthawi ino tiwonetsa zosiyana paminda. M'munda Pezani ikani malo amodzi, ndi munda "M'malo ndi" zisiyeni zilibe kanthu. Kuti muwonetsetse kuti mulibe malo panjirayi, ikani cholozera mmalo mwake ndikuyika batani loyang'ana kumbuyo (mwa muvi) pa kiyibodi. Gwirani batani mpaka khumbuyo ikapumula kumalire akumunda. Pambuyo pake, dinani batani Sinthani Zonse.



3. Pulogalamuyi idzagwira ntchito yochotsa malo pakati pa manambala. Monga momwe munachitira kale, kuti muwonetsetse kuti ntchitoyi yakwaniritsidwa, fufuzani kwachiwiri kufikira uthenga utawoneka kuti mtengo womwe udafunawo sunapeze.

Kupatukana pakati pa manambala kudzachotsedwa, ndipo mafomula ayambira kuwerengedwa molondola.

Njira 3: chotsani zopatukana pakati pa zolumikizira mitundu

Koma pamakhala zochitika zina pamene muwona bwino kuti pa pepalali manambala amasiyanitsidwa ndi manambala ndi malo, ndipo kusaka sikupereka zotsatira. Izi zikusonyeza kuti pankhani iyi, kupatukana kunachitika mwa kupanga mitundu. Kusankha danga koteroko sikungakhudze momwe kuwonekera kwa mawonekedwe, koma nthawi imodzimodzi, ogwiritsa ntchito ena amakhulupirira kuti popanda iwo tebulo lidzawoneka bwino. Tiyeni tiwone momwe tingachotsere njira yopatukana.

Popeza malo amapangidwa pogwiritsa ntchito zida zosinthira, zimakhala ndi zida zomwezo zomwe zimatha kuchotsedwa.

1. Sankhani manambala osiyanasiyana ndi achinyengo. Dinani pa kusankha ndi batani la mbewa yoyenera. Pazosankha zomwe zimapezeka, sankhani "Mtundu wamtundu ...".



2. Tsamba losintha likuyamba. Pitani ku tabu "Chiwerengero"chifukwa kufufuzaku kudachitika kwina. Ngati kulekanitsidwa kwatchulidwa pogwiritsa ntchito masanjidwe, ndiye kuti mu gawo "Mawerengero Amanambala" njira iyenera kuyikiridwa "Numeric". Mbali yakumanja ya zenera ili ndi zoikamo ndindende. Pafupifupi mfundo "Osiyanitsa gulu ()" muyenera kungoyimitsa. Kenako, kuti zosinthazo zichitike, dinani batani "Zabwino".



3. Zenera losintha likutseka, ndipo kulekanitsa pakati pa manambala mumitundu yosankhidwa kumachotsedwa.

Phunziro: Kukhazikitsa matebulo ku Excel

Njira 4: chotsani malo ndikugwiritsa ntchito ntchito

Chida Pezani ndi Kusintha Zabwino pakuchotsa malo owonjezera pakati pa zilembo. Koma bwanji ngati akufunika kuchotsedwa koyamba kapena kumapeto kwa mawu? Potere, ntchito yochokera kwa gulu la ogwiritsira ntchito ipulumutsa GAPS.

Ntchitoyi imachotsa malo onse pazomwe zidasankhidwa, kupatula malo amodzi pakati pa mawu. Ndiye kuti, imatha kuthana ndi vutoli poyambira mawu a khungu, kumapeto kwa mawu, ndikuchotsanso malo awiri.

Matanthauzidwe a opaleshoni awa ndi ophweka ndipo ali ndi mfundo imodzi yokha:

= ZOONA (zolemba)

Monga mkangano "Zolemba" mawu olemba amatha kuwonekera mwachindunji, komanso ulalo wa khungu lomwe lilimo. Kwa ife, njira yotsiriza ndi yomwe idzaiganizira.

1. Sankhani khungu lomwe likufanana ndi mzere kapena mzere pomwe malo ayenera kuchotsedwa. Dinani batani "Ikani ntchito"ili kumanzere kwa baramu yamu formula.



2. Windo la Ntchito Wizard liyamba. Gulu "Mndandanda wathunthu wa zilembo" kapena "Zolemba" kufunafuna chinthu SZPROBELY. Sankhani ndikudina batani. "Zabwino".



3. Zenera la zotsutsa za ntchito limatsegulidwa. Tsoka ilo, ntchitoyi siyikupereka ntchito yogwiritsidwa ntchito pamitundu yonse yomwe timafunikira monga mkangano. Chifukwa chake, timayika cholozera m'gawo la mikangano, kenako ndikusankha khungu loyambirira lomwe tikugwira nalo. Pambuyo foni yamawonekedwe m'munda, dinani batani "Zabwino".



4. Monga mukuwonera, zomwe zili m'chipindacho zikuwonetsedwa m'dera lomwe ntchitoyi ili, koma popanda malo owonjezera. Tinachotsa malo pazinthu chimodzi chokha. Kuti muwachotse mu maselo ena, muyenera kuchita zomwezo ndi maselo ena. Zachidziwikire, mutha kuchita opareshoni ndi foni iliyonse, koma izi zitha kutenga nthawi yambiri, makamaka ngati mtunduwo uli wokulirapo. Pali njira yothamangitsira njirayi mwachangu. Ikani cholozera mu ngodya ya kumunsi kwa foni yomwe ili kale ndi fomula. Chopereka chimasinthidwa kukhala mtanda wawung'ono. Amatchedwa chikhomo chodzaza. Gwirani batani lakumanzere ndikukokera chikhomo chofananira ndi mtundu womwe mukufuna kuchotsa malo.



5. Monga mukuwonera, izi zitatha, mawonekedwe atsopano amapangidwa, momwe zinthu zonse za malo oyambira zimapezekera, koma popanda malo owonjezera. Tsopano tayang'anizana ndi ntchito yosinthira zofunikira za mtundu woyambirira ndi zomwe zasinthidwa. Ngati tichita kope losavuta, fomuloli idatsatiridwa, zomwe zikutanthauza kuti phalalo siligwira ntchito moyenera. Chifukwa chake, tiyenera kungotengera zofunikira.

   Sankhani mtundu ndi mfundo zomwe zasinthidwa. Dinani batani Copyili pa nthiti mu tabu "Pofikira" pagulu lazida Clipboard. Mwinanso, mutatha kuwunikira, mutha kulemba mitundu yosakanizira Ctrl + C.



6. Sankhani mtundu woyambira. Dinani pa kusankha ndi batani la mbewa yoyenera. Pazosankha zamakono zili mu block Ikani Zosankha sankhani "Makhalidwe". Chawonetsedwa ngati chithunzi pachithunzi chokhala ndi manambala mkati.



7. Monga mukuwonera, pambuyo pa magawo omwe ali pamwambapa, mawonekedwe omwe ali ndi malo ena owonjezera adasinthidwa ndi zofananira popanda iwo. Ndiye kuti, ntchito yakwaniritsidwa. Tsopano mutha kuchotsa gawo lomwe lidagwiritsidwa ntchito pakusintha. Sankhani maselo osiyanasiyana omwe ali ndi formula GAPS. Timadulira pomwepo ndi batani la mbewa. Pazosankha zomwe mwazichita, sankhani Chotsani Zolemba.



8. Pambuyo pake, zambiri zochuluka zidzachotsedwa papepala. Ngati pali magulu ena pagome omwe ali ndi malo owonjezera, ndiye muyenera kuthana nawo pogwiritsa ntchito algorithm yomweyo monga tafotokozera pamwambapa.

Phunziro: Ntchito Wizard ku Excel

Phunziro: Momwe mungachite mosamalitsa mu Excel

Monga mukuwonera, pali njira zingapo zochotsera msanga malo ena ku Excel. Koma zosankha zonsezi zimachitika ndi zida ziwiri zokha - windows Pezani ndi Kusintha ndi wothandizira GAPS. Nthawi zina, mafomati amathanso kugwiritsidwa ntchito. Palibe njira yanthawi zonse yomwe ingakhale yosavuta kugwiritsa ntchito nthawi zonse. Munjira imodzi, ndizotheka kugwiritsa ntchito njira imodzi, ndipo yachiwiri - ina, ndi zina. Mwachitsanzo, kuchotsa malo awiri pakati pa mawu nthawi zambiri kumakhala chida Pezani ndi Kusintha, koma ntchito yokhayo ndi yomwe ingathe kuchotsa bwino malo koyambirira ndi kumapeto kwa khungu GAPS. Chifukwa chake, wosuta ayenera kusankha pakugwiritsa ntchito njira inayake pamaziko ake.