IMicrosoft Excel yenye yezona nkqubo zisetyenziswa kakhulu kwi-spreadsheet software ekuvumela ukuba ulawule idatha yakho kwaye yenza izinto zibe lula kuwe ngoncedo lweefomula. Nangona kunjalo, xa ufuna ukukopa kwaye uncamathisele amaxabiso owabale kwangaphambili ngeefomula. Kodwa, xa ukopa la maxabiso, ukopa iifomyula ngokunjalo. Ayinakuba mnandi kakhulu xa ufuna ukukopa-coca amaxabiso, kodwa uncamathisela iifomyula kunye namaxabiso. Ngethamsanqa, sinesikhokelo kwi ukukopa kunye nokuncamathisela amaxabiso ngaphandle kweefomula kwi-Excel onokuthi uyilandele ukukopa nokuncamathisela amaxabiso ngaphandle kweefomula.
Imixholo[ fihla ]
- Uncamathisela njani amaxabiso ngaphandle kweefomula kwi-Excel
- Indlela yoku-1: Sebenzisa indlela yokukopa-uncamathisele
- Indlela yesi-2: Sebenzisa i-Kutools add-in
Uncamathisela njani amaxabiso ngaphandle kweefomula kwi-Excel
Indlela yoku-1: Sebenzisa indlela yokukopa-uncamathisele
Ungakopa kwaye uncamathisele ngokulula amaxabiso ngaphandle kweefomula kwi-Excel usebenzisa ikopi kwaye uncamathisele iinketho kwicandelo lakho lebhodi eqhotyoshwayo.
1. Vula i Iphepha leMicrosoft Excel .
Mbini. Ngoku, khetha amaxabiso onqwenela ukuwakopa kwaye uwancamathisele kwenye iseli okanye iphepha.
3. Emva kokukhetha iseli, nqakraza kwithebhu yasekhaya kwicandelo lakho lebhodi eqhotyoshwayo phezulu kwaye ukhethe ikopi. Kwimeko yethu, sikhuphela ixabiso esilibalileyo kunye nefomula ye-SUM. Jonga umfanekiso wekhusi kwireferensi.
4. Ngoku, yiya kwiseli apho unqwenela ukuncamathisela ixabiso.
5. Ukusuka kwicandelo lakho lebhodi eqhotyoshwayo, nqakraza kwi-menu eyehlayo ezantsi coma.
6. Ekugqibeleni, unako nqakraza kumaxabiso (V) phantsi kwamaxabiso okucola ukuncamathisela ixabiso kwiseli ngaphandle kwayo nayiphi na ifomula.
Kwakhona Funda: Ukutshintsha njani amaKholamu okanye imiqolo kwi-Excel
Indlela yesi-2: Sebenzisa i-Kutools add-in
Ukuba awukwazi ukukopisha ngokuzenzekelayo amaxabiso agqwesileyo, kungekhona iifomyula, ungasebenzisa i-Kutools extension for Excel. I-Kutools ye-Excel inokuhamba kakuhle xa ufuna ukukopisha amaxabiso angempela ngaphandle kweefomula.
1. Khuphela Kutools ukongeza kwi-excel yakho.
2. Emva ngempumelelo ukufaka i-add-in, vula i-excel sheet yakho kwaye ukhethe amaxabiso onqwenela ukuwakopa.
3. Cofa ekunene kwaye ukope ixabiso.
4. Yiya kwiseli ukuncamathelisa ixabiso kwaye wenze i cofa ekunene ukuncamathisela ixabiso.
5. Ngoku, susa ifomula kwixabiso. Cofa kwi Ithebhu ye-Kutools ukusuka phezulu kwaye khetha Kweyona kanye.
Okokugqibela, owona msebenzi uyakususa iifomyula kumaxabiso owancamathiselayo.
Imibuzo Ebuzwa Rhoqo (FAQs)
Ngaba unokukopa amanani ngaphandle kweefomula?
Ungakopa ngokulula amanani ngaphandle kweefomula. Nangona kunjalo, kufuneka usebenzise umsebenzi wamaxabiso wokuncamathisela ukukopa nokuncamathisela amanani ngaphandle kweefomula. Ukukopa amanani ngaphandle kweefomula, khuphela amanani onqwenela ukuwakopa kwaye ucofe kwimenyu eyehlayo phantsi kweqhosha lokucola kwicandelo lakho lebhodi eqhotyoshwayo engaphezulu. Ukusuka kwi-drop-down menu, kufuneka ucofe kumaxabiso phantsi kwamaxabiso okuncamathisela.
Ndiyisusa njani ifomyula kwaye ndincamathisele amaxabiso kwi-Excel?
Ukususa ifomula kwaye uncamathisele amaxabiso kuphela kwi-Excel, khuphela amaxabiso kwaye uye kwicandelo lakho lebhodi eqhotyoshwayo. Ngaphantsi kwekhaya> cofa kwi-drop-down menu phantsi kweqhosha lokunamathisela. Ngoku, khetha amaxabiso phantsi kwexabiso lokuncamathisela ukuncamathisela ixabiso ngaphandle kwefomula.
Ndiyinyanzela njani i-Excel ukuba incamathelise amaxabiso kuphela?
Ungasebenzisa i-Excel add-in ebizwa ngokuba yi-Kutools ye-Excel, evumela ukuba ukopishe kwaye unamathisele amaxabiso angempela ngaphandle kweefomula. Unokulandela ngokulula isikhokelo sethu esicacileyo ukusebenzisa i-Kutools add-in.
eCetyisiweyo:
- Zizitshixa njani okanye uzivule njani iiseli kwi-Excel?
- Lungisa Windows 10 Iqhosha lokuQala alisebenzi
- Ulisusa njani igama lokugqithisa kwiFayile ye-Excel
- Lungisa uMthombo weChromecast ongaxhaswanga ngumba kwisixhobo sakho
Siyathemba ukuba esi sikhokelo sibe luncedo kwaye ukwazile ukukopa nokuncamathisela amaxabiso ngaphandle kweefomula kwi-Excel . Nangona kunjalo, ukuba unawo nawaphi na amathandabuzo, zive ukhululekile ukubabuza kwicandelo lezimvo.
nguPete Mitchell UPete ungumbhali wabasebenzi oPhezulu kwiCyber S. UPete uthanda zonke izinto itekhnoloji kwaye ukwangu-DIYer okhutheleyo entliziyweni. Uneminyaka elishumi yamava okubhala indlela-tos, iimpawu, kunye nezikhokelo zetekhnoloji kwi-intanethi.