Ulahlekelwe yifayile yakho ye-Excel? Isikhokelo esipheleleyo sokuqonda kunye nokuphepha iimpazamo zokugcina

Ngaba unengxaki yokugcina iifayile zakho kwi-Excel? Le meko inokukhathaza ngokwenene, ngakumbi ukuba uchithe ixesha elininzi usebenza kwi-spreadsheet yakho kwaye uyoyika ukuphulukana nalo lonke utshintsho lwakho. IMicrosoft Excel yenye yezona zixhobo zisetyenziswa kakhulu kulawulo lwedatha kunye nohlalutyo, ngoko Ukudibana neempazamo xa uzama ukugcina amaxwebhu ngomnye wemibuzo eqhelekileyo kunye nokuxhalaba phakathi kwabasebenzisi bayo.

Kweli nqaku, siza kuphonononga zonke Izizathu ezinokuthi zithintele i-Excel ekugcineni iifayile zakhokwaye siya kubonelela ngezisombululo ezineenkcukacha kwimeko nganye. Apha awuyi kufumana iinkqubo zesinyathelo-nge-nyathelo kuphela, kodwa kunye neenkcazo ezicacileyo kunye neengcebiso ezincedo zokuphepha ezi ntlobo zeengxaki kwixesha elizayo. Yiza, hlala sizokucacisela. indlela yokuchacha kwezi meko kwaye uzithintele.

Isebenza njani inkqubo yogcino kwi-Excel kwaye kutheni inokusilela

Ngaphambi kokungena kwizisombululo, kubalulekile ukuqonda indlela i-Excel igcina ngayo iifayile, ekubeni inkqubo ayilula njengoko ibonakala. I-Excel, xa ugcina ngesandla okanye ngokuzenzekelayo incwadi yomsebenzi, yenza kuqala ifayile yethutyana kwindawo enye noxwebhu lokuqala.. Nje ukuba ugcino lugqityiwe, cima ifayile yoqobo kwaye unike ifayile yethutyana igama elichanekileyo. Ukuba kukho nayiphi na imiba eyenzeka ngexesha lale nkqubo, iintlobo ezahlukeneyo zeempazamo zinokuthi zenzeke, kwaye ifayile enotshintsho lwamva nje ayinakugcinwa ngokuchanekileyo.

Iziphazamiso kwinkqubo yokulondoloza inokuba ngenxa yezizathu ezininzi: ukucofa iqhosha elithi "Esc", iingxaki zehardware, iingxaki zesoftware, iingxaki ze-antivirus, iingxabano zemvume, iindlela zefayile ezinde kakhulu, okanye ukunqongophala kwendawo yedisk. Kwakhona kufuneka uqaphele ngeendawo zothungelwano okanye iidrive zangaphandle, njengokungathi uxhulumaniso lulahlekile ngelixa i-Excel igcina, unokugqiba ngeefayile ezonakalisiweyo okanye utshintsho olungagcinwanga.

Imiyalezo yemposiso eqhelekileyo xa ugcina iifayile kwi-Excel

Phakathi kwemiyalezo yemposiso eqhelekileyo xa i-Excel ingayigcini ifayile, oku kulandelayo kugqamile:

• "Uxwebhu alugcinwanga"
• "Uxwebhu aluzange lugcinwe ngokupheleleyo"
• «Uxwebhu lokufunda kuphela alunakufikelelwa. »
• "Idiski epheleleyo"
• "Iimpazamo zichongiwe ngelixa ugcina..."
• "Igama lefayile alisebenzi"

Impazamo nganye kwezi yalatha kunobangela owahlukileyo., ngoko ke kungcono ukuchonga umyalezo ochanekileyo phambi kokukhangela isisombululo esifanelekileyo.

Izizathu eziphambili zokuba kutheni i-Excel ingagcini utshintsho

Ngokwamaxwebhu asemthethweni, iiforam zoncedo kunye namava abasebenzisi, Ezona zizathu ziqhelekileyo zokuba kutheni i-Excel inika iingxaki xa ugcina iifayile:

• Ukunqongophala kweemvume kwifolda yendawo: Ukuba awunakufunda, ukubhala, okanye ukulungisa iimvume kwifolda apho uzama ukugcina incwadi yomsebenzi, i-Excel ayizukwazi ukugqiba ukugcina.
• Iiplagi zeqela lesithathu: Ezinye izongezo ezifakwe kwi-Excel zinokuphazamisana nenkqubo yokugcina, kubangele ukuphahlazeka okungalindelekanga okanye iimpazamo.
• Iifayile ezonakeleyo okanye ezonakeleyo: Ukuba ifayile yoqobo yonakele, i-Excel inokuthintela utshintsho ekugcinweni ngokuchanekileyo.
• Isithuba sedisk esingonelanga: Ukuba indawo ekuyiwa kuyo ayinaso isithuba esikhululekileyo, i-Excel ayiyi kuwugqiba umsebenzi wokulondoloza.
• Isoftware yeAntivirus: Ezinye iinkqubo ze-antivirus zinokuvala inkqubo yokugcina, ngakumbi ukuba ziskena iifayile ezintsha okanye ziguqule iifayile ezivuliweyo ngexesha lokuskena.
• Ukwabelana ngeengxabano okanye izitshixo: Ukuba ifayile ivulwe ngomnye umntu okanye komnye umzekelo we-Excel, iimpazamo zingenzeka xa ugcina.
• Indlela yefayile yinde kakhulu: I-Excel imisela umda kwigama lefayile kunye nendlela epheleleyo yoonobumba abangama-218. Ukuba iyagqitha, uya kufumana impazamo yegama elingasebenziyo.
• Iingxaki zoqhagamshelwano kwiindawo zenethiwekhi: Ukuba ugcina iifayile kwinethiwekhi kwaye unxibelelwano lulahlekile, ugcino lunokusilela kwaye unokuphulukana nedatha yakutsha nje.
• Iifayile ezikwimowudi yokufunda kuphela: Ifayile inokuba nale ndlela yenziwe yasebenza okanye awunakuba ngumnini, unciphisa ukukwazi ukuyigcina ngotshintsho.
• Iimpazamo zehardware (idiski, iidrive ze-USB, njl.njl.): Ukusilela ngokwasemzimbeni okanye ukuqhawuka konxibelelwano lwedrive ngelixa ugcinayo kunokubangela iimpazamo kunye neefayile ezonakeleyo.
• Iifayile zitshixiwe yinkqubo okanye olunye usetyenziso: Ukuba ifayile isetyenziswa yenye inkqubo, inokuthintela ukugcinwa.

Uyilungisa njani i-Excel ingagcini utshintsho?

Makhe sihlole enye nganye ezona zisombululo zisebenzayo kwimeko nganye ethile.

1. Jonga kwaye ulungise iimvume zefolda

Okokuqala Khangela ukuba uneemvume ezaneleyo kulawulo apho ugcine khona ifayile. Cofa ekunene kwifolda, khetha Propiedades, fikelela kwithebhu Khu seleko kwaye ujonge iimvume ezinikezelwe kumsebenzisi wakho. Ukuba awunayo imvume yokubhala okanye yokuguqula, cela umlawuli weqela ukuba akunike zona okanye zama ukugcina ifayile kwenye indawo onazo.

2. Gcina ifayile njengencwadi yomsebenzi entsha okanye elinye igama

Enye yezinto zokuqala ezicetyiswayo xa i-Excel ingakuvumeli ukuba ugcine kukusebenzisa ukhetho Gcina njenge kwaye utshintshe igama lefayile okanye indlela. Ngale ndlela, uyakuphepha ukubhala ngaphezulu ifayile yokuqala kwaye unqande ukungqubana okanye ukulinganiselwa kwexesha. Ukwenza oku:

1. Fikelela kwimenyu Oovimba kwaye ukhethe Gcina njenge.
2. Faka igama elahlukileyo kwaye uzame ukuligcina kwindawo eyahlukileyo.

Eli qhinga lihlala lisebenza xa ungquzulwano lungaphezu kweemvume, ezonakalisiweyo iifayile zexeshana, okanye ukungqubana okwethutyana.

3. Hambisa iispredishithi zoqobo uye kwenye incwadi yomsebenzi

Ukuba ifayile ibonakala yonakele okanye igcina isilela ukuyigcina, indlela eluncedo yi susa onke amaxwebhu (ngaphandle kwephepha elinye lokuzalisa) kwincwadi yomsebenzi entsha. A) Ewe:

1. Yongeza ishidi lokuzalisa nge Shift + F11.
2. Hlanganisa onke amaphepha oqobo ngaphandle kwephepha lokuzalisa (cofa kwelokuqala, Shift-cofa kwelokugqibela).
3. Cofa ekunene kwaye ukhethe Shenxisa okanye Khuphela... > khetha (Incwadi entsha) > Yamkela.

Ngale ndlela, unokuhlala ugcina ifayile entsha ngaphandle kweempazamo kwaye uphinde ufumane kwakhona yonke imixholo, kubandakanya i-VBA macros, ngokukopa iimodyuli ngesandla. Ukuba ufuna ukufunda ngakumbi malunga nendlela yokuphepha iimpazamo kwi-Excel, sincoma ukuphonononga inqaku lethu Iimpazamo zeBitLocker kwiWindows.

4. Gcina njengohlobo olwahlukileyo lwefayile (.xlsx, .xlsm, njl.)

Ngamanye amaxesha ifomathi yefayile yoqobo iyonakala. Ukutshintsha uhlobo lwefayile kunokusombulula umba. Ukwenza oku:

1. En Oovimba, Cinezela Gcina njenge.
2. Kukhetho Uhlobo, khetha ifomathi eyahlukileyo (umzekelo, .xlsm kwiifayile ezinemakhro okanye .xlsx ukuba eyakuqala yayiyiyo .xls).

Ngale nto unokuphelisa ukungahambelani okudala okanye iimpazamo zefomathi.

5. Zama ukugcina ifayile kwenye indawo

Ukuba uyakrokrela ukuba ingxaki ikwindawo ekuyiwa kuyo (umzekelo, idrayivu yangaphandle, idrayivu yenethiwekhi, okanye ulawulo oluthintelweyo), gcina ifayile kwidesktop okanye olunye ulawulo lobulali yeqela lakho. Oku kukhupha inethiwekhi, iimvume, okanye imiba yendawo. Kwakhona, ukuba unayo nayiphi na imibuzo malunga nokubuyisela iifayile ezingagcinwanga, ungajonga isifundo sethu apha buyisa iifayile zeLizwi ezingagcinwanga.

6. Gcina iifayile ezintsha kwindawo yokuqala

Yenza incwadi yokusebenza entsha ye-Excel kwaye ugcine ikopi kwifolda enye apho yayikhona yokuqala. Ukuba awukwazi, ingxaki mhlawumbi ziimvume, indawo engonelanga kwi-drive, okanye ingxabano yesoftware. Ukuba unokugcina ifayile entsha, ingxaki inokuba kwifomathi okanye umxholo weyokuqala.

7. Qala i-Excel kwimodi ekhuselekileyo

Maxesha amaninzi Iiplagi zomntu wesithathu zibangela iingxaki xa ugcina iifayile. Ukuvavanya ukuba lo ngunobangela:

• Inketho 1: Bamba isitshixo Ctrl kwaye uvule i-Excel, uqinisekise umyalezo wemowudi ekhuselekileyo.
• Inketho 2: Cinezela Windows + RUbhala ukugqwesa / kukhuselekile kwaye ucofe u-Enter.

Ukuba unokugcina kwimo ekhuselekileyo, vala okanye ususe izongezo nganye nganye de ufumane unobangela. Ukwenza oku:

1. Vula i-Excel ngokuqhelekileyo.
2. Imenyu Oovimba > Khetha > Izinto ezenziwayo.
3. Ezantsi, khetha Iiplagi ze-COM kwaye cinezela Ir.
4. Susa ukujonga zonke ezongezo kwaye uqalise kwakhona i-Excel.

8. Khangela indawo ekhoyo kwidisk

Esinye sezona zizathu zeklasiki akunandawo yaneleyo yasimahla. Sebenzisa iFayile Explorer ukujonga indawo ekhoyo. Ukuba igcwele, khulula indawo ngokuchitha inkunkuma, ukucima iifayile zexeshana, okanye wandise isahlulelo ngezixhobo ezifana I-EaseUS Partition Master okanye efanayo.

9. Khubaza okwethutyana isoftware ye-antivirus

Ezinye iinkqubo ze-antivirus zinokuskena iifayile okanye amaxwebhu amatsha ngexesha lokwenyani, zithintele okwethutyana ukuba zingagcinwa. Khubaza okwethutyana iantivirus yakho ngelixa ugcina, kodwa khumbula ukuyivula emva koko. Ukuba impazamo iyanyamalala, jonga useto lwakho lwe-antivirus ukuze ungabandakanyi iifolda apho ugcina khona amaxwebhu e-Excel.

10. Lungisa ufakelo lwakho lweOfisi

Ukuba akukho nto isebenzayo, ufakelo lweOfisi yakho lunokonakala. Ukuyilungisa:

1. Yiya kwiPhaneli yoLawulo> Iinkqubo kunye neempawu.
2. Khangela Microsoft Office, cofa ekunene kwaye ukhethe Ukulungiswa.
3. Khetha Ukulungisa ngokukhawuleza (ngokukhawuleza) okanye Ukulungiswa kwi-Intanethi (Nzulu kakhulu).

Emva koko, zama ukugcina iifayile zakho ze-Excel kwakhona.

Iimpazamo ezithile kunye nezisombululo zazo

"Uxwebhu lokufunda kuphela alunakufikelelwa."

Oku kungenxa yokuba ifayile iphawulwe njengefundeka kuphela okanye ngenxa yokuba itshixelwe ngomnye umzekelo. Izisombululo:

• Qinisekisa ukuba uneemvume zokuhlela.
• Gcina ifayile ngegama elahlukileyo okanye kwenye indawo.
• Vala yonke imizekelo ye-Excel kwaye uvule enye kuphela.

"Idiski igcwele"

Njengoko besesitshilo, khulula isithuba kuqhubo okanye uzame ukugcina kwenye idiski. Ukuba ugcina kwiidrive zangaphandle, qiniseka ukuba ziqhagamshelwe ngokufanelekileyo kwaye musa ukuqhawuka ngexesha logcino.

"Igama lefayile alisebenzi"

Khangela indlela epheleleyo (kuquka iincwadi ezineefayili kunye namagama eefayile) ayidluli kwiimpawu ezingama-218. Ukuba kunjalo, nciphisa umendo ngokugcina ifayile kwisiqulathi seengcambu (ezifana ne C: \) kwaye usebenzise igama elifutshane.

Iimpazamo xa ugcina kwiindawo zenethiwekhi

Ukuba usebenza kuthungelwano kwaye uphulukane noqhagamshelwano lwakho ngelixa usebenza, i-Excel inokuthintela ukugcina kunye nokubonisa imiyalezo yempazamo malunga neendlela ezingafikelelekiyo zenethiwekhi. Ukuba oku kuyenzeka:

• Gcina ifayile ekuhlaleni kwaye uyikhuphele emva kwi-network drive xa uxhulumaniso lubuyiselwe.
• Kwiinethiwekhi zeWindows, unokuguqula irejistri ukuphucula ukomelela kuqhawulo lwengozi.

Iimpazamo ezinxulumene neVisual Basic for Applications (VBA)

Ukuba ifayile ibandakanya i-macros okanye i-VBA kwaye yonakele, Ungazama ukuyilungisa ngokucima iiprojekthi zeVBA ezonakalisiweyo.. Njengesisombululo esiphezulu, Kuyacetyiswa ukuba wenze ikopi yokugcina kwaye usebenzise izixhobo zokujonga ugcino olucwangcisiweyo ukususa izinto ezonakeleyo ngaphambi kokuphinda uvule kwaye ugcine uxwebhu.

Iingxaki ngeefayile ezonakalisiweyo okanye ezonakeleyo

Ukuba ukrokrela ukuba ifayile yakho yonakele, i-Excel ibandakanya umsebenzi wokuya vula kwaye ulungise:

1. Vula i-Excel, yiya ku Oovimba > Vula.
2. Khetha ifayile eyingxaki.
3. Kwiqhosha elivulekileyo, cofa utolo olusezantsi kwaye ukhethe vula kwaye ulungise.

Kwiimeko ezinzima, ungabhenela kwizixhobo zomntu wesithathu ezifana Uhlaziyo lweWondershare o Ukulungiswa kweStellar kwi-Excel, ekuvumela ukuba ulungise iifayile ezonakalisiweyo ngokubuyisela iitafile, iifomyula kunye nezinye izinto.

Iingcebiso zokuthintela kunye nokubuyiselwa kweefayile ezingagcinwanga

Ukuthintela ukuphulukana nomsebenzi wakho kwixesha elizayo, kubalulekile ukuba:

• Yenza kwaye uqwalasele ugcino oluzenzekelayo: Ngale ndlela i-Excel izakugcina iinguqulelo ezizenzekelayo ngamaxesha athile.
• Qhagamshela iakhawunti yakho yeMicrosoft uze usebenzise iOneDrive: Oku kukuvumela ukuba ugcine ii-backups ezizenzekelayo efini.
• Lungisa i-auto-save frequency: Ungalinciphisa ithuba lokunyusa ukhuseleko lwedatha yakho.

Uzifumana njani iifayile ezingagcinwanga?

Ukuba uvale i-Excel ngaphandle kokugcina, zama ezi ndlela:

• Vula i-Excel, yiya ku Oovimba > Ulwazi > Lawula incwadi > Fumana iincwadi ezingagcinwanga. Apha ungafumana iinguqulelo zexeshana.
• Khangela iifayile zexeshana kwi C:\Abasebenzisi\Igama lakho\AppData\Local\Temp (tshintsha "Igama lakho" kwigama lakho lomsebenzisi). Khangela iifayile ezinolwandiso .tmp.

Ezi ndlela zongeza amathuba okubuyisela umsebenzi wakho emva kokusilela okungalindelekanga.

Iingcebiso kunye namaqhinga okuphepha iimpazamo ezizayo kwi-Excel

• Hlala ugcina iOfisi isexesheni ukuthatha ithuba lokhuseleko kunye nokulungiswa.
• Kuphephe ukusebenza kwiifayile ezigcinwe kuphela kwiidrive ze-USB okanye iindawo zenethiwekhi ezingazinzanga.
• Yenza iikopi rhoqo kwiindawo ezahlukeneyo (kwindawo, ilifu, ukuqhuba kwangaphandle).
• Zilumkele ezongezo zomntu wesithathu ezingaqinisekiswanga kwaye uzicime ukuba awuzifuni.
• Jonga indawo yakho yokugcina phambi kokuba usebenze ngeefayile ezinkulu.

Le seti yeengcebiso inceda ukunciphisa amathuba eempazamo xa ugcina kwi-Excel kwaye ugcine ingqibelelo yedatha yakho ngamaxesha onke.