Excel: izindlela yokutakula ifayela jikelele

Kaningi, abasebenzisi eziningi isihleli se-spreadsheet Excel bebhekene nenkinga nini ngenxa yokwehluleka uhlelo noma isicelo ngokwalo wadala amafayela yayo ingangeni egcinwe noma zilimele ukuze ke alikwazi ukuvulwa. Ngomqondo onabile, i-Excel yokutakula ifayela kungenziwa ngezindlela eziningana. Ake sicabangele ngayinye yalezi zinkulumo. Vele uqaphele ukuthi akukho nzima ikakhulukazi lezo zinqubo lapho, futhi ngamunye yezindlela ezibalwe ngezansi ku akhe khe sizakala!. Nokho, izinto zokuqala kuqala.

Phinda Excel ifayela ezingalondoloziwe

Asiqale nezimo banal kakhulu, uma umsebenzisi umane akazishiyanga kwedatha yokufaka isikhathi umhleli, futhi uhlelo izingozi. Kuthiwani uma kwakukhona ngolwazi oluningi kakhulu, bese uyifaka futhi umane nje awunaso isikhathi noma ithuba?

Ukuze Esimweni esinjalo akazange kuphakama, kubalulekile ukunikeza iseluleko kancane: zangaphambi kusebenze umsebenzi Ukulondoloza. Kamuva (lapho kabusha uqale uhlelo emva ukwehluleka ezibucayi), isicelo ngeke anikele ngokwayo ukubuyisela ifayela weyesi othize ngesikhathi. Ngitjho nanyana angakhuthaza bona ayikazeki igama kwenzekani okwamanje ekonga.

Ukuze uthole olunye ukuxazulula kanjani ukubuyisela ezingalondoloziwe ifayela le-Excel 2016 ukuthi udinga ukuya izilungiselelo kwesigaba kwimenyu ifayela, vula uhlelo, futhi ewindini elisha ukuya umugqa ukulondolozwa ngakwesokunxele. Ohlangothini lwesokunene kukhona iphuzu ukonga ngokuzenzekelayo. Ngokuzenzakalelayo, ngilithole emizuzwini eyishumi edalulwa. Cacisa ukubaluleka siqu (isib 1 iminithi) bese ukusebenzisa izinguquko. Nokho, kwezinye izimo, kungase kancane Ukulondoloza umhleli umsebenzi, kodwa ngenxa yokuthi uma kwenzeka ukwehluleka alulame kungaba ingxenye enkulu idatha. Ngokuvamile, umuntu Akufanele siwuthathe kalula kungenzeka Imodi okuzenzakalelayo londoloza.

Phinda ezilimele amafayela e-Excel ngamathuluzi-spreadsheet ejwayelekile

Manje cabanga amafayela onakele ukuthi, ngoba noma ngabe yisiphi isizathu, indlela ejwayelekile alikwazi ukuvulwa. Ku-Excel yokutakula ifayela engenziwa usebenzisa iqhinga elilodwa, okuyinto ambalwa abantu bazi.

Ngakho, qala umhleli kanye kwimenyu enkulu ivuleka umyalo ifayela ejwayelekile evulekile (kulula ukwenza lokhu inhlanganisela Ctrl O). Into Ukukhetha iwindi lizovela. Sithola ukuthi udinga ini, futhi waba ikumodi iwindi kuyakhethwa ukutholakala nokulungiswa kwesimo esidalekile. Uhlelo lokusebenza luzozama ukuvula ifayela lonakele edingekayo, ngaleyo ndlela kokulungisa ngokuzenzakalelayo amaphutha.

Ukusebenzisa ehhovisi analog OpenOffice Calc

Ngezinye izikhathi kuyenzeka ukuthi Excel yokutakula ifayela akusebenzi. Okufanele ukwenze kuleli cala? Ungasebenzisa uhlelo okunye OpenOffice Calc, okuyinto analog ephelele Excel, nakuba esincintisana yayo eqondile.

Ngomqondo onabile, inkulumo isinyathelo kuvulwa ifayela ifake isandla ekubuyiselweni kwalo othomathikhi ayafana, kuphela uhlobo lwefayela udinga ukukhetha .xls isandiso. Futhi lokhu yokutakula kusukela akhawunti ayikwazi ehlisiwe.

amathuluzi Special

Manje amagama ambalwa mayelana izicelo ezikhethekile ukuthi babedalelwe kumadokhumenti ehhovisi yokutakula, lapho unezinkinga. Omunye amathuluzi anamandla kakhulu uhlelo ukuze alulame amafayela e-Excel, ngokuthi yokutakula i-Excel (ke likhona eziyisisekelo iphakethe OfficeRecovery).

Nalapha futhi, yonke into ilula. Qalisa Umbuso indawo bese uchofoza yokutakula Phinda ukumba, bese ukhetha ohlwini ifayela oyifunayo, bese inkinobho efanayo iphaneli engenhla ngeke kusebenze inqubo yokutakula. Ekuqedeni wefayela angavulwa e umhleli spreadsheet.

Elinye ithuluzi omkhulu - Cimaware OfficeFIX. Isebenza azizimbi kwalowo odlule, futhi isebenzisa algorithm efanayo. Ngemuva kokuqala isicelo, kumelwe ukhethe ExcelFIX ithuluzi, cindezela inkinobho isiqalo bese uya yokutakula sigaba. Kusalokhu, njengoba kwaba njalo endabeni langaphambilini, ukhethe ifayela futhi ugijime etafuleni futhi silungise inqubo iphutha yokutakula. Ngemva kwalokho, into abuyiselwe, ungakwazi ukubuka (Buka inkinobho), bese, ngakho ukukhuluma, "resave" (inkinobho Go To Save).

Online yokutakula

Kodwa akugcini lapho. Ukuze Excel yokutakula ifayela engenziwa ngokusebenzisa imithombo ekhethekile online, okuyinto manje kwi-inthanethi ungathola amaningi. Njengenjwayelo, konke zehla yokuthi umsebenzisi emva login kusayithi usebenzisa ukwahlukanisa yokutakula futhi ukulayisha ifayela lakho. Inkinga nje wukuthi ungase uthola ilinki ukuze ulande inguqulo demo into kabusha kumodi khulula ekupheleni inqubo. Ukulanda ifayela ephelele, kuyodingeka bakhokhe. Ngakho, ngokusebenzisa le ndlela kubasebenzisi abaningi akwamukeleki.

esikhundleni isiphetho

Sibukeze izindlela eziyinhloko zokuvuselela imibhalo etafuleni ehhovisi. Kusukela ngomhla ka-yalokho, singaba uqaphele ukuthi kungcono kuqala uzame izimali yomhleli siqu noma esikhundleni, futhi kuphela ngaleso sikhathi, uma kungaphumeleli, sifune usizo inhlangano ekhethekile. Futhi, ungakhohlwa ukusetha Ukulondoloza. Ngempela, kulesi simo, ukuze alulame amafayela e imodi ibhukwana ngeke kudingeke nhlobo. Oh, futhi njengoba i-intanethi, ngicabanga bambalwa kakhulu abantu uzowasebenzisela kuphela ngenxa inqubo yokukhokha. Nokho, njengenhlangano eyokugcina, lapho ifayela umthombo ngeke ibuyiselwe ngokuphelele noma yiziphi izindlela ngenhla, kanye nolwazi kubaluleke kakhulu, kusetshenziswa le ndlela sisengakwazi. Yini ongakhetha kuzo zonke kuchaziwe, kukuwe.