Momwe mungalembe zilembo zazikulu mu Excel

Ogwiritsa ntchito a Active Excel nthawi zambiri amakumana ndi zochitika zomwe zimafunikira kulembera zilembo zoyambirira. Ngati pali maselo ochepa, mukhoza kuchita izi pamanja. Komabe, ngati tikukamba za kusintha tebulo lalikulu, mapepala angapo odzazidwa ndi chidziwitso, ndi bwino kugwiritsa ntchito zinthu zomwe zapangidwa mu Excel palokha, zomwe zidzasintha ndondomeko yonseyi.

Momwe mungasinthire zilembo zing'onozing'ono m'malo mwa zilembo zazikulu

Limodzi mwamavuto akulu a pulogalamu ya Excel ndikusowa kwa ntchito yosiyana yosinthira zilembo zosankhidwa m'maselo ndi ena. Njira yosavuta ndikuchita pamanja, koma kubwereza njira yomweyi kudzatenga nthawi yayitali ngati pali maselo ambiri odzazidwa. Kuti mumalize ntchitoyi mwachangu, muyenera kuphatikiza zida zomangira Excel pakati pawo.

Momwe mungalembe chilembo choyamba cha liwu limodzi

Kuti musinthe zilembo zoyambirira mu liwu limodzi lokha la gawo kapena mndandanda wokhala ndi zilembo zazikulu, muyenera kugwiritsa ntchito ntchito zitatu:

  1. "M'MALO" ndiye ntchito yayikulu. Pamafunika kusintha chidutswa chonse kuchokera ku selo kapena chilembo chimodzi kupita ku zomwe zidzasonyezedwe mu mkangano wa ntchito.
  2. "UPPER" ndi ntchito yokhudzana ndi dongosolo loyamba. Pamafunika kusintha zilembo zing'onozing'ono m'malo mwa zilembo zazikulu.
  3. "KULEFT" ndi ntchito yokhudzana ndi dongosolo lachiwiri. Ndi chithandizo chake, mutha kuwerengera zilembo zingapo kuchokera mu cell yomwe mwasankha.
Momwe mungalembe zilembo zazikulu mu Excel
Chitsanzo cha tebulo kuti amalize ntchitoyi

Kumvetsetsa momwe mungakwaniritsire ntchitoyi kudzakhala kosavuta ngati mukufotokozera ndondomeko yonseyi pang'onopang'ono. Kachitidwe:

  1. Lembani tebulo ndi deta yofunikira pasadakhale.
  2. Podina LMB, chongani selo laulere papepala lofunikira la tebulo.
  3. Mu cell yosankhidwa, muyenera kulemba mawu a malo omwe mukufuna kusintha zilembo zina ndi zina. Mawuwa akuwoneka motere: REPLACE(A(cell number),1,UPPER(LEFT(A(cell number),1))).
  4. Fomula ikakonzedwa, muyenera kukanikiza batani la "Enter" kuti ndondomekoyo ichitike. Ngati mawuwo analembedwa molondola, mtundu wosinthidwa wa mawuwo udzawonekera mu selo losankhidwa padera.
  5. Kenako, muyenera kuyang'ana pa mawu osinthidwa ndi cholozera cha mbewa, ndikusunthira kukona yakumanja yakumanja. Mtanda wakuda uyenera kuwoneka.
  6. Ndikofunikira kugwira mtanda wa LMB, kuukokera pansi mizere yambiri monga momwe zilili pagawo logwirira ntchito.
  7. Mukamaliza kuchita izi, ndime yatsopano idzawonekera, pomwe mizere yonse ya gawo logwirira ntchito idzawonetsedwa ndi zilembo zoyamba kusinthidwa kukhala zilembo zazikulu.
Momwe mungalembe zilembo zazikulu mu Excel
Danga lowonjezera lomwe lili ndi zambiri zomwe zasinthidwa kale ndi fomula
  1. Kenako, muyenera kukopera zomwe mwalandira ku malo a chidziwitso choyambirira. Kuti muchite izi, muyenera kusankha ndime yatsopano, koperani kudzera mu menyu yankhani kapena mzere wokhala ndi zida mu tabu ya "Home".
  2. Sankhani mizere yonse kuchokera pagawo loyambirira lomwe mukufuna kusintha. Dinani kumanja, pazosankha zomwe zikuwonekera, sankhani ntchito yachiwiri mu gulu la "Paste Options", dzina lake ndi "Values".
  3. Ngati zonse zachitika molondola, zikhalidwe zomwe zili m'maselo olembedwa zisintha kukhala zomwe zidapezedwa ndi formula.
  4. Zimatsalira kuchotsa gawo lachitatu. Kuti muchite izi, sankhani maselo onse osinthidwa, dinani kumanja kuti mutsegule menyu, sankhani ntchito ya "Chotsani".
  5. Zenera liyenera kuwoneka ndi mwayi wochotsa ma cell patebulo. Apa muyenera kusankha momwe zinthu zomwe zasankhidwa zidzachotsedwere - gawo lonse, mizere yamunthu, ma cell omwe ali ndi masinthidwe mmwamba, ma cell omwe ali ndi kusintha kumanzere.
  6. Kuti mumalize kufufuta, dinani batani "Chabwino".

Ndondomeko yosinthira zilembo zoyambirira za mawu onse ndi zilembo zazikulu

Kugwira ntchito ndi matebulo Excel, nthawi zina zimakhala zofunikira kusintha zilembo zoyambirira za mawu onse m'maselo ena kukhala zilembo zazikulu. Kuti muchite izi, tikulimbikitsidwa kugwiritsa ntchito "PROPER" ntchito. Ndondomeko:

  1. Sankhani selo lopanda kanthu patebulo podina kumanja, yonjezerani mawu oyambirapo pogwiritsa ntchito batani la "Insert Function" (yomwe ili kumanzere kwa bar ya formula, yotchulidwa ndi "fx").
Momwe mungalembe zilembo zazikulu mu Excel
Kuwonjezera Ntchito ku Selo Yosankhidwa
  1. Zenera lowonjezera zoikamo lidzawonekera pamaso pa wogwiritsa ntchito, momwe muyenera kusankha "PROPER", dinani batani "Chabwino".
  2. Pambuyo pake, muyenera kudzaza mkangano wa ntchito. M'munda waulere, muyenera kulemba dzina la cell yomwe deta yomwe mukufuna kusintha. Dinani batani "Chabwino".

Zofunika! Kwa ogwiritsa ntchito omwe amadziwa zambiri za Excel pamtima, sikofunikira kugwiritsa ntchito "Function Wizard". Mutha kulowetsa ntchitoyi mu cell yosankhidwa pagome pamanja ndikuwonjezera ma coordinates a cell omwe deta yake mukufuna kusintha. Chitsanzo =KUTHANDIZA(ndi 2).

Momwe mungalembe zilembo zazikulu mu Excel
Kufotokozera Mkangano Wantchito Kupyolera mu Ntchito Wizard
  1. Zotsatira zomalizidwa zidzawonetsedwa mu selo la tebulo, lomwe linalembedwa mosiyana ndi mizati yogwira ntchito.
  2. Bwerezani masitepe 5, 6, 7 kuchokera munjira yapitayi. Ngati zonse zachitika molondola, ndime yatsopano yokhala ndi data yosinthidwa iyenera kuwoneka.
  3. Mzere wosiyana uyenera kusankhidwa pogwiritsa ntchito RMB, gulu la zolemba kapena kuphatikiza kiyi pa kiyibodi "CTRL + C".
  4. Sankhani ma cell onse patsamba lomwe mukufuna kusintha. Matani mtundu wosinthidwa kudzera mu "Values" ntchito.
  5. Chochita chomaliza musanasunge zotsatira ndikuchotsa gawo lowonjezera lomwe deta idakopera, monga momwe tafotokozera m'njira yoyamba.

Kutsiliza

Ngati muphatikiza bwino zida zomwe zikupezeka mu mtundu wamba wa Excel, mutha kusintha zilembo zoyambirira za mawu amodzi kapena angapo kuchokera pamaselo osankhidwa, omwe nthawi zambiri amakhala osavuta komanso othamanga kuposa kulowa pamanja.

Siyani Mumakonda