Ungawafihla kanjani wonke amanothi ku-Excel ngesikhathi esisodwa

Amanothi ku-Microsoft Office Excel angolunye ulwazi olwengeziwe umsebenzisi aluhlanganisayo engxenyeni ethile yohlu lwethebula noma kuhlu lwamaseli. Inothi likuvumela ukuthi ubhale ulwazi olwengeziwe kuseli eyodwa ukuze likukhumbuze ngokuthile. Kodwa ngezinye izikhathi amanothi adinga ukufihlwa noma asuswe. Indlela yokwenza lokhu kuzoxoxwa ngayo kulesi sihloko.

Indlela yokudala inothi

Ukuze uqonde ngokugcwele isihloko, okokuqala udinga ukufunda ngezindlela zokwenza amanothi ku-Microsoft Office Excel. Akulungile ukucabangela zonke izindlela ezingaphakathi kohlaka lwalesi sihloko. Ngakho-ke, ukuze wonge isikhathi, sethula i-algorithm elula yokuqeda umsebenzi:

1. Chofoza kwesokudla kuseli ofuna ukubhala kulo inothi.
2. Ewindini lohlobo lokuqukethwe, chofoza i-LMB kulayini "Faka inothi".

3. Ibhokisi elincane lizovela eduze kweseli, lapho ungafaka khona umbhalo wenothi. Lapha ungabhala noma yini oyifunayo ngokubona komsebenzisi.

4. Uma umbhalo ubhalwa, uzodinga ukuchofoza kunoma iyiphi iseli yamahhala ku-Excel ukuze ufihle imenyu. I-elementi enenothi izomakwa ngonxantathu omncane obomvu ekhoneni eliphezulu kwesokudla. Uma umsebenzisi ehambisa ikhesa yegundane phezu kwaleli seli, umbhalo othayiphiwe uzovezwa.

Nakani! Ngokufanayo, ungakha inothi lanoma iyiphi iseli ekhasini lokusebenzela le-Excel. Inombolo yezinhlamvu ezifakwe efasiteleni ayinqunyelwe.

Njengenothi esitokisini, awukwazi ukusebenzisa umbhalo kuphela, kodwa futhi nezithombe ezihlukahlukene, izithombe, izimo ezilandiwe kukhompyutha. Kodwa-ke, kuzodingeka ziboshwe engxenyeni ethile yohlu lwetafula.

Indlela yokufihla inothi

Ku-Excel, kunezindlela ezimbalwa ezijwayelekile zokufeza umsebenzi, ngayinye yazo idinga ukucatshangelwa kabanzi. Lokhu kuzophinde kuxoxwe ngakho.

Indlela 1: Fihla inothi elilodwa

Ukuze ususe okwesikhashana ilebula yeseli eyodwa ohlwini lwethebula, kufanele wenze okulandelayo:

1. Sebenzisa inkinobho yegundane engakwesokunxele ukuze ukhethe into equkethe inothi okudingeka ilungiswe.
2. Chofoza kwesokudla kunoma iyiphi indawo yeseli.
3. Kumenyu yokuqukethwe evelayo, thola umugqa "Susa inothi" bese uchofoza kuwo.

4. Hlola umphumela. Isiginesha eyengeziwe kufanele inyamalale.
5. Uma kudingekile, efasiteleni elifanayo lohlobo lwesimo, chofoza umugqa "Hlela inothi" ukuze ubhale kabusha umbhalo othayiphe ngaphambilini, ulungise ukushiyeka.

Indlela 2. Ulikhipha kanjani inothi kuwo wonke amaseli ngesikhathi esisodwa

I-Microsoft Office Excel inomsebenzi wokukhipha kanyekanye ukuphawula kuzo zonke izici etholakala kuzo. Ukuze usebenzise leli thuba, kufanele wenze lokhu okulandelayo:

1. Khetha lonke uhlu lwethebula ngenkinobho yegundane engakwesokunxele.
2. Hambisa kuthebhu "Buyekeza", etholakala kubha yamathuluzi ephezulu yohlelo.
3. Endaweni yesigaba evulayo, izinketho ezimbalwa zizokwethulwa. Kulesi simo, umsebenzisi unentshisekelo kunkinobho ethi "Susa", etholakala eduze kwegama elithi "Dala Inothi". Ngemva kokuchofoza, amasiginesha azosuswa ngokuzenzakalelayo kuwo wonke amaseli epuleti elikhethiwe.

Kubalulekile! Indlela yokufihla amasiginesha engeziwe okukhulunywe ngawo ngenhla ibhekwa njengejwayelekile futhi isebenza kuzo zonke izinguqulo zesoftware.

Indlela yesi-3: Sebenzisa imenyu yokuqukethwe ukuze ufihle amazwana ku-Excel

Ukuze ususe amalebula kuwo wonke amaseli kuthebula ngesikhathi esifanayo, ungasebenzisa enye indlela. Kubandakanya ukwenza lokhu kukhohlisa okulandelayo:

1. Ngokohlelo olufanayo okuxoxwe ngalo esigabeni sangaphambilini, khetha ububanzi obufunekayo bamaseli kuthebula.
2. Chofoza kwesokudla endaweni ekhethiwe yohlu lwedatha yethebula ngenkinobho yegundane elingakwesokudla.
3. Ewindini lohlobo lokuqukethwe elivelayo, chofoza i-LMB kanye kulayini "Susa inothi".

4. Qiniseka ukuthi ngemva kokwenza isinyathelo sangaphambilini, amalebula awo wonke amaseli ayakhishwa.

Indlela yesi-4: Hlehlisa isenzo

Ngemva kokudala amanothi amaningana ayiphutha, ungawafihla ngalinye ngalinye, uwasuse usebenzisa ithuluzi lokuhlehlisa. Empeleni, lo msebenzi wenziwa ngale ndlela elandelayo:

1. Khipha okukhethiwe kuthebula lonke, uma likhona, ngokuchofoza i-LMB esikhaleni samahhala sephepha lokusebenzela le-Excel.
2. Ekhoneni eliphezulu kwesokunxele lesixhumi esibonakalayo sohlelo, eduze kwegama elithi "Ifayela", thola inkinobho esesimweni somcibisholo kwesokunxele bese uchofoza kuyo. Isenzo esenziwe ekugcineni kufanele sihlehliswe.
3. Ngokufanayo, cindezela inkinobho "Khansela" kuze kube yilapho wonke amanothi esuswa.

Le ndlela ine-drawback ephawulekayo. Ngemuva kokuchofoza inkinobho ecatshangelwayo, izenzo ezibalulekile ezenziwe umsebenzisi ngemuva kokudala amasiginesha nazo zizosuswa.

Ulwazi olubalulekile! Ku-Excel, njengakunoma yimuphi umhleli we-Microsoft Office, isenzo sokuhlehlisa singenziwa kusetshenziswa isinqamuleli sekhibhodi. Ukuze wenze lokhu, udinga ukushintsha ikhibhodi yekhompiyutha ibe yisakhiwo sesiNgisi bese ubamba izinkinobho "Ctrl + Z" ngasikhathi sinye.

Isiphetho

Ngakho, amanothi ku-Microsoft Office Excel adlala indima ebalulekile ekuhlanganiseni amatafula, ukwenza umsebenzi wokwengeza, ukwandisa ulwazi oluyisisekelo kuseli. Nokho, ngezinye izikhathi kufanele zifihlwe noma zisuswe. Ukuze uqonde ukuthi ungawasusa kanjani amasiginesha ku-Excel, udinga ukufunda ngokucophelela izindlela ezingenhla.