Kuphwanya mzere mu Excel cell

Mu Excel, zambiri zomwe zili mu cell, malinga ndi makonzedwe anthawi zonse, zimayikidwa pamzere umodzi. Mwachiwonekere, kuwonetsera kotereku sikumakhala kothandiza nthawi zonse, ndipo kusinthidwa kwa tebulo kungakhale kofunikira. Tiyeni tiwone momwe mungadulire mzere mkati mwa cell yomweyi ya Excel.

Kusamutsa Zosankha

Nthawi zambiri, kuti musunthire mawu pamzere watsopano, muyenera kukanikiza kiyi Lowani. Koma ku Excel, kuchita koteroko kudzatipititsa ku selo yomwe ili m'munsimu, zomwe siziri zomwe timafunikira. Koma ndizotheka kupirira ntchitoyi, komanso m'njira zingapo.

Njira 1: gwiritsani ntchito ma hotkeys

Njira iyi mwina ndiyotchuka kwambiri komanso yosavuta. Zomwe tikuyenera kuchita ndikuti, mumaseweredwe osintha ma cell, sunthani cholozera pamalo pomwe tikuyenera kusamutsa, kenako dinani kuphatikiza. Alt (kumanzere) + Lowani.

Zonse zomwe zidapezeka pambuyo pa cholozera zidzasunthidwa ku mzere watsopano mkati mwa selo lomwelo.

Popeza tsopano gawo la malembawo lili pansipa, danga lisanafike silikufunika (kwa ife, pamaso pa mawu akuti "oak") ndipo akhoza kuchotsedwa. Ndiye zimangokhala kukanikiza kiyi Lowanikuti amalize kukonza.

Njira 2: Sinthani Mapangidwe a Maselo

Njira yomwe ili pamwambapa ndi yabwino chifukwa ife tokha timasankha pamanja mawu oti titumize ku mzere watsopano. Koma ngati izi sizofunika, ndiye kuti njirayi ikhoza kuperekedwa ku pulogalamu yomwe ingachite zonse zokha ngati zomwe zili pamwambazi zidutsa selo. Za ichi:

1. Dinani kumanja pa cell yomwe mukufuna kusamutsa, mumenyu yomwe ikuwonekera, dinani pamzere "Cell Format".Komanso, m'malo mwake, mutha kuyima mu cell yomwe mukufuna ndikusindikiza makiyi ophatikizira Ctrl + 1.
2. A mtundu zenera adzaoneka pa zenera. Apa tikusintha ku tabu "Kugwirizana", pomwe timatsegula mwayi "lemba zolemba"poyang'ana bokosi lomwe lili pafupi nalo. Dinani pamene mwakonzeka OK.
3. Zotsatira zake, tikuwona kuti mawu omwe ali mu selo yosankhidwa asinthidwa.

Zindikirani: pokhazikitsa njirayi, zosintha zokha zomwe zikuwonetsa deta. Choncho, ngati mukufuna kusunga kuzimata mosasamala kanthu za kukula kwa selo, muyenera kugwiritsa ntchito njira yoyamba.

Komanso, masanjidwe amatha kugwiritsidwa ntchito paselo limodzi kapena angapo nthawi imodzi. Kuti muchite izi, sankhani mtundu womwe mukufuna m'njira iliyonse yabwino, kenako pitani pazenera la masanjidwe, pomwe timatsegula gawo lomwe tikufuna.

Njira 3: gwiritsani ntchito "CONCATENATE".

Kukulunga kwa mzere kungathenso kuchitidwa mwa ntchito yapadera.

1. Lowetsani fomula mu selo losankhidwa, lomwe nthawi zambiri limawoneka motere:

   =CONCATENATE(“Text1″, CHAR(10),”Text2”)Komabe, mmalo mwa mikangano "Text1" и "Text2" timalemba zilembo zofunika, ndikusunga mawu. Dinani pamene mwakonzeka Lowani.

2. Monga njira pamwambapa, timayatsa kusamutsa kudzera pawindo la masanjidwe.
3. Timapeza zotsatira zotere.

Zindikirani: m'malo mwazomwe zili mu fomula, mutha kufotokozera ma cell. Izi zidzakuthandizani kusonkhanitsa malemba monga omanga kuchokera kuzinthu zingapo, ndipo nthawi zambiri njirayi imagwiritsidwa ntchito.

Kutsiliza

Chifukwa chake, patebulo la Excel, pali njira zingapo zomwe mungagwiritse ntchito zomwe mutha kukulunga mawu pamzere watsopano mkati mwa selo lomwelo. Njira yosavuta ndiyo kugwiritsa ntchito ma hotkey apadera kuti muzichita pamanja zomwe zikufunika. Kuphatikiza apo, palinso makonzedwe omwe amakulolani kusamutsa deta yokha kutengera kukula kwa selo, komanso ntchito yapadera yomwe siigwiritsidwe ntchito kawirikawiri, koma nthawi zina ingakhale yofunika kwambiri.