Excel yokhazikika - momwe mungasungire deta

Nthawi zina mukamagwira ntchito ndi chikalata cha spreadsheet, zimachitika kuti pulogalamuyo imaundana. Pazifukwa izi, funso limadza nthawi yomweyo: "Momwe mungasungire deta?". Pali njira zingapo zothetsera vutoli. M'nkhaniyi, tisanthula mwatsatanetsatane zosankha zonse zomwe zimasunga deta mu chikalata chopachikidwa kapena chotsekedwa mwangozi.

Kubwezeretsanso zidziwitso zotayika mu mkonzi wa spreadsheet

Tikuwona nthawi yomweyo kuti mutha kubwezeretsanso zomwe sizinasungidwe pokhapokha ngati kusungirako kutsegulidwa mumkonzi wa spreadsheet. Ngati ntchitoyi siyikuthandizidwa, ndiye kuti zosintha zonse zimakonzedwa mu RAM, kotero sizingatheke kubwezeretsa zidziwitso zosasungidwa. Mwachisawawa, kusunga basi kumayatsidwa. Pazikhazikiko, mutha kuwona momwe ntchitoyi ikuyendera, komanso kukhazikitsa nthawi yosungira fayilo ya spreadsheet.

Zofunika! Mwachikhazikitso, kusunga kokha kumachitika kamodzi mphindi khumi zilizonse.

Njira Yoyamba: Kubwezeretsa Fayilo Yosasungidwa Pamene Pulogalamu Imalendewera

Tiyeni tiwone momwe tingabwezeretsere deta ngati mkonzi wa spreadsheet wazizira. Malangizo atsatanetsatane amawoneka motere:

1. Tsegulanso mkonzi wa spreadsheet. A kachigawo adzakhala basi kuonekera kumanzere kwa zenera, kukulolani kubwezeretsa wapamwamba. Tiyenera kudina ndi batani lakumanzere la mbewa pamtundu wa fayilo yosungidwa yokha yomwe tikufuna kubwezeretsa.

2. Mukapanga kusintha kosavuta uku, zikhalidwe zochokera pachikalata chosasungidwa zidzawonekera patsamba lantchito. Tsopano tiyenera kukhazikitsa kupulumutsa. Kuti muchite izi, dinani kumanzere pa chithunzi chooneka ngati floppy, chomwe chili kumtunda kumanzere kwa mawonekedwe a chikalata cha spreadsheet.

3. Iwindo linawonekera pachiwonetsero ndi dzina "Saving Document". Tiyenera kusankha malo omwe chikalata cha spreadsheet chidzasungidwa. Apa, ngati mukufuna, mutha kusintha dzina la chikalata cha spreadsheet, komanso kukulitsa kwake. Mukamaliza kuchita zonse, dinani kumanzere "Save".

4. Okonzeka! Tapeza zomwe zidatayika.

Njira yachiwiri: kubwezeretsanso chikalata chosasungidwa pamene chikalata cha spreadsheet chatsekedwa mwangozi

Zimachitika kuti wogwiritsa ntchito sanasunge chikalatacho, kutseka mwangozi. Pankhaniyi, njira yomwe ili pamwambayi sichitha kubwezera zomwe zatayika. Kuti mubwezeretse, muyenera kugwiritsa ntchito chida chapadera. Malangizo atsatanetsatane amawoneka motere:

1. Timayamba mkonzi wa spreadsheet. Pitani ku "Fayilo" submenu. Dinani LMB pa "Posachedwapa", ndiyeno pa "Bweretsani Zosasungidwa". Izo ili pansi pa anasonyeza zenera mawonekedwe.

2. Palinso njira ina. Pitani ku "Fayilo" submenu, kenako dinani "Zambiri" chinthu. Pa "Versions" block block, dinani "Version Management". Pamndandanda womwe ukuwonekera, dinani chinthu chomwe chili ndi dzina lakuti "Bweretsani Mabuku Osapulumutsidwa".

3. Mndandanda wa zolemba za spreadsheet zomwe sizinasungidwe zidawonekera pachiwonetsero. Mayina onse a mapepala a spreadsheet adalandiridwa okha. Fayilo yofunikira iyenera kupezeka pogwiritsa ntchito gawo la "Date modified". Sankhani chikalata chomwe mukufuna ndi batani lakumanzere, kenako dinani "Open".

4. Fayilo yofunikira imatsegulidwa mumkonzi wa spreadsheet. Tsopano tiyenera kuchisunga. Dinani batani la "Save As" lomwe lili pa riboni yachikasu.

5. Iwindo linawonekera pachiwonetsero ndi dzina "Saving Document". Tiyenera kusankha malo omwe chikalata cha spreadsheet chidzasungidwa. Apa, ngati mukufuna, mutha kusintha dzina la chikalata cha spreadsheet, komanso kukulitsa kwake. Mukamaliza kuchita zonse, dinani batani lakumanzere "Sungani".

6. Okonzeka! Tapeza zomwe zidatayika.

Njira Yachitatu: Kutsegula Pamanja Zolemba Zosasungidwa Zamasamba

Mumkonzi wa spreadsheet, mutha kutsegula pamanja zolembedwa zamasamba osasungidwa. Njirayi siyothandiza ngati yomwe ili pamwambapa, koma itha kugwiritsidwanso ntchito ngati mkonzi wa spreadsheet sakugwira ntchito bwino. Malangizo atsatanetsatane amawoneka motere:

1. Tsegulani mkonzi wa spreadsheet. Timasunthira ku "Fayilo" submenu, ndikudina batani lakumanzere pagawo la "Open".

2. Iwindo lotsegulira chikalata likuwonetsedwa. Timasunthira ku chikwatu chofunikira m'njira zotsatirazi: C:Usersимя_пользователяAppDataLocalMicrosoftOfficeUnsavedFiles. "Username" ndi dzina la akaunti yanu yogwiritsira ntchito. Mwa kuyankhula kwina, iyi ndi chikwatu pa kompyuta yanu yomwe ili ndi zofunikira zonse. Kamodzi mufoda yofunikira, timasankha chikalata chomwe tikufuna kubwezeretsa. Mukamaliza masitepe onse, dinani "Open".

3. Fayilo yomwe tikufuna yatsegulidwa, yomwe ikufunika kusungidwa. Timadina ndi batani lakumanzere la mbewa pa chithunzi chooneka ngati floppy, chomwe chili kumtunda kumanzere kwa mawonekedwe a chikalata cha spreadsheet.
4. Iwindo linawonekera pachiwonetsero ndi dzina "Saving Document". Tiyenera kusankha malo omwe chikalata cha spreadsheet chidzasungidwa. Apa, ngati mukufuna, mutha kusintha dzina la chikalata cha spreadsheet, komanso kukulitsa kwake. Mukamaliza kuchita zonse, dinani kumanzere pa batani "Save".
5. Okonzeka! Tapeza zomwe zidatayika.

Mapeto ndi ziganizo za kuchira deta

Tidapeza kuti pali njira zambiri zobwezeretsera zidziwitso kuchokera ku chikalata cha spreadsheet ngati pulogalamuyo imaundana kapena wogwiritsa ntchitoyo atseka fayiloyo mwangozi. Aliyense wosuta akhoza paokha kusankha njira yabwino kwambiri achire otayika zambiri.