Momwe mungaphatikizire ma cell mu Excel

Maselo ophatikizidwa mu Excel ndi chida champhamvu chomwe chimakulolani kuti muphatikize ndikulinganiza zambiri bwino mu spreadsheet. Mbali yapamwambayi imapatsa ogwiritsa ntchito mwayi wogwira ntchito ndi deta m'njira yokonzekera komanso yowoneka bwino. M'nkhaniyi, tiwona mwatsatanetsatane momwe mungaphatikizire ma cell mu Excel komanso momwe mungagwiritsire ntchito bwino izi kuti muwongolere ntchito zanu mu pulogalamuyi. Kuchokera ku njira zoyambira kupita ku malangizo apamwamba, mupeza momwe mungaphatikizire ma cell bwino ndi kukwaniritsa zotsatira za akatswiri muma projekiti anu. Ngati mukufuna konzani luso lanu ndi Excel ndikuwongolera mbali yofunikayi, werengani kuti mupeze kalozera wathunthu wamomwe mungaphatikizire maselo.

1. Chiyambi cha kuphatikiza ma cell mu Excel

Mu Excel, kuphatikiza ma cell ndi ntchito yothandiza kuphatikiza ma cell awiri kapena angapo oyandikana kukhala cell imodzi. Izi zitha kukhala zothandiza makamaka mukafuna kukonza mawonekedwe a spreadsheet kapena mukafuna kupanga mitu yayikulu, yolimba kapena mitu. Kuphatikiza apo, kuphatikiza ma cell kungapangitse kuti zikhale zosavuta kukonza ndikusintha deta mu spreadsheet.

Kuti muphatikize ma cell mu Excel, njira zotsatirazi zitha kutsatiridwa:

• Sankhani ma cell omwe mukufuna kuphatikiza. Izi zitha kuchitika gwira batani la "Ctrl" ndikudina pa selo lililonse, kapena kukoka mbewa kuti musankhe a maselo osiyanasiyana.
• Dinani kumanja pamaselo osankhidwa ndikusankha "Maselo a Format" kuchokera pamenyu yoyambira.
• Mu tabu ya "Kulinganiza", chongani bokosi la "Lowani Maselo" pansi pa gawo la "Horizontal" ndikudina "Chabwino" batani.

Ndikofunikira kuzindikira kuti pophatikiza ma cell, zomwe zili mu cell yakumanzere yakumanzere ndizokhazikika mu cell yophatikizidwa. Zomwe zili m'maselo ena zidzachotsedwa. Kuti muwonetsetse kuti zomwe zili m'maselo ophatikizidwa zimakutidwa bwino, mutha kugwiritsa ntchito "Wrap Text" pa "Home" tabu ya riboni ya Excel.

2. Kodi kuphatikiza ma cell ndi chiyani ndipo n'chifukwa chiyani kuli kothandiza mu Excel?

Kuphatikiza ma cell mu Excel ndi ntchito yomwe imakupatsani mwayi wophatikiza ma cell awiri kapena kuposerapo kukhala cell imodzi yayikulu. Izi ndizothandiza mukafuna kupanga mutu kapena mutu patebulo kapena mukafuna kuwunikira gawo lofunikira la data.

Kuti tiphatikize ma cell mu Excel, choyamba tiyenera kusankha ma cell onse omwe tikufuna kuphatikiza. Kenako, dinani kumanja pamaselo osankhidwa ndikusankha njira ya "Gwirizanitsani Maselo" kuchokera pamenyu yotsitsa.

Ndikofunikira kudziwa kuti pophatikiza ma cell, zomwe zili mu cell yakumanzere yakumanzere ndizomwe zimawonetsedwa mu cell yomwe ikubwera. Ngati pali deta m'maselo oyandikana nawo, idzatayika. Kuphatikiza apo, mawonekedwe amtundu wa ma fuse cell adzagwiritsidwa ntchito ku cell yomwe ikubwera.

Mwachidule, kuphatikiza maselo mu Excel ndi ntchito yomwe imakupatsani mwayi wophatikiza maselo awiri kapena angapo kukhala amodzi. Ndizothandiza kupanga pamutu, onetsani magawo ofunikira a data, ndikuwongolera mawonekedwe a spreadsheet. Kumbukirani kuti kuphatikiza ma cell kumataya zomwe zili m'maselo oyandikana ndikugwiritsa ntchito mawonekedwe a maselo osakanikirana.

3. Njira zophatikizira ma cell mu Excel

Kuphatikiza ma cell mu Excel ndi ntchito yothandiza kwambiri yomwe imatilola kuphatikiza ma cell awiri kapena angapo kukhala cell imodzi yayikulu. Izi zitha kukhala zothandiza ngati tikufuna kuwunikira mutu kapena kupanga zilembo zazikulu patebulo. M'munsimu muli:

1. Sankhani ma cell omwe mukufuna kuphatikiza. Mutha kuchita izi pogwira fungulo la Ctrl ndikudina pamaselo amodzi, kapena mutha kudina ndikukoka kuti musankhe. ma cell osiyanasiyana.

2. Pitani ku tabu "Kunyumba" pa riboni ndikuyang'ana gulu la "Kulinganiza". Dinani batani la "Gwirizanitsani ndi Pakati" kuti muphatikize ma cell osankhidwa ndikuyika zomwe zatuluka.

4. Njira zophatikizira ma cell mu Excel

5. Momwe Mungaphatikizire Maselo Molunjika mu Excel

Kuti muphatikize ma cell mozungulira mu Excel, tsatirani izi:

1. Sankhani ma cell omwe mukufuna kuphatikiza. Mutha kusankha cell imodzi kapena ma cell angapo.

2. Pitani ku tabu ya "Home" pa toolbar ya Excel ndikuyang'ana gulu la "Kulinganiza". Dinani batani la "Phatikizani ndi Pakati" kuti mutsegule menyu yotsitsa.

3. Kuchokera dontho-pansi menyu, kusankha "Phatikizani maselo" njira. Maselo osankhidwa aphatikizidwa kukhala selo limodzi mopingasa. Zomwe zili m'maselo zidzayikidwa mu selo loyamba lophatikizidwa ndipo maselo ena adzasiyidwa opanda kanthu.

6. Momwe Mungaphatikizire Maselo Molunjika mu Excel

Phatikizani maselo vertically mu Excel ndi ntchito yothandiza yomwe imatithandiza kuphatikiza zomwe zili m'maselo awiri kapena angapo kukhala selo limodzi. Izi ndizothandiza makamaka tikakhala ndi tebulo kapena spreadsheet yokhala ndi data yomwe tikufuna kufotokoza mwachidule kapena kuwonetsa mwadongosolo. M'munsimu muli njira zochitira izi:

1. Sankhani ma cell omwe mukufuna kuphatikiza. Kuti muchite izi, dinani ndikugwira kiyi Ctrl pamene kuwonekera pa maselo mukufuna kuphatikiza. Mutha kusankha ma cell olumikizana kapena osalumikizana.

2. Dinani kumanja pa imodzi mwa maselo osankhidwa ndikusankha njirayo "Mawonekedwe a cell" mu menyu yotsitsa. Zenera la zokambirana lidzatsegulidwa.

3. Mu tabu "Mayikidwe" Pazenera la masanjidwe a ma cell, chongani bokosi "Phatikizani ma cell" mu gawo "Kulinganiza malemba". Izi ziphatikiza ma cell omwe asankhidwa.

7. Momwe mungaphatikizire ma cell mu Excel ndikusunga zoyambira

8. Momwe mungasinthire ma cell mu Excel

Kuti mutsegule ma cell mu Excel, tsatirani njira zosavuta izi.

1. Sankhani maselo ophatikizidwa omwe mukufuna kusintha. Kuti muchite izi, gwirani Ctrl kiyi ndikudina pa selo iliyonse. Ngati ma cell ophatikizidwa apanga mndandanda wolumikizana, mutha kusankha selo loyamba ndikukokera cholozera kupita ku selo lomaliza.

2. Maselo akasankhidwa, pitani ku tabu ya "Home" pa toolbar ya Excel. Pagulu la "Malumikizidwe", dinani chizindikiro cha "Merge and Center". Mudzawona kuti chisankhocho chalembedwa ndi kamvekedwe ka imvi, zomwe zimasonyeza kuti maselo aphatikizidwa. Dinani chizindikiro chomwechi kuti musasankhe ndikuchotsa ma cell.

9. Mavuto wamba pophatikiza ma cell mu Excel ndi momwe angawakonzere

Mukaphatikiza ma cell mu Excel, ndizofala kukumana ndi zovuta zina zomwe zingapangitse kuti ntchitoyi ikhale yovuta. Komabe, ndi njira zolondola, zopingazi zimatha kugonjetsedwa mosavuta. Pano tiwona zina mwazovuta zomwe zimachitika kwambiri komanso momwe tingawathetsere.

Mmodzi wa mavuto ambiri pamene kuphatikiza maselo deta imfa. Izi zimachitika pamene ma cell akuphatikizidwa amakhala ndi chidziwitso ndipo mukawaphatikiza, zina kapena zonse zimatayika. Pofuna kupewa izi, ndikofunikira kuchita kopi yachitetezo za data musanaphatikize ma cell. Kuonjezera apo, njira ya "Phatikizani ndi Pakati" ingagwiritsidwe ntchito m'malo mwa "Phatikizani Maselo" kuti musunge deta yoyambirira.

Vuto linanso lodziwika bwino ndilakuti masanjidwe amasokonekera pophatikiza ma cell. Mukachita izi, mawonekedwe amtundu wotsatira sangakhale momwe amayembekezera. Kuti tichite izi, tikulimbikitsidwa kugwiritsa ntchito masanjidwewo musanaphatikize ma cell. Izi zikuphatikizapo kusintha m'lifupi m'lifupi ndi kutalika kwa mizere, komanso mawu ochititsa chidwi kwambiri kapena otsikira pansi. Ndikofunikiranso kuzindikira kuti pophatikiza ma cell, mapangidwe a cell yakumanzere yakumanzere adzagwiritsidwa ntchito ku selo lomwe likubwera.

10. Malangizo ndi Njira Zabwino Zophatikiza Maselo mu Excel

Kuphatikiza ma cell mu Excel kumatha kukhala ntchito yothandiza kukonza ndikupereka deta moyenera. Komabe, ndikofunikira kukumbukira njira zina zabwino zopewera zovuta komanso kusunga kukhulupirika kwa data. Pansipa pali maupangiri ndi malingaliro ophatikiza ma cell mu Excel:

1. Konzani masanjidwe a tebulo: Musanaphatikize ma cell, ndikofunikira kukonzekera makonzedwe a tebulo kapena ma cell. Izi zili choncho chifukwa kuphatikiza ma cell kungakhudze momwe deta imawerengedwera, kusefedwa, kapena mafomuwa. Ndikoyenera kuphatikiza ma cell okha omwe ali ofunikira kuti pakhale mawonekedwe a tebulo ndikupewa kuphatikiza ma cell omwe ali ndi data yovuta.

2. Gwiritsani ntchito njira ya "Center" mutaphatikiza: Mukaphatikiza ma cell mu Excel, zolemba kapena deta sizingakhale zokha. Kuti muwonetsetse kuti zomwe zaphatikizidwazo zakhazikika bwino, sankhani kuchuluka kwa maselo ophatikizidwa, dinani kumanja ndikusankha "Maselo a Format". Mu tabu "Malumikizidwe", sankhani njira ya "Center" mozungulira komanso molunjika.

3. Pewani kuwerengera kapena kulowetsa deta m'maselo ophatikizana: Ngakhale kuti n'zotheka kuwerengera kapena kulowetsa deta m'maselo ophatikizidwa, izi zikhoza kusokoneza kasamalidwe ka deta ndikukhudza kulondola kwa zotsatira. Ndibwino kuti musamachite masamu kapena kulemba mawu mwachindunji m'maselo ophatikizidwa, chifukwa izi zingayambitse mavuto powerengera kapena kusanja deta. Selo loyandikana litha kugwiritsidwa ntchito kuyika deta yofananira kapena ma fomula m'malo mwake.

11. Momwe mungagwiritsire ntchito chophatikiza ndi chapakati pophatikiza ma cell mu Excel

Kuphatikizika ndi ntchito yapakati mu Excel ndi chida chothandiza kwambiri chophatikiza ma cell ndikusintha ma data mu spreadsheet. Kuti mugwiritse ntchito izi, njira zotsatirazi ziyenera kutsatiridwa:

1. Sankhani ma cell omwe mukufuna kuphatikiza. Mutha kusankha ma cell angapo pogwira batani la Ctrl ndikudina lililonse.
2. Dinani kumanja pamaselo osankhidwa ndikusankha njira ya "Gwirizanitsani ndi Pakati" pamenyu yotsitsa.
3. Mudzawona kuti maselo osankhidwa akuphatikizidwa kukhala selo limodzi ndipo zomwe zili mkati mwake zimakhazikika.

Ndikofunikira kuzindikira kuti pophatikiza ma cell, zomwe zili mu cell yakumanzere yakumanzere zimasungidwa. Ngati pali deta m'maselo ena osankhidwa, idzatayika.

Ngati mukufuna kuchotsa ma cell, ingosankhani selo lophatikizidwa ndikudina kumanja. Ndiye, kusankha "Gawani Maselo" njira pa dontho-pansi menyu. Maselo adzagawanika ndipo deta idzabwezeretsedwa ku maselo oyambirira.

12. Momwe mungagwiritsire ntchito mafomu pamaselo ophatikizidwa mu Excel

Kuyika mafomu pamaselo ophatikizidwa mu Excel kungawoneke ngati kovuta, koma potsatira njira zoyenera, ndizotheka kuzikwaniritsa bwino. M'munsimu muli malangizo ena ofunikira pokonza ma cell ophatikizidwa:

• Sankhani maselo ophatikizidwa omwe mukufuna kuyika masanjidwewo. Mutha kuchita izi podina ndi kukoka mbewa pamaselo, kapena mutha kugwiritsanso ntchito kiyi ya Shift kuti musankhe imodzi ndi imodzi.
• Pazida za Excel, pitani ku tabu ya "Home" ndikuyang'ana gawo la "Font" momwe mungasinthire mawonekedwe, kukula ndi kalembedwe. Mupezanso mwayi wogwiritsa ntchito molimba mtima, pansi pamzere kapena mawu opendekera.
• Kuti mupange manambala m'maselo ophatikizidwa, sankhani maselo ndikupita ku tabu "Kunyumba". Pagawo la "Nambala", sankhani mtundu womwe mukufuna, monga ndalama, maperesenti, kapena mtundu wamasiku.

Ndikofunika kukumbukira kuti masanjidwe omwe agwiritsidwa ntchito adzafikira ma cell onse ophatikizidwa omwe akusankhidwa. Ngati mukufuna kulembetsa mitundu yosiyanasiyana kumaselo enaake ophatikizika, muyenera kusintha kusanja kwanu musanagwiritse ntchito mawonekedwe omwewo. Mukhozanso kugwiritsa ntchito mwambo mtundu chida kulenga wapadera akamagwiritsa malinga ndi zosowa zanu. Tsatirani izi ndipo mutha kugwiritsa ntchito mawonekedwe mosavuta pama cell anu ophatikizidwa mu Excel.

13. Momwe mungawerengere ndi ma cell ophatikizidwa mu Excel

Kuwerengera ndi maselo ophatikizidwa mu Excel kungakhale kovuta, chifukwa izi zingayambitse chisokonezo pochita masamu. Komabe, pali njira ndi njira zosiyanasiyana zomwe zingathandize izi ndikutsimikizira zotsatira zolondola. M'nkhaniyi, tipereka malangizo ndi maupangiri owerengera ndi ma cell ophatikizidwa mu Excel bwino.

Gawo loyamba powerengera ndi ma cell ophatikizana ndikuwonetsetsa kuti ma cell omwe aphatikizidwa alibe ma values ​​kapena ma formula omwe adzagwiritsidwe ntchito powerengera. Kupanda kutero, muyenera kukonzanso kwakanthawi kuphatikizako, kutengera zofunikira kapena ma formula, kenako ndikuphatikizanso. Izi zidzapewa zolakwika pazotsatira ndikuwonetsetsa kukhulupirika kwa data.

Njira ina yowerengera ndi ma cell ophatikizidwa ndikugwiritsa ntchito "Equals" m'maselo oyandikana ndi ma cell ophatikizidwa. Izi zimalola mtengo kapena fomula yamaselo ophatikizidwa kuti akopeleredwe kumaselo oyandikana nawo. Mwanjira iyi, mtengo kapena chilinganizo choyambirira chidzasungidwa ndipo kuwerengera komwe mukufuna kungathe kuchitika popanda mavuto. Mukamaliza, maselo owonjezera amatha kuchotsedwa popanda kusokoneza zotsatira.

14. Momwe mungagwiritsire ntchito njira yogawa ma cell ophatikizidwa mu Excel

Ngati mudakumana ndi vuto lokhala ndi ma cell ophatikizidwa mu Excel ndipo muyenera kuwagawa m'maselo amodzi, muli pamalo oyenera! Mwamwayi, Excel imapereka njira yomwe imakupatsani mwayi wochita izi mwachangu komanso mosavuta. Kenako, ine kukusonyezani inu sitepe ndi sitepe.

1. Sankhani maselo ophatikizidwa omwe mukufuna kuwagawa. Mutha kuchita izi pogwira batani la 'Ctrl' kwinaku mukudina selo lililonse.

2. Pitani ku 'Home' tabu mu kapamwamba menyu ndi kuyang'ana kwa 'Align Text' gulu. Dinani kamuvi kakang'ono kumunsi kumanja kwa ngodya ya gulu kuti mutsegule zokambirana.

3. Mu bokosi la zokambirana, onetsetsani kuti muli pa tabu ya 'Kulinganiza'. Chotsani cholembera m'bokosi lomwe likuti 'Gwirizanitsani Ma cell' ndikudina 'Chabwino'.

Ndipo ndi zimenezo! Tsopano ma cell ophatikizidwa adagawika m'maselo amodzi mu Excel. Izi ndizothandiza makamaka mukafuna kugwiritsa ntchito deta yomwe ili m'maselo ophatikizana, chifukwa imakulolani kuti mugwire nawo ntchito pawokha. Ndikukhulupirira kuti yankho ili likuthandizani komanso limathandizira ntchito zanu mu Excel.

Pomaliza, kuphatikiza ma cell mu Excel kumatha kukhala ntchito yothandiza kukonza mafotokozedwe ndi dongosolo la data mumaspredishithi. Ntchitoyi imatithandiza kuphatikiza ma cell angapo kukhala amodzi, zomwe zitha kukhala zothandiza kwambiri pakuwunikira mitu kapena zolemba pamakalata athu. Kuphatikiza apo, taphunzira momwe tingaphatikizire ma cell mozungulira komanso molunjika, komanso momwe tingathere izi ngati kuli kofunikira. Ndikofunika kukumbukira kuti kugwirizanitsa maselo kuyenera kugwiritsidwa ntchito mosamala, chifukwa kungakhudze kasamalidwe ndi kusintha kwa chidziwitso mu spreadsheets yathu. Mwachidule, kuphatikiza ma cell ndi chida chamtengo wapatali chomwe amatipatsa Excel, zomwe zimatilola kukonza zokometsera ndi kulinganiza deta yathu m'njira yosavuta komanso yothandiza.