Okuqukethwe
Lapho usebenza namathebula ahlukene ngefomethi ye-Excel, ngokushesha noma kamuva kuyodingeka ukuthi ufihle idatha ethile noma ufihle izibalo ezimaphakathi namafomula. Ngesikhathi esifanayo, ukususwa akwamukelekile, ngoba kungenzeka ukuthi ukuhlelwa kwedatha efihliwe kuyodingeka ukuze amafomula asebenze kahle. Ukufihla lokhu noma lolo lwazi okwesikhashana, kunomsebenzi onjengokufihla amaseli.
Ungawafihla kanjani amaseli ku-Excel?
Kunezindlela ezimbalwa zokufihla amaseli kumadokhumenti e-Excel:
- ukushintsha imingcele yekholomu noma umugqa;
- usebenzisa ibha yamathuluzi;
- usebenzisa imenyu esheshayo;
- ukuhlanganisa;
- vumela izihlungi;
- ukufihla ulwazi namanani kumaseli.
Ngayinye yalezi zindlela inezici zayo:
- Isibonelo, ukufihla amaseli ngokushintsha imingcele yawo kulula kakhulu. Ukwenza lokhu, vele uhambise ikhesa emngceleni ongezansi womugqa endaweni yokufaka izinombolo bese uyihudulela phezulu kuze kuthinte imingcele.
- Ukuze amaseli afihliwe amakwe ngokuthi “+”, udinga ukusebenzisa okuthi “Grouping”, okungatholakala kuthebhu yemenyu ethi “Idatha”. Ngakho-ke amaseli afihliwe azomakwa ngesikali kanye nophawu oluthi “-”, lapho uchofozwa, amaseli ayafihlwa bese kuvela uphawu “+”.
Kubalulekile! Usebenzisa inketho "Yokwenza iqembu", ungafihla inani elingenamkhawulo lamakholomu nemigqa kuthebula.
- Uma kudingekile, ungakwazi futhi ukufihla indawo ekhethiwe ngokusebenzisa imenyu ye-pop-up lapho ucindezela inkinobho yegundane elingakwesokudla. Lapha sikhetha into ethi "Fihla". Ngenxa yalokho, amaseli ayanyamalala.
- Ungakwazi ukufihla amakholomu ambalwa noma imigqa ngethebhu "Ekhaya". Ukuze wenze lokhu, iya kupharamitha ethi “Fometha” bese ukhetha isigaba esithi “Fihla noma bonisa”. Enye imenyu izovela, lapho sikhetha khona isenzo esidingekayo:
- fihla amakholomu;
- fihla imigqa;
- fihla ishidi.
- Usebenzisa indlela yokuhlunga, ungafihla ulwazi emigqeni embalwa noma kumakholomu ngesikhathi esisodwa. Kuthebhu "Eyinhloko", khetha isigaba "Hlunga futhi Hlunga". Manje kumenyu evelayo, yenza kusebenze inkinobho ethi "Hlunga". Ibhokisi lokuhlola elinomcibisholo obheke phansi kufanele livele kuseli elikhethiwe. Uma uchofoza kulo mcibisholo kumenyu yokudonsela phansi, ungaqoki amabhokisi aseduze namanani uXNUMXbuXNUMXb ofuna ukuwafihla.
- Ku-Excel, kungenzeka ukufihla amaseli ngaphandle kwamanani, kodwa ngesikhathi esifanayo ungaphuli ukwakheka kwezibalo. Ukuze wenze lokhu, sebenzisa isilungiselelo esithi "Ifomethi Yeseli". Ukuze ubize ngokushesha le menyu, vele ucindezele inhlanganisela “Ctrl + 1”. Ohlangothini lwesokunxele lwewindi, yiya esigabeni esithi “(wonke amafomethi)”, futhi kunkambu ethi “Uhlobo” yehlela enani lokugcina, okungukuthi, “;;;”. Ngemva kokuchofoza inkinobho ethi "KULUNGILE", inani elikuseli lizonyamalala. Le ndlela ikuvumela ukuthi ufihle amanani athile, kodwa wonke amafomula azosebenza kahle.
Uma abasebenzisi abambalwa besebenza kudokhumenti, kufanele wazi ukuthi ungathola kanjani ukuba khona kwamaseli afihliwe kufayela le-Excel. Ukuze uthole kuphela amakholomu nemigqa efihliwe, kodwa ungawabonisi, kuzodingeka uhlole ukulandelana kwawo wonke amakholomu nezihloko zemigqa. Uhlamvu olungekho noma inombolo ibonisa amaseli afihliwe.
Uma ithebula likhulu kakhulu, le ndlela ayilula neze. Ukuze wenze kube lula inqubo yokuthola amaseli afihliwe kudokhumenti, udinga ukuya kumyalo othi “Ukuhlela” osethwe kumenyu ethi “Ekhaya”. Esigabeni esithi "Thola bese ukhetha", khetha umyalo othi "Khetha iqembu lamaseli ...".
Ewindini elivulayo, hlola isigaba "Amaseli abonakalayo kuphela". Ngemva kwalokho, ngaphakathi kwetafula, awukwazi ukubona kuphela indawo ekhethiwe yamaseli, kodwa futhi nemigqa eqinile, ebonisa ukuba khona kwemigqa efihliwe noma amakholomu.
Kanjalo nje, ukuvula amaseli afihliwe emehlweni okubuka ngeke kusebenze. Okokuqala udinga ukuqonda izindlela ezazisetshenziswa ukuzifihla. Phela, ukukhetha kwesibonisi sabo kuzoxhomeka kulokhu. Ngokwesibonelo, lokhu kungaba:
- ukususwa kwemingcele yamaseli;
- ukuhlukaniswa kwamaseli;
- ukuvala isihlungi;
- ukufometha amaseli athile.
Ake sicabangele ngayinye yazo ngokuningiliziwe.
Indlela 1: Shift Imingcele Yeseli
Uma indlela yokuguqula ngokomzimba imingcele yekholomu noma umugqa isetshenziselwe ukufihla amaseli, khona-ke ukuyibonisa kwanele ukubuyisela imingcele endaweni yayo yasekuqaleni usebenzisa igundane lekhompyutha. Kodwa kufanele ulawule ngokucophelela konke ukunyakaza kwekhesa. Futhi endabeni yenani elikhulu lamaseli afihliwe, ukubonisa kwawo kungathatha isikhathi eside. Kodwa nalo msebenzi ungenziwa ngemizuzwana nje:
- Kuyadingeka ukukhetha amaseli amabili aseduze, futhi kufanele kube neseli efihliwe phakathi kwamaseli. Bese kuthi ebhokisini lamathuluzi elithi “Amaseli” kumenyu ethi “Ekhaya” sithola ipharamitha ethi “Fometha”.
- Uma wenza le nkinobho isebenze kumenyu ye-pop-up, hamba esigabeni "Fihla noma bonisa". Okulandelayo, khetha umsebenzi owodwa - "Bonisa Imigqa" noma "Khombisa Amakholomu". Inketho incike ekutheni yimaphi amaseli afihliwe. Kuleli qophelo, amaseli afihliwe azovezwa ngokushesha.
Iseluleko! Eqinisweni, le ndlela elula ingenziwa ibe lula ngokwengeziwe, futhi okubaluleke kakhulu, isheshiswe. Okokuqala, asikhethi kuphela amaseli aseduze, kodwa imigqa eseduze noma amakholomu, phakathi kwawo Ngokuchofoza inkinobho engakwesokudla yegundane lekhompyutha, kuzovela imenyu ye-pop-up, lapho sikhetha khona ipharamitha ethi "Bonisa". Amaseli afihliwe azovela endaweni yawo futhi azohleleka.
Lezi zindlela ezimbili zizosiza ukuveza nokubonisa idatha efihliwe kuphela uma kwenzeka kufihlwa mathupha amaseli kuspredishithi se-Excel.
Indlela yesi-2: Hlukanisa amaseli
Ithuluzi le-Excel elibizwa ngokuthi ukuqoqa likuvumela ukuthi ufihle indawo ethile yamaseli ngokuwahlanganisa ndawonye. Idatha efihliwe ingaboniswa futhi ifihlwe futhi kusetshenziswa izinqamuleli zekhibhodi ezikhethekile.
- Okokuqala, sibheka ishidi le-Excel ukuthola amaseli olwazi afihliwe. Uma kukhona, kuzovela uphawu lokuhlanganisa kwesokunxele somugqa noma ngenhla kwekholomu. Uma uchofoza ku-"+" wonke amaseli aqoqwe azovuleka.
- Ungadalula izindawo ezifihliwe zefayela ngenye indlela. Endaweni efanayo lapho u-“+” ekhona, kukhona nezinombolo. Lapha kufanele ukhethe inani eliphezulu. Amaseli azovezwa uma uchofoza inombolo ngenkinobho yegundane engakwesokunxele.
- Ngokungeziwe ezinyathelweni zesikhashana zokubonisa amaseli, ukwenza iqembu kungavalwa ngokuphelele. Sikhetha iqembu elithile lemigqa noma amakholomu. Okulandelayo, kuthebhu ebizwa ngokuthi “Idatha” kubhulokhi yamathuluzi ethi “Isakhiwo,” khetha isigaba esithi “Susa iqembu”.
- Ukuze ususe ngokushesha iqembu, sebenzisa isinqamuleli sekhibhodi u-Alt+Shift+Umcibisholo Wesokunxele.
Indlela yesi-3: Vala isihlungi
Enye indlela enamandla yokuthola nokuhlela amanani amakhulu olwazi ukuhlunga amanani ethebula. Kufanele kukhunjulwe ukuthi uma usebenzisa le ndlela, amanye amakholomu etafuleni lefayela angena kumodi efihliwe. Ake sijwayelane nokuboniswa kwamaseli afihliwe ngale ndlela isinyathelo ngesinyathelo:
- Khetha ikholomu ehlungwe ngepharamitha ethile. Uma isihlungi sisebenza, khona-ke sikhonjiswa ilebula yefaneli, etholakala eduze komcibisholo oseseli eliphezulu lekholomu.
- Uma uchofoza “ifaneli” yesihlungi, kuzovela iwindi elinezilungiselelo zokuhlunga ezitholakalayo. Ukuze ubonise idatha efihliwe, phawula inani ngalinye noma ungasebenzisa inketho ethi "Khetha Konke". Chofoza okuthi “KULUNGILE” ukuze uqedele zonke izilungiselelo.
- Lapho ukuhlunga kukhanseliwe, zonke izindawo ezifihliwe kusipredishithi se-Excel zizovezwa.
Nakani! Uma ukuhlunga ngeke kusasetshenziswa, hamba uye esigabeni esithi “Hlunga nesihlungi” kumenyu ethi “Idatha” bese uchofoza okuthi “Hlunga”, uvale umsebenzi.
Indlela 4: Ukufometha Kweseli
Kwezinye izimo, ufuna ukufihla amanani kumaseli ngamanye. Ukwenza lokhu, i-Excel inikeza umsebenzi wokufometha okhethekile. Uma usebenzisa le ndlela, inani kuseli liboniswa ngefomethi “;;;”, okungukuthi, amasemikholoni amathathu. Ungawabona kanjani amaseli anjalo bese uwenza atholakalele ukubukwa, okungukuthi, abonise amanani awo?
- Efayelini le-Excel, amaseli anamanani afihliwe abonakala engenalutho. Kodwa uma udlulisela iseli kumodi esebenzayo, khona-ke idatha ebhalwe kuyo izoboniswa kulayini wokusebenza.
- Ukuze wenze amanani afihliwe kumaseli atholakale, khetha indawo oyifunayo bese ucindezela inkinobho yegundane engakwesokudla. Kuwindi le-pop-up, khetha umugqa "Fometha Amaseli ...".
- Izilungiselelo zokufometha kweseli ye-Excel zizovela efasiteleni. Kuthebhu ethi “Inombolo,” kukholamu yesokunxele “Amafomethi ezinombolo”, yiya esigabeni esithi “(wonke amafomethi)”, zonke izinhlobo ezitholakalayo zizovela kwesokudla, okuhlanganisa “;;;”.
- Kwesinye isikhathi ifomethi yeseli ingakhethwa ngokungalungile - lokhu kuholela ekubonisweni okungalungile kwamanani. Ukuze ususe leli phutha, zama ukukhetha ifomethi ethi "Okuvamile". Uma wazi kahle ukuthi yiliphi inani eliqukethwe kuseli - umbhalo, usuku, inombolo - ngakho-ke kungcono ukukhetha ifomethi efanelekile.
- Ngemva kokushintsha ifomethi yeseli, amanani kumakholomu akhethiwe nemigqa afundeka. Kodwa uma kwenzeka ukuboniswa okungalungile okuphindaphindiwe, kufanele uzame amafomethi ahlukene - enye yazo izosebenza nakanjani.
Kunamavidiyo amahle awusizo azokusiza ukuthi uthole ukuthi uwafihla kanjani amaseli kufayela le-Excel futhi uwabonise.
Ngakho-ke, ukuze ufunde ukufihla amaseli, sincoma ukubuka ividiyo engezansi, lapho umbhali wevidiyo ebonisa ngokucacile izindlela ezimbalwa zokufihla imigqa noma amakholomu athile, kanye nolwazi olukuwo:
Sincoma futhi ukuthi uzijwayeze nezinye izinto eziphathelene nesihloko:
Ngemva kokubuka ngokucophelela amavidiyo ambalwa kulesi sihloko, noma yimuphi umsebenzisi uzokwazi ukubhekana nomsebenzi onjengokubonisa noma ukufihla iseli elinolwazi kumathebula e-Excel.
Isiphetho
Uma udinga ukubonisa amaseli afihliwe, kufanele unqume ukuthi amakholomu nemigqa bekufihlwe ngayiphi indlela. Kuye ngendlela ekhethiwe yokufihla amaseli, kuzothathwa isinqumo sokuthi aboniswa kanjani. Ngakho-ke, uma amaseli abefihliwe ngokuvala imingcele, ngakho-ke kungakhathaliseki ukuthi umsebenzisi uzama kanjani ukuwavula esebenzisa ithuluzi le-Ungroup noma I-Filter, idokhumenti ngeke ibuyiselwe.
Uma idokhumenti idalwe umsebenzisi oyedwa, futhi omunye ephoqeleka ukuhlela, khona-ke kuzodingeka uzame izindlela ezimbalwa kuze kube yilapho wonke amakholomu, imigqa namaseli ngamanye embulwe lonke ulwazi oludingekayo.