Momwe mungagwiritsire pa mawu achinsinsi

Anonim

Mawu achinsinsi pa fayilo ya Microsoft

Chitetezo ndi chitetezo cha deta ndi chimodzi mwazofunikira pakukula kwa matekinoloje amakono. Kufunikira kwa vutoli sikufupika, koma kumangokula. Makamaka otetezedwa ndi deta mafayilo omwe chidziwitso chofunikira chimasungidwa mu malonda. Tiyeni tiwone momwe mungatetezere mafayilo apamwamba pogwiritsa ntchito mawu achinsinsi.

Kukhazikitsa password

Opanga pulogalamuyi amamvetsetsa bwino kufunika kokhazikitsa achinsinsi pa mafayilo apamwamba, kotero pali zingapo zomwe mungachite pochita njirayi nthawi imodzi. Nthawi yomweyo, ndizotheka kukhazikitsa kiyi, potsegulira bukuli komanso kusintha kwake.

Njira 1: Kukhazikitsa chinsinsi mukasunga fayilo

Njira imodzi imaphatikizapo kukhazikitsa mawu achinsinsi populumutsa buku la Exll.

  1. Pitani ku "Fayilo" ya pulogalamu ya Excel.
  2. Pitani ku fayilo ya fayilo mu Microsoft Excel

  3. Dinani pa "Sungani monga".
  4. Pitani kupulumutsa fayilo ku Microsoft Excel

  5. Pazenera lomwe limatsegulira batani la "Ntchito", lomwe lili pansi kwambiri. Mumenyu zomwe zikuwoneka, sankhani "magawo onse ...".
  6. Sinthani ku magawo ambiri mu Microsoft Excel

  7. Windo lina laling'ono limatsegulidwa. Mmenemo, mutha kutchula mawu achinsinsi pafayilo. Mu "achinsinsi otsegulira" gawo, timalowa mawu ofunikira omwe angafunike kunena mukatsegula buku. Mu "achinsinsi kuti musinthe" munda, lowetsani kiyi kuti mulowe ngati mukufuna kusintha fayilo iyi.

    Ngati mukufuna fayilo yanu kuti muthe kusintha anthu osavomerezeka, koma mukufuna kuchoka kuti muwone kwaulere, ndiye, mudalire mawu achinsinsi oyamba. Ngati makiyi awiri atchulidwa, ndiye kuti mutsegula fayilo, mudzalimbikitsidwa kulowa. Ngati wogwiritsa ntchito akungodziwa koyamba mwa iwo, ndiye kuti zipezeka kokha kuti muwerenge, popanda kuthekera kusintha deta. M'malo mwake, idzatha kusintha zonse, koma sizingatheke kupulumutsa zosinthazi. Itha kupulumutsidwa mu mawonekedwe a kope popanda kusintha chikalata choyambirira.

    Kuphatikiza apo, mutha kuyikapo zojambulajambula nthawi yomweyo.

    Nthawi yomweyo, ngakhale wosuta yemwe amadziwa nonse achinsinsi, fayilo yokhazikika itsegulidwa popanda chida. Koma, ngati angafune, nthawi zonse amatha kutsegula gululi pokana batani loyenerera.

    Pambuyo pa zosintha zonse mu zenera wamba zimapangidwa, dinani batani la "Ok".

  8. Kukhazikitsa mapasiwedi ku Microsoft Excel

  9. Zenera limatsegulidwa komwe mukufuna kulowanso. Izi zimachitika kuonetsetsa kuti wogwiritsa ntchitoyo amayamba kulowa mu zofanana. Dinani pa batani la "OK". Pankhani yosagwirizana ndi mawu osakira, pulogalamuyi imaperekanso mawu achinsinsi.
  10. Chitsimikizo cha Chinsinsi mu Microsoft Excel

  11. Pambuyo pake, timabweranso ku zenera lopulumutsa. Apa, ngati mukufuna, sinthani dzina lake ndikusankha chikwatu chomwe chidzakhala. Izi zikachitika, dinani batani la "Sungani".

Kusunga fayilo ku Microsoft Excel

Chifukwa chake tinateteza fayilo yapamwamba. Tsopano itenga mapasiwedi oyenera kuti mutsegule ndikuzisintha.

Njira 2: Kukhazikitsa mawu achinsinsi mu gawo la "Zambiri"

Njira yachiwiri imatanthawuza kukhazikitsa mawu achinsinsi mu gawo la "Zambiri".

  1. Monga nthawi yomaliza, pitani ku "fayilo" tabu.
  2. Mu gawo la "tsatanetsatane", dinani pa batani la "file". Mndandanda wazomwe mungasankhe kuti mutetezeke pafoni. Monga mukuwonera, mutha kuteteza mawu achinsinsi osati fayilo yonse, komanso pepala lina, komanso kuti musinthe chitetezo kuti musinthe pogwiritsa ntchito bukuli.
  3. Kusintha ku chitetezo cha bukuli mu Microsoft Excel

  4. Ngati timitsa kusankha pa "Enpat achinsinsi", zenera lidzatseguka pomwe mawu ofunikira ayenera kulowa. Mawu achinsinsi amakumana ndi fungulo kuti titsegule buku lomwe tidagwiritsa ntchito mu njira yapitayo ndikusunga fayilo. Pambuyo polowa data, kanikizani batani la "OK". Tsopano, osadziwa chinsinsi, fayilo palibe amene angatsegule.
  5. Mawu achinsinsi mu Microsoft Excel

  6. Mukasankha "tengani pepala lapano", zenera lidzatsegulidwa ndi zoikamo zambiri. Palinso zenera lolowera achinsinsi. Chida ichi chimakupatsani mwayi kuteteza pepalalo kuti musinthe. Nthawi yomweyo, mosiyana ndi kutetezedwa kuti asasinthe pogwiritsa ntchito kupulumutsa, njirayi siyipereka mphamvu yopanga pepala losinthidwa. Zochita zonse zimatsekedwa pa izi, ngakhale nthawi yayikulu bukulo lingapulumutsidwe.

    Zikhazikiko Zoteteza Muyezo Wogwiritsa Ntchito Yemwe Amagwiritsa Ntchito Yemwe Amagwiritsa Ntchito Mwachisawawa, ku machitidwe onse kwa wosuta yemwe alibe mawu achinsinsi, omwe ali pa pepala amangosankha maselo okha. Koma, wolemba wa chikalatacho amatha kuloleza kukonza, kuyika ndikuchotsa mizere ndi zigawo, kukonza autofiter, kusintha kwa zinthu ndi zolemba, etc. Mutha kuchotsa chitetezo ndi pafupifupi chilichonse. Mukakhazikitsa makonda, dinani batani la "OK".

  7. Scene Encrryption mu Microsoft Excel

  8. Mukadina pa "chitetezo cha buku" chinthu, mutha kuyika chitetezo cha chikalatacho. Zosintha zimapereka chizindikiro cha kusintha kwa kapangidwe kake, zonse ndi chinsinsi komanso popanda icho. Poyamba, uku ndi kutetezedwa kopusa "kopusa", ndiye kuti, kuchokera pakuchita mwadala. Mlandu wachiwiri, izi zimatetezedwa kale ku chikalata chosungidwa ndi ogwiritsa ntchito ena.

Kuteteza kapangidwe kake mu Microsoft Excel

Njira 3: Kukhazikitsa password ndi kuchotsedwa kwake mu "kuwunika" tabu

Kutha kukhazikitsa mawu achinsinsi omwe alinso mu "Kuunikira" tabu.

  1. Pitani ku tabu pamwambapa.
  2. Kusintha ku TOP BONB ku Microsoft Excell Extix

  3. Tikufuna kusintha chida chosintha pa tepi. Dinani pa "batani la tsamba", kapena "Tetezani Buku". Mabatani awa ali ogwirizana kwathunthu ndi zinthuzo "Tetezani pepalalo" ndikuti "Tetezani kapangidwe ka buku" mu "chidziwitso", chomwe tidalankhula kale pamwambapa. Zochita zinanso ndizofanana.
  4. Kuteteza mapepala ndi mabuku ku Microsoft Excel

  5. Pofuna kuchotsa mawu achinsinsi, muyenera kudina batani la "Chotsani masamba" pa tepi ndikulowetsa mawu oyenera.

Kuchotsa chitetezo ku pepala mu Microsoft Excel

Monga mukuwonera, Microsoft Excel imapereka njira zingapo zotetezera fayilo ndi mawu achinsinsi, onse osamalira mwadala, komanso chifukwa chochita mwadala. Mutha kudutsa pa kutsegulidwa kwa bukulo ndikusintha kapena kusintha zinthu zake. Nthawi yomweyo, wolemba amatha kudziyesa yekha, momwe amasintha momwe akufuna kuteteza chikalatacho.

Werengani zambiri