Momwe mungawerengere kuchuluka kwa mawu mu cell spreadsheet ya Excel

Mu Microsoft Office Excel, mutha kuwerengera kuchuluka kwa zinthu zolembedwa m'maselo a tebulo. Kwa izi, njira yosavuta imagwiritsidwa ntchito nthawi zambiri. Zambiri pamutuwu zidzafotokozedwa m'nkhaniyi.

Njira zowerengera mawu mu ma cell a Excel

Pali njira zingapo zodziwika bwino zogwirira ntchito yomwe mwapatsidwa, iliyonse yomwe imafunikira kuphunzira mozama kuti mumvetsetse bwino. Kenaka, tidzakambirana za zosavuta komanso zothandiza kwambiri.

Njira 1: kuwerengera pamanja

Njirayi si yoyenera kwa MS Excel, mosasamala kanthu za mtundu wake, chifukwa. pulogalamuyi imagwiritsa ntchito zida zowerengera zokha. Komabe, ndikofunikira kuganiziranso akaunti yamanja yomwe ili mkati mwa nkhaniyo. Kukonzekera kwake ndikofunikira:

1. Lembani mndandanda wa tebulo loyambirira.
2. Sankhani mwa kukanikiza batani lakumanzere la mbewa cell yomwe mukufuna kuwerengera mawuwo.
3. Werengani zinthu zomwe zasonkhanitsidwa.
4. Kuti musataye nthawi yanu, mutha kutengera zomwe zili mu cell, zomwe zimawonetsedwa pamzere wolowetsa mafomu, ndikuziyika pagawo logwira ntchito la tsamba lapadera kuti muwerenge mwachangu kuchuluka kwa zilembo, mawu.

Tcherani khutu! Kuwerengera mawu m'maselo a Excel pamanja sikothandiza ngati tebulo lili ndi zambiri.

Njira 2: Kugwiritsa ntchito Microsoft Office Word

Muzolemba zolemba, mawu onse otayidwa amawerengedwa okha ndipo nambala yawo ikuwonetsedwa pazenera. Kuti mugwiritse ntchito njirayi, wogwiritsa ntchito Excel adzafunika:

1. Onetsani LMB ya mawu omwe ali mu cell ya piritsi kuti muwerengenso nambala yawo.
2. Sinthani kiyibodi kuti ikhale yachingerezi ndipo nthawi yomweyo gwirani makiyi a "Ctrl + C" kuti mukopere zilembo zomwe zasankhidwa pa clipboard.
3. Tsegulani zolemba zolemba MS Word.
4. Ikani cholozera cha mbewa kumayambiriro kwa gawo logwira ntchito la pulogalamuyo ndikusindikiza mabatani "Ctrl + V" pa kiyibodi.
5. Onani zotsatira. Zinthu zomwe zakopedwa kuchokera ku Excel ziyenera kuikidwa mu Mawu popanda vuto lililonse.
6. Samalani kumunsi kumanzere kwa tsamba la ntchito. Taskbar iwonetsa kuchuluka kwa mawu omwe alembedwa pano.

Zina Zowonjezera! Excel ilibe chida chowerengera mawu m'maselo, chifukwa pulogalamuyi sinapangidwe kuti igwire ntchito ndi zolemba.

Njira 3: Kugwiritsa Ntchito Ntchito Yapadera

Iyi ndiye njira yabwino kwambiri komanso yachangu kwambiri yowerengera mawu m'maselo, ziganizo za Excel. Kuti mudziwe mwachangu kuchuluka kwazinthu zomwe zikufunika, wogwiritsa ntchitoyo ayenera kuchitapo kanthu molingana ndi algorithm:

1. Sankhani selo lililonse lopanda kanthu patsamba la pulogalamuyo. Zotsatira za kuwerengera zidzawonetsedwa m'tsogolomu.
2. Ikani cholozera cha mbewa pamzere wolowetsa mafomula pamwamba pa pulogalamuyo ndikulemba mawu awa kuchokera pa kiyibodi: "=Utali (TRIMSPACES(mtsutso))-DLSTR(M'MALO (mtsutso;» «;»»))+1".
3. M'malo mwa mawu oti "Mkangano", adilesi ya selo yomwe kuwerengetserako ikuwonetsedwa.

4. Mukamaliza kulemba fomula, muyenera kukanikiza "Enter" kuti mutsimikizire.
5. Onani zotsatira. Selo yosankhidwa kale idzakhala ndi nambala yogwirizana ndi chiwerengero cha mawu a chinthu chomwe chikufunsidwa.

Momwe mungawerengere kuchuluka kwa zilembo mu cell ya Excel

Nthawi zina ogwiritsa ntchito a Excel amafunika kuwerengera kuchuluka kwa zilembo mu selo linalake la gulu la tebulo. Kuwerengera zizindikiro ndikosavuta kuposa mawu. Pali njira zingapo zochitira izi, zomwe zidzakambidwe pansipa.

Njira 1: kuwerengera pamanja

Njira imeneyi ndi yofanana ndi ya m’mbuyomo imene takambirana m’chigawo choyamba cha nkhaniyi. Kuti agwiritse ntchito, wogwiritsa ntchitoyo ayenera kusankha selo linalake la mbale ndikuwerengera munthu aliyense mmenemo.

Zofunika! Pakhoza kukhala zilembo zambiri m'maselo a tebulo la Microsoft Office Excel, zomwe zingatenge nthawi yochuluka kuti muwerenge pamanja. Choncho, kuwerengera pamanja kuli koyenera pankhani ya mbale yaying'ono.

Njira 2: Kugwiritsa Ntchito Ntchito Powerengera Utali wa Chingwe

Excel ili ndi chilinganizo chapadera chomwe chimakulolani kuti muwerenge zinthu motsatizana. Kuti mugwiritse ntchito, muyenera kuchita zingapo zosavuta malinga ndi malangizo:

1. Ndi kiyi yakumanzere ya manipulator, sankhani mzere wopanda kanthu, selo lomwe zotsatira za kuwerengera zilembo zidzawonetsedwa.
2. Sunthani cholozera cha mbewa pamzere kuti mulowetse mafomu pamwamba pa zenera la pulogalamu ndikulemba mawu akuti: “=DLSTR(mkangano)». Mmalo mwa mkangano, adiresi ya selo yeniyeni imasonyezedwa, kumene muyenera kupeza chiwerengero cha zilembo.

3. Dinani "Enter" pamene fomula yalembedwa kutsimikizira kuchitidwa kwake.
4. Onani zotsatira. Chinthu chomwe chatchulidwa kale chidzawonetsa nambala yofananira.

Njira 3: Kugwiritsa ntchito masamba apadera pa intaneti

Mutha kupita m'njira yovuta kuwerengera kuchuluka kwa zilembo m'maselo a gulu la Excel. Zimaphatikizapo zinthu zotsatirazi malinga ndi algorithm:

1. Momwemonso, sankhani cell yomwe mukufuna patebulo ndi LMB ndikusuntha cholozera cha mbewa pamzere wolowetsa mafomu pamwamba pa pulogalamuyi.
2. Tsopano, ndi kiyi yowongolera yomweyi, muyenera kusankha zomwe zili mu cell mumzere wolowetsa.
3. Dinani kumanja pagawo lililonse la mawu omwe mwasankhidwa ndipo pazenera lamtundu wankhaniyo dinani "Koperani".
4. Lowani mumsakatuli pa PC ndikupita kumalo aliwonse kuti muwerenge kuchuluka kwa zilembo.
5. Dinani kumanja pa malo ogwirira ntchito patsambalo ndikusankha "Ikani".
6. Dzidziweni bwino ndi phindu lake. Pambuyo popanga zomwe zili pamwambapa, tsambalo liwonetsa zonse zokhudzana ndi kutalika kwa mawuwo.

Tcherani khutu! Pamasamba oterowo, mutha kuwerengeranso kuchuluka kwa ziganizo pamawu omwe mwatchulidwa.

Kutsiliza

Chifukwa chake, mu Excel, mutha kudziwa mwachangu za kuchuluka kwa mawu m'maselo omwe mukufuna patebulo. Momwe mungachitire izi zidafotokozedwa mwatsatanetsatane pamwambapa.