Lapho usebenza namatafula i-Excel, kwesinye isikhathi udinga ukufihla amafomula noma idatha yesikhashana engenasidingo ukuze ingaphazamisi. Kepha kungekudala, kuza isikhathi lapho udinga ukulungisa ifomula, noma imininingwane equkethwe kumaseli afihliwe, umsebenzisi adinga ngokungazelelwe. Lapho-ke umbuzo wokuthi ungazibonisa kanjani izinto ezifihliwe uyafaneleka. Ake sibheke ukuthi singayixazulula kanjani le nkinga.
Khombisa Inqubo Yokunika amandla
Kufanele kushiwo ngaleso sikhathi ukuthi ukukhethwa kwenketho ukunika amandla ukubonisa kwezinto ezifihliwe ngokuyinhloko kuya ngokuthi kufihlwe kanjani. Imvamisa lezi zindlela zisebenzisa ubuchwepheshe obuhluke ngokuphelele. Kunezindlela ezinjalo zokufihla okuqukethwe eshidi:
- shintsha imingcele yezinsika noma imigqa, kufaka phakathi imenyu yokuqukethwe noma inkinobho kubambo;
- ukuhlukaniswa kwedatha;
- ukuhlunga
- ukufihla okuqukethwe amaseli.
Manje ake sizame ukuthola ukuthi singakuveza kanjani okuqukethwe yizinto ezifihliwe kusetshenziswa izindlela ezingenhla.
Indlela yoku-1: imingcele evulekile
Imvamisa, abasebenzisi bafihla amakholomu nemigqa, bavale imingcele yabo. Uma imingcele yayihanjiswa ngokuqinile, khona-ke kunzima ukubamba onqenqemeni ukuyicindezela emuva. Sizothola ukuthi lokhu kungenziwa kanjani kalula futhi ngokushesha.
- Khetha amaseli amabili asondelene nawo, phakathi kwawo kukhona amakholomu afihliwe noma imigqa. Iya kuthebhu "Ikhaya". Chofoza inkinobho "Ifomathi"etholakala kwibhulokhi yamathuluzi "Amaseli". Kuluhlu olubonakala, hambela phezulu Fihla noma uboniseokuyiqembu "Ukubonakala". Okulandelayo, kumenyu evelayo, khetha Khombisa Imigqa noma Khombisa Amakholamu, kuya ngokuthi kufihlwe ini.
- Ngemuva kwalesi senzo, kuzovela izinto ezifihliwe ekhasini.
Kukhona enye inketho ongayisebenzisa ukubonisa okufihliwe ngokushintsha imingcele yezinto.
- Kwiphaneli evundlile noma eqondile yokuxhumanisa, ngokuya ngalokho okufihliwe, amakholomu noma imigqa, nesikhombisi ngenkathi ibambe inkinobho yegundane kwesobunxele, khetha imikhakha emibili eseduze lapho izinto zifihlwe khona. Chofoza ekukhetheni ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe, khetha Khombisa.
- Izinto ezifihliwe zizokhonjiswa ngokushesha esikrinini.
Lezi zinketho ezimbili azikwazi ukusetshenziswa kuphela uma imingcele yeseli yayiguqulwe ngesandla, kodwa futhi uma ngabe ifihliwe kusetshenziswa amathuluzi kubhali noma kumenyu yokuqukethwe.
Indlela yesi-2: Ukungahlanganisi
Imigqa nezinsika nazo zingafihlwa kusetshenziswa amaqembu lapho ziqoqiwe ngamaqembu ahlukile bese zifihlwa. Asibone ukuthi ungazikhombisa kanjani esikrinini futhi.
- Inkomba yokuthi imigqa noma ikholomu ihlelwe futhi yafihlwa ukuba khona kwesithonjana. "+" ngakwesobunxele sepaneli yokuqondisa mpo noma ngaphezulu kwephaneli evundlile, ngokulandelana. Ukuze ubonise izinto ezifihliwe, vele uchofoze kulesi sithonjana.
Ungazibonisa futhi ngokuchofoza kwidijithi yokugcina yezinombolo zeqembu. Okusho ukuthi, uma idijithi yokugcina kuyinto "2"bese uchofoza kukho uma "3", bese uchofoza lesi sibalo. Inani eliqondile lincike ekutheni mangaki amaqembu ahlanganisiwe komunye nomunye. Lezi zinombolo zitholakala ngaphezu kwephaneli yokuqondisa evundlile noma ngakwesobunxele seyileyo mpo.
- Ngemuva kwanoma yiziphi zalezi zenzo, okuqukethwe yiqembu kuzovula.
- Uma lokhu akwanele wena futhi udinga ukwenza i-ungroup ephelele, khona-ke khetha kuqala amakholomu noma imigqa efanele. Bese kuba kuthebhu "Idatha"chofoza inkinobho Ungroupelibekwe ebhlokini "Isakhiwo" ekhasethini. Ngenye indlela, ungacindezela inhlanganisela ye-hotkey UShift + Alt + Umcibisholo ongakwesobunxele.
Amaqembu azosuswa.
Indlela 3: susa okokuhlunga
Ukuze ufihle idatha yesikhashana engenasidingo, ukuhlunga kuvame ukusetshenziswa. Kepha, lapho kudingekile ukubuyela ukusebenza ngalolu lwazi, isihlungi kufanele sisuswe.
- Sichofoza isithonjana sokuhlunga kukholamu, amanani awo ahlungiwe. Kulula ukuthola amakholamu anjalo, ngoba anesithonjana esijwayelekile sokuhlunga esinophawu olunxantathu olunezelwe lokunisela lufaka uphawu.
- Imenyu yokuhlunga iyavula. Sihlola amabhokisi abhekene nalezi zinto lapho zingekho. Lemigqa ayikhonjiswa eshidini. Bese uchofoza inkinobho "Kulungile".
- Ngemuva kwalesi senzo, imigqa izovela, kepha uma ufuna ukususa ukuhlunga ngokuphelele, kuzodingeka uchofoze inkinobho "Hlunga"etholakala kuthebhu "Idatha" ethepheni eqenjini Hlunga nesihlungi.
Indlela 4: ukufometha
Ukuze kufihlwe okuqukethwe amaseli ngamanye, ukufometha kusetshenziswa ngokufaka isisho esithi ";;;;" Ukukhombisa okuqukethwe okufihliwe, udinga ukubuyisela lezi zinto kwifomethi yazo yoqobo.
- Khetha amaseli lapho okuqukethwe okufihliwe kutholakala khona. Izinto ezinjalo zinganqunywa yiqiniso lokuthi ayikho idatha ekhonjiswa kumaseli ngokwawo, kepha uma kukhethiwe, okuqukethwe kuzokhonjiswa kubha yefomula.
- Ngemuva kokuthi ukukhetha kwenziwe, chofoza kukho ngenkinobho yegundane elifanele. Imenyu yokuqukethwe yethulwe. Khetha into "Ifomethi yeseli ..."ngokuchofoza kukho.
- Ukuqalisa ukufometha kuqala. Hambisa kuthebhu "Inombolo". Njengoba ubona, enkundleni "Thayipha" inani elikhonjisiwe ";;;".
- Kuhle kakhulu uma ukhumbula ukuthi ukufakwa kwamaseli kwasekuqaleni kwakunjani. Kulokhu, uzohlala kuphela kubhulokhi bepharamitha "Amafomethi ezinombolo" qokomisa into ehambisanayo. Uma ungayikhumbuli ifomethi ngqo, bese uncika emcabangweni wokuqukethwe obekwe esitokisini. Isibonelo, uma kunolwazi mayelana nesikhathi noma usuku, bese ukhetha "Isikhathi" noma Usuku, njll. Kepha ngezinhlobo eziningi zokuqukethwe, iphuzu liwukuthi "Okujwayelekile". Senza ukukhetha bese sichofoza inkinobho "Kulungile".
Njengoba ukwazi ukubona, emva kwalokho amanani afihliwe ayakhonjiswa futhi ephepheni. Uma ubheka ukuthi ukuboniswa kolwazi akulungile, futhi, ngokwesibonelo, esikhundleni sosuku ubona isethi yezinombolo ezijwayelekile, bese uzama ukuguqula ifomethi futhi.
Isifundo: Ungashintsha kanjani ifomethi yeseli ku-Excel
Lapho uxazulula inkinga yokubonisa izinto ezifihliwe, umsebenzi oyinhloko ukuthola ukuthi ubufihle ubuchwepheshe obunjani. Ngemuva kwalokho, ususele kulokhu, sebenzisa enye yezindlela ezine ezichazwe ngenhla. Kumele kuqondwe ukuthi, ngokwesibonelo, okuqukethwe bekufihlwe ukuvala imingcele, khona-ke ukungathululi noma ukususa isihlungi akusizi ukubonisa idatha.
