Kubvisa dziviriro kubva kune Excel worksheet uye bhuku rebasa

Kuti uchengetedze data kubva kune vasina kubvumidzwa uye kubva kune yavo netsaona zviito, vashandisi vanogona kuseta dziviriro paExcel zvinyorwa. Maiwe, haasi munhu wose anoziva kubvisa kudzivirira kwakadaro kuitira kuti awane ruzivo, kusanganisira kukwanisa kuigadzirisa. Uye ko kana iyo faira yakagamuchirwa kubva kune mumwe mushandisi akanganwa kutipa password, kana isu takakanganwa netsaona (kurasika)? Ngatinyatsoongororai.

Ziva kuti pane nzira mbiri dzekukiya gwaro reExcel: chengetedza pepa rebasa kana bhuku rebasa. Saizvozvowo, zviito zvipi zvinoda kutorwa kuti zvizarure zvinoenderana neizvi.

Kubvisa dziviriro kubva mubhuku

1. Kana tikaedza kuvhura gwaro rakachengetedzwa, panzvimbo yezviri mukati maro, hwindo reruzivo richaratidzwa umo tinoda kuisa password kuti tibvise kudzivirira.
2. Mushure mekuisa iyo password password uye nekudzvanya bhatani OK, zviri mukati mefaira zvicharatidzwa.
3. Kana iwe uchida kubvisa kuchengetedza gwaro zvachose, vhura menyu "Faira".
4. Dzvanya pane chikamu "Intelligence". Muchikamu chekurudyi chehwindo, tinya bhatani “Chengetedza Bhuku racho”, mune rondedzero inovhura, tinoda murairo - "Encrypt nepassword".
5. Iwindo rekuvhara gwaro rine password richaonekwa pachiratidziri. Dzima, wobva wadzvanya OK.
6. Dzvanya pane floppy disk icon kuti uchengetedze gwaro. Kana kuti unogona kushandisa murairo “Ponesa” menyu "Faira".
7. Iyo password yakabviswa uye nguva inotevera iyo faira inovhurwa, haizokumbirwe.

Kubvisa kudzivirira kubva papepa

Password yekudzivirira inogona kusetwa kwete yegwaro rese chete, asiwo kune rakananga pepa. Muchiitiko ichi, mushandisi achakwanisa kuona zviri mukati mepepa, asi haazokwanisi kugadzirisa ruzivo.

Kuti usadzivirire pepa, tevera matanho aya:

1. Chinja kune tab "Ongorora"… Batanidza bhatani "Bvisa sheet protection", iyo iri muboka rematurusi “Chengetedzo”.
2. Iwindo diki richaonekwa, kwatinoisa iyo yakambosetwa password uye tinya OK.
3. Nekuda kweizvozvo, shizha rekuvhara richavharwa, uye ikozvino tinogona kururamisa ruzivo zvakachengeteka.

Shandura kodhi yefaira kuti ubvise kudzivirira pepa

Iyi nzira inodiwa mumamiriro ezvinhu apo password yakarasika kana kuti isina kutamiswa pamwe chete nefaira kubva kune mumwe mushandisi. Inoshanda chete maererano nemagwaro iwayo akadzivirirwa pamwero wemashizha ega, uye kwete bhuku rose, nokuti. isu tinofanirwa kupinda mumenyu "Faira", izvo zvisingagoneke kana password-inodzivirira gwaro rose.

Kuti ubvise dziviriro, unofanirwa kuita zvinotevera kutevedzana kwezviito:

1. Enda zvakananga kunhanho 4 kana iyo faira yekuwedzera iri XLSX (Книга Excel). Kana iyo fomu yegwaro iri XLS (Excel Workbook 97-2003), unofanira kutanga waichengeta zvakare nekuwedzera kwaunoda. Kuti uite izvi, enda kumenyu "Faira".
2. Sarudza kubva pane zvakarongwa kuruboshwe “Sevha se”, ipapo muchikamu chekurudyi chehwindo, tinya bhatani "Ongorora".
3. Muhwindo rinoonekwa, sarudza chero nzvimbo yakanakira kuchengetedza faira, isa fomati "Excel Book" uye baya OK.
4. Vhura mukati mupanguri XLSX gwaro folda (ichangobva kuchengetwa kana isati yavapo). Kugonesa mafaera ekuwedzera, enda kune tab "Ona", kwatinogonesa sarudzo yaunoda muboka rekushandisa “Ratidza kana kuvanza”.Cherechedza: iyo inoshanda sisitimu nhanho mune ino nhanho uye pazasi inotsanangurwa uchishandisa Windows 10 semuenzaniso.
5. Tinya-kurudyi pagwaro uye mune rondedzero inovhura, tinya pane kuraira "Rename" (kana kuti unogona kungodzvanya kiyi F2, mushure mekusarudza faira).
6. Panzvimbo pekuwedzera "xlsx" nyora "zip" uye simbisa shanduko.
7. Ikozvino sisitimu icharatidza iyo faira seyakachengetwa, zviri mukati maro zvinogona kuvhurwa nekudzvanya kaviri bhatani rekuruboshwe.
8. Mune folda yakavhurwa, enda kune dhairekitori “xl”, zvino - "worksheets". Pano tinoona mafaira mufomati XML, iyo ine ruzivo pamusoro pemashizha. Unogona kuzvivhura nemazuva ese Notepad.Cherechedza: in Windows 10, unogona kugovera chirongwa chekusarudzika nemhando yefaira mumasetimu ehurongwa (yakatangwa nekudzvanya makiyi. Win + ini), Muchitsauko "Applications", zvino - "Default Apps" - "Sarudzo yeakajairwa mafomu emhando dzefaira".
9. Mushure mekubudirira kuvhura faira, tinoda kuwana mutsara mune zviri mukati maro "SheetProtection". Kuti tiite izvi, tichashandisa kutsvaga, iyo inogona kutangwa zvose kuburikidza nemenyu "Gadzirisa" (chinhu “Wana”), kana nekudzvanya kiyi musanganiswa Ctrl + F.
10. Pinda chirevo chaunoda wodzvanya bhatani “Tsvaga zvinotevera”.
11. Mushure mekuwana mutambo waunoda, hwindo rekutsvaga rinogona kuvharwa.
12. Isu tinodzima mutsara uye zvese zvine chekuita nazvo (pakati pekuvhura nekuvhara tags).
13. Pamenu "Faira" sarudza timu “Sevha se” (kana kuti tinya nzira yekudimbudzira keyboard Ctrl + Shift + S).
14. Kuchengetedza gwaro nekukurumidza mudura hazvishande. Naizvozvo, tinozviita mune chero imwe nzvimbo yakatinakira pakombuta, tisingachinji zita uye tichitsanangura kuwedzera "xml" (rudzi rwefaira runofanira kusarudzwa - "Mafaera ese").
15. Kopira iyo ichangobva kugadzirwa faira kune folda "worksheets" yedu archive (pamwe nekutsiviwa kweyekutanga).Cherechedza: rekodhi "SheetProtection" iripo mune ese password-akachengetedzwa mapepa mafaira. Naizvozvo, zviito zvinotsanangurwa pamusoro pekutsvaga nekudzima zvinoitwa nemamwe mafaera ese. XML mufolda "worksheets".
16. Zvekare isu tinoenda kune folda ine archive yedu uye shandura kudzosera yekuwedzera kubva "zip" on "xlsx" nekutumidza zita.
17. Iye zvino unogona kuvhura faira uye nekurigadzirisa zvakachengeteka. Iwe haufanire kuisa password kuti usadzivirire.

Wechitatu bato password anobvisa

Unogona kushandisa wechitatu-bato zvirongwa kubvisa password yako. Panguva imwecheteyo, zvakakosha kuyeuka njodzi inogona kuve yakabatana nekurodha, kuisa uye kushandisa zvisiri-yakajairwa maturusi eiyo sisitimu yekushandisa uye Excel.

Kana iwe, zvisinei, ukasarudza kushandisa mukana uyu, iwe unogona kuterera kune yakaringana chirongwa. Accent OFFICE Password Recovery.

Batanidza kune peji repamutemo nechirongwa:.

Ndokumbira utarise kuti kuti uwane mukana kune ese mabasa echirongwa, unofanirwa kutenga rezinesi. Demo vhezheni iripo kuti uzive nezve application, zvisinei, haibvumire iwe kudzima mapassword.

mhedziso

Kuchengetedza bhuku rebasa kana pepa rimwechete chinhu chinobatsira zvakanyanya chechirongwa cheExcel kana iwe uchida kuchengetedza ruzivo kubva kuvanhu vasina mvumo kana, semuenzaniso, zvidzivirire kubva pakuchinja netsaona kune yakakosha kuverenga-chete data. Asi dzimwe nguva zvakapesana zvinodiwa zvinomuka - kubvisa yakamboiswa dziviriro. Izvi zvinogona kuitwa nenzira dzakasiyana, zvichienderana nekuti yakaiswa sei. Uye kunyange kana iwe wakakanganwa password, kuvhara kunogona kubviswa, zvisinei, chete kana kodeti yakagadzirirwa mapepa ega, uye kwete yebhuku rose.