Yuav ua li cas Password Tiv thaiv ib daim ntawv Excel

Cov txheej txheem:

Yuav ua li cas Password Tiv thaiv ib daim ntawv Excel
Yuav ua li cas Password Tiv thaiv ib daim ntawv Excel
Anonim

Yuav Paub

  • Document-Qhib password: Xaiv File > Info > Tiv thaiv Password > Tiv thaiv Phau Ntawv Ua Haujlwm > Encrypt nrog Password.
  • Tom ntej: Nkag mus rau tus password muaj zog > xaiv OK > rov nkag tus password > xaiv OK. Tus password tam sim no yuav tsum qhib.
  • Modify: Xaiv File > Save As > Browse > Cov cuab yeej > General Options > Password hloov kho > sau tus password.

Kab lus no piav qhia yuav ua li cas kom ruaj ntseg ib daim ntawv nrog tus password hauv Excel 2019, 2016, 2013, Excel rau Microsoft 365, thiab Excel rau Mac.

Yuav ua li cas teev cov ntaub ntawv-Qhib Password hauv Excel

Txhawm rau teeb tsa koj phau ntawv ua haujlwm kom tsis muaj leej twg tuaj yeem qhib nws yam tsis muaj tus password, siv cov ntaub ntawv qhib lo lus zais hauv thaj chaw Cov Ntaub Ntawv ntawm Excel.

  1. Nrog phau ntawv qhib, xaiv File > Info > Tiv thaiv Password. Xaiv cov ntawv qhia zaub mov Protect Workbook, ces xaiv Encrypt nrog Password.

    Image
    Image
  2. Sau tus password muaj zog hauv lub qhov rai pop-up thiab xaiv OK.

    Image
    Image

    Nco ntsoov tus password yog qhov tseem ceeb, yog li koj tuaj yeem sib txawv ntawm cov peev thiab tsab ntawv qis kom ua kom tus password kom ruaj ntseg dua.

  3. Rov nkag tus password, ntaus nws raws nraim li koj tau ua hauv thawj lub qhov rais. Tom qab ntawd, xaiv OK.

    Image
    Image

    Yuav tsum nkag tus password ob zaug kom paub meej tias yog tias koj ntaus ntawv yuam kev ib zaug, koj yuav tsis tas kaw daim ntawv nrog tus password tsis raug.

  4. Thaum koj ua tiav, koj yuav pom qhov kev xaiv Protect Workbook xaiv hloov xim, nrog cov xwm txheej qhia tias yuav tsum muaj tus password kom qhib phau ntawv ua haujlwm.

    Image
    Image

    Koj phau ntawv ua haujlwm tam sim no raug tiv thaiv los ntawm leej twg qhib nws yog tias lawv tsis paub tus password.

  5. Thaum leej twg sim qhib daim ntawv ua haujlwm, lawv pom lub qhov rai pop-up nug tus password.

    Image
    Image

    Yog tias lawv nkag lo lus zais tsis raug, Excel cia lawv sim nkag mus rau nws zaum ob. Yog tias lawv tsis nkag mus rau tus password kom raug dua, daim ntawv ua haujlwm yuav tsis qhib. Nov yog txoj hauv kev zoo tshaj plaws los tiv thaiv koj cov ntaub ntawv Excel.

Txhawm rau tshem tawm cov ntaub ntawv tiv thaiv tus password, rov ua cov txheej txheem saum toj no tab sis tshem tawm tus password thiab xaiv OK.

Yuav ua li cas Ntxiv Hloov Hloov Tus password rau koj phau ntawv Excel

Lwm txoj hauv kev los tiv thaiv Excel daim ntawv ua haujlwm yog siv tus password los tiv thaiv tib neeg los ntawm kev hloov pauv rau nws tom qab nws qhib. Nws dhau los ua kev nyeem nkaus xwb rau leej twg tsis muaj tus password.

  1. Nrog koj daim ntawv ua haujlwm qhib, xaiv File > Save As. Tom qab ntawd, xaiv Browse txhawm rau qhib cov ntaub ntawv xauj qhov rai.

    Image
    Image
  2. Nyob rau hauv Txuag Raws li qhov rais, xaiv Tools thiab xaiv Kev xaiv dav dav hauv cov ntawv qhia zaub mov.

    Image
    Image
  3. Nyob rau hauv General Options window, ntaus tus password rau hauv Password hloov kho teb.

    Image
    Image

    Koj tseem tuaj yeem sau tus password rau hauv Password qhib teb, uas yuav xav tau tus password qhib phau ntawv ua haujlwm txhua. Qhov no ua haujlwm zoo ib yam li Cov Ntaub Ntawv Tiv Thaiv tus password tau piav qhia saum toj no.

  4. Koj tau hais kom rov nkag tus password hauv qab Reenter password to modify kom paub tseeb tias koj tsis ntaus nws tsis raug. Xaiv OK txhawm rau kaw qhov kev lees paub thiab Save.

    Image
    Image

    Txhawm rau tshem tawm hloov kho tus password tiv thaiv, tsuas yog ua raws li cov txheej txheem saum toj no, tab sis tshem tawm tus password thiab xaiv OK.

  5. Thaum leej twg qhib phau ntawv no, lawv raug ceeb toom kom nkag mus rau tus password kom raug los hloov kho phau ntawv ua haujlwm, lossis lawv tuaj yeem xaiv Read-Only txhawm rau qhib phau ntawv ua haujlwm hauv hom nyeem nkaus xwb.

    Image
    Image

    Siv kev tiv thaiv daim ntawv ua haujlwm nkaus xwb yog txoj hauv kev ntse los qhia cov ntaub ntawv tseem ceeb rau tib neeg thaum tiv thaiv lawv los ntawm kev hloov lossis hloov daim ntawv uas koj tau ua haujlwm hnyav los tsim. Qhov no yog qhov muaj txiaj ntsig zoo rau kev xa cov ntawv ceeb toom nrog kev suav cov lej thiab cov qauv.

Yuav ua li cas tiv thaiv tus qauv password thaum rov tshuaj xyuas

Yog tias koj nquag tshuaj xyuas cov ntawv sau ua haujlwm uas tib neeg tsim, lo lus zais tiv thaiv phau ntawv ua haujlwm thaum nws nyob rau theem tshuaj xyuas yog txoj hauv kev zoo los tiv thaiv kev hloov pauv thaum lub sijhawm tshuaj xyuas zoo.

Qhov no tsis tiv thaiv cov ntsiab lus hloov pauv, tab sis nws tiv thaiv tib neeg los ntawm kev ntxiv, tshem tawm, hloov npe, lossis tsim cov nplooj ntawv tshiab. Nws tiv thaiv cov qauv ntawm phau ntawv ua haujlwm nws tus kheej, tsis yog cov ntsiab lus.

  1. Nrog phau ntawv qhib, xaiv Review > Tiv thaiv Phau Ntawv.

    Image
    Image
  2. Hloov tus password thiab tom qab ntawd xaiv OK. Koj raug ceeb toom kom nkag mus rau tus password dua.

    Image
    Image
  3. Ib zaug qhib, thaum leej twg qhib phau ntawv no thiab nyem rau ntawm daim ntawv, txhua txoj kev xaiv los hloov daim ntawv lossis ntxiv cov nplooj ntawv tshiab raug kaw.

Pom zoo: