Zamkatimu
Pakusintha mu Excel spreadsheet editor, nthawi zambiri zimakhala zofunikira kuphatikiza ma cell. Ndikosavuta kugwiritsa ntchito njirayi, makamaka ngati maselo alibe chidziwitso. M'malo omwe maselo ali ndi deta, zinthu zimakhala zosiyana pang'ono. Mu phunziro ili, tidziwa njira zonse zomwe zimatilola kugwiritsa ntchito kuphatikiza ma cell.
Kuphatikiza ma cell mu spreadsheet editor
Njirayi ndiyosavuta kugwiritsa ntchito ndipo imagwiritsidwa ntchito ngati:
- Phatikizani ma cell opanda kanthu;
- kuphatikiza ma cell nthawi yomwe pali gawo limodzi lodzaza ndi chidziwitso.
Malangizo atsatanetsatane amawoneka motere:
- Poyamba, tiyenera kusankha ma cell omwe titha kulumikizana wina ndi mnzake. Kusankhidwa kumapangidwa ndi batani lakumanzere. Pa gawo lotsatira, timapita ku gawo la "Home". Mu gawoli, tikupeza chinthu chomwe chili ndi dzina "Gwirizanitsani ndi malo pakati."
- Njira iyi imakulolani kuti muphatikize maselo osankhidwa kukhala amodzi, ndipo zambiri zomwe zili mkati mwawo ziziyikidwa pakati pamunda.
- Ngati wogwiritsa ntchito akufuna kuti deta isayikidwe pakatikati, koma mwanjira ina, ndiye kuti muyenera kudina muvi wawung'ono wakuda, womwe uli pafupi ndi chizindikiro chophatikiza ma cell. Pamndandanda wotsitsa, muyenera dinani chinthucho "Phatikizani Maselo".
- Njirayi imakulolani kuti muphatikize maselo osankhidwa kukhala amodzi, ndikuyika zambiri mkati mwawo kumanja.
- Kuphatikiza apo, mumkonzi wa tebulo, pali kuthekera kwa kulumikizana kwa zingwe zama cell. Kuti mugwiritse ntchito njirayi, m'pofunika kusankha malo omwe mukufuna, omwe adzaphatikizapo mizere ingapo. Kenako muyenera dinani kachidutswa kakang'ono kamdima, komwe kamakhala pafupi ndi chithunzi cholumikizira foni. Pamndandanda womwe umatsegulidwa, muyenera dinani chinthucho "Phatikizani ndi mizere".
- Izi zimakulolani kuti muphatikize maselo osankhidwa kukhala amodzi, komanso kusunga kusweka ndi mizere.
Kuphatikiza Maselo Pogwiritsa Ntchito Menyu Yachidziwitso
Kugwiritsa ntchito mndandanda wapadera wazinthu ndi njira ina yomwe imakupatsani mwayi wogwirizanitsa ma cell. Malangizo atsatanetsatane amawoneka motere:
- Timasankha mothandizidwa ndi batani lakumanzere la mbewa malo ofunikira, omwe tikukonzekera kuphatikiza. Kenako, dinani kumanja kulikonse mumndandanda wosankhidwa. Zosankha zazing'ono zawonekera pazenera, momwe muyenera kupeza chinthu chotchedwa "Cell Format ..." ndikudina ndi batani lakumanzere.
- Zenera latsopano linawonekera pachiwonetsero chotchedwa "Format Cells". Timapita ku gawo la "Alignment". Timayika chizindikiro pafupi ndi mawu akuti "Phatikizani maselo". Kuphatikiza apo, mutha kusintha magawo ena ophatikiza pawindo ili. Mutha kuyambitsa kusamutsa kwa chidziwitso ndi mawu, sankhani mawonekedwe osiyana, ndi zina zotero.. Tikapanga zoikamo zonse zofunika, dinani LMB pa chinthu "Chabwino".
- Okonzeka! Malo osankhidwa kale asinthidwa kukhala selo limodzi.
Kuphatikiza ma cell popanda kutaya zambiri
Maselo akamalumikizidwa nthawi zambiri, zonse zomwe zili mkati mwake zimachotsedwa. Tiyeni tiwunike mwatsatanetsatane momwe tingagwiritsire ntchito njira yolumikizira ma cell popanda kutaya zambiri.
Kuti tichite izi, tifunika kugwiritsa ntchito CONCATENATE. Malangizo atsatanetsatane amawoneka motere:
- Poyamba, tidzagwiritsa ntchito kuwonjezera selo yopanda kanthu pakati pa maselo omwe tikukonzekera kulumikiza. Kuti muchite izi, muyenera kudina kumanja pa nambala kapena mzere. Menyu yapadera yankhani idawonekera pazenera. Dinani LMB pa chinthu cha "Insert".
- Kaonedwe kawonse ka wogwiritsa ntchito: “=CONCATENATE(X;Y)”. Zotsutsana za ntchito ndi ma adilesi a ma cell oti alumikizike. Tiyenera kuchita ntchito yophatikizira ma cell B2 ndi D. Chifukwa chake, timalemba zotsatirazi mu cell yopanda kanthu C2: “=CONCATENATE(B2,D2). "
- Zotsatira zake, timapeza chidziwitso chophatikizika mu cell momwe tidalowamo fomula ili pamwambapa. Tikuwona kuti pamapeto pake tili ndi ma cell atatu: 3 oyamba ndi amodzi owonjezera, momwe chidziwitso chophatikizika chilili.
- Tiyenera kuchotsa maselo osafunika. Izi ziyenera kuchitika ndikudina kumanja pa selo C2, ndikusankha chinthu cha "Koperani" pamndandanda wotsitsa.
- Tsopano tikusunthira kumunda womwe uli kumanja kwa omwe adakopedwa. Mu cell yolondola iyi, muli chidziwitso choyambirira. Dinani kumanja pa selo ili. Menyu yapadera yankhani idawonekera pachiwonetsero. Pezani chinthu chotchedwa "Paste Special" ndikudina pacho ndi batani lakumanzere.
- Zenera lotchedwa "Paste Special" linawonekera pachiwonetsero. Timayika chizindikiro pafupi ndi mawu akuti "Values". Tikapanga zoikamo zonse zofunika, dinani LMB pa chinthu "Chabwino".
- Pamapeto pake, mu selo D2, tinapeza zotsatira za munda C2.
- Tsopano mutha kugwiritsa ntchito kuchotsa maselo osafunika B2 ndi C2. Sankhani ma cell awa, imbani menyu yankhaniyo ndi batani lakumanja la mbewa, kenako sankhani chinthu "Chotsani".
- Chotsatira chake, selo yokhayo inatsalira pamalo ogwirira ntchito, momwe chidziwitso chophatikizidwa chikuwonetsedwa. Maselo onse omwe adawuka panthawi yantchito achotsedwa, chifukwa sakufunikanso mu chikalatacho.
Ndikoyenera kudziwa kuti njira zonse zomwe zili pamwambazi zingagwiritsidwe ntchito ndi mizere ndi mizere.
Kutsiliza
Tapeza kuti njira yophatikiza ma cell ndi yosavuta kukhazikitsa. Kuti mugwirizane ndi ma cell, kusunga deta yoyambirira, muyenera kugwiritsa ntchito "CONCATENATE" woyendetsa. Ndikoyenera kwambiri musanayambe chinyengo kuti mupange zosunga zobwezeretsera za chikalata choyambirira kuti pakakhala zolakwika mutha kubweza chilichonse pamalo ake osataya chidziwitso chofunikira.