Momwe mungapangire ndime mu cell ya Excel

Nthawi zina ogwiritsa ntchito a Microsoft Office Excel amafunika kulemba mizere ingapo mu selo limodzi lamagulu a tebulo nthawi imodzi, kupanga ndime. Kuthekera uku mu Excel kumatha kukhazikitsidwa m'njira zingapo pogwiritsa ntchito zida zokhazikika zamapulogalamu. Momwe mungawonjezere ndime ku selo mu tebulo la MS Excel tikambirana m'nkhaniyi.

Njira zomangirira mawu m'maselo a tebulo

Ku Excel, simungathe kupanga ndime podina batani la "Enter" kuchokera pa kiyibodi ya pakompyuta, monga mu Mawu. Apa tiyenera kugwiritsa ntchito njira zina. Zikambidwanso mowonjezereka.

Njira 1: Manga mawu pogwiritsa ntchito zida zoyankhulirana

Mawu akulu kwambiri sangakwane mu selo limodzi la gulu la tebulo, choncho amayenera kusunthidwa kupita ku mzere wina wa chinthu chomwecho. Njira yosavuta yochitira ntchitoyi imagawidwa m'njira zotsatirazi:

1. Gwiritsani ntchito batani lakumanzere kuti musankhe selo lomwe mukufuna kupanga ndime.

2. Pitani ku tabu ya "Home", yomwe ili pazida zapamwamba za pulogalamu yayikulu.
3. Mu gawo la "Kulinganiza", dinani batani la "Kukulunga Malemba".

4. Onani zotsatira. Pambuyo pochita masitepe am'mbuyomu, kukula kwa selo yosankhidwa kudzawonjezeka, ndipo malemba omwe ali mmenemo adzamangidwanso kukhala ndime, yomwe ili pamizere ingapo mu chinthucho.

Tcherani khutu! Kuti mupange bwino ndime yomwe idapangidwa mu cell, zolembazo zitha kusinthidwa pokhazikitsa miyeso yomwe mukufuna, komanso kukulitsa m'lifupi mwake.

Njira 2. Momwe mungapangire ndime zingapo mu cell imodzi

Ngati malemba olembedwa mu Excel array element ali ndi ziganizo zingapo, ndiye kuti akhoza kulekanitsidwa wina ndi mzake poyambitsa chiganizo chilichonse pamzere watsopano. Izi zidzawonjezera kukongola kwa mapangidwe, kukonza mawonekedwe a mbale. Kuti mupange gawo ili, muyenera kuchita motere:

1. Sankhani cell yomwe mukufuna.
2. Onani mzere wa fomula pamwamba pa menyu yayikulu ya Excel, pansi pazida zokhazikika. Imawonetsa zolemba zonse za chinthu chosankhidwa.
3. Ikani cholozera cha mbewa pakati pa ziganizo ziwiri za mawu pamzere wolowetsa.
4. Sinthani kiyibodi ya PC kuti ikhale yachingerezi ndipo nthawi yomweyo gwirani mabatani a "Alt + Enter".
5. Onetsetsani kuti ziganizozo zagawa malire, ndipo imodzi isunthira pamzere wotsatira. Choncho, ndime yachiwiri imapangidwa mu selo.

6. Chitaninso chimodzimodzi ndi masentensi ena onse m’mawu olembedwa.

Zofunika! Pogwiritsa ntchito makiyi a Alt + Enter, simungathe kukulunga ndime zokha, komanso mawu aliwonse, potero kupanga ndime. Kuti muchite izi, ingoikani cholozera paliponse m'mawu ndi kukanikiza mabatani omwe awonetsedwa.

Njira 3: Gwiritsani ntchito zida zosinthira

Njira iyi yopangira ndime mu Microsoft Office Excel imaphatikizapo kusintha mawonekedwe a cell. Kuti mugwiritse ntchito, muyenera kutsatira njira zosavuta malinga ndi algorithm:

1. LMB kuti musankhe selo lomwe mawu otayidwawo sakukwanira chifukwa cha kukula kwake.
2. Dinani pagawo lililonse la chinthucho ndi batani lakumanja la mbewa.
3. Pazenera lomwe limatsegulira, dinani chinthucho "Format cell ...".

4. Muzosankha zopangira zinthu, zomwe zidzawonetsedwa mutatha kusinthana kale, muyenera kupita ku gawo la "Kulinganiza".
5. Mu gawo latsopano la menyu, pezani chipika cha "Zowonetsa" ndikusankha bokosi pafupi ndi "Manga ndi mawu".
6. Dinani Chabwino pansi pa zenera kuti mugwiritse ntchito zosintha.

7. Onani zotsatira. Selo idzasintha miyeso kuti mawuwo asapitirire malire ake, ndipo ndime idzapangidwa.

Njira 4. Kugwiritsa ntchito ndondomeko

Microsoft Office Excel ili ndi njira yapadera yopangira ndime, kukulunga malemba pamizere ingapo m'maselo a tebulo. Kuti muchite izi, mutha kugwiritsa ntchito algorithm yotsatirayi:

1. Sankhani selo yeniyeni ya tebulo la LMB. Ndikofunika kuti chinthucho poyamba chisakhale ndi malemba kapena zilembo zina.
2. Lowetsani chilinganizo pamanja kuchokera pa kiyibodi ya pakompyuta=CONCATENATE(“TEXT1″,CHAR(10),”TEXT2”)“. M'malo mwa mawu oti "TEXT1" ndi "TEXT2" muyenera kuyendetsa muzinthu zinazake, mwachitsanzo, lembani zilembo zofunika.
3. Mukamaliza kulemba, dinani "Enter" kuti mumalize fomula.

4. Onani zotsatira. Mawu otchulidwa adzayikidwa pamizere ingapo ya selo, kutengera kuchuluka kwake.

Zina Zowonjezera! Ngati ndondomeko yomwe takambiranayi sikugwira ntchito, wogwiritsa ntchitoyo ayenera kuyang'ana kalembedwe kake kapena agwiritse ntchito njira ina yopangira ndime mu Excel.

Momwe mungakulitsire fomula yopangira ndime ndi nambala yofunikira yama cell mu Excel

Ngati wogwiritsa ntchito akufunika kukulunga mizere muzinthu zingapo patebulo nthawi imodzi pogwiritsa ntchito njira yomwe takambirana pamwambapa, ndiye kuti liwiro la njirayi ndi lokwanira kukulitsa ntchitoyo kumagulu osiyanasiyana. Mwambiri, njira yowonjezerera fomula mu Excel ndi motere:

1. Sankhani selo lomwe lili ndi zotsatira za fomula.
2. Ikani cholozera cha mbewa kumunsi kumanja kwa chinthu chomwe mwasankha ndikusunga LMB.
3. Tambasulani selo pa chiwerengero chofunikira cha mizere ya tebulo popanda kutulutsa LMB.
4. Tulutsani kiyi yakumanzere ya manipulator ndikuwona zotsatira.

Kutsiliza

Chifukwa chake, kupanga ndime m'maselo a Microsoft Office Excel sikumayambitsa mavuto ngakhale kwa ogwiritsa ntchito osadziwa. Pakukulunga mizere yoyenera, ndikofunikira kutsatira malangizo omwe ali pamwambapa.