Ungahlukanisa kanjani iseli libe amaseli amaningi ku-Excel

Ngokuzenzakalelayo, alikho ithuluzi elingasiza ukuhlukanisa amaseli ku-Excel. Ngakho-ke, uma kunesidingo sokudala inhlokweni yetafula eliyinkimbinkimbi, kuzodingeka usebenzise amaqhinga ambalwa. Azosiza ukuhlukanisa amaseli e-Excel ngaphandle kokufaka engozini ulwazi olukumathebula. Ngale njongo, sisebenzisa izindlela eziningana.

Indlela yokuqala: ukuhlanganisa okulandelwa ukuhlukanisa

Ngaphambi kokuba siqale inqubo, ake sicabange ngokucophelela ngesakhiwo setafula. Kutuswa ngisho ukuyidweba ephepheni. Manje ake siphendukele ekuhleleni isinyathelo ngesinyathelo kweshidi le-Excel:

1. Khetha amaseli amabili noma amathathu kumugqa wokuqala endaweni lapho kuzotholakala khona ithebula.

2. Iya kuthebhu ethi "Ekhaya", bheka ibhulokhi ethi "Ukuqondanisa", chofoza kuyo ithuluzi elithi "Hlanganisa kanye nendawo".

3. Siyabona ukuthi ukuhlukaniswa kwesiqephu esikhethiwe kunyamalele. Ngakho, kwavela iwindi elilodwa eliqinile. Ukuze sibone lokhu kangcono, masidale imingcele ecacile. Ukuze wenze lokhu, kubhulokhi ethi "Font", sebenzisa ithuluzi elithi "All Borders".

4. Manje khetha amakholomu ngaphansi kwamaseli ahlanganisiwe bese usetha imigqa emaphethelweni amaseli ngendlela efanayo. Njengoba ubona, amaseli ahlukanisiwe atholakala, futhi ingxenye engenhla, eqokwe ngaphansi kwesihloko, ayishintshi ubuqotho bayo.

Ngokufanayo, ungakha unhlokweni onamazinga amaningi ngenani elingenamkhawulo lamaseli ahlanganisiwe ezindaweni ezihlukene ekhasini.

Indlela Yesibili: Ukuhlukanisa Amaseli Asevele Ahlanganisiwe

Ake sicabange ukuthi ithebula lethu selivele selinokuhlanganyela kumafasitela eMicrosoft Excel. Kodwa sizozihlanganisa ngaphambi nje kokuhlukaniswa ukuze siqonde kangcono isibonelo somyalelo onikeziwe. Ngemuva kwalokho, kuzokwazi ukuwahlukanisa ukuze udale inhlokweni yesakhiwo setafula. Ake sibone ukuthi lokhu kwenziwa kanjani ekusebenzeni:

1. Khetha amakholomu amabili angenalutho ku-Excel. (Zingaba ngaphezulu, kuye ngesidingo). Bese uchofoza ithuluzi elithi "Hlanganisa futhi ubeke phakathi nendawo", litholakala kubhulokhi elithi "Ukuqondanisa". Chofoza okuthi “Hlanganisa Amaseli”.

2. Ngemva kokufaka imingcele ngendlela evamile kithi (njengasesigabeni esandulele). Sidinga ukuthola ifomethi yethebula. Ukuthi izobukeka kanjani cishe, ungabona esithombeni-skrini:

3. Ukuze sihlukanise iwindi elikhulu eliwumphumela libe amaseli, sizosebenzisa ithuluzi elifanayo lokuhlanganisa kanye nokuthi Maphakathi. Kuphela manje, ngokuchofoza ibhokisi lokuhlola, sikhetha "Khipha Amaseli" - atholakala ekugcineni ohlwini lwamathuluzi. Ungakhohlwa ukukhetha kusengaphambili ibanga ku-e-book elidinga ukuhlukaniswa.

4. Ithebula lizothatha ifomu esilifunayo. Ububanzi obukhethiwe kuphela obuzohlukaniswa ngenani lamaseli ebeliyiwo ngaphambi kokuhlanganiswa. Awukwazi ukwandisa inombolo yabo.

Encwadini! Kuvela ukuthi lapho sihlukanisa, asitholi iwindi elilodwa, kodwa amabili ahlukene. Ngakho-ke, lapho ufaka idatha noma, ikakhulukazi, amafomula okwenza izibalo, cabangela lokhu.

Indlela yesithathu: ukuhlukanisa amaseli ngokudayagonali

Ukuhlukaniswa kwe-diagonal kwenziwa ngokufometha. Lesi simiso sibandakanya ukuhlukaniswa kwamaseli avamile, maqondana nokufometha okungasetshenzisiwe.

1. Khetha iseli oyifunayo kunkambu yeshidi le-Excel, bese uchofoza kwesokudla kuyo ukuze uveze imenyu yokuqukethwe. Kuyo sithola ithuluzi elithi "Fometha Amaseli".

2. Ewindini elivulayo, iya kuthebhu ethi "Border". Kwesokunxele, khetha umugqa we-diagonal, bese ucindezela inkinobho ethi KULUNGILE. Ngakwesokudla ungathola umugqa ofanayo, kodwa ngokuphambene.

3. Ngakwesokunxele, kukhona amathuluzi okufometha esingakhetha kuwo uhlobo lomugqa noma ukushintsha umthunzi womngcele.

4. Lawa mathuluzi asiza ukwenza kube ngokwakho ukufometha.

Kodwa-ke, iseli elihlukaniswe ngale ndlela lisalokhu liyithuluzi elilodwa, ngakho-ke, ukuze ufake idatha kusuka phansi nangaphezulu kuyo, kufanele uqale welule iseli bese ukhetha ifonti efanelekile ukuze ilingane kahle okufakiwe.

Encwadini! Uma uthatha iseli bese ulihudulela phansi, amanye amawindi emigqa noma amakholomu azothatha ngokuzenzakalelayo ifomethi efanayo. Konke kuncike ekutheni ukushanela kuzokwenziwa ngakuphi (phansi noma eceleni).

Indlela yesine: ukuhlukaniswa kwe-diagonal ngokufaka

Kule ndlela, siphakamisa ukusebenzisa indlela okudingeka ngayo ukufaka ubujamo bejometri. Indlela esebenza ngayo, siphakamisa ukuthi siyicabangele kuleli bhukwana.

1. Khetha iseli eyodwa ofuna ukufaka kuyo isihlukanisi, bese udlulela kuthebhu ethi “Faka”, bese uthola ingxenye ethi “Imifanekiso”, chofoza kuyo isengezo esithi “Amamo.

2. Uhlu lwamajamo angasetshenziswa luyavuleka. Kuyo sithola isigaba "Imigqa" bese uchofoza umugqa we-diagonal.

3. Bese sidweba lo mugqa kuseli esilidingayo. Ngokuphathelene nayo, singasebenzisa izinketho ezihlukahlukene zokufometha: shintsha umthunzi, ukujiya, uhlobo lomugqa, faka imiphumela.

Ngemva kokudweba imigqa, ngeke kwenzeke ukubhala umbhalo nhlangothi zombili zomugqa we-diagonal. Ngakho-ke, ukufaka imininingwane yombhalo noma yezinombolo kuyadingeka ngaphambi kokudweba. Ukuze umugqa uvumelane kamuva futhi "ungasiki" umbhalo, kuyadingeka ukusebenzisa kahle izikhala kanye "Faka".

Encwadini! Inketho enhle ukudala itafula elinezinhlobo ezifiselekayo zamaseli ku-Word, bese uliguqulela ku-Excel.

Ukufingqa

Ukuhlukanisa amaseli ku-Microsoft Excel eBook kuyinqubo elula futhi ewusizo, kodwa kufanele ucabangele ukuthi kunzima ukuwahlela enguqulweni ephelile. Ngakho-ke, sincoma ngokuqinile ukuthi ufake idatha ngaphambi kwesiteji sokuguqula iwindi elilodwa libe ngamabili noma ngaphezulu. Futhi, ungamane ufomethe ububanzi obufunayo njengetafula, ngemva kokulumisa esigabeni esifanele. Inketho engcono nakakhulu futhi enethezekile ukudweba imingcele ngesandla.