Iprosesa ye-Excel ye-Excel ye-Excel yenye yezicelo ezininzi ezibandakanyiweyo kwiOfisi yeOfisi yeMicrosoft. Zonke izinto zayo zinxulumene ngokusondeleyo omnye komnye kwaye zinezinto ezininzi, amathuba. Ke, igama elithi i-imeyile ikwakuvumela ukuba usebenze neetafile, uzenze ekufumaneni kwaye uhlele. Kodwa ngamanye amaxesha kukho umsebenzi wokudlulisela izinto zohlobo ukusuka kwenye inkqubo ukuya kwenye. Malunga nendlela eyenziwa ngayo, siza kuxelela namhlanje.
Ukudluliselwa kwetafile ukusuka kwi-Excel ukuya kwigama
Njengoko kuchaziwe apha ngasentla, kukho indibaniselwano esondeleyo phakathi kwezicelo ze-Excel kunye namagama. Oku kubonelela ngokukhuphela okufanelekileyo kokungenisa ngaphakathi kunye nokuthumela ngaphandle izinto ezinxulumene kunye neefayile, ukwabelana ngokunjalo nokusebenzisa imisebenzi yenkqubo kwenye. Ukudluliselwa kwetafile ukusuka kwisicelo eyilelwe ngokukodwa ukuba kuzenze kwindawo ekugxilwe kuyo ngokusebenzisa itekisi-enye yemisebenzi, kwaye nganye nganye siza kujonga ngakumbi.Indlela yoku-1: Khuphela kwaye ufake
Eyona nto ifanelekileyo kunye nesisombululo esicacileyo siya kuba yikopi elula yetafile ukusuka kwi-Excel kwigama.
- Khetha itafile usebenzisa imouse ukuze idluliselwe kumhleli wokubhaliweyo.
Phawula: Ngaphambi kokuba uqhubekele ekuhambeni kwetafile, kufuneka ivakalise ngobukhulu, okanye endaweni yoko, qiniseka ukuba ayizukuhamba ngaphaya kwamasimi obubhaliweyo. Kwimeko yesidingo esigqithisileyo, awungekhe unciphise (okanye, ngokuchaseneyo, yandise) ngokubhekisele kwi-Excel, kodwa ikwaqwalasele amasimi ngencwadi eneencwadi eziqhelekileyo kwincwadi esetyenziswayo.
Funda ngokugqithisileyo:
Ungalutshintsha njani ubungakanani betafile kwi-Excel
Ukuseta amasimi kwigama
Ungawenza njani iphepha lemihlaba kwigama
- Khuphela itafile elungiselelwe ngokusebenzisa amaqhosha kwiteyiphu, imenyu yomxholo okanye amaqhosha "eshushu" Ctrl + C ".
- Ngoku yiya kwi-MS Word. Vula uxwebhu ukuba lidluliselwe kwitheyibhile, beka isikhombisi se-Cirsor (inqwelwana) endaweni yephepha apho kuya kufuneka libe khona, kwaye lenze enye yezi zinto zilandelayo:
- Yandisa i "Faka" imenyu yeqhosha iqhosha kwaye ucofe kwi icon yokuqala kuluhlu - "Gcina ifomathi yentsusa";
- Ukucofa ekunene (i-PCM) kwindawo yetafile, kwaye kwimenyu yemeko ebonakalayo, khetha iqhosha elikhankanywe apha ngasentla ngomfanekiso wecwecwe kunye neebrashi;
- Sebenzisa amaqhosha "Ctrl + v" amaqhosha okanye, ngcono, "faka".
Itheyibhile ekhutshelwe ukusuka kwi-Excel iya kufakwa kwigama kwifom yayo yoqobo, emva koko unokuqhubeka nokusebenza nayo - gcwalisa, uhlele.
Njengoko unokuqaphela, zikho ezinye iindlela kwimenyu yoMhleli we-Edminion. Ngokufutshane cinga nganye nganye.
- Sebenzisa izitayile zoxwebhu lokugqibela. Itheyibhuli iya kufakwa ngaphandle kokufota komthombo kwaye yenziwa kwisitayile osisebenzisayo kwi-MS Word. Oko kukuthi, ukuba, ukuba, umzekelo, ifonti yeTahoma ene-12 ifakwe njengeyona iphambili, kukwilo ukuba imixholo yetafile iya kurekhodwa.
- Bopha kwaye ugcine ifomathi yokuqala. Itheyibhuli ifakwe kwifom efanayo apho yenziwa e-Excel kwaye igcina unxibelelwano neprosesa yetafile-Iinguqu ezingeniswe kuyo ziya kubonakala kwigama kunye ne-vice verda.
- Bopha kwaye usebenzise izitayile ezigqibeleleyo. Olu khetho yi-synthesis yababini yangaphambili-itafile ithatha isitayile sobhaliso lwegama langoku, kodwa liqhagamshelane ne-Excel.
- Umzobo. Itheyibhile iya kufakwa njengomfanekiso ongafanelekanga ukuhlela.
- Gcina kuphela isicatshulwa kuphela. Itheyibhile ifakwe njengombhalo, kodwa igcina ubume boqobo (ngaphandle kwemida ebonakalayo, iikholamu kunye neeseli).
Bona: Ungayiguqula njani itafile kwisicatshulwa kwigama
Le ndlela yokusombulula umsebenzi wethu ilula kakhulu ekuphunyezweni kwayo, kwaye ibonelela ngeendlela ezahlukeneyo zokufakelwa kweenketho ngexesha elinye, zikuvumela ukuba ukhethe eyona ifanelekileyo. Nangona kunjalo, le ndlela ayifikanga iziphoso: Iitafile ezinkulu kakhulu ziya kugqithiselwa ukuba zitshintshelwe-ziya kudlula ngaphaya kwemimandla yoxwebhu lwesicatshulwa.
Funda kwakhona: Iitafile zokufomatha kwiMicrosoft Word
Indlela 2: Khuphela kunye nePhayinti ekhethekileyo
Kwizicelo zephakheji yeMicrosoft, kukho into ebalulekileyo ye "fan fatha ekhethekileyo", ekuvumela ukuba ugqithise itafile ngohlobo olugqwesileyo, ngelixa usindisa unxibelelwano lwe-Excel (njenge / okanye ifayile yomthombo). Le ndlela icwangcisa isombulula ingxaki yendlela edlulileyo, ivumela ukuba ubeke itafile enkulu kakhulu (ebanzi okanye ephezulu) kumaphepha oxwebhu, anokuboniswa ngokungachanekanga.
- Chaza kwaye ukhuphele itafile ukusuka kwi-Excel njengoko senze kwinqanaba lokuqala lendlela edlulileyo.
- Yiya kumhleli wokubhaliweyo kwaye kwi-"ephambili" yayo, cofa kwiqhosha "Colas". Khetha "i-Inser ekhethekileyo" kuluhlu olusezantsi.
- Kwi "Ifestile ekhethekileyo" yokufakelwa ", khetha i-" Excel ye-Excel yokuqala (isixhobo), kwaye ufake imarkres malunga nelinye lala manqaku mabini:
- "Faka" -Ongezwa "
- "Itafile" - itafile ifakwe ngokuchanekileyo ngendlela efanayo njengakwimeko yangaphambili, kodwa lonke ulungelelwano (kunokwenzeka ngokucinezela kabini (kuyakwenziwa kwifayile ye-Excel olwenziweyo. Kwaye ukuba wenza naluphi na utshintsho kuyo kwiprosesa ye-tabustar, baya kuboniswa kumhleli wokubhaliweyo. Eyona nto ibalulekileyo njengenketho yokufaka "ikhonkco kwaye igcine ifomathi yentsusa", ithathelwe ingqalelo kwindlela yangaphambili.
Ukuthatha isigqibo malunga nokhetho, cofa "Kulungile" ukuqinisekisa, emva koko into ekhutshelweyo iya kuvela kwiphepha lencwadi.
Ukuhlela, kwanele ukucofa i-LX kwitafile kabini, kwaye ukuphuma kule ndlela-cofa ngaphandle kwetafile.
Yiya kuhlela, unako kwaye ngemenyu yomxholo
- Faka isikhombisi endaweni yegama olwafuna ukubeka itafile ukusuka kwi-Excel kwaye uye kwi-fab "ithebhu.
- Kwi-Toolbar yesixhobo, cofa kwiqhosha "lweNdawo" (okanye ukhethe into ekhethiweyo kuluhlu lwayo ezantsi).
- Kwifayile "yokufaka ifayile" yefestile evula, yiya kwifayile "Yenza ifayile" yethebhu.
Cofa kwi "Ushwankathelo" iqhosha kwaye uhambe kwinkqubo "Ehloli" kwifolda apho ifayile igcinwe khona ngespredishithi. Khalule kwaye ucofe "unamathisela".
- Okulandelayo, unokwenza into kwenye yezi gogorithms ezintathu:
- Cofa nje "Kulungile". Itheyibhuli iya kufakwa ngendlela yento, imilinganiselo yento enokutshintshwa, kodwa umxholo awunakuhlelwa.
- Faka ibhokisi ejongene nonxibelelwano nefayile ngefayile - itheyibhile efakiweyo iya kunxulunyaniswa ne-Excel kwaye ilungele ukuhlela kuyo nakwigama. Utshintsho olwenziwe kwiprogram enye luya kuboniswa ngoko nangoko (emva konxibelelwano oluhlaziyayo).
- Phawula uphawu lokutshekisha ngokuchasene ne "ngohlobo lwebheji" - ilebhile yefayile ye-Exfele iya kongezwa kuxwebhu lwesicatshulwa. Ukuba awuphanga "ukunxibelelana nefayile", itafile iya kuvulwa kwifomu ebenayo ngexesha lokufakwa. Ukuba la manqaku afakiwe, indlela emfutshane iya kufumana iipropathi ezifanayo ezichazwe kumhlathi odlulileyo, kunye nolwaziso kuphela olungenakukwazi ukuwulungisa kwigama.
Phawula: Ukuba uxwebhu lweMicrosoft Excel, ukufaka kwayo kwenziwe kwi-Microsoft, kuya kuvulwa, isaziso sempazamo kubonisiwe kwi-skrini apha ngezantsi. Kule meko, kuyimfuneko ukuvala le nkqubo kwaye uphinda izenzo ezichazwe apha ngasentla.
- Nje ukuba uthathe isigqibo malunga nokhetho kwaye ucofe u "Kulungile" kwi "Ifayile" yefestile,
Kwiphepha leencwadi zegama, into ebalaseleyo okanye itafile iya kuvela, okanye ilebheli yayo, kuxhomekeka koluphi ukhetho olikhethileyo.
- Fumana indawo kuxwebhu lwetafile yexesha elizayo kwaye uye kwithebhu "yokufaka".
- Cofa kwindawo ethi "Into" ukuvula ifestile "yokufaka ifayile" sele iqhelekile kuthi.
- Kwithebhu yakhe yokuqala, khetha "Iphepha lokuSebenza le-Excel", emva koko ucofa "ukuqinisekisa.
- Ngokubeka isikhombisi se-Cirsor kwindawo yoxwebhu apho uceba ukubeka khona itafile kwifom yexesha elizayo, yiya kwi "Faka" ithebhu.
- Yandisa i "Tebhule" Imenyu yeqhosha iqhosha uze ukhethe "itafile ye-Excel".
- Uya kuba noncinci kumgangatho kwaye ukuza kuthi ga ngoku igqabi elingenanto le-Excel ifana nale ndlela ingentla. Umsebenzi ongaphezulu naye wenziwa kwi-algorithm enye.
Le ndlela yokudlulisela iitafile ukusuka kwi-Excel kwigama kwezinye iparamitha lingaphezulu kwezi zinto zingasentla. Ikuvumela ukuba usebenzise onke amanqaku eprosesa ye-tabium, egqithisa ezo kumhleli wokubhaliweyo.
Indlela 3: Faka kwifayile
Kukho ukhetho lokudlulisela itafile ngegama ukusuka kwi-Excel ngaphandle kwemfuneko yokuvula le yokugqibela. Kwanele ukwazi kuphela malunga nefayile oyifunayo. Enye imeko ebalulekileyo-ayifanele ibe nezinto ezingeyomfuneko.
Elinye itafile netheyibhile lenziwa ngendlela efanayo nakwezi meko zichazwe apha ngasentla, ngaphandle kokuba ifakwe njengento engahambelani nefayile yoqobo.
Indlela 4: Itheyibhile engenanto
Ifana neyona ndlela idlulileyo yokudlulisela kwento kwifayile ye-Excel kwigama, ungafaka indawo yokugqibela engazaliswanga yidatha, kodwa netafile engenanto. Yenziwa phantse ngendlela efanayo, ngqo ngaphakathi kumhleli wokubhaliweyo.
Iphepha le-Excel liza kufakwa kwigama apho unokwenza itafile yakho ukusuka kwi-scratch usebenzisa zonke izixhobo ezisisiseko zeprosesa yetafile eza kuvela kwi-Edping Toolter.
Ukuphuma kwimowudi yokuhlela, cofa ngokulula i-LKM ngaphandle kwento efakiweyo.
Indlela 5: Indalo Ezimeleyo
Ikho enye indlela yokwenza itheyibhile yokugxotha ngokuthembekileyo ngqo eLizwini, kwaye ekuphunyezweni kwayo ilula ngakumbi kunale ingentla.
Ngaphandle kwento yokuba eli nqaku linikezelwe ikakhulu kukudluliselwa kweetafile ukusuka kwi-Excel, sisawuqwalasele kuyimfuneko ukuze siqwalasele kwaye sibenze bakrexeze. Kwangelo xesha, kumhleli weMicrosoft Emiyalezo, unokwenza iitafile ezilula, ezizimeleyo kwiphakheji yeOfisi yeOfisi yeOfisi ePhambili ekhulileyo kwesi sicwangciso. Yintoni enye enye indlela yokusombulula umsebenzi wethu wanamhlanje, unokufunda kwikhonkco elingezantsi.
Funda ngakumbi: Ungayenza njani itafile kwigama
Ukuqukumbela
Sajonga zonke iindlela zokudlulisela itafile ukusuka kwi-Excel kwigama, kwaye iphinde yachukumisa izisombululo ezizezinye ezibonelela ngokuzimeleyo olu hlobo lwezinto.
Jonga kwakhona: Ungayitshintshela njani imixholo yefayile yegama ukuya kwi-Excel