Timamvetsetsa kuti mukamasintha zolemba za mawu a Microsoft, muyenera kusintha chilichonse pamanja chifukwa mawu a Microsoft samakupatsirani mawonekedwe osinthira mizere kapena mizati kuti musinthenso mawuwo. Zitha kukhala zokwiyitsa komanso zowononga nthawi kukonzanso mizere kapena zidziwitso pamanja pa mawu a Microsoft. Komabe, simuyenera kudutsa chinthu chomwecho ndi Microsoft Excel mukamapeza ntchito yosinthira mu Excel yomwe mungagwiritse ntchito kusinthana mizati mu Excel.
Pamene mukugwira ntchito pa pepala la Excel, muli ndi maselo odzaza ndi deta, koma mwangozi mumayika deta yolakwika pamzere umodzi kapena mzere wina kapena mzere wina. Pa nthawiyo, funso limakhala lakuti Momwe mungasinthire mizati kapena mizere mu Excel ? Chifukwa chake, kuti tikuthandizeni kudziwa ntchito yosinthira ya Excel, tabwera ndi kalozera kakang'ono komwe mungatsatire.
Zamkatimu[ kubisa ]
- Momwe Mungasinthire Mizati kapena Mizere mu Microsoft Excel
- Zifukwa zodziwira momwe mungasinthire mizati kapena mizere mu Excel
- Njira 1: Sinthanitsani Mzerewu pokoka
- Njira 2: Sinthani Mizati ndi Copy/Pasting
- Njira 3: Gwiritsani Ntchito Column Manager Kuti Mukonzenso Mizati
Momwe Mungasinthire Mizati kapena Mizere mu Microsoft Excel
Zifukwa zodziwira momwe mungasinthire mizati kapena mizere mu Excel
Pamene mukuchita ntchito yofunikira kwa abwana anu, pomwe muyenera kuyika zolondola pamizere kapena mizere mu Excel sheet, mwangozi mumayika zidziwitso za gawo 1 mu Column 2 ndi zomwe zili mzere 1 mu mzere 2. Ndiye mungakonze bwanji cholakwikacho chifukwa kuchita pamanja kukutengerani nthawi yochuluka? Ndipo apa ndipamene kusinthana kwa Microsoft Excel kumakhala kothandiza. Ndi ntchito yosinthira, mutha kusinthana mosavuta mizere kapena mizati popanda kuchita pamanja. Chifukwa chake, ndikofunikira kudziwa momwe mungasinthire mizati kapena mizere mu Excel.
Tikutchula njira zingapo zosinthira mizere kapena mizere mu Excel. Mutha kuyesa njira iliyonse mwa njira zotsatirazi zosinthira mizere kapena mizere patsamba la Excel.
Njira 1: Sinthanitsani Mzerewu pokoka
Njira yokoka imafunikira kuchitapo kanthu chifukwa ingakhale yovuta kuposa momwe imamvekera. Tsopano, tiyerekeze kuti muli ndi pepala la Excel lokhala ndi zigoli zosiyanasiyana pamwezi kwa mamembala anu ndipo mukufuna kusinthana ndi Column D kukhala gawo C, ndiye mutha kutsatira njira izi.
1. Tikutenga Chitsanzo cha magulu osiyanasiyana a mwezi uliwonse a mamembala athu, monga mukuwonera pachithunzichi pansipa. Mu skrini iyi, tikuwonetsani sinthanani kuchuluka kwa mwezi wa Gawo D kupita ku Gawo C ndi mosinthanitsa.
2. Tsopano, muyenera kutero sankhani ndime kuti mukufuna kusintha. Kwa ife, tikusankha gawo D podina pamwamba pa Column D . Yang'anani pa skrini kuti mumvetse bwino.
3. Mukasankha ndime yomwe mukufuna kusinthana, muyenera kutero bweretsani cholozera cha mbewa yanu m'mphepete mwa mzerewo , pomwe mudzawona kuti cholozera cha mbewa chidzatembenuka kuchokera ku a choyera kuphatikiza ndi cholozera chambali zinayi .
4. Mukawona cholozera chambali zinayi mutayika cholozera pamphepete mwa mzati, muyenera gwiritsani kiyi yosinthira ndi dinani kumanzere kuti mukoke ndime ya malo omwe mumakonda.
5. Mukakokera ndime kupita kumalo atsopano, mudzawona mzere wolowetsa pambuyo pa gawo lomwe mukufuna kusuntha gawo lanu lonse.
6. Pomaliza, mukhoza kukoka ndime ndikumasula kiyi yosinthira kuti musinthe ndime yonse. Komabe, mungafunike kusintha mutu wagawo pamanja kutengera zomwe mukugwiritsa ntchito. Kwa ife, tili ndi deta ya mwezi uliwonse, kotero tiyenera kusintha mutu wa gawo kuti tisunge ndondomekoyi.
Iyi inali njira imodzi yosinthira mizati, ndipo mofananamo, mungagwiritse ntchito njira yomweyi kuti musinthe deta m'mizere. Njira yokoka imeneyi ingafunike kuyeseza, koma njira imeneyi ingakhale yothandiza mutaidziwa bwino.
Komanso Werengani: Momwe mungasinthire fayilo ya Excel (.xls) kukhala fayilo ya vCard (.vcf)?
Njira 2: Sinthani Mizati ndi Copy/Pasting
Njira ina yosavuta kusintha mizati mu Excel ndi njira ya kukopera/kupatira, yomwe ndiyosavuta kugwiritsa ntchito kwa ogwiritsa ntchito. Mukhoza kutsatira njira izi.
1. Chinthu choyamba ndi kuchita sankhani ndime zomwe mukufuna kusintha kudina pamutu wandalama . Kwa ife, tikusintha Gawo D kupita ku Gawo C.
2. Tsopano, dulani ndime yosankhidwa podina pomwe pagawo ndikusankha njira yodulidwa. Komabe, mutha kugwiritsanso ntchito njira yachidule pokanikiza batani ctrl + x makiyi pamodzi.
3. Muyenera kusankha mzati pamaso zimene mukufuna amaika odulidwa ndime ndiyeno dinani kumanja pagawo losankhidwa kusankha njira ya ' Ikani maselo odulidwa 'kuchokera pa pop-up menyu. Kwa ife, tikusankha gawo C.
4. Mukangodina njira ya ' Ikani maselo odulidwa ,' idzasinthana ndi gawo lanu lonse kumalo omwe mumakonda. Pomaliza, mutha kusintha mutu wagawo pamanja.
Njira 3: Gwiritsani Ntchito Column Manager Kuti Mukonzenso Mizati
Mutha kugwiritsa ntchito in-built column manager kuti kusintha mizati mu Excel . Ichi ndi chida chachangu komanso chachangu chosinthira mizati papepala la Excel. Woyang'anira magawo amalola ogwiritsa ntchito kusintha dongosolo lazanja popanda kukopera pamanja kapena kumata zomwe zili. Choncho, musanapitirize ndi njirayi, muyenera kukhazikitsa Suite yomaliza kuwonjezera pa pepala lanu la Excel. Tsopano, nayi momwe mungasinthire mizati mu Excel pogwiritsa ntchito njira iyi:
1. Mukatha kukhazikitsa zowonjezera zowonjezera pa pepala lanu la Excel, muyenera kupita ku 'Ablebits data' tabu ndipo dinani ‘Manage.’
2. Mu kasamalidwe tabu, muyenera sankhani woyang'anira Column.
3. Tsopano, zenera la woyang'anira ndime lidzatulukira kumanja kwa pepala lanu la Excel. M'malo mwa manejala, mudzawona mndandanda wamagulu anu onse.
Zinayi. Sankhani ndime patsamba lanu la Excel lomwe mukufuna kusuntha ndikugwiritsa ntchito mivi yopita mmwamba & pansi pazenera la woyang'anira ndime kumanzere kuti musunthe mzati womwe mwasankha mosavuta. Kwa ife, tikusankha gawo D kuchokera patsamba logwirira ntchito ndikugwiritsa ntchito muvi wopita mmwamba kuti tisunthe patsogolo pa ndime C. Mofananamo; mutha kugwiritsa ntchito makiyi amivi kuti musunthire data yazazambiri. Komabe, ngati simukufuna kugwiritsa ntchito zida za mivi, ndiye kuti mulinso ndi mwayi wokokera mzere pawindo la woyang'anira ndime kupita komwe mukufuna.
Iyi inali njira ina yosavuta yomwe mungathe kusintha mizati mu Excel. Chifukwa chake, ntchito zilizonse zomwe mumachita pazenera loyang'anira magawo zimachitidwa nthawi imodzi patsamba lanu lalikulu la Excel. Mwanjira iyi, mutha kukhala ndi mphamvu zonse pazantchito zonse za woyang'anira magawo.
Alangizidwa:
- Sinthani Mwamsanga Pakati pa Mapepala Ogwira Ntchito mu Excel
- Momwe Mungachotsere Mawu Achinsinsi pa Fayilo ya Excel
- Momwe mungasinthire chingwe cha Coaxial kukhala HDMI
Tikukhulupirira kuti bukuli linali lothandiza ndipo munalimvetsetsa Momwe mungasinthire mizati kapena mizere mu Excel . Njira zomwe zili pamwambazi ndizosavuta kuchita, ndipo zimatha kukhala zothandiza mukakhala pakati pa ntchito ina yofunika. Komanso, ngati mukudziwa njira ina iliyonse yosinthira mizati kapena mizere, mutha kutidziwitsa mu ndemanga pansipa.
Pete Mitchell Pete ndi Mlembi wamkulu wa ogwira ntchito ku Cyber S. Pete amakonda zinthu zonse zamakono komanso ndi DIYer wofunitsitsa pamtima. Ali ndi zaka khumi akulemba momwe-tos, mawonekedwe, ndi maupangiri aukadaulo pa intaneti.