Microsoft Excel ndi imodzi mwamapulogalamu omwe amagwiritsidwa ntchito kwambiri pamasamba omwe amakulolani kuti muzitha kuyang'anira deta yanu ndikukupangitsani zinthu kukhala zosavuta mothandizidwa ndi ma formula. Komabe, mukafuna kukopera ndi kumata zikhalidwe zomwe mudawerengera kale ndi mafomula. Koma, mukamakopera izi, mumatengeranso mafomuwo. Sizingakhale zosangalatsa kwambiri mukafuna kukopera-kumata zikhalidwezo, komanso mumayika mafomuwo pamodzi ndi zikhalidwe zake. Mwamwayi, tili ndi kalozera kukopera ndi kumata zikhalidwe popanda mafomula mu Excel zomwe mungatsatire kukopera ndi kumata zikhalidwe popanda mafomula.
Zamkatimu[ kubisa ]
- Momwe Mungayikitsire Makhalidwe Opanda Mafomula mu Excel
- Njira 1: Gwiritsani ntchito njira ya copy-paste
- Njira 2: Gwiritsani ntchito Kutools add-in
Momwe Mungayikitsire Makhalidwe Opanda Mafomula mu Excel
Njira 1: Gwiritsani ntchito njira ya copy-paste
Mutha kukopera ndi kumata zikhalidwezo mosavuta popanda mafomula mu Excel pogwiritsa ntchito zosankha zamakopera ndi kumata kuchokera pagawo lanu lojambula.
1. Tsegulani Tsamba la Microsoft Excel .
awiri. Tsopano, sankhani zomwe mukufuna kukopera ndikuziyika ku selo kapena pepala lina.
3. Mukasankha selo, dinani pa tsamba lanyumba kuchokera pa clipboard yanu pamwamba ndikusankha kukopera. Kwa ife, tikutengera mtengo womwe tawerengera ndi fomula ya SUM. Yang'anani skrini kuti muwone.
4. Tsopano, pitani ku cell komwe mukufuna kuyika mtengo wake.
5. Kuchokera pa bolodi lanu, dinani pa menyu yotsitsa pansi pamasamba.
6. Pomaliza, mukhoza dinani ma values (V) pansi pamitengo kumata mtengo mu selo popanda formula iliyonse.
Komanso Werengani: Momwe Mungasinthire Mizati kapena Mizere mu Excel
Njira 2: Gwiritsani ntchito Kutools add-in
Ngati simukudziwa momwe mungakoperere zokhazokha, osati ma formula, mungagwiritse ntchito Kutools extension kwa Excel. Kutools kwa Excel ikhoza kukhala yothandiza pamene mukufuna kukopera zenizeni zenizeni popanda mafomu.
1. Koperani Kutools kuwonjezera kwa Excel yanu.
2. Pambuyo bwino kukhazikitsa chowonjezera, tsegulani pepala lanu la Excel ndikusankha zomwe mukufuna kutengera.
3. Dinani kumanja ndikutengera mtengo wake.
4. Pitani ku selo kuti muyike mtengo ndikupanga a dinani kumanja kuti muyike mtengowo.
5. Tsopano, chotsani chilinganizo pamtengo. Dinani pa Kutools tab kuchokera pamwamba ndi sankhani Kuti Zenizeni.
Pomaliza, ntchito yeniyeniyo idzachotsa mafomuwa pamakhalidwe omwe mukulemba.
Mafunso Ofunsidwa Kawirikawiri (FAQs)
Kodi mungakopere manambala opanda ma fomula?
Mutha kukopera manambala mosavuta popanda mafomu. Komabe, muyenera kugwiritsa ntchito manambala ntchito kukopera ndi kumata manambala popanda mafomula. Kuti mukopere manambalawo popanda mafomula, koperani manambala omwe mukufuna kukopera ndikudina pa menyu yotsikira pansi pa batani la matani pagawo lanu la clipboard ya Excel pamwamba. Kuchokera pa menyu yotsitsa, muyenera kudina ma values pansi pa ma values.
Kodi ndimachotsa bwanji ma fomula ndikumata mu Excel?
Kuti muchotse chilinganizocho ndikungoyika zomwe zili mu Excel, koperani zikhalidwezo ndikupita kugawo lanu lojambula. Pansi panyumba> dinani pa menyu yotsitsa pansi pa batani la matani. Tsopano, sankhani ma values pansi pa mtengo wa phala kuti muyike mtengowo popanda fomula.
Kodi ndimaumiriza bwanji Excel kuti amamitse zikhalidwe zokha?
Mungagwiritse ntchito chowonjezera cha Excel chotchedwa Kutools kwa Excel , chomwe chimakulolani kukopera ndi kuyika mfundo zenizeni popanda mafomu. Mukhoza kutsatira ndondomeko yathu yatsatanetsatane kuti mugwiritse ntchito Kutools add-in.
Alangizidwa:
- Momwe Mungatsegule Kapena Kutsegula Maselo Mu Excel?
- Konzani Windows 10 batani loyambira silikugwira ntchito
- Momwe Mungachotsere Mawu Achinsinsi pa Fayilo ya Excel
- Konzani Chromecast Gwero Losagwiritsidwa Ntchito pa Chipangizo Chanu
Tikukhulupirira kuti bukhuli linali lothandiza ndipo munatha kukopera ndi kumata zikhalidwe popanda mafomula mu Excel . Komabe, ngati muli ndi kukayikira kulikonse, khalani omasuka kuwafunsa mu gawo la ndemanga.
Pete Mitchell Pete ndi Senior staff writer ku Cyber S. Pete amakonda zinthu zonse zaukadaulo komanso ndi DIYer wofunitsitsa pamtima. Ali ndi zaka khumi akulemba momwe-tos, mawonekedwe, ndi maupangiri aukadaulo pa intaneti.