Okuqukethwe
Kulesi sihloko, uzofunda izindlela ezi-2 ezisheshayo zokufaka ifomula efanayo noma umbhalo kumaseli amaningi ngesikhathi esisodwa ku-Excel. Lokhu kuyasiza ezimeni lapho ufuna ukufaka ifomula kuwo wonke amaseli kukholamu, noma ugcwalise wonke amaseli angenalutho ngenani elifanayo (isibonelo, “N/A”). Womabili amasu asebenza ku-Microsoft Excel 2013, 2010, 2007 nangaphambili.
Ukwazi la maqhinga alula kuzokongela isikhathi esiningi semisebenzi ethokozisayo.
Khetha wonke amaseli ofuna ukufaka kuwo idatha efanayo
Nazi izindlela ezisheshayo zokugqamisa amaseli:
Khetha ikholomu yonke
- Uma idatha eku-Excel yakhelwe njengethebula eligcwele, mane uchofoze kunoma iyiphi iseli yekholomu oyifunayo bese uchofoza Ctrl+Space.
Qaphela: Uma ukhetha noma iyiphi iseli etafuleni eligcwele, iqembu lamathebhu livela ku-Menu Ribbon Sebenza ngamatafula (Amathuluzi Ethebula).
- Uma lobu ububanzi obuvamile, okungukuthi lapho kukhethwa elinye lamaseli alobu bubanzi, iqembu lamathebhu Sebenza ngamatafula (Amathuluzi Ethebula) akuveli, yenza okulandelayo:
Qaphela: Ngeshwa, esimweni sobubanzi obulula, ukucindezela Ctrl+Space izokhetha wonke amaseli ekholomu eshidini, isb C1 kuya C1048576, noma ngabe idatha iqukethwe kumaseli kuphela C1:C100.
Khetha iseli yokuqala yekholomu (noma eyesibili, uma iseli lokuqala libhalwe isihloko), bese ucindezela Shift+Ctrl+Endukuze ukhethe wonke amaseli ethebula phezulu kwesokudla. Okulandelayo, ukubamba Shift, cindezela inkinobho izikhathi eziningana umcibisholo wesokunxelekuze kube yilapho kuphela ikholomu oyifunayo ihlala ikhethiwe.
Lena indlela eshesha kakhulu yokukhetha wonke amaseli kukholamu, ikakhulukazi uma idatha ihlanganiswe namaseli angenalutho.
Khetha umugqa wonke
- Uma idatha eku-Excel yakhelwe njengethebula eligcwele, mane uchofoze kunoma iyiphi iseli yomugqa oyifunayo bese uchofoza. Shift+Space.
- Uma unebanga ledatha elivamile phambi kwakho, chofoza iseli lokugcina lomugqa oyifunayo bese uchofoza Shift+Ekhaya. I-Excel izokhetha ububanzi kusukela kuseli oyishilo kuze kufike kukholomu А. Uma idatha oyifunayo iqala, isibonelo, ngekholomu B or C, ncinza Shift bese ucindezela inkinobho Umcibisholo wesokudlauze uthole umphumela oyifunayo.
Ukukhetha amaseli amaningi
Bamba Ctrl bese uchofoza inkinobho yegundane kwesokunxele kuwo wonke amaseli adinga ukugcwaliswa ngedatha.
Khetha lonke ithebula
Chofoza kunoma iyiphi iseli etafuleni bese ucindezela Ctrl + A.
Khetha wonke amaseli eshidini
Cindezela Ctrl + A kanye kathathu. Cindezela kuqala Ctrl + A igqamisa indawo yamanje. Ukuchofoza kwesibili, ngaphezu kwendawo yamanje, ukhetha imigqa enezihloko namathothali (isibonelo, kumathebula agcwele). Umshini wesithathu ukhetha ishidi lonke. Ngicabanga ukuthi ukuqagelile, kwezinye izimo kuzokuthatha ukuchofoza okukodwa kuphela ukuze ukhethe lonke ishidi, futhi kwezinye izimo kuzothatha ukuchofoza okuthathu.
Khetha amaseli angenalutho endaweni enikeziwe (emgqeni, kukholomu, kuthebula)
Khetha indawo oyifunayo (bheka umfanekiso ongezansi), isibonelo, ikholomu yonke.
Cindezela F5 nasengxoxweni evelayo Inguquko (Yiya ku) cindezela inkinobho Qinisekisa (Okukhethekile).
Ebhokisini lengxoxo Khetha iqembu lamaseli (Go To special) maka ibhokisi Amaseli angenalutho (Aziqedi) bese uxova OK.
Uzobuyela kumodi yokuhlela yeshidi le-Excel futhi uzobona ukuthi amaseli angenalutho kuphela akhethiwe endaweni ekhethiwe. Amaseli amathathu angenalutho kulula kakhulu ukukhetha ngokuchofoza igundane okulula - uzosho futhi uzobe ulungile. Kodwa kuthiwani uma kunamaseli angenalutho angaphezu kuka-300 futhi ahlakazeke ngokungahleliwe phezu kwebanga lamaseli angu-10000?
Indlela eshesha kakhulu yokufaka ifomula kuwo wonke amaseli wekholomu
Kunetafula elikhulu, futhi udinga ukwengeza ikholomu entsha enefomula ethile kulo. Ake sithi lolu uhlu lwamakheli e-inthanethi ofuna ukukhipha kuwo amagama wesizinda ukuze uthole umsebenzi oqhubekayo.
- Guqula ububanzi bube ithebula le-Excel. Ukwenza lokhu, khetha noma iyiphi iseli ohlwini lwedatha bese ucindezela Ctrl + Tukuletha ibhokisi lengxoxo Ukwakha itafula (Yakha Ithebula). Uma idatha inezihloko zekholomu, khetha ibhokisi Ithebula elinezihloko (Ithebula lami linezihloko). Ngokuvamile i-Excel ibona izihloko ngokuzenzakalelayo, uma lokho kungasebenzi, hlola ibhokisi ngesandla.
- Engeza ikholomu entsha etafuleni. Ngethebula, lokhu kusebenza kulula kakhulu kunohlu olulula lwedatha. Chofoza kwesokudla kunoma iyiphi iseli kukholamu ezayo ngemva kwalapho ofuna ukufaka khona ikholomu entsha, futhi kumenyu yokuqukethwe khetha Faka > Ikholomu kwesokunxele (Faka > Ikholomu Yethebula Kwesokunxele).
- Nikeza igama kukholamu entsha.
- Faka ifomula kuseli lokuqala lekholomu entsha. Esibonelweni sami, ngisebenzisa ifomula ukukhipha amagama wesizinda:
=MID(C2,FIND(":",C2,"4")+3,FIND("/",C2,9)-FIND(":",C2,"4")-3)=ПСТР(C2;НАЙТИ(":";C2;"4")+3;НАЙТИ("/";C2;9)-НАЙТИ(":";C2;"4")-3) - Cindezela Faka. Voila! I-Excel igcwalise ngokuzenzakalelayo wonke amaseli angenalutho kukholamu entsha ngefomula efanayo.
Uma unquma ukubuya usuka kuthebula uye kufomethi yebanga evamile, bese ukhetha noma iyiphi iseli kuthebula nakuthebhu umakhi (Design) chofoza Guqulela kububanzi (Guqula kububanzi).
Leli qhinga lingasetshenziswa kuphela uma wonke amaseli kukholamu engenalutho, ngakho-ke kuhle kakhulu ukwengeza ikholomu entsha. Okulandelayo kujwayelekile kakhulu.
Namathisela idatha efanayo kumaseli amaningana usebenzisa u-Ctrl + Enter
Khetha amaseli eshidini le-Excel ofuna ukuwagcwalisa ngedatha efanayo. Amasu achazwe ngenhla azokusiza ukuthi ukhethe ngokushesha amaseli.
Ake sithi sinetafula elinohlu lwamakhasimende (Yebo, sizothatha uhlu oluqanjiwe). Enye yamakholomu aleli thebula iqukethe amasayithi lapho amakhasimende ethu aphuma khona. Amaseli angenalutho kule kholomu kufanele agcwaliswe ngombhalo othi “_unknown_” ukuze kube lula ukuhlunga okwengeziwe:
- Khetha wonke amaseli angenalutho kukholamu.
- Cindezela F2ukuhlela iseli esebenzayo, futhi ufake okuthile kuyo: kungaba umbhalo, inombolo, noma ifomula. Esimeni sethu, lona umbhalo othi “_unknown_”.
- Manje esikhundleni sokuthi Faka ukuchofoza I-Ctrl + Faka. Wonke amaseli akhethiwe azogcwaliswa ngedatha efakiwe.
Uma wazi ezinye izindlela zokufaka idatha ngokushesha, sitshele ngazo kumazwana. Ngizobengeza ngenjabulo kulesi sihloko, ngicaphuna wena njengombhali.