Ungawafihla kanjani wonke amanothi ku-Excel ngasikhathi sinye

Amanothi ku-Microsoft Office Excel eminye imininingwane eyengeziwe umsebenzisi ahlanganisa into ethize yohlu oluthile lwethebula noma ebangeni lamaseli. Inothi likuvumela ukuthi ubhalise imininingwane eminingi esitokisini esisodwa ukukhumbuza noma yini. Kepha kwesinye isikhathi amanothi adinga ukufihlwa noma ukususwa. Ungakwenza kanjani lokhu kuzotshelwa kule ndatshana.

Ungayakha kanjani inothi

Ukuqonda okuphelele kwesihloko, okokuqala kudingeka ufunde ngezindlela zokwakha amanothi ku-Microsoft Office Excel. Cabanga ngezindlela zonke eziphakathi kwalesi sihloko esingenakugwemeka. Ngakho-ke, ukonga isikhathi, sinikeza i-algorithm elula kunazo zonke emsebenzini ogcwalisiwe:

1. Chofoza ukhiye wesokudla ku-Manipulator eseliphethe lapho inothi kufanele libhaliswe khona.
2. Ewindini lokuqukethwe komongo, chofoza i-LKM ku- "Faka inothi" umugqa.

Izenzo ezilula zokwakha amasiginesha ku-Excel, ezethulwe ku-Screenshot eyodwa

1. Eduze kweseli kuzoba osayizi omncane lapho ungangena khona umbhalo wenothi. Lapha ungabhala noma yini ngokubona komsebenzisi.

Iwindi lokubukeka lokufaka amanothi ku-Excel

1. Lapho umbhalo ubhaliwe, kuzodingeka uchofoze kunoma iyiphi iseli yamahhala e-Excel ukuze imenyu ifihliwe. Into enenothi izomakwa ngonxantathu omncane obomvu ekhoneni eliphezulu kwesokudla. Uma umsebenzisi evakashela isikhombisi segundane kuleli ngliya, umbhalo oqoqwe uzovuleka.

Njengenothi esitokisini, ungasebenzisa hhayi kuphela umbhalo, kepha futhi nezithombe ezahlukahlukene, izithombe, izibalo ezilayishwe kwikhompyutha. Kodwa-ke, kuzofanela ziboshwe kwinto ethize yohlu lwethebula.

Ungayifihla kanjani i-Qaphela

Ku-Excel, kunezindlela ezimbalwa ezijwayelekile zokwenza lo msebenzi, ngamunye wazo ofanelwe ukucatshangelwa okuningiliziwe. Lokhu kuzoxoxwa ngakho ngokuqhubekayo.

Indlela 1. Ukufihla inothi elilodwa

Ukususa okwesikhashana isiginesha yeseli ethile kuhlu lwethebula, kufanele wenze okulandelayo:

1. Ukhiye wesobunxele we-manipulator ukugqamisa into lapho inothi lidinga ukuqedwa kukhona.
2. Cindezela i-PCM kunoma iyiphi indawo yeseli.
3. Kumenyu yokuqukethwe ekhonjisiwe, thola umugqa we- "Delete Qaphela" bese uqhafaza kuyo.

Indlela elula yokususa isiginesha yeseli elilodwa ku-Microsoft Office Excel

1. Bheka umphumela. Isiginesha eyengeziwe kufanele inyamalale.
2. Uma kunesidingo, ewindini elifanayo lokuqukethwe, chofoza ku "Umucu we-Hlela Note" ukubhala kabusha umbhalo oqoqwe ngaphambili, lungisa ukushiyeka.

Iwindi lokulungisa uhlobo lwenothi. Lapha ungashintsha indlela efakiwe yombhalo 2. Ungayisusa kanjani inothi ngokushesha kusuka kuwo wonke amaseli

Ku-Microsoft Office Excel Kunomsebenzi wokususwa ngasikhathi sinye samanothi avela kuzo zonke izinto ezikhona. Ukuze usizakale ngethuba elinjalo, kuyadingeka ukwenza okulandelayo:

1. Qokomisa lonke uhlu lwethebula lwenkinobho yegundane kwesobunxele.
2. Hambisa kuthebhu ethi "Ukubuyekezwa", okutholakala phezulu kwe-Toolbar yamathuluzi.
3. Endaweni yokuvula yesigaba, kuzokwethulwa izinketho eziningana. Esimweni somsebenzisi, unentshisekelo kwinkinobho yokususa, etholakala eduze kwegama elithi "Dala inothi". Ngemuva kokucindezela isiginesha isuswe ngokuzenzakalela kuwo wonke amaseli epuleti elikhethiwe.

Izenzo zokususa ngasikhathi sinye ukusungula yonke i-Table Array eyenziwe ngasikhathi sinye. Indlela 3. Usebenzisa imenyu yokuqukethwe ukufihla amanothi ku-Excel

Ukuze wonke amaseli etafuleni ukuze asuse amasiginesha ngasikhathi sinye, ungasebenzisa enye indlela. Kuqukethe ukwenza lokhu okulandelayo:

1. Ngokwesikimu esifanayo okuxoxwe ngaye esigabeni esedlule, khetha uhla olufunayo lwamaseli etafuleni.
2. Ngokuchofoza i-manipulator efanelekile endaweni ekhethiwe yohlu lwedatha yetafula.
3. Efasitezini yohlobo lokuqukethwe oluvelayo, chofoza i-LX kanye kulayini we- "Delete Qaphela".

Imenyu yokuqukethwe ukususa wonke amanothi ku-Excel

1. Qiniseka ukuthi ngemuva kwesenzo esedlule, amasiginesha awo wonke amaseli ayakhishwa.

Indlela 4. Khansela

Njengoba ususungule amanothi ambalwa ayiphutha, ungawafihla ngokuhlukile, ukhiphe ngethuluzi lokukhanselwa kwezenzo zangaphambilini. Ekusebenzeni, umsebenzi onjalo usetshenziswa kanjena:

1. Susa ukukhethwa etafuleni lonke, uma kukhona ngokucindezela i-LKM esikhaleni samahhala se-Excel Wheet Sheet.
2. Ekhoneni elingaphezulu kwesokunxele lesibonisi sohlelo oluseceleni kwegama elithi "ifayela", thola inkinobho ngesimo somcibisholo kwesobunxele bese uqhafaza kuyo. Isenzo esagcwaliseka ngokugcina kufanele sikhanselwe.
3. Ngokufanayo, cindezela inkinobho ethi "Khansela" kuze kube yilapho wonke amanothi asusiwe.

Khansela inkinobho ku-Excel. Inhlanganisela yokhiye ye- "CTRL + Z" nayo iyasebenza, ithola amaphuzu kwikhibhodi ye-PC

Le ndlela inokubuya okubalulekile. Ngemuva kokuchofoza kubhekwayo, izenzo ezibalulekile ezabulawa ngumsebenzisi ngemuva kokudala amasiginesha nazo zizosuswa.

Ukugcina

Ngakho-ke, amanothi ku-Microsoft Office Excel adlala indima ebalulekile ekulungiseleleni amatafula, enza isici sokwengeza, andise imininingwane eyisisekelo esitokisini. Kodwa-ke, kufanele bazifihle noma bazisuse. Ukuze uqonde ukuthi ungazisusa kanjani amasiginesha ku-Excel, kufanele ufunde ngokucophelela izindlela ezingenhla.

Umlayezo wokuthi ungawafihla kanjani wonke amanothi ku-Excel ngasikhathi sinye kwavela kuqala kubuchwepheshe bolwazi.