Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta

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:

  1. 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."
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
1
  1. Njira iyi imakulolani kuti muphatikize maselo osankhidwa kukhala amodzi, ndipo zambiri zomwe zili mkati mwawo ziziyikidwa pakati pamunda.
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
2
  1. 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".
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
3
  1. Njirayi imakulolani kuti muphatikize maselo osankhidwa kukhala amodzi, ndikuyika zambiri mkati mwawo kumanja.
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
4
  1. 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".
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
5
  1. Izi zimakulolani kuti muphatikize maselo osankhidwa kukhala amodzi, komanso kusunga kusweka ndi mizere.
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
6

Kuphatikiza Maselo Pogwiritsa Ntchito Menyu Yachidziwitso

Kugwiritsa ntchito mndandanda wapadera wazinthu ndi njira ina yomwe imakupatsani mwayi wogwirizanitsa ma cell. Malangizo atsatanetsatane amawoneka motere:

  1. 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.
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
7
  1. 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".
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
8
  1. Okonzeka! Malo osankhidwa kale asinthidwa kukhala selo limodzi.
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
9

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.

Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
10

Kuti tichite izi, tifunika kugwiritsa ntchito CONCATENATE. Malangizo atsatanetsatane amawoneka motere:

  1. 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".
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
11
  1. 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). "
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
12
  1. 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.
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
13
  1. Tiyenera kuchotsa maselo osafunika. Izi ziyenera kuchitika ndikudina kumanja pa selo C2, ndikusankha chinthu cha "Koperani" pamndandanda wotsitsa.
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
14
  1. 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.
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
15
  1. Zenera lotchedwa "Paste Special" linawonekera pachiwonetsero. Timayika chizindikiro pafupi ndi mawu akuti "Values". Tikapanga zoikamo zonse zofunika, dinani LMB pa chinthu "Chabwino".
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
16
  1. Pamapeto pake, mu selo D2, tinapeza zotsatira za munda C2.
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
17
  1. 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".
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
18
  1. Chotsatira chake, selo yokhayo inatsalira pamalo ogwirira ntchito, momwe chidziwitso chophatikizidwa chikuwonetsedwa. Maselo onse omwe adawuka panthawi yantchito achotsedwa, chifukwa sakufunikanso mu chikalatacho.
Momwe mungaphatikizire ma cell mu Excel spreadsheet. Kupyolera mu mndandanda wa nkhani komanso popanda kutaya deta
19

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.

Siyani Mumakonda