Xa usebenza kwi-Excel, umsebenzisi usenokungabinalo ixesha lokugcina idatha ngezizathu ezahlukeneyo. Okokuqala, kunokubangela ukusilela kwamandla, isoftware kunye neempazamo ze-HOSHEWADE. Kukho iimeko xa umsebenzisi ongenamava xa uvala ifayile kwibhokisi yencoko yababini endaweni yokonga iNcwadi, ukubetha "musa ukugcina" iqhosha. Kuzo zonke ezi meko, umba wokubuyisela uxwebhu olucokisekileyo kwi-Excel ibalulekile.
Ukubuyiswa kwedatha
Kuyimfuneko ukuba uqaphele ngokukhawuleza ukuba kunokwenzeka ukubuyisela ifayile engagcinwanga kuphela ukuba inkqubo ibandakanya ukugcinwa ngokuzenzekelayo. Ngaphandle koko, phantse zonke iintshukumo zenziwa kwi-RAM kunye nokululama akunakwenzeka. Ukugcinwa okungagqibekanga kuqhubeke, nangona kunjalo, kungcono ukuba ujonge imeko yayo kwiseto ukuze uzikhusele ngokupheleleyo kuyo nayiphi na into eyothusayo. Ngendlela efanayo, ukuba unqwenela, ungayenza rhoqo i-frequency yogcino loncwadi oluzenzekelayo (ngokwasilela kwimizuzu eli-10).Isifundo: Ungayibeka njani isigxina se-Auto kwi-Excel
Indlela yoku-1: Ukubuyisela uxwebhu olungagcinwanga emva kokusilela emsebenzini
Nge-Hardware okanye isoftware, ukusilela kwekhompyuter, okanye xa ukusilela kwamandla kwezinye iimeko, umsebenzisi akanakho ukugcina incwadi ye-ECEC, awayesebenza kuyo. Kwenziwe ntoni?
- Emva kokusebenza kwenkqubo ibuyiselwe ngokupheleleyo, vula inkqubo ye-Excel. Kwicala lasekhohlo lefestile kwangoko emva kokuqalisa, ukubuyiswa kwexwebhu kuya kuvulwa ngokuzenzekelayo. Khetha ngokulula uxwebhu lwexwebhu le-autosunt ofuna ukubuyisela (kwimeko yeendlela ezininzi). Cofa kwigama layo.
- Emva koko, idatha evela kwifayile engacocekanga iya kuboniswa kwiphepha. Ukuze wenze inkqubo yokonga, cofa kwi icon kwifom yediski yefloppy kwikona ephezulu yefestile yenkqubo.
- Gcina i-Window Window ivuliwe. Khetha indawo yefayile, ukuba iyimfuneko, tshintsha igama kunye nefomathi yayo. Cofa kwindawo ethi "Gcina".
Kwinkqubo yokubuyisela kwimeko yesiqhelo inokuqwalaselwa ngaphezulu.
Indlela 2: Ukubuyisela iNcwadi engagcinwanga xa uvala ifayile
Ukuba umsebenzisi akayigcinanga ncwadi engeyiyo ngenxa yenkqubo yokungaphumeleli, kodwa kuphela kuba xa ivala iqhosha elithi "Musa ukugcina" iqhosha "Angayigcini", ke ngekhe kwenzeke ukubuyisela le ndlela ingentla. Kodwa, ukuqala ngo-2010, kukho esinye isixhobo esifanelekileyo sokubuyisela idatha ngokulinganayo.
- Sebenzisa inkqubo ye-Excel. Yiya kwi "Ifayile" yethebhu. Cofa kwindawo ethi "yokugqibela". Apho cofa kwi "Buyisela Gcina iqhosha". Ibekwe ezantsi kwesiqingatha sasekhohlo sefestile.
Kukho indlela enye. Xa kwithebhu yefayile, yiya "kwiinkcukacha" zecandelwana " Ezantsi kwenxalenye ephakathi yewindows kwi "Versies" ibhloko yeparamitha, cofa iqhosha u- "Guqula". Kuluhlu oluvelayo, khetha into ethi "Buyisela iincwadi ezingakhuselekanga".
- Nokuba ziyintoni na ezi ndlela ozikhethileyo, emva kwezi zinto zinikezela ngoluhlu lweencwadi zokugqibela ezingakhuselekanga. Ngokwemvelo, igama labelwe ngokuzenzekelayo. Ke ngoko, yiphi incwadi ekufuneka ibuyiselwe, umsebenzisi kufuneka abale ngexesha, indawo ekwikho ikholam "yoMhla wotshintsho". Emva kokuba ifayile oyifunayo ikhethiwe, cofa iqhosha u "Vula".
- Emva koko, incwadi ekhethiweyo ivula i-Excel. Kodwa, ngaphandle kwento yokuba ivuliwe, ifayile ayigqitywanga. Ukuze ugcine, cofa kwi "Gcina njenge" iqhosha, elikwe kwikhasethi eyongezelelweyo.
- Ifestile engasesikweni yefayile ivula apho unokukhetha indawo yokubekwa kunye nefomathi, kunye nokutshintsha igama layo. Emva kokhetho lwenziwe, cofa iqhosha u "Gcina".
Incwadi iya kusindiswa kulawulo oluchaziweyo. Ke, ukuphinda baphinde kwenzeke.
Indlela 3: Ukuvulwa kwencwadi engagcinwanga
Kukho amandla okuvula uyilo lweefayile ezingagcinwanga ngesandla. Ewe kunjalo, olu khetho aluyi kuba lula njengendlela edlulileyo, kodwa, nangona kunjalo, kwezinye iimeko, umzekelo, ukuba le nkqubo yona yonakele, kuphela kwento eyenzekayo yokufumana idatha.
- Sebenzisa i-Excel. Yiya kwi "Ifayile" yethebhu. Cofa kwicandelo "Vula".
- Ifestile yokuvula iyasebenza. Kule festile, yiya kwidilesi ngale template ilandelayo:
C: \ Abasebenzisi \ Igama lomsebenzisi \ \ appdata \ yengingqi \ iMicrosoft \ offin \ ye-ofisi
Kwidilesi, endaweni yegama elithi "igama lomsebenzisi" kufuneka endaweni yegama leakhawunti yakho yeWindows, oko kukuthi, igama lefolda kwikhompyuter ngolwazi lomsebenzisi. Emva kokufudukela kulawulo olufunwayo, khetha ifayile yomzobo ekufuneka ibuyiselwe. Cofa iqhosha "Vula".
- Emva kokuba incwadi ivuliwe, siyayigcina kwidiski ngendlela efanayo esele ithethwe ngaphezulu.
Unokuya kukufota nje kulawulo lwefayile oyilwayo ngeFayile yoMhloli. Le yifolda ebizwa ngokuba zizinxibo. Indlela eya kuyo iboniswe apha ngasentla. Emva koko, khetha uxwebhu olufunwayo ukuze ufumane kwakhona kwaye ucofe kuyo ngeqhosha lasekhohlo.
Ifayile iqala. Siyigcina ngendlela eqhelekileyo.
Njengoko ubona, nokuba awunaxesha lokugcina incwadi ye-Excel, ukuba uyasilela ukusebenza kwikhompyuter yakho, okanye ngempazamo ukuyicima ukuba igcinwe, ke kukho iindlela ezininzi zokubuyisela idatha. Eyona meko iphambili ekubuyiseleni kukufakwa kokugcinwa ngokuzenzekelayo kwinkqubo.