Kawirikawiri, mukamagwira ntchito ku Excel, palifunika kuyika ndemanga pafupi ndi zotsatira za kuwerengera fomu, zomwe zimathandiza kumvetsetsa deta iyi. Inde, mukhoza kusankha gawo losiyana kuti lifotokozedwe, koma osati muzochitika zonse kuwonjezera zinthu zina zowonjezera. Komabe, mu Excel pali njira zoyika ndondomekoyi ndi mawu mu selo imodzi pamodzi. Tiyeni tiwone momwe izi zingathere ndi chithandizo cha njira zosiyanasiyana.
Ndondomeko yowonjezera malemba pafupi ndi fomu
Ngati mutayesa kulemba mawuwo mu selo limodzi ndi ntchitoyi, ndiye kuti kuyesa kwa Excel kudzawonetsa uthenga wolakwika mu njirayi ndipo sikudzakulolani kuyikapo. Koma pali njira ziwiri zomwe mungagwiritsire ntchito zolembazo pambaliyi. Yoyamba ndi kugwiritsa ntchito ampersand, ndipo yachiwiri ndikugwiritsa ntchito ntchitoyi Kuti mutenge.
Njira 1: Kugwiritsa ntchito Ampersand
Njira yosavuta yothetsera vutoli ndi kugwiritsa ntchito chizindikiro cha ampersand (&). Chizindikiro ichi chimapanga kusiyanitsa kwanzeru kwa deta yomwe malembawo ali nawo kuchokera m'mawu olembedwa. Tiyeni tiwone momwe mungagwiritsire ntchito njirayi pakuchita.
Tili ndi tebulo laling'ono limene zikhomo ziwiri zikuwonetsa ndalama zomwe zimagwiritsidwa ntchito komanso zosinthika za malonda. Gawo lachitatu liri ndi njira yowonjezera yowonjezerapo, yomwe imawafotokozera mwachidule ndi kuwatulutsa onsewo. Tifunika kuwonjezera mawu ofotokozera pambuyo pa mndandanda wa selo lomwelo momwe ndalama zonse zikuwonetsedwa "rubles".
- Gwiritsani ntchito selo yomwe ili ndi mawu. Kuti muchite izi, pindani pawiri ndi batani lamanzere, kapena sankhani ndi dinani pafungulo la ntchito. F2. Mukhozanso kusankha selo, ndiyeno ikani ndondomeko mu bar.
- Mwamsanga mukangotenga ndondomekoyi, ikani chizindikiro cha ampersand (&). Komanso, mu ndemanga timalemba mawu "rubles". Pankhaniyi, ndemanga sizidzawonetsedwa mu selo pambuyo pa nambala yomwe ikuwonetsedwa ndi njirayi. Zimangokhala ngati pointer pa pulogalamu yomwe ndi yolemba. Kuti muwonetse zotsatira mu selo, dinani pa batani Lowani pabokosi.
- Monga mukuonera, mutatha izi, pambuyo pa chiwerengero chomwe chiwonetserocho chikuwonetsera, pali kulembedwa kwafotokozedwa "rubles". Koma njirayi ili ndi drawback imodzi yoonekayo: nambala ndi ndemanga zolemba zimagwirizanitsidwa popanda malo.
Pa nthawi yomweyi, ngati tiyesera kuika malo pamanja, sikugwira ntchito. Bomba likangomangidwe Lowani, zotsatirazo "zimagwirizanitsa pamodzi."
- Koma pali njira yothetsera vutoli. Apanso, yambitsani selo yomwe ili ndi malemba ndi malemba. Atangomaliza ampersand, mutsegule mawuwo, kenaka muikepo danga podalira makiyi ofanana pa makiyi, ndi kutseka ndemangazo. Pambuyo pake, ikani chizindikiro cha ampersand kachiwiri (&). Kenaka dinani Lowani.
- Monga momwe mukuonera, tsopano zotsatira za chiwerengero cha mawonekedwe ndi mawu akulekanitsidwa ndi danga.
Mwachibadwa, zonsezi sizitanthauza. Ife tangosonyeza kuti ndi mawu oyamba omwe alibe yachiwiri ampersand ndi ndemanga ndi danga, deta ndi deta deta ziphatikizana. Mukhoza kukhazikitsa malo oyenera ngakhale pamene mukuchita ndime yachiwiri ya bukuli.
Polemba malemba asanayambe kufotokozera, timatsatila mawuwa. Pambuyo potsatira "=" chizindikiro, mutsegule mawuwo ndipo lembani mawuwo. Pambuyo pake, kutseka ndemangazo. Timayika chizindikiro cha ampersand. Ndiye, ngati mukufuna kuyika danga, kutsegula mawu omveka, ikani malo ndi omaliza. Dinani pa batani Lowani.
Polemba malemba ndi ntchito, m'malo molemba mwachizolowezi, zochita zonse ziri chimodzimodzi ndi zomwe zafotokozedwa pamwambapa.
Malemba angathenso kutchulidwa ngati kulumikizana kwa selo yomwe ilipo. Pachifukwa ichi, ndondomeko ya ntchitoyi imakhalabe yofanana, koma simukufunikira kutenga makonzedwe a selo m'mavesi.
Njira 2: Kugwiritsa ntchito NTCHITO ntchito
Mukhozanso kugwiritsa ntchito ntchitoyi kuti muikepo malemba pamodzi ndi zotsatira zake. Kuti mutenge. Wogwiritsira ntchitoyi akukonzekera kuti aphatikize zikhalidwe zomwe zikuwonetsedwa muzinthu zingapo za pepala mu selo imodzi. Ndilo gawo la malemba ntchito. Mawu ake omasulira ndi awa:
= CLUTCH (malemba1; text2; ...)
Wogwiritsa ntchitoyi akhoza kukhala ndi zonse 1 mpaka 255 za zifukwa. Mmodzi wa iwo amaimira malemba (kuphatikizapo manambala ndi zina zotchulidwa), kapena maumboni a maselo omwe ali nawo.
Tiyeni tiwone momwe ntchitoyi ikugwirira ntchito. Mwachitsanzo, tiyeni titenge tebulo lomwelo, ingowonjezerani ndime imodzi yokha. "Ndalama Zonse" ndi selo yopanda kanthu.
- Sankhani selo yopanda kanthu. "Ndalama Zonse". Dinani pazithunzi "Ikani ntchito"ili kumbali yakumanzere ya bar.
- Kuchita kumachitidwa Oyang'anira ntchito. Pitani ku gawo "Malembo". Kenako, sankhani dzina "CLICK" ndipo dinani pa batani "Chabwino".
- Fenera la zotsutsana zowonjezera. Kuti mutenge. Fenera ili liri ndi minda pansi pa dzina "Malembo". Chiwerengero chawo chikufika 255, koma pa chitsanzo chathu tikusowa madera atatu okha. Poyambirira, tidzakhala ndi gawolo, lachiwiri, kulumikizana ndi selo lomwe lili ndi ndondomekoyi, ndipo lachitatu tidzakumbiranso.
Ikani cholozera mmunda "Text1". Timalemba mawu kumeneko "Total". Mungathe kulembera malemba opanda malemba, popeza pulogalamuyi idzawagwetsa pansi.
Ndiye pitani kumunda "Text2". Timayika ndondomeko kumeneko. Tiyenera kufotokoza apa mtengo umene mawonekedwewo akuwonekera, zomwe zikutanthauza kuti tipereke chiyanjano kwa selo yomwe ili nayo. Izi zingatheke pokhapokha mutalowa mu adiresi pamanja, koma ndi bwino kukhazikitsa cholozera mmunda ndikusungira selo liri ndi ndondomeko pa pepala. Adilesi idzawoneka mwachindunji pazenera zotsutsana.
Kumunda "Text3" lowetsani mawu oti "ruble".
Pambuyo pake dinani pa batani "Chabwino".
- Chotsatiracho chikuwonetsedwa mu selo yoyamba yosankhidwa, koma, monga momwe tingathe kuwonera, monga mwa njira yapitayi, mfundo zonse zalembedwa pamodzi popanda malo.
- Pofuna kuthetsa vutoli, timasankhiranso selo yomwe ili ndi woyendetsa Kuti mutenge ndipo pitani ku bar. Kumeneko pambuyo pa kutsutsana kulikonse, ndiko kuti, pambuyo pa semicoloni iliyonse ife tikuwonjezera mawu otsatirawa:
" ";Payenera kukhala malo pakati pa ndemanga. Mwachidziwikire, mawu awa akuyenera kuwonetsedwa muzotsatira:
= "" "" "" "" "" ";" ";" ";" ";" ";" "Ruble")Dinani pa batani ENTER. Tsopano miyezo yathu imasiyanitsidwa ndi malo.
- Ngati mukufuna, mukhoza kubisa chigawo choyamba "Ndalama Zonse" ndi chiyambi choyambirira, kotero kuti sichikhala ndi malo ochulukira pa pepala. Kungochotsa izo sikugwira ntchito, chifukwa izo ziphwanya ntchitoyi Kuti mutenge, koma mukhoza kuchotsa chinthucho. Dinani batani lamanzere lachitsulo pamzere wotsogoleredwa wa mndandanda umene uyenera kubisika. Pambuyo pake, ndime yonseyi ikufotokozedwa. Dinani kusankhidwa ndi batani lamanja la mouse. Yayambitsa mndandanda wamakono. Sankhani chinthu mmenemo "Bisani".
- Pambuyo pake, monga tikuonera, chinsinsi chosafunika chikubisika, koma deta mu selo yomwe ntchitoyo ili Kuti mutenge kuwonetsedwa molondola.
Onaninso: Ntchito YAKUTCHITSA ku Excel
Momwe mungabise masamu ku Excel
Motero, tinganene kuti pali njira ziwiri zolembera ndondomekoyi mu selo limodzi: mothandizidwa ndi ampersand ndi ntchito Kuti mutenge. Njira yoyamba ndi yophweka komanso yabwino kwa ogwiritsa ntchito ambiri. Koma, komabe, mu nthawi zina, mwachitsanzo pamene mukukonza machitidwe ovuta, ndi bwino kugwiritsa ntchito operekera Kuti mutenge.
