Kuphatikiza khola mu Microsoft Excel

Pogwira ntchito ku Excel, nthawi zina zimakhala zofunika kuphatikiza zipilala ziwiri kapena zingapo. Ogwiritsa ntchito ena sakudziwa momwe angachitire izi. Ena amangodziwa zosankha zosavuta. Tidzakambirana njira zonse zophatikizira zinthu izi, chifukwa munthawi zonse zimakhala zomveka kugwiritsa ntchito njira zingapo.

Kuphatikiza ndondomeko

Njira zonse zophatikiza mizati zitha kugawidwa m'magulu akulu awiri: kugwiritsa ntchito mitundu ndi kugwiritsa ntchito ntchito. Njira yopangira mawonekedwe ndiyosavuta, koma ntchito zina zophatikiza mizati zitha kuthetsedwa pokhapokha pogwiritsa ntchito ntchito yapadera. Ganizirani zosankha zonse mwatsatanetsatane ndikuwona momwe zingakhalire bwino kugwiritsa ntchito njira inayake.

Njira 1: kuphatikiza kugwiritsa ntchito mndandanda wa nkhani

Njira yodziwika kwambiri yophatikiza pazigawo ndikugwiritsa ntchito zida za menyu.

1. Sankhani mzere woyamba wamitundu yosanja kuchokera pamwamba yomwe tikufuna kuphatikiza. Timadina pazinthu zosankhidwa ndi batani loyenera la mbewa. Zosankha zam'mawu zimatsegulidwa. Sankhani zomwe zili mmenemo "Mtundu wamtundu ...".



2. Tsamba losintha maselo limatseguka. Pitani pa tabu ya "Alignment". M'magulu azokonda "Onetsani" pafupi paramenti Cell Union ikani chizindikiro. Pambuyo pake, dinani batani "Zabwino".



3. Monga mukuwonera, tinangophatikiza maselo apamwamba patebulopo. Tiyenera kuphatikiza maselo onse azigawo ziwiri mzere mzere. Sankhani khungu lolumikizidwa. Kukhala mu tabu "Pofikira" pa riboni, dinani batani "Mtundu wapangidwe". Kanemayo ali ndi mawonekedwe a burashi ndipo amapezeka pazida Clipboard. Pambuyo pake, ingosankha gawo lonse lomwe latsalira momwe mukufuna kuphatikizira mzati.



4. Mukatha kupanga mtunduwo, mizati ya tebulo iphatikizika kukhala imodzi.

Yang'anani! Ngati pakhala deta mu maselo ophatikizidwa, ndiye chidziwitso chokhacho chomwe chili mgulu loyambirira kumanzere kwa nthawi yosankhidwa ndi chomwe chidzasungidwe. Zina zonse zidzawonongedwa. Chifukwa chake, kupatula kosowa, njirayi imalimbikitsidwa kuti igwiritsidwe ntchito ndi maselo opanda kanthu kapena mizati yokhala ndi data yotsika mtengo.

Njira yachiwiri: kuphatikiza pogwiritsa ntchito batani pa riboni

Mutha kuphatikizanso mizati pogwiritsa ntchito batani pambali. Njira iyi ndi yoyenera kugwiritsa ntchito ngati mukufuna kuphatikiza osati mizati ya tebulo lina, koma pepalalo lonse.

1. Kuti muphatikize mizere pachidacho kwathunthu, ayenera kusankha. Tikufika pagawo logwirizanitsa la Excel, momwe mayina ammizati alembedwa zilembo za zilembo za Chilatini. Gwirani batani lakumanzere ndikusankha mizati yomwe tikufuna kuphatikiza.



2. Pitani ku tabu "Pofikira"ngati muli pagulu lina. Dinani pazithunzi mu mawonekedwe a pembetatu, nsonga ikuloza pansi, kumanja kwa batani "Phatikizani ndi pakati"ili pa riboni m'bokosi la chida Kuphatikiza. Menyu umatsegulidwa. Sankhani zomwe zili mmenemo Phatikizani Mzere.

Pambuyo pa izi, mizati yosankhidwa ya pepala lonse iphatikizika. Mukamagwiritsa ntchito njirayi, monga momwe idapangidwira kale, deta yonse, kupatula yomwe idali kumanzere kwambiri asanalumikizidwe, idzatayika.

Njira 3: Sonkhanitsani Ntchito

Nthawi yomweyo, ndizotheka kuphatikiza mizati popanda kutayika kwa deta. Kukhazikitsa njirayi ndizovuta kwambiri kuposa njira yoyamba. Imachitika pogwiritsa ntchito ntchito POPANDA.

1. Sankhani khungu lililonse pachuma chopanda patsamba la Excel. Kuyimbira Fotokozerani Wizarddinani batani "Ikani ntchito"ili pafupi ndi mzere wa fomula.



2. Windo limatseguka ndimndandanda wazinthu zosiyanasiyana. Tiyenera kupeza dzina pakati pawo. KONANI. Tikapeza, sankhani chinthuchi ndikudina batani "Zabwino".



3. Pambuyo pake, zenera zotsutsana ndi ntchito zimatsegulidwa POPANDA. Zotsutsana zake ndi ma adilesi amaselo omwe zomwe zimafunikira zimaphatikizidwa. Kulowa m'minda "Lemba1 ", "Lemba2 " etc. tifunika kulowa ma adilesi a maselo mzere wapamwamba wamizati yolumikizidwa. Mutha kuchita izi polemba ma adilesi pamanja. Koma, ndizosavuta kuyika chidziwitso m'munda wamakani yofananira, ndikusankha khungu kuti liphatikizidwe. Ndendende momwe timakhalira ndi maselo ena a mzere woyamba wa mizati yolumikizidwa. Pambuyo pazolumikizana zidawonekera m'minda "Test1", "Lemba2 " etc., dinani batani "Zabwino".



4. Mu khungu lomwe zotsatira za kukhathamiritsa ndi ntchito zimawonetsedwa, zosakanikirana za mzere woyamba wa mizati kuti ziwonetsedwe. Koma, monga tikuwona, mawu omwe ali m'chipindacho ndi zotsatirazi amamangiriridwa, palibe malo pakati pawo.

   

   Pofuna kuwalekanitsa, mu fomula itatha semicolon pakati pa maselo, ikani zilembo izi:

   " ";

   Nthawi yomweyo, timayika malo pakati pa zolemba ziwiri zowonjezera pamitunduyi. Ngati titalankhula za mtundu winawake, kwa ife kulowamo:

   = CLICK (B3; C3)

   zasinthidwa kukhala zotsatirazi:

   = CLICK (B3; ""; C3)

   Monga mukuwonera, malo akuwonekera pakati pa mawu, ndipo samalumikizananso. Ngati mungafune, mutha kuyika mahema kapena wina aliyense wogwirizanitsa ndi malo.



5. Koma, pakadali pano tikuwona zotsatira za mzere umodzi wokha. Kuti mupeze phindu la kuphatikiza kwa masamu mu maselo ena, tifunika kukopera ntchitoyo POPANDA mpaka m'munsi. Kuti muchite izi, ikani temberezo pakona ya m'munsi ya foni ili ndi fomula. Chizindikiro chodzaza ndi mawonekedwe a mtanda. Gwirani batani lakumanzere ndikulikokera kumapeto kwa tebulo.



6. Monga mukuwonera, fomuloli imakoperedwa kumitundu yomwe ili pansipa, ndipo zotsatirazi zikuwonetsedwa m'maselo. Koma timangoika zofunikira mbali imodzi. Tsopano muyenera kuphatikiza maselo oyambirirawo ndikubwezeretsanso zomwe zidakhazikitsidwa momwe zidakhalira. Ngati mungophatikiza kapena kufufuta mizati yoyambirira, ndiye kuti mwatsatanetsatane POPANDA idzasweka ndipo tidzataya idatha mwanjira iliyonse. Chifukwa chake, tichita mosiyana. Sankhani mzere ndi zotsatira zophatikizika. Pa "Home" tabu, dinani batani "Copy" lomwe lili pa riboni mu "Clipboard" chida. Monga njira ina, mukasankha mzati, mutha kuylemba makiyi pa kiyibodi Ctrl + C.



7. Khazikitsani chotengera ku malo aliwonse opanda pepalalo. Dinani kumanja. Pazosankha zomwe zikuwonekera Ikani Zosankha sankhani "Makhalidwe".



8. Tasunga zofunikira paziphatikizidwe, ndipo sizitengera fomuloli. Bwerezaninso, koperani izi, koma kuchokera kumalo atsopano.



9. Sankhani mzere woyamba wamtundu woyambirira, womwe ungafunike kuphatikizidwa ndi mizati ina. Dinani batani Ikani kuyikidwa pa tabu "Pofikira" pagulu lazida Clipboard. M'malo lomaliza kuchita, mutha kukanikiza njira yaying'ono pa kiyibodi Ctrl + V.



10. Sankhani mizati yoyambirira kuti iphatikizidwe. Pa tabu "Pofikira" mu bokosi la zida Kuphatikiza tsegulani menyu zomwe tidazolowera kale ndi njira yapita ndikusankha zomwe zili mmenemo Phatikizani Mzere.



11. Pambuyo pake, zenera lokhala ndi chidziwitso chakuchepetsa kwa data limatha kuwonekera kangapo. Nthawi iliyonse kanikizani batani "Zabwino".



12. Monga mukuwonera, pamapeto pake zosakanikazo zimaphatikizidwa m'chigawo chimodzi pamalo pomwe zinali zofunikira. Tsopano muyenera kufafaniza zapaulendo. Tili ndi madera awiri otere: mzati wokhala ndi mafomu ndi mzere wokhala ndi zolemba zosatsutsidwa. Timasankha mndandanda woyamba komanso wachiwiri. Dinani kumanja pamalo osankhidwa. Pazosankha zofanizira, sankhani Chotsani Zolemba.



13. Tikachotsa zapaulendo, timapanga fomali paliponse mwakufuna kwathu, chifukwa chifukwa cha mabungwe athu, mawonekedwe ake adakonzedwanso. Apa zonse zimatengera cholinga cha tebulo linalake ndipo zimatsalira malinga ndi wogwiritsa ntchito.

Pamenepa, njira yophatikiza zipilala popanda kuwononga deta imatha kuonedwa kuti ndi yathunthu. Inde, njirayi ndiyovuta kwambiri kuposa zomwe zidasankhidwa kale, koma nthawi zina ndizofunikira.

Phunziro: Ntchito Wizard ku Excel

Monga mukuwonera, pali njira zingapo zophatikiza zipilala mu Excel. Mutha kugwiritsa ntchito chilichonse, koma nthawi zina muyenera kusankha zina mwanjira inayake.

Chifukwa chake, ogwiritsa ntchito ambiri amakonda kugwiritsa ntchito mgwirizanowu kudzera pazosankha, monga zopatsa chidwi kwambiri. Ngati mukufunikira kuphatikiza mizati osati pagome pokha, koma papepala lonse, kenako kujambulidwa kudzera pazosankha zomwe zili pa riboni kudzakuthandizani Phatikizani Mzere. Ngati mukufuna kuphatikiza popanda kutaya deta, ndiye kuti mutha kuthana ndi ntchitoyi pokhapokha pogwiritsa ntchito ntchitoyo POPANDA. Ngakhale, ngati ntchito yosungitsa deta siyidafunsidwa, ndipo makamaka ngati maselo kuti aphatikizidwe mulibe, ndiye kuti njira iyi siyabwino. Izi ndichifukwa choti ndizovuta kwambiri ndipo kukhazikitsa kwake kumatenga nthawi yayitali.