Momwe Mungapangire Kusamutsa Mzere mu cell mu Excel

Anonim

Kusamukira mzere mu Microsoft Excel

Monga mukudziwa, mwachisawawa, mu khungu limodzi, pepala labwino limapezeka mzere umodzi, mawu kapena deta ina. Koma ndiyenera kuchita chiyani ngati mukufuna kusintha malembawo mkati mwa khungu lomwelo kupita ku mzere wina? Ntchito imeneyi ikhoza kuchitidwa pogwiritsa ntchito pulogalamu ina ya pulogalamuyo. Tiyeni tiwone momwe mungapangire mzere womasulira mu cell kuzinthu.

Njira Zosamutsa Zolemba

Ogwiritsa ntchito ena amayesa kusamutsa mawu mkati mwa khungu pokakamiza batani la batani la batani. Koma ndi izi akufuna kuti curlori ipite ku mzere wotsatira. Tikambirana zosankhazo mkati mwa khungu, zosavuta komanso zovuta.

Njira 1: Kugwiritsa ntchito kiyibodi

Njira yosatha yosasinthika ku chingwe china ndikukhazikitsa cholozera gawo lisanayambe kusamutsa, kenako lembani kiyibodi kipt (kumanzere) + kulowa). +

Khungu komwe mungafune kusintha mawu ku Microsoft Excel

Mosiyana ndi batani la batani limodzi lokha, pogwiritsa ntchito njirayi, zikhala kuti zotsatira zake zikayikidwa.

Kusintha kwa mawu ndikofunikira mu Microsoft Excel

Phunziro: Makiyi otentha kwambiri

Njira 2: Kupanga

Ngati wogwiritsa ntchito sakhazikitsa ntchito kuti asamutsane mosamalitsa mawu enaake pamzere watsopano, ndipo muyenera kuwakwanira mkati mwa khungu limodzi, osapitilira malire, mutha kugwiritsa ntchito chida.

  1. Sankhani khungu lomwe lembalo limapitilira malire. Dinani pa batani la mbewa. M'ndandanda womwe umatsegula, sankhani chinthu "cell a mtundu ...".
  2. Kusintha kwa mtundu wa maselo mu Microsoft Excel

  3. Zenera lotseguka limatsegulidwa. Pitani ku "kuphatikizidwa". Mu "zowonetsera" zosintha, sankhani "kusamutsa malingana ndi" gawo, kuzidziwa ndi chizindikiro. Dinani pa batani la "OK".

Ma cell cell a Microsoft Excel

Pambuyo pake, ngati zomwe zakhala zikuwoneka zopitilira m'malire a khungu, zimakulitsa kutalika kwake, ndipo mawuwo adzasamutsidwa. Nthawi zina muyenera kukulitsa malire pamanja.

Pofuna kuti inunso musamapangitse aliyense payekhapayekha, mutha kusankha malo onsewo. Kuwonongeka kwa njirayi ndikuti kusamutsa kumachitika pokhapokha ngati mawuwo sagwirizana m'malire, pambali pake, magawano amachitika mosavuta popanda kuganizira zofuna za wogwiritsa ntchito.

Njira 3: Kugwiritsa Ntchito Fomu

Muthanso kuchita kusintha mkati mwa khungu pogwiritsa ntchito njira. Izi ndizothandiza kwambiri ngati zomwe zili m'mawuwo zikuwonetsedwa pogwiritsa ntchito ntchito, koma zitha kugwiritsidwa ntchito mobwerezabwereza.

  1. Mtundu wa cell monga wasonyezedwera mu mtundu wapitawu.
  2. Sankhani foni ndikuyika mawu otsatirawa kapena mu chingwe:

    = Kugwira ("mawu1"; chizindikiro (10); "mawu2")

    M'malo mwa "malembawo" ndi "zolemba2", muyenera kulowetsa mawu kapena mawu omwe mukufuna kusamutsa. Zikhalidwe zotsalazo sizofunikira.

  3. Ntchito zogwiritsira ntchito zimapangitsa Microsoft Excel

  4. Kuti izi zitheke kuwonetsedwa pa pepalalo, dinani batani la Enter pa kiyibodi.

Mawu amaikidwanso pogwiritsa ntchito FNCA mu Microsoft Excel

Choyipa chachikulu cha njirayi ndikuti ndizovuta kwambiri pakuphedwa kuposa zosankha zakale.

Phunziro: Zinthu Zothandiza Zapamwamba

Mwambiri, wogwiritsa ntchito ayenera kusankha njira mwa njira zomwe zili zoyenera kugwiritsa ntchito mwanjira inayake. Ngati mukufuna zilembo zonsezo kuti zigwirizane m'malire a cell, ndiye ingomangirani munjira yomwe mukufuna, ndi bwino kwambiri mtundu wonsewo. Ngati mukufuna kukhazikitsa kusamutsa mawu, kenako imbani kuphatikiza zazikulu, monga tafotokozera pakufotokozera kwa njira yoyamba. Njira yachitatuyi ikulimbikitsidwa pokhapokha deta yomwe yatulutsidwa kuchokera ku magawo ena pogwiritsa ntchito formula. Nthawi zina, kugwiritsa ntchito njirayi kumakhala kosavomerezeka, chifukwa pali njira zosavuta zothetsera ntchitoyo.

Werengani zambiri