Kudzidza kuisa password kuExcel kunobatsira zvakanyanya, kunyanya paunenge uchiita rimwe basa uye usingade kuti ribviswe. Inobatsirawo zvikuru mumamiriro ezvinhu apo iwe unoda kugovera faira, asi haudi kuti imwe data igadziriswe nekukanganisa.
Muchinyorwa chino tinokuratidza nzira dzaungakiya nadzo bhuku rebasa reExcel kana mamwe mapepa efaira.
Matanho ekuti iwe udzidze kuisa password pane Excel workbook
Kugadzirisa kuchengetedza bhuku rekushanda reExcel hakuna kuoma, chero iwe uchiziva matanho aunofanira kutevera kuti uzviite. Tevere, tinokupa iwe matanho ekuti iwe ugone kuzviita:
- Chinhu chekutanga chaunofanirwa kuita vhura faira reExcel kuti unoda kudzivirira
- Paunenge watoivhura, iwe unofanirwa kuenda kune iyo menyu "Archive” wobva watsvaga chikamu chinoti “Mashoko".
- Zvadaro muchikamu chemashoko unofanira kusarudza sarudzo "Chengetedza bhuku” uye ipapo unofanira kusarudza “Encrypt ne password".
- Paunosarudza "encrypt password" bhokisi rinoratidzwa richikubvunza pinda password uye wozvidzokorora kuti zvionekwe.
- Kana uchinge wasimbisa password, bhuku richadzivirirwa uye paunoivhura zvakare uchada kuipinda.
Nekutevera aya matanho mashanu iwe unozokwanisa kudzidza kuisa password paExcel workbook uye nekudaro chengetedza ruzivo rwaunoshanda pariri.
Iwe unofanirwa kugara uchifunga kuti iwe unofanirwa kuve nepassword yakanyorwa pasi munzvimbo yakachengeteka, nekuti kana ukasadaro, unogona kurasikirwa neruzivo rwawakagadzira muExcel workbook. Iyo encryption yakasimba zvekuti kunyangwe vanhu veMicrosoft vaisakwanisa kuwana ruzivo pasina password.
Zvinokurudzirwawo kuti sarudza password isinga fungidzike zviri nyore nevechitatu mapato. Kana ukasarangarira izvi, vamwe vanogona kufungidzira password uye nekudaro vanokwanisa kuwana iyo data yausingade kuburitswa.
Nzira yekuti iwe udzidze kuisa password mumaspredishiti
Sarudzo yakanaka kwazvo kudzidza kuisa password mumaspredishiti, sezvo izvi zvichigona kukubatsira chengetedza data yausingadi kuchinjwa netsaona kana nemaune.
Chii chaunofanira kuchengeta mupfungwa ndechokuti iyi ndiyo nzira iyo haikiyi faira zvachose, uyewo haiganhurirwi nevashandisi vanogona kuona mashoko ari mubhuku. Kuti ukwanise kushandisa uku kuvharika kwemashizha ebhuku rebasa reExcel unofanirwa kutevera matanho anotevera:
- Kutanga unofanira kuziva kana paine mamwe makoramu aunoda, kana achigona kugadziridzwa ndisati ndavharisa vamwe.
- Kana waona makoramu ausingade kuvharwa, unofanira kuzvisarudza wobva wadzvanya kurudyi negonzo.
- Mumenyu itsva unofanira kutarisa chikamu "Sero fomati” uye mune inotevera menyu unofanirwa kutsvaga sarudzo "Zvidzivirire".
- Kamwe mune yekudzivirira sarudzo unofanirwa kudzima sarudzo "yakavharwa” iyo yakatoongororwa.
- Iye zvino iwe unofanirwa kuenda kune iyo menyu "Kudzokorora” iri pamusoro pebhuku racho.
- Paunopinda muchikamu chekuongorora, unofanirwa kusarudza sarudzo "Chengetedza pepa".
- Paunenge wasarudza pepa rekudzivirira, hwindo rinoratidzwa mairi unokumbirwa kuisa password yekukiya. Asi iwe unogona zvakare kusarudza zviitwa nevashandisi kana wavhara pepa.
- Nekuisa kiyi uye kusarudza zviitiko zvinotenderwa vashandisi, unofanira kungodzvanya bvuma kuseta kukiya.
Nekutevera aya nhanho 8, hauna kungodzidza kuisa password paExcel sheet, asi unodzivirirawo data rausingadi kuchinjwa mubhuku rebasa.
Dzimwe dziviriro uye nzira dzekuchengetedza muExcel faira
Microsoft yakagadzira nzira dzakasiyana dzekukwanisa kuchengetedza chengetedzo yeExcel faira, kuwedzera kune idzo dzatakatotaura nezvazvo. Zvadaro, tichazotaura nezvedzimwe dzedzimwe nzira idzi.
- Maka faira seyekupedzisira. Iyi isarudzo inopihwa neExcel kana iwe uchida kumaka faira seyekupedzisira vhezheni uye usingade kuti igamuchire magadzirirwo kubva kune wechitatu bato.
- Kutungamira kodzero dzeruzivo (IRM). Iyi ndiyo imwe yesarudzo dzaungashandisa kuvhara faira, ine kodzero dzekutarisira ruzivo iwe unogona kuidzivirira kubva pakugadziriswa kana kushandiswa nevamwe vanhu.
- Siginecha yedhijitari. Kushandisa siginecha yedhijitari inogona kuve sarudzo yakanaka kuitira kuti data rako risashandiswa kana kubiwa nevechitatu mapato. Kune iyi nzira iwe unofanirwa kuve uine chitupa chakasimba kubva kune chiremera chetifiketi.
- bhuku level. Iyi isarudzo yekuvhara yechimiro chebhuku rebasa, ndiko kuti, nayo iwe unogona kudzivirira vamwe vashandisi kubva pakukwanisa kufamba, kuwedzera, kudzima, kuviga uye kutopa zita rebasa rako.
- Spreadsheet level. Ichi chidziviriro chinokutendera kuti udzivirire zvimwe zvinhu zvakaita semasero, mazinga, mafomula, ActiveX kudzora, mafomu. Ndokunge, inodzikamisa sarudzo dzemushandisi dzekugadzirisa muExcel sheet.
Idzi dzimwe nzira dzinogona kubatsira zvakanyanya zvichienderana nerudzi rweruzivo rwauri kushanda narwo mubhuku rako rekushanda reExcel.
Yambiro kana uchidzidza kuisa password muExcel
Pane akati wandei ma caveats kana zvasvika pakudzidza kuisa password yeExcel. Saka zvakakosha kuti uvazive usati washandisa imwe yenzira idzi.
- Izvo zvakakosha kuti chengetedza password yako, sezvo ukaikanganwa, Microsoft haigone kuisa iyo faira kuti idzore ruzivo rwako.
- Iyo iyo faira ine password hazvireve kuti yakachengeteka zvachose kana kuchengetedzwa. Saka unofanira kungwarira paunenge uchigovera mafaira neruzivo rwakakosha kune vechitatu mapato kana vatorwa.
- Hazvikurudzirwe kuti uchengete ruzivo rwemunhu senhamba dzekadhi rechikwereti, kuchengetedzwa kwevanhu kana kuzivikanwa kwevashandi mubhuku rekushanda reExcel. Yeuka kuti chokwadi chokuti yakavharwa hazvirevi kuti yakachengeteka zvachose.
- Dziviriro ine hukama neshizha nhanho haisi inofungidzirwa kuchengetedza nzira, nekuti inongomisa maseru awakavharira kuti asagadziriswe.
Izvo zvakakosha kuti utore yambiro idzi mufunge, kunyanya kana iwe uchibata ruzivo rwakaiswa musangano rako kana kambani yaunoshandira.