Malo owonjezera omwe ali m'malemba sakuwonetsa malemba onse. Makamaka safunikira kuloledwa mu magome omwe aperekedwa kwa oyang'anira kapena anthu. Koma ngakhale mutati mugwiritse ntchito deta pokhapokha pazinthu zaumwini, malo owonjezera amathandiza kuwonjezeka kukula kwa chikalata, chomwe chiri cholakwika. Kuphatikizanso apo, kukhalapo kwa zinthu zosafunika koteroko kumapangitsa kuti zikhale zovuta kufufuza fayilo, kugwiritsa ntchito mafyuluta, kugwiritsa ntchito kusankha ndi zida zina. Tiyeni tipeze momwe mungapezere mwamsanga ndi kuwachotsa.
Phunziro: Chotsani malo akuluakulu mu Microsoft Word
Kachipangizo chatsopano chochotsamo
Nthawi yomweyo ndikuyenera kunena kuti malo opezeka mu Excel akhoza kukhala osiyana. Izi zikhoza kukhala malo pakati pa mawu, danga kumayambiriro kwa mtengo ndi mapeto, olekanitsa pakati pa mawerengedwe a manambala, ndi zina zotero. Chifukwa chake, njira yowonongedwa kwao m'mabukuwa ndi yosiyana.
Njira 1: Gwiritsani ntchito Chida Cholowera
Chidachi chimapanga ntchito yabwino yochotsera malo owiri pakati pa mawu ndi osakwatira ku Excel "Bwezerani".
- Kukhala mu tab "Kunyumba", dinani pa batani "Pezani ndi kuonetsa"yomwe ili mu chida chogwiritsa ntchito Kusintha pa tepi. M'ndandanda wotsika pansi, sankhani chinthucho "Bwezerani". Mwinanso mungathe kuchita zinthu zomwe tatchula pamwambapa Ctrl + H.
- Muzomwe mungasankhe, "Fufuzani ndi Kuyikapo" zenera likutsegula mu tabu "Bwezerani". Kumunda "Pezani" ikani cholozeracho ndipo dinani kawiri pa batani Spacebar pabokosi. Kumunda "Bwezerani ndi" sungani danga limodzi. Kenaka dinani pa batani "Bwezerani Zonse".
- Pulogalamuyi imalowetsa malo awiriwa limodzi. Pambuyo pake, mawindo amawoneka ndi lipoti la ntchito yomwe yachitika. Timakanikiza batani "Chabwino".
- Ndiye zenera zikuwonekera kachiwiri. "Pezani ndi kusintha". Timachita muzenera izi chimodzimodzi ndi zomwe zikufotokozedwa mu ndime yachiwiri ya phunziroli mpaka uthenga ukuwoneka kuti deta yofunidwayo siinapezeke.
Potero, tachotsa malo awiri owonjezera pakati pa mawu omwe ali m'kabuku.
Phunziro: Chotsani Mkhalidwe Wosintha
Njira 2: Chotsani malo pakati pa manambala
Nthawi zina, malo amakhala pakati pa manambala ndi manambala. Ichi si kulakwitsa, chifukwa cha malingaliro owona a chiwerengero chachikulu cholemba ichi chiri chosavuta. Komabe, izi sizikugwirizana ndi nthawi zonse. Mwachitsanzo, ngati selo silingapangidwe monga mawerengedwe a chiwerengero, kuwonjezera kwa kulekanitsa kungasokoneze kuwona kwa chiwerengero mwa malemba. Choncho, nkhani yochotsa olekanitsa oterewa imakhala yofulumira. Ntchitoyi ikhoza kugwiritsidwa ntchito pogwiritsira ntchito chida chomwecho. "Pezani ndi kusintha".
- Sankhani ndondomeko kapena maulendo omwe mukufuna kuchotsa oyendetsa pakati pa manambala. Nthawiyi ndi yofunika kwambiri, chifukwa ngati chingwecho sichinasankhidwe, chidacho chidzachotsa malo onsewo, kuphatikizapo pakati pa mawu, ndiko kuti, komwe kuli kofunikira. Komanso, monga kale, dinani pa batani "Pezani ndi kuonetsa" mu chigawo cha zipangizo Kusintha pa kaboni mu tab "Kunyumba". Mu menyu owonjezera, sankhani chinthucho "Bwezerani".
- Zenera likuyambanso. "Pezani ndi kusintha" mu tab "Bwezerani". Koma nthawi ino tidzasintha malingaliro osiyana m'minda. Kumunda "Pezani" ikani danga limodzi ndi munda "Bwezerani ndi" timasiya zambiri opanda kanthu. Kuti muonetsetse kuti mulibe mipata yomwe ili pamtundawu, ikani cholozeracho ndikugwiritsira ntchito ndondomeko ya backspace (ngati mawonekedwe) pa kibokosilo. Gwirani batani mpaka chithunzithunzi chikugwera kumbali yakumanzere ya kumunda. Pambuyo pake, dinani pa batani "Bwezerani Zonse".
- Pulogalamuyo idzachita ntchito yochotsa malo pakati pa mawerengedwe. Monga mwa njira yapitayi, kutsimikiza kuti ntchitoyo yatha, timachita kufufuza mobwerezabwereza mpaka uthenga ukuwoneka kuti mtengo wofunidwa sukupezeka.
Magulu pakati pa majambulidwa adzachotsedwa, ndipo mayendedwe ayamba kuwerengedwa molondola.
Njira 3: Chotsani olekanitsa pakati pa mawerengedwe ndi maonekedwe
Koma pali zochitika mukamawona kuti pamasamba amapepala ali osiyana ndi malo, ndipo kufufuza sikupereka zotsatira. Izi zikutanthauza kuti pakadali pano kupatulidwa kunkachitika mwa kupanga maonekedwe. Njira iyi ya danga sichikukhudzani kulondola kwa mawonekedwe a mawonekedwe, koma pa nthawi yomweyi, ena ogwiritsa ntchito amakhulupirira kuti popanda izo, tebulo liwoneka bwino. Tiyeni tiwone momwe tingachotsere kusiyana kotereku.
Popeza malo adapangidwa pogwiritsira ntchito zipangizo zojambula, akhoza kugwiritsa ntchito zipangizo zomwezo.
- Sankhani manambala angapo ndi olekanitsa. Dinani kusankhidwa ndi batani lamanja la mouse. Mu menyu imene ikuwonekera, sankhani chinthucho "Sungani maselo ...".
- Fesitimu yokongoletsa ikuyamba. Pitani ku tabu "Nambala", ngati kutsegulira kuchitika kwinakwake. Ngati kupatukana kudakhazikitsidwa pogwiritsa ntchito maonekedwe, ndiye kuti muyambe kulemba "Maofomu Owerengeka" chofunika chiyenera kukhazikitsidwa "Numeric". Gawo lomwenso lawindo ndi mawonekedwe enieni a mtundu uwu. Pafupi "Yambani gulu lolekanitsa ()" muyenera kungozimitsa. Kenaka, kuti zotsatira zisinthe, dinani pa batani "Chabwino".
- Wowonetsera mawindo amatseka, ndipo kulekanitsa pakati pa chiwerengero cha manambala mu chisankho chosankhidwa chichotsedwa.
Phunziro: Kupanga tebulo la Excel
Njira 4: Chotsani malo ndi ntchito
Chida "Pezani ndi kusintha" Ndibwino kuti muchotse mipata yowonjezera pakati pa zilembo. Koma bwanji ngati akufunikira kuchotsedwa kumayambiriro kapena kumapeto kwa mawu? Pankhaniyi, ntchitoyo imachokera ku gulu la olemba ntchito. KUKHALA.
Ntchitoyi imachotsa mipata yonse kuchokera kumalo osankhidwawo, kupatula malo osakanikirana pakati pa mawu. Izi ndizotheka kuthetsa vutoli ndi malo kumayambiriro kwa mawu mu selo, kumapeto kwa mawu, komanso kuchotsa malo awiri.
Mphatikiti wa wogwiritsira ntchitoyi ndi osavuta ndipo ali ndi kukangana kokha:
= TRIMS (malemba)
Monga kutsutsana "Malembo" akhoza kuchita ngati malemba, kapena kuti kutanthauza selo limene liripo. Kwa nkhani yathu, njira yomaliza yokha idzaonedwa.
- Sankhani selo lomwe likufanana ndi ndime kapena mzere kumene malo ayenera kuchotsedwa. Dinani pa batani "Ikani ntchito"ili kumbali yakumanzere ya bar.
- Function Wizard yayamba. M'gululi "Mndandanda wathunthu wa alfabeti" kapena "Malembo" ndikuyang'ana chinthu "SZHPROBELY". Sankhani ndipo dinani pa batani. "Chabwino".
- Ntchito yotsutsana yenera ikutsegula. Mwamwayi, ntchitoyi siyikugwiritsira ntchito ntchito yonse yomwe tikufunikira monga mkangano. Choncho, timayika ndondomeko mumsasa wokambirana, ndiyeno sankhani selo yoyamba ya mautumiki omwe timagwira ntchito. Pambuyo pa adilesi ya selo ikuwonetsedwa m'munda, dinani pa batani "Chabwino".
- Monga mukuonera, zomwe zili mu selo zimawonetsedwa kudera limene ntchitoyo ili, koma popanda malo owonjezera. Tachotsa mipata ya chinthu chimodzi chokha. Kuti muwachotse mu maselo ena, muyenera kuchita zofanana ndi maselo ena. Inde, n'zotheka kugwira ntchito yosiyana ndi selo iliyonse, koma izi zingatenge nthawi yochuluka, makamaka ngati kukula kwake kuli kwakukulu. Pali njira yowonjezera mwatsatanetsatane ndondomekoyi. Ikani cholozera kumbali ya kumanja kwa selo, yomwe ili ndi kalembedwe. Mtolowo umasandulika kukhala mtanda wawung'ono. Icho chimatchedwa chikalata chodzaza. Gwiritsani botani lamanzere la mchenga ndi kukokera chida chodzaza chimodzimodzi ndi zomwe mukufuna kuchotsa.
- Monga momwe mukuonera, mutatha izi, mndandanda watsopano unayambika, momwe zonse zomwe zili mu gwero la chitsime zili, koma popanda malo ena owonjezera. Tsopano ife tikuyang'anizana ndi ntchito yothetsera malingaliro oyambirira oyambirira ndi deta yosinthidwa. Ngati tikupanga kophweka, ndiye kuti chikhomocho chidzaponyedwa, zomwe zikutanthauza kuti kulemba kudzachitika molakwika. Kotero, ife tikungoyenera kupanga kopi ya makhalidwe.
Sankhani zamtunduwu ndi ziyeso zotembenuzidwa. Timakanikiza batani "Kopani"ili pamtambali mu tab "Kunyumba" mu gulu la zida "Zokongoletsera". Monga njira ina, mukhoza kulemba njira yotsatila pambuyo pa kusankha Ctrl + C.
- Sankhani zolemba zoyambirira. Dinani kusankhidwa ndi batani lamanja la mouse. M'mawotchu a nkhaniyi muzitsulo "Njira Zowonjezera" sankhani chinthu "Makhalidwe". Imawonetsedwa ngati pictogram yambiri ndi manambala mkati.
- Monga mukuonera, zotsatirazi zapamwamba, zogwirizana ndi malo owonjezera zidasinthidwa ndi deta yofanana popanda iwo. Ndiko, ntchitoyo yatha. Tsopano mutha kuchotsa malo omwe amachitira kusintha. Sankhani magulu osiyanasiyana a maselo omwe ali ndi fomu KUKHALA. Timangosinthanitsa ndi batani lamanja la mouse. Mu menyu yoyanjidwa, sankhani chinthucho "Chotsani Chokhutira".
- Pambuyo pake, deta yowonjezera idzachotsedwa pa pepala. Ngati pali mitsinje ina yomwe ili ndi mipata yambiri, muyenera kuigwiritsa ntchito pogwiritsira ntchito ndondomeko yomweyi.
Phunziro: Wowonjezera Wogwira Ntchito
Phunziro: Momwe mungapangire autocomplete mu Excel
Monga mukuonera, pali njira zingapo zoti muthe kuchotsa malo owonjezera mu Excel. Koma zonsezi zingagwiritsidwe ntchito ndi zida ziwiri - mawindo "Pezani ndi kusintha" ndi woyendetsa KUKHALA. Muzosiyana, mungagwiritsenso ntchito mapangidwe. Palibe njira zonse zomwe zingakhale zabwino kwambiri kuzigwiritsa ntchito pazochitika zonse. Nthawi ina, zidzakhala zabwino kugwiritsa ntchito njira imodzi, ndipo yachiwiri - yina, ndi zina zotero. Mwachitsanzo, kuchotsa danga lamkati pakati pa mawu mwachiwonekere likuchitidwa ndi chida. "Pezani ndi kusintha", koma ntchito yokha ingathe kuchotsa bwino malo kumayambiriro ndi kumapeto kwa selo KUKHALA. Choncho, wogwiritsa ntchitoyo ayenera kupanga chisankho pakugwiritsa ntchito njira inayake pokhapokha, powalingalira zochitikazo.
