Umlobi we-OpenOffice. Isikhala somugqa

Uma usebenzisa ama-spreadsheet e-Excel, ngezinye izikhathi udinga ukufihla amafomula noma idatha engadingekile okwesikhashana ukuze bangaphazamisi. Kodwa ngokushesha noma ngokuhamba kwesikhathi kufika isikhathi lapho udinga ukulungisa ifomula, noma ulwazi oluqukethwe kumaseli afihliwe, umsebenzisi ngokuzumayo udinga. Yilapho umbuzo wokuthi ungabonisa kanjani izakhi ezifihliwe ziba efanele. Ake sithole indlela yokuxazulula le nkinga.

Inqubo yokunika amandla ukubonisa

Masinyane kufanele ngithi ukukhetha ukhetho ukuvumela ukuboniswa kwezinto ezifihliwe endaweni yokuqala kuxhomeke endleleni abafihliwe ngayo. Ngokuvamile lezi zindlela zisebenzisa ubuchwepheshe obuhlukile ngokuphelele. Kunezinketho ezinjalo zokufihla okuqukethwe kwekhasi:

• ukuguqula imingcele yamakholomu noma imigqa, kufaka phakathi imenyu yokuqukethwe noma inkinobho ku-ribbon;
• ukuqoqa idatha;
• ukuhlunga;
• ukufihla okuqukethwe kwamaseli.

Futhi manje sizame ukuthola indlela yokubonisa okuqukethwe kwezakhi ezifihliwe ngokusebenzisa izindlela ezingenhla.

Indlela 1: vula imingcele

Ngokuvamile, abasebenzisi bafihla amakholomu nemigqa, ukuvala imingcele yabo. Uma imingcele ishintshwe kakhulu ngokuqinile, kunzima ukunamathela emaphethelweni ukuze uwaxoshe. Thola ukuthi lokhu kungenziwa kanjani kalula futhi ngokushesha.

1. Khetha amaseli amabili aseduze, phakathi kwalakho amakholomu afihliwe noma imigqa. Iya kuthebhu "Ikhaya". Chofoza inkinobho "Fometha"esitholakala kwibhulogi yamathuluzi "Amaseli". Kulolu hlu oluvela, susa isikhombisi entweni "Fihla noma Bonisa"esiseqenjini "Ukubonakala". Okulandelayo, kwimenyu evelayo, khetha into "Bonisa izikhonkwane" noma Bonisa amakholomu, kuye ngokuthi yini efihliwe.



2. Ngemuva kwalesi senzo, izakhi ezifihliwe zivela eshadini.

Kunenye indlela engasetshenziswa ukubonisa efihliwe ngokushintsha imingcele yezinto.

1. Esikhundleni sokuxhumanisa esiqondile noma esiqondile, kuye ngokuthi yikuphi okufihliwe, amakholomu noma imigqa, sikhetha imikhakha emibili ehambisana nesikebhe inkinobho yegundane lesokunxele egcinwe phansi, phakathi kwezinto ezikhona ezicashiwe. Chofoza ekukhethweni ngenkinobho yegundane efanele. Kumenyu yesimo, khetha into "Bonisa".



2. Izinto ezifihliwe zizoboniswa ngokushesha esikrinini.

Lezi zikhetho ezimbili zingasetshenziswa kuphela uma imingcele yeselula ishintshwe ngesandla, kodwa futhi uma ifihliwe besebenzisa amathuluzi ebhodini noma kwimenyu yemongo.

Indlela 2: Ukuhlangana

Ungakwazi futhi ukufihla imigqa namakholomu usebenzisa ukuqoqa, uma zihlanganisiwe bese zifihliwe. Ake sibone ukuthi singabonisa kanjani esikrinini futhi.

1. Inkomba yokuthi imigqa noma amakholomu aqoqiwe futhi afihliwe yisithonjana "+" ngakwesokunxele kwephaneli eliqondile lama-coordinates noma ngenhla iphaneli enezingqimba, ngokulandelana. Ukuze ubonise izinto ezifihliwe, chofoza nje kulesi sithonjana.

   

   Ungabonisa futhi ngokuchofoza kudijithi yokugcina yamaqembu wokubala. Okusho ukuthi, uma idijithi yokugcina ikhona "2"bese uchofoza kuso uma "3", bese uchofoza kulesi sibalo. Inombolo ethize ixhomeke ukuthi zingaki amaqembu atshalwa imali. Lezi zibalo zitholakala ngaphezu kwepaneli yokuxhumanisa enezingqimba noma ngakwesokunxele komunye.



2. Ngemuva kweyodwa yalezi zenzo, okuqukethwe kweqembu kuzovulwa.



3. Uma lokhu okwanele kuwe futhi udinga ukwenza ungrouping okuphelele, bese uqala ukhethe amakholomu noma imigqa efanele. Khona-ke, ekubeni kuthebhu "Idatha"chofoza inkinobho "Hlanganisa"esitholakala kubhulogi "Isakhiwo" kwi-tape. Ngokunye, ungacindezela inhlanganisela yezinkinobho ezishisayo Shift + Alt + Umcibisholo Wwesobunxele.

Amaqembu azosuswa.

Indlela 3: Susa isihlungi

Ukuze ufihle idatha engadingekile okwesikhashana, ukuhlunga kuvame ukusetshenziswa. Kodwa, uma kuziwa ngesidingo sokubuyela ekusebenzeni nalolu lwazi, isihlungi kufanele sisuswe.

1. Chofoza kusithonjana sokuhlunga kukholomu, ngamanani okuhlunga okwenziwe ngawo. Kulula ukuthola amakholomu anjalo, ngoba anesithonjana esivamile sokuhlunga ngendondo esiphenduliwe enezelwa nesinye isithonjana ngendlela yokunisela.



2. Imenyu yokuhlunga ivula. Beka ibhokisi lokuhlola phambi kwalawo maphuzu lapho alahlekile khona. Le migqa ayiboniswa kushidi. Bese uchofoza inkinobho. "Kulungile".



3. Ngemuva kwalesi senzo, imigqa izovela, kodwa uma ufuna ukususa ukuhlunga ngokuphelele, kuzomele uchofoze inkinobho "Hlunga"elitholakala kuthebhu "Idatha" kwi-tape eqenjini "Hlunga futhi uhlunge".

Indlela 4: Ukufometha

Ukuze ufihle okuqukethwe kwamaseli ngabanye, ukufometha kusetshenziswa ngokufaka inkulumo ethi ";;;" kwifomathi yohlobo lwefomethi. Ukuze ubonise okuqukethwe okufihliwe, udinga ukubuyisa ifomethi yangempela kulezi zakhi.

1. Khetha amaseli aqukethe okuqukethwe okufihliwe. Izakhi ezinjalo zinganqunywa ukuthi akukho datha ekhonjisiwe kumaseli ngokwawo, kodwa uma ekhethiwe, okuqukethwe kuzoboniswa kubha yamatomu.



2. Emva kokukhethwa kwenzelwe, chofoza kuso nge inkinobho yesokudla yegundane. Iqala imenyu yokuqukethwe. Khetha into "Fometha amaseli ..."ngokuchofoza kuso.



3. Ifasitela lokufometha iqala. Hambisa kuthebhu "Inombolo". Njengoba ungabona, ensimini "Thayipha" Inani liyaboniswa ";;;".



4. Kuhle kakhulu, uma ukhumbula ukuthi ukufometha kwasekuqaleni kwamaseli kwakunjani. Kulesi simo, uzohlala kuphela ku-parameter block. "Amafomu Amanani" qokomisa into efanelekile. Uma ungakhumbuli uhlobo oluthile, ke uthembele ekutheni okuqukethwe okufakwa esitokisini. Isibonelo, uma kukhona ulwazi mayelana nesikhathi noma usuku, khetha "Isikhathi" noma "Usuku"njll. Kodwa ngezinhlobo eziningi zokuqukethwe, into "Jikelele". Yenza ukhethe bese uchofoza inkinobho. "Kulungile".

Njengoba ungabona, emva kwalokhu, amanani afihliwe aphinde aboniswe kushidi. Uma ucabanga ukuthi ukuboniswa kolwazi akulungile, futhi, ngokwesibonelo, esikhundleni sosuku ubona isethi evamile yezinombolo, bese uzama ukushintsha ifomethi futhi.

Isifundo: Ungashintsha kanjani ifomethi yeseli ku-Excel

Lapho uxazulula inkinga yokubonisa izakhi ezifihliwe, umsebenzi oyinhloko ukucacisa ukuthi yibuphi ubuchwepheshe obufihliwe. Khona-ke, ngokusekelwe kulokhu, sebenzisa enye yalezo zindlela ezine ezichazwe ngenhla. Kubalulekile ukuqonda ukuthi uma, isibonelo, okuqukethwe kwafihliwe ngokuvala imingcele, ukungena noma ukukhipha isihlungi ngeke kusize ukubonisa idatha.