Ngobuninzi abasebenzisi be-Excel, inkqubo yokukhuphela iitafile ayisiyongxaki enkulu. Kodwa, ayinguye wonke umntu owaziyo into ethile evumela ukuba wenze le nkqubo ibekwe ngokufanelekileyo kuhlobo olwahlukileyo lwedatha kunye neenjongo ezahlukeneyo. Makhe siqwalasele ngokweenkcukacha amanqaku athile okukhuphela idatha kwinkqubo ye-Excel.
Ukukhuphela ukuze kwenziwe
Ukukhuphela itafile e-Excel kukudala uphindaphini. Kule nkqubo, akukho mahluko kuxhomekeka ekubeni uza kufaka i-data: kwenye indawo yephepha elinye, kwiphepha elitsha okanye enye incwadi (ifayile). Umahluko ophambili phakathi kweendlela zokukhuphela iindlela yindlela ofuna ukukopa ngayo ulwazi: kunye nefomula okanye kuphela ngedatha ebonisiweyo.Isifundo: Ukukhuphela iitafile kwi-Mirosoftword
Indlela yoku-1: Khuphela okungagqibekanga
Ukukhuphela okulula ngokungagqibekanga ukuya kwi-Excel kubandakanya ukudala ikopi yetafile kunye nazo zonke iifomula ezibekwe kuyo kunye nokufomatha.
- Sibonisa indawo esifuna ukukopa kuyo. Cofa kwindawo eyabiweyo ngeqhosha lasekunene lemouse. Imenyu yemeko iyavela. Khetha kuyo "Khuphela".
Kukho ezinye iindlela zokwenza eli nyathelo. Eyokuqala kubo iqulethe ukucinezela ikhibhodi ye-CTRL + C izitshixo emva kokukhethwa kwendawo. Inketho yesibini ibandakanya ukucofa iqhosha elithi "Khuphela", elikwe kwikhasethi "kwikhaya" kwi-doloton "ye-Buffer".
- Vula indawo esifuna ukufaka idatha. Inokuba liphepha elitsha, enye ifayile ye-Excel okanye enye yeeseli kwiphepha elinye. Cofa kwiseli ekufuneka ibe yitafile ephezulu yeseli. Kwimenyu yenguqu kwi-parameters, khetha "i-paste".
Kukho ezinye iindlela zenyathelo. Unokuqaqambisa ikhibhodi ye-CTRL + v kwikhibhodi. Ukongeza, ungacofa iqhosha "paste", elikwindawo yasekhohlo yeteyiphu ecaleni kweqhosha "Khuphela".
Emva koko, ukufakelwa kwedatha kuya kwenziwa ngelixa kulondolozwa ifomathi kunye neefomula.
Indlela 2: Ukukhuphela amaxabiso
Indlela yesibini ibonelela ngokukhuphela itafile yetafile kuphela ebonisiweyo kwiscreen, hayi ifomula.
- Khuphela idatha yenye yeendlela ezichazwe apha ngasentla.
- Ngokucofa iqhosha lemouse ekunene kwindawo ofuna ukuyifaka kuyo idatha. Kwimenyu yenguqu kwi-parameter ye-Inforter, khetha eyona nto "yexabiso".
Emva koko, itafile iya kongezwa kwishiti ngaphandle kokulondolozwa kwefomathi kunye neefomula. Oko kukuthi, kuphela idatha ebonisiweyo kwisikrini iya kutyunjelwa.
Ukuba ufuna ukukopa amaxabiso, kodwa kwangaxeshanye gcina ifomathi yoqobo, kuya kufuneka uye kwimenyu "yokufakwa okhethekileyo" ngexesha lokufakwa. Apho, kwi "Ixabiso" lebhloko ", kufuneka ukhethe" amaxabiso kunye nefomathi yentsusa ".
Emva koko, itafile iya kuboniswa kwifom yokuqala, kodwa kuphela endaweni yefoli yeseli iya kuzalisa amaxabiso rhoqo.
Ukuba ufuna ukwenza lo msebenzi kuphela ngokugcinwa kwefomathi yamanani, hayi itafile yonke, emva koko kwintente ekhethekileyo kufuneka ukhethe okhethekileyo kwinto ethi "amaxabiso kunye neefomathi zamanani".
Indlela yesi-3: Yenza ikopi ngelixa ukonga iikholamu zobubanzi
Kodwa, ngelishwa, kwanokusetyenziswa kwefomathi yomthombo ayikuvumeli ukuba wenze ikopi yetafile kunye nobubanzi bekholamu yokuqala. Oko kukuthi, amaxesha amaninzi kukho iimeko xa idatha ingabekwa kwiiseli emva kokufaka. Kodwa e-Excel, kunokwenzeka ukugcina ububanzi bekholamu yokuqala besebenzisa izenzo ezithile.
- Khuphela itafile ngayo nayiphi na indlela eqhelekileyo.
- Kwindawo apho kufuneka ufake khona idatha, tsalela imenyu yemeko. Singagungqi rhoqo kwizinto "zokufakwa okhethekileyo" kwaye "songe ububanzi bekholamu yentsusa."
Ungabhalisa ngenye indlela. Ukusuka kwimenyu yeMongozo kabini yiya kwinto enegama elifanayo "ukufakelwa okhethekileyo ...".
Ifestile ivula. Kwi "Faka i-Toolbar yesixhobo, sihlengahlengisa ukutshintshela kwindawo" yobubanzi bekholomu ". Cofa kwiqhosha "Kulungile".
Nokuba yeyiphi na indlela oyikhethileyo kwezi ndlela zibini zidweliswe apha ngasentla, nangayiphi na imeko, itafile ekopi iya kuba nobubanzi obufanayo bokomthombo.
Indlela yesi-4: Faka njengomfanekiso
Kukho iimeko xa itafile kufuneka ifakwe kwifomathi eqhelekileyo, kodwa njengomfanekiso. Lo msebenzi usonjululwe usebenzisa i-PAINT.
- Yenza ikopi yoluhlu olufunayo.
- Khetha indawo yokufaka kwaye ubize imenyu yemeko. Yiya kwinto "yokufakwa okhethekileyo". Kwi "Okunye iisetingi ze-Prit" ibhloko, khetha "into".
Emva koko, idatha iya kufakwa kwiphepha njengomfanekiso. Ngokwemvelo, kuya kuba yinto engenakwenzeka ukuba ihlele itafile enjalo.
Indlela ye-5: Ukukhuphela iphepha
Ukuba ufuna ukukopa yonke itafile kwelinye iphepha, kodwa kwangaxeshanye lusigcine njengomthombo ofanayo, ke kule meko, kungcono ukukopa iphepha lonke. Kule meko, kubalulekile ukufumanisa ukuba ufuna ngokwenene ukudlulisela yonke into ekwiphepha lemithombo, kungenjalo le ndlela ayizukulunga.
- Ukuzaliswa ngesandla Emva koko, iphepha lonke liya kugxininiswa. Ukukhuphela imixholo, chwetheza i-CTRL + C indibaniselwano kwikhibhodi.
- Ukufaka idatha, vula iphepha elitsha okanye incwadi entsha (ifayile). Ngokufanayo, nqakraza kwi-orctungle ibekwe kwi-insorlic yephaneli. Ukufaka idatha, uhlobo lweqhosha le-CTRL + V.
Njengoko ubona, emva kokwenza le nto, sikwazile ukukopa iphepha kunye netafile kunye nemixholo yayo yonke. Ijika igcinwe kungekuphela nje ukufomatha kokuqala, kodwa kunye nobungakanani beeseli.
Umhleli wetheyibhile ye-Exfel Inezixhobo ezinkulu zokukopa iitafile kanye njengoko kufuneka umsebenzisi efunwa. Ngelishwa, ayinguye wonke umntu owaziyo malunga ne-numes yokusebenza ngokufakelwa okhethekileyo kunye nezinye izixhobo ezikuvumela ukuba zikhulise kakhulu amathuba okudluliselwa kwedatha.