Ungahlukanisa kanjani iseli ku-Excel. Izindlela ezi-4 zokuhlukanisa amaseli ku-Excel

Ukwethulwa kwedokhumenti kuncike ngokuqondile ekutheni idatha yakhiwe kanjani. Ungasiza ukuhlela idatha ngendlela enhle nelula ngokuyifometha ibe amatafula ku-Excel, okungenakwenzeka ukusebenza ngaphandle kokusebenza okuhlukahlukene ngamaseli. Izinguquko kumaseli, imigqa namakholomu zisiza ukwenza ithebula lifundeke kakhudlwana futhi libe lihle, amaseli ahlukanisayo kungenye inketho enjalo. Kunezindlela ezimbalwa ezilula ezithandwayo zokuhlukanisa amaseli, okuzoxoxwa ngakho ngezansi.

Indlela 1: Ukuhlanganisa Amaseli Asondelene Amaningi

Iseli kuthebula iyunithi yokulinganisa encane kakhulu ngakho-ke iyingxenye engahlukaniseki. Umsebenzisi angakwazi ukushintsha usayizi wawo, awuhlanganise nomakhelwane, kodwa angawuhlukanisi. Kodwa-ke, ngosizo lwamanye amaqhinga, ungenza ukuhlukaniswa okubonakalayo kube mpo, umugqa ovundlile kanye ne-diagonal. Usebenzisa le ndlela, ungahlukanisa amaseli ku-Excel ngokuhlanganisa amaseli ancikene. I-algorithm elandelayo:

  • Thola amaseli azohlukaniswa. Kulesi sibonelo, ukuhlukaniswa kube izingxenye ezi-2 kuzocatshangelwa.
  • Khetha amaseli amabili ancikene, chofoza okuthi “Hlanganisa futhi Maphakathi” kuthebhu ethi “Ukuqondanisa”.
  • Yenza okufanayo nakwamanye amaseli emgqeni.
Ungahlukanisa kanjani iseli ku-Excel. Izindlela ezi-4 zokuhlukanisa amaseli ku-Excel
1

Ngokufanayo, ungenza ukwahlukanisa ube inombolo ehlukile yezingxenye ngaphandle kwezimbili. Ngokuqhubekayo, usebenzisa izenzo ezijwayelekile, ungalungisa osayizi bamaseli, amakholomu nemigqa. Ngenxa yalokho, amakholomu angaphansi kweseli azohlukaniswa ngokubukeka abe yisigamu, futhi ulwazi oluvela etafuleni luzotholakala maphakathi neseli.

Indlela 2: hlukanisa amaseli ahlanganisiwe

Indlela isetshenziselwa ukuhlukanisa amaseli athile kuthebula noma yikuphi kudokhumenti. Udinga ukwenza lezi zinyathelo ezilandelayo:

  • Khetha amakholomu noma imigqa kuphaneli yezixhumanisi lapho amaseli ahlukene azoba khona. Kulesi sibonelo, kuzoba nokuhlukaniswa ngamakholomu.
  • Chofoza umcibisholo kubha yamathuluzi eduze kwesithonjana sokuhlanganisa nokuthi maphakathi bese ukhetha Hlanganisa Ngemigqa.
  • Kusuka kumakholomu angu-2 ngokubonakalayo kuzovela eyodwa. Okulandelayo, kufanele uthole izakhi ezizohlukaniswa zibe izingxenye ezimbili, chofoza kuzo bese ukhetha "Hlanganisa futhi ubeke phakathi."
Ungahlukanisa kanjani iseli ku-Excel. Izindlela ezi-4 zokuhlukanisa amaseli ku-Excel
2

Ngendlela efanayo, ungahlukanisa ube izingxenye eziningi, kodwa uzodinga ukuhlanganisa ikholomu ngayinye ngokwehlukana. Ngale ndlela, amaseli akhethiwe azohlanganiswa abe elilodwa, futhi okuqukethwe kuzobekwa phakathi nendawo.

Kubalulekile ukuqaphela ukuthi ukuhlukanisa amaseli akuzuzisi ngaso sonke isikhathi. Kungcono ukuyisebenzisa uma udinga kuphela ukuhlukanisa iseli. Uma ukuhlunga nokunye kusetshenziswa kudokhumenti, ama-elementi ahlukene azokweqiwa.

Indlela yesi-3: Ukuhlukaniswa kwamaseli ediagonal

Amathebula amaningi angase adinge ukwahlukaniswa hhayi ngokuqondile nangokuvundlile, kodwa ngokudayagonali. Ungenza ukuhlukaniswa kwe-diagonal usebenzisa amathuluzi e-Excel akhelwe ngaphakathi. Ukuze wenze lokhu udinga:

  • Chofoza kwesokudla entweni lapho kudingeka khona ukuhlukaniswa kwe-diagonal, faka umbhalo kuyo ngemigqa emibili.
  • Khetha "Fometha Amaseli".
  • Ewindini elivelayo, khetha ithebhu "Border". Okulandelayo, izithonjana ezimbili ezine-diagonal division zizovela, udinga ukukhetha ezifanele. Amapharamitha womugqa angalungiswa njengoba kudingeka.
  • Chofoza futhi inkinobho enomugqa we-diagonal.
  • Cindezela OK.
Ungahlukanisa kanjani iseli ku-Excel. Izindlela ezi-4 zokuhlukanisa amaseli ku-Excel
3

Nakani! Iseli lizohlukaniswa ngokubonakalayo, kodwa uhlelo luyibona iyonke.

Indlela yesi-4: Dweba isihlukanisi ngethuluzi le-Shapes

Umsebenzi wokufaka umumo ungase futhi usetshenziselwe ukuhlukanisa imidwebo ngokudweba umugqa. I-algorithm elandelayo:

  • Khetha into ozoyihlukanisa.
  • Yiya kuthebhu ethi "Faka" bese uchofoza "Amamo".
  • Khetha uhlobo lomugqa olufanele ohlwini lwezinketho eziphakanyisiwe.
  • Sebenzisa inkinobho yegundane engakwesokunxele ukuze udwebe isihlukanisi.
Ungahlukanisa kanjani iseli ku-Excel. Izindlela ezi-4 zokuhlukanisa amaseli ku-Excel
4

Iseluleko! Kuthebhu ethi "Fometha", ungashuna kahle umugqa odwetshiwe.

Isiphetho

Ukufundeka kungenye yezidingo eziyinhloko zanoma iyiphi idatha ehlelekile. Uma ithebula lizoba nokubukeka okuyinkimbinkimbi namaseli ahlanganisiwe noma ahlanganisiwe, imigqa noma amakholomu, uzodinga ukwenza imisebenzi efanele. Ngisho noma iseli liyinto encane kakhulu yetafula, amathuluzi akhelwe ngaphakathi ku-Excel akuvumela ukuthi uyihlukanise ngokuyibuka ibe izingxenye ezi-2, ezi-3 noma ngaphezulu noma yikuphi kuthebula usebenzisa izindlela ezingenhla.

shiya impendulo