Kuchotsa chitetezo ku Excel worksheet ndi workbook

Pofuna kuteteza deta kuchokera kwa anthu osaloleka komanso ku zochita zawo mwangozi, ogwiritsa ntchito amatha kukhazikitsa chitetezo pamakalata a Excel. Tsoka ilo, si aliyense amene akudziwa momwe angachotsere chitetezo choterocho kuti apeze chidziwitso, kuphatikizapo kutha kusintha. Ndipo bwanji ngati fayiloyo idalandiridwa kuchokera kwa wogwiritsa ntchito wina yemwe wayiwala kutipatsa mawu achinsinsi, kapena mwangozi tidayiwala (kutayika)? Tiyeni tione bwinobwino.

Dziwani kuti pali njira ziwiri zotsekera chikalata cha Excel: tetezani tsamba kapena buku lantchito. Chifukwa chake, zomwe muyenera kuchita kuti mutsegule zimadalira izi.

Kuchotsa chitetezo m'buku

1. Ngati tiyesa kutsegula chikalata chotetezedwa, m'malo mwa zomwe zili mkati mwake, zenera lachidziwitso lidzawonetsedwa momwe tiyenera kuyika mawu achinsinsi kuti tichotse chitetezo.
2. Pambuyo kulowa achinsinsi olondola ndi kukanikiza batani OK, zomwe zili mufayilo zidzawonetsedwa.
3. Ngati mukufuna kuchotsa chitetezo cha zikalata kwamuyaya, tsegulani menyu "Fayilo".
4. Dinani pa gawo "Intelligence". Kumanja kwa zenera, dinani batani “Tetezani Buku”, pamndandanda womwe umatsegulidwa, tikufuna lamulo - "Encrypt ndi password".
5. Zenera lolembera chikalata chokhala ndi mawu achinsinsi lidzawonekera pazenera. Fufutani, kenako dinani OK.
6. Dinani pa chithunzi cha floppy disk kuti musunge chikalatacho. Kapena mungagwiritse ntchito lamulo “Sungani” menyu "Fayilo".
7. Mawu achinsinsi achotsedwa ndipo fayilo ikadzatsegulidwanso, sidzafunsidwa.

Kuchotsa chitetezo pa pepala

Mawu achinsinsi oteteza akhoza kukhazikitsidwa osati pa chikalata chonse, komanso pa pepala linalake. Pankhaniyi, wogwiritsa ntchito azitha kuwona zomwe zili patsambalo, koma sangathe kusintha zomwe zalembedwazo.

Kuti musateteze pepala, tsatirani izi:

1. Sinthani ku tabu Ndemanga… Dinani batani "Chotsani chitetezo cha pepala", yomwe ili mu gulu la zida "Chitetezo".
2. Iwindo laling'ono lidzawonekera, pomwe timalowetsa mawu achinsinsi omwe adayikidwa kale ndikudina OK.
3. Zotsatira zake, loko yamasamba idzayimitsidwa, ndipo tsopano titha kukonza bwino chidziwitsocho.

Sinthani nambala ya fayilo kuti muchotse chitetezo cha pepala

Njirayi ndiyofunika pazochitika zomwe mawu achinsinsi adatayika kapena osasamutsidwa pamodzi ndi fayilo kuchokera kwa wosuta wina. Zimagwira ntchito pokhapokha pokhudzana ndi zolemba zomwe zimatetezedwa pamlingo wa mapepala aumwini, osati buku lonse, chifukwa. tiyenera kulowa menyu "Fayilo", zomwe sizingatheke pamene mawu achinsinsi akuteteza chikalata chonse.

Kuti muchotse chitetezo, muyenera kuchita zotsatirazi:

1. Pitani molunjika ku sitepe 4 ngati fayilo yowonjezera ili XLSX (Kulemba Excel). Ngati mtundu wa chikalata ndi XLS (Excel Workbook 97-2003), choyamba muyenera kuchisunganso ndi chowonjezera chomwe mukufuna. Kuti muchite izi, pitani ku menyu "Fayilo".
2. Sankhani kuchokera pamndandanda womwe uli kumanzere “Sungani ngati”, ndiye kumanja kwa zenera, dinani batani "Review".
3. Pazenera lomwe likuwoneka, sankhani malo aliwonse abwino kuti musunge fayilo, ikani mtunduwo "Excel Book" ndipo dinani OK.
4. Tsegulani Explorer Foda ya zikalata za XLSX (zosungidwa kumene kapena zomwe zidalipo kale). Kuti mutsegule mafayilo owonjezera, pitani ku tabu "Onani", komwe timathandizira njira yomwe tikufuna mu gulu la zida "Kuwonetsa kapena kubisa".Zindikirani: machitidwe opangira masitepe mu sitepe iyi ndi pansipa akufotokozedwa pogwiritsa ntchito Windows 10 monga chitsanzo.
5. Dinani kumanja pa chikalatacho ndipo pamndandanda womwe ukutsegulidwa, dinani lamulo "Rename" (kapena mutha kungodina batani F2, mutasankha fayilo).
6. M'malo kuwonjezera "xlsx" kulemba "zipi" ndi kutsimikizira kusintha.
7. Tsopano kachitidwe kadzazindikiritsa fayilo ngati malo osungira, zomwe zili mkati mwake zimatha kutsegulidwa ndikudina kawiri batani lakumanzere.
8. Mu foda yotsegulidwa, pitani ku chikwatu "xl", ndiye - "ntchito". Apa tikuwona mafayilo mumtundu XML, yomwe ili ndi chidziwitso cha mapepala. Mukhoza kuwatsegula ndi mwachizolowezi polembapo.Zindikirani: mkati Windows 10, mutha kugawa pulogalamu yokhazikika ndi mtundu wa fayilo muzokonda zamakina (yoyambitsidwa ndi kukanikiza makiyi. Pambana + Ine), Mu mutu "Mapulogalamu", ndiye - "Mapulogalamu Ofikira" - "Kusankhidwa kwa mapulogalamu okhazikika amitundu yamafayilo".
9. Pambuyo potsegula bwino fayilo, tiyenera kupeza mawuwo m'kati mwake "SheetProtection". Kuti tichite izi, tidzagwiritsa ntchito kusaka, komwe kutha kuyambitsidwa kudzera mu menyu "Sinthani" (chinthu "Pezani"), kapena mwa kukanikiza kuphatikiza makiyi Ctrl + F.
10. Lowetsani mawu omwe mukufuna ndikudina batani “Pezani chotsatira”.
11. Pambuyo kupeza machesi ankafuna, kufufuza zenera akhoza kutsekedwa.
12. Timachotsa mawuwo ndi chilichonse chokhudzana nawo (pakati pa ma tag otsegulira ndi otseka).
13. Pa menyu "Fayilo" sankhani gulu “Sungani ngati” (kapena dinani njira yachidule ya kiyibodi Ctrl + Shift + S).
14. Kusunga chikalatacho nthawi yomweyo muzosunga sikungagwire ntchito. Chifukwa chake, timachita m'malo ena aliwonse abwino kwa ife pakompyuta, osasintha dzina ndikuwonjezeranso "xml" (mtundu wa fayilo uyenera kusankhidwa - "Mafayilo onse").
15. Koperani fayilo yomwe yangopangidwa kumene kufoda "ntchito" athu archive (ndi m'malo mwa choyambirira).Zindikirani: mbiri "SheetProtection" kupezeka m'mafayilo onse otetezedwa achinsinsi. Chifukwa chake, zomwe tafotokozazi pozipeza ndikuzichotsa zimachitidwa ndi mafayilo ena onse. XML mu chikwatu "ntchito".
16. Apanso timapita ku chikwatu chomwe chili ndi zosungira zathu ndikusinthanso zowonjezera kuchokera "zipi" on "xlsx" posintha dzina.
17. Tsopano inu mukhoza kutsegula wapamwamba ndi bwinobwino kusintha izo. Simufunikanso kuyika mawu achinsinsi kuti musateteze.

Ochotsa achinsinsi chachitatu

Mutha kugwiritsa ntchito mapulogalamu a chipani chachitatu kuchotsa mawu anu achinsinsi. Panthawi imodzimodziyo, ndi bwino kukumbukira chiwopsezo chomwe chingakhale chokhudzana ndi kutsitsa, kukhazikitsa ndi kugwiritsa ntchito zida zosagwirizana ndi makina opangira opaleshoni ndi Excel.

Ngati, komabe, mwasankha kugwiritsa ntchito mwayiwu, mutha kulabadira pulogalamu yotchuka kwambiri. Accent OFFICE Kubwezeretsa Achinsinsi.

Lumikizani patsamba lovomerezeka ndi pulogalamuyi:.

Chonde dziwani kuti kuti mupeze ntchito zonse za pulogalamuyi, muyenera kugula laisensi. Mtundu wa demo ulipo kuti udziwe bwino za pulogalamuyi, komabe, sikukulolani kuti muchotse mawu achinsinsi.

Kutsiliza

Kuteteza bukhu lantchito kapena pepala limodzi ndi gawo lothandiza kwambiri la pulogalamu ya Excel mukafunika kuteteza zidziwitso kwa anthu osaloledwa kapena, mwachitsanzo, dzitetezeni kuti musasinthe mwangozi pazofunikira zowerengera zokha. Koma nthawi zina kufunikira kosiyana kumabuka - kuchotsa chitetezo chomwe chidayikidwa kale. Izi zitha kuchitika m'njira zosiyanasiyana, kutengera momwe zidayikidwira. Ndipo ngakhale mutayiwala mawu achinsinsi, loko ikhoza kuchotsedwa, komabe, pokhapokha ngati codeyo yakhazikitsidwa pamapepala amodzi, osati buku lonse.