Momwe mungabwezeretsere fayilo ya Excel yosasungidwa. Zoyenera kuchita ngati simunasunge fayilo ya Excel

Mukamagwira ntchito ndi Excel, zinthu zosiyanasiyana zimatha kuchitika, monga kuzimitsa kwamagetsi, zolakwika zamakina. Zonsezi zingapangitse kuti deta yosasungidwa ikhale yotsalira. Komanso, wogwiritsa ntchitoyo, yemwe mwangozi adadina batani la "Musasunge" potseka chikalatacho, angakhalenso chifukwa cha vutoli.

Mwina kompyuta amaundana. Pankhaniyi, palibe njira ina yomwe yatsala koma kuyambitsanso kuyambiranso mwadzidzidzi. Mwachibadwa, tebulo silidzapulumutsidwa mu nkhaniyi ngati munthuyo sakhala ndi chizolowezi chosunga chikalatacho nthawi zonse. Chosangalatsa apa ndikuti nthawi zambiri, kubwezeretsanso chikalata cha Excel chomwe sichinasungidwe ndikotheka chifukwa pulogalamuyo imapanga malo obwezeretsa ngati malo oyenera athandizidwa.

Njira za 3 Zobwezeretsanso Spreadsheet Yosasungidwa ya Excel

Ubwino waukulu wa Excel ndikuti pali njira zitatu zopezera deta yotayika. Chinthu chokhacho chomwe izi zingatheke, monga tafotokozera pamwambapa, ndi ntchito yokhazikitsidwa ndi autosave. Apo ayi, simungathe kuchira deta, ziribe kanthu momwe mukufuna. Kungoti zidziwitso zonse zidzasungidwa mu RAM, ndipo sizingasungidwe pa hard disk.

Choncho, tikulimbikitsidwa kuti tisalowe muzochitika zoterezi. Ngati mukugwira ntchito ndi Microsoft Excel osati Google Spreadsheets, komwe kupulumutsa kumangochitika zokha, muyenera kusunga nthawi zonse.

Zimatengera kuyeserera pang'ono, ndiyeno zikhala chizolowezi. Njira yobwezeretsa deta yonse ndi motere:

1. Tsegulani gawo la "Zosankha", lomwe lili mu "Fayilo" menyu. Batani lokha loti mupite ku menyuyi lili pafupi ndi tabu ya "Home".
2. Kenako, m'bokosi la zokambirana lomwe likuwonekera, timapeza gawo la "Sungani" ndikutsegula zokonda za gululi. Pafupifupi kumayambiriro kwenikweni kwa mndandanda kumanja pali zoikamo autosave. Apa mutha kukhazikitsa ma frequency omwe Excel idzasungire chikalatacho. Mtengo wokhazikika ndi mphindi 10, koma ngati mukufuna kupanga izi pafupipafupi (mwachitsanzo, ngati mukugwira ntchito pachikalata chimodzi ndikukhala ndi nthawi yomaliza ntchito yayikulu mumphindi 10), ndiye kuti mutha kusankha chaching'ono. nthawi. Komanso, muyenera kumvetsetsa kuti autosave pafupipafupi imafuna, ngakhale yaying'ono, koma zida zamakompyuta. Chifukwa chake, ngati mukugwira ntchito pa laputopu yofooka, kusungirako nthawi zambiri kumatha kusokoneza magwiridwe antchito.
3. Muyeneranso kuwonetsetsa kuti njira "Sungani mtundu waposachedwa wobwezeretsedwanso mukatseka osasunga" watsegulidwa. Izi ndiye njira zomwe zimatithandizira kutseka kwadzidzidzi kwa kompyuta, kulephera kwa pulogalamu kapena kusasamala kwathu.

Mukamaliza masitepe onse pamwambapa, dinani OK batani. Ndipo tsopano tiyeni tipite mwachindunji njira zitatu mmene mukhoza achire deta kuti watayika.

Bwezeretsani Zosasungidwa mu Excel Pamanja

Zimachitika kuti wogwiritsa ntchito akufuna kubwezeretsa deta, koma mufoda yomwe akuyenera kukhala, sali. Izi ndizokhudza chikwatu cha "UnsavedFiles". N’chifukwa chiyani zimenezi zikuchitika? Monga mukumvetsetsa kuchokera ku dzina la bukhuli, mafayilo okhawo omwe wosuta sanawasunge ndi omwe amaponyedwa pano. Koma pali mikhalidwe yosiyana. Mwachitsanzo, wogwiritsa ntchito adasunga chikalatacho, koma pazifukwa zina, akutseka zenera la Excel, adakanikiza batani la "Osasunga".

Kodi tichite zotani?

1. Pitani ku gawo la zosankha, lomwe lili mu "Fayilo" menyu. Momwe mungatsegule zafotokozedwa kale pamwambapa.
2. Kenako, tsegulani gawo la "Sungani" ndikupeza zoikamo, zomwe ndizotsika pang'ono poyerekeza ndi autosave. Imatchedwa Autosave Data Directory. Apa titha kukonza chikwatu chomwe zolemba zosunga zobwezeretsera zidzasungidwa, ndikuwona fodayi. Tiyenera kutengera njira yomwe yasonyezedwa pamzerewu ndikukanikiza kuphatikiza kiyi Ctrl + C.
3. Kenako, tsegulani File Explorer. Iyi ndi pulogalamu yomwe mumapeza mafoda onse. Pamenepo timadina pa adilesi ndikumata njira yomwe tidakopera pagawo lapitalo. Dinani Enter. Pambuyo pake, chikwatu chomwe mukufuna chidzatsegulidwa.
4. Apa mutha kuwona mndandanda wa zikalata zomwe zitha kubwezeretsedwanso. Ingotsala kuti mutsegule, ndipo ndi momwemo.

Zofunika! Fayiloyo idzatchulidwa mosiyana ndi yoyamba. Kuti mudziwe yolondola, muyenera kuyang'ana pa tsiku lopulumutsa.

Pulogalamuyi idzapereka chenjezo kuti iyi ndi fayilo yosasungidwa. Kuti mubwezeretse, muyenera dinani batani loyenera ndikutsimikizira zomwe zikuchitika.

Momwe mungabwezeretsere chikalata cha Excel chosasungidwa

Monga tamvetsetsa kale, kuti mubwezeretse chikalata chosasungidwa, muyenera kutsegula chikwatu chapadera. Mukhozanso kugwiritsa ntchito njira iyi:

1. Tsegulani "Fayilo" menyu.
2. Dinani pa "Open" batani. Pambuyo kukanikiza batani ili, batani laposachedwa likhala kumanja kwa chinsalu. Ulalo wopita kufoda yomwe ili ndi mabuku osasungidwa uli pansi, pansi pa chikalata chosungidwa chomaliza. Muyenera alemba pa izo.
3. Pali njira inanso. Mutha kudina chinthu cha "Zambiri" mumenyu ya "Fayilo". Imapezeka podina kokha ngati fayilo ina yatsegulidwa kale pakadali pano. Kumeneko timadina "Kasamalidwe ka Mabuku" ndipo kumeneko mungapeze chinthucho "Bwezeretsani Mabuku Osapulumutsidwa". Ikutsalira kuti dinani ndikutsegula fayilo yomwe mukufuna.

Momwe mungabwezeretsere deta ya Excel pambuyo pa ngozi

Excel imazindikira zokha kuti pulogalamu yawonongeka. Mukangotsegula pulogalamu yomwe yawonongeka, mndandanda wa zolemba zomwe zingathe kubwezeretsedwa zidzawonekera zokha.

Mutha kusunga fayiloyi. Komanso, ndi bwino kutero. Tikuwona kuti Excel mwiniyo ndi wokonzeka kutipulumutsa, ngati apatsidwa mwayi wotero. Ngati pali zovuta, chikalatacho chidzabwezeretsedwanso.