5 Txoj Kev Tshem Tawm Nyeem-Tsuas Ntaus ntawm Excel 2021/2019/2016/2013/2010/2007
Thaum koj tau ua tiav cov kev hloov kho phau ntawv ua haujlwm, koj tuaj yeem tso cov kev txwv nyeem nkaus xwb rau nws thiab txhua tus uas koj qhia nws nrog yuav tuaj yeem nyeem tau, tab sis lawv yuav tsis tuaj yeem hloov kho cov ntaub ntawv hauv ib txoj kev. Txawm li cas los xij, kev siv nyeem nkaus xwb tuaj yeem ua rau muaj kev cuam tshuam thaum koj xav tau hloov cov ntaub ntawv tiag tiag. Tej zaum ib tug phooj ywg lossis cov npoj yaig tau qhia cov ntawv nyeem nkaus xwb Excel nrog koj thiab tsis nco qab qhia koj yuav ua li cas tshem tawm qhov kev txwv no.
Excel tuaj yeem teem caij nyeem nkaus xwb nrog ntau txoj kev xaiv. Hauv tsab xov xwm no, peb sau tag nrho cov teeb meem tshwm sim thiab lawv cov kev daws teeb meem kom koj paub yuav ua li cas tshem tawm kev nyeem ntawv los ntawm excel nyob rau hauv ob peb kis.
Excel yog ua nyeem nkaus xwb siv "Mark as Final"
Ib qho laj thawj vim li cas Excel daim ntawv koj muaj tsuas yog nyeem nkaus xwb yog tias nws tau raug cim kawg los ntawm tus editor. Yog tias qhov no yog qhov teeb meem, koj yuav tsum pom cov lus nyob rau sab saum toj ntawm cov ntaub ntawv hais tias "Cim li zaum kawg."
Thaum ib daim ntawv raug cim kawg, nws yuav yog qhov tseem ceeb tsis tuaj yeem hloov pauv rau nws. Koj tsis tuaj yeem sau, kho lossis sim cov ntaub ntawv hauv lub xeev no. Tab sis nws kuj yog ib qho yooj yim tshem tawm. Tsuas yog nyem lub pob "Kho kom raug lawm" tom kawg ntawm cov lus thiab koj tuaj yeem kaw qhov kev nyeem nkaus xwb hauv Excel.
Excel cov ntaub ntawv dhau los ua cov ntawv nyeem nkaus xwb pom zoo los ntawm "Save As"
Lwm qhov xwm txheej kom paub tias daim ntawv Excel nyob rau hauv hom nyeem nkaus xwb yog tias koj yuav raug ceeb toom kom qhib cov ntaub ntawv hauv hom nyeem nkaus xwb tshwj tsis yog koj yuav tsum hloov pauv rau nws. Yog tias koj tsis xav hloov cov ntaub ntawv, tsuas yog nyem "Yes." Thiab yog tias koj xav hloov cov ntaub ntawv, tsuas yog nyem "Tsis yog" qhib nws.
Yog tias koj xav qhib cov ntawv nyeem nkaus xwb, ua raws cov kauj ruam yooj yim no:
Kauj ruam 1: Thaum koj xub qhib Excel daim ntawv thiab tau txais cov lus muab peb txoj hauv kev qhib cov ntawv nyeem nkaus xwb, tsuas yog nyem "Yes" qhib cov ntaub ntawv hauv hom nyeem nkaus xwb.
Kauj ruam 2: Yog tias koj ua ib qho kev hloov pauv rau cov ntsiab lus ntawm cov ntaub ntawv thiab sim khaws cov kev hloov pauv, cov lus tshiab tshwm sim hais kom koj khaws ib daim qauv ntawm cov ntaub ntawv thiab hloov npe nws. Nyem "OK" qhib lub "Txuag Raws li" dialog box, thiab tom qab ntawd nyem "Tools> General Options."
Kauj Ruam 3: Nyob rau hauv lub "General Options" dialog box uas tshwm, uncheck lub "Rau pom zoo nyeem nkaus xwb" kev xaiv thiab nias "OK."
Kauj Ruam 4: Rov qab rau hauv "Txuag Raws li" dialog box, nyem "Txuag." Qhov no yuav ua ib daim qauv ntawm cov ntaub ntawv Excel qub. Cov ntaub ntawv theej yuav tsis tau nyeem nkaus xwb thiab koj tuaj yeem txuas ntxiv kho nws raws li koj xav tau.
Qhov no yuav tshem tawm cov kev txwv nyeem nkaus xwb los ntawm Excel daim ntawv.
Cov qauv ntawm Excel nplooj ntawv thiab phau ntawv ua haujlwm raug kaw thiab nyeem nkaus xwb
Yog tias Excel cov ntaub ntawv nyob rau hauv hom nyeem nkaus xwb vim tias daim ntawv ua haujlwm lossis phau ntawv ua haujlwm raug kaw, koj tuaj yeem tshem tawm Excel tsuas yog kev txwv yog tias koj paub tus password. Nov yog qhov koj ua:
Kauj ruam 1: Qhib cov ntaub ntawv Excel tiv thaiv, yog li koj tuaj yeem pom tag nrho cov ntawv ua haujlwm thiab lawv cov ntsiab lus.
Kauj ruam 2: Nyem "Saib" hauv cov ntawv qhia zaub mov tseem ceeb thiab tom qab ntawd xaiv "Unprotect Sheet" nyob rau hauv "Hloov". Sau tus password kom tiav cov txheej txheem.
Kauj ruam 3 : Yog tias nws yog phau ntawv ua haujlwm uas muaj kev tiv thaiv, nyem "Unprotect Workbook" thiab tom qab ntawd sau tus password kom tshem tawm qhov txwv.
Txuag cov ntaub ntawv thiab qhov kev txwv nyeem nkaus xwb yuav raug tshem tawm.
Excel cov ntaub ntawv yog tus password txwv raws li nyeem nkaus xwb
Qee zaum thaum koj qhib cov ntaub ntawv Excel encrypted, koj yuav raug nug kom nkag mus rau tus password rau kev sau ntawv lossis qhib nws nyeem nkaus xwb. Nyem rau ntawm qhov "Nyeem nkaus xwb" kev xaiv thiab Excel cov ntaub ntawv yuav raug txwv rau kev hloov kho thiab nyeem ntawv. Ua raws li cov kauj ruam no txhawm rau qhib cov ntawv nyeem nkaus xwb Excel:
Kauj ruam 1. Txuag cov ntaub ntawv Excel tam sim no nyeem nkaus xwb los ntawm nyem Cov Ntaub Ntawv> Txuag Raws li.
Kauj ruam 2. Cia li txuag nws ua ib daim ntawv Excel sib txawv thiab nyem "Txuag" mus txuas ntxiv.
Tam sim no koj tuaj yeem qhib daim ntawv theej ntawm Excel cov ntaub ntawv thiab hloov pauv rau nws.
Cov Lus Qhia Ntxiv: Tshem tawm Excel nyeem nkaus xwb yam tsis muaj lo lus zais (Rau txhua qhov xwm txheej saum toj no)
Yog tias koj xav tshem Excel hom "nyeem nkaus xwb". teem los ntawm txhua txoj kev xaiv hauv ib nias xwb tsis muaj tus password , tom qab ntawd ib txoj hauv kev zoo tshaj plaws los ua qhov no yog los ntawm kev siv Excel lo lus zais tshem tawm cov cuab yeej zoo li Passper rau Excel .
Passper rau Excel yog ib lub cuab yeej uas tso cai rau koj tshem tawm cov ntawv nyeem nkaus xwb siv Mark li Kawg thiab Txuag Raws li, tshem tawm cov kev txwv ntawm cov qauv ntawm Excel nplooj ntawv thiab phau ntawv ua haujlwm, thiab tshem tawm lo lus zais qhib ntawm txhua daim ntawv Excel kaw.
Yog li, nws yog ib qho tseem ceeb heev thaum koj tsis tuaj yeem qhib lossis kho cov ntawv nyeem nkaus xwb Excel. Nov yog qee qhov ntawm nws cov nta:
Passper rau Excel: Tshem tawm kev nyeem Excel hauv 2 vib nas this:
- Txhua qhov xwm txheej tau them: Tshem tawm lossis lov tes taw nyeem Excel hauv txhua kis.
- Qhov kev vam meej tshaj plaws: Cov algorithm siab heev guarantees a 100% tshem tawm tus nqi .
- Yooj yim rau siv : Nws kuj yog ib qho yooj yim heev rau siv. Nrog nws, koj tuaj yeem rov qab tau qhib lo lus zais hauv ob peb kauj ruam yooj yim thiab tshem tawm cov kev txwv hauv ib nias.
Yuav Ua Li Cas Xauv Read-Tsuas Excel Cov Ntaub Ntawv nrog Passper rau Excel
Nov yog yuav ua li cas siv Passper rau Excel kom tshem tawm cov kev txwv nyeem nkaus xwb los ntawm Excel daim ntawv:
Kauj ruam 1: Download tau thiab nruab Passper rau Excel ntawm koj lub computer thiab ces qhib nws. Hauv lub qhov rais loj, xaiv « Tshem tawm cov kev txwv «.
Kauj ruam 2: Nyem "Ntxiv" kom import cov ntaub ntawv txwv rau hauv Passper.
Kauj Ruam 3: Thaum cov ntaub ntawv tau ua tiav tiav rau qhov kev pab cuam, nyem "Tshem tawm » thiab ib qho kev txwv nyeem nkaus xwb ntawm Excel daim ntawv yuav raug tshem tawm kom tiav.
Lub tswv yim: Raws li peb tau hais ua ntej, Passper rau Excel kuj tuaj yeem siv los rov qhib cov passwords. Yog tias koj tau poob tus password los qhib koj cov ntaub ntawv Excel lossis yog tias koj tau txais cov ntaub ntawv Excel tiv thaiv nrog tus password qhib, koj tuaj yeem sim nws.
Xaus
Cov saum toj no yog 5 txoj hauv kev zoo tshaj rau koj yog tias koj tsis paub yuav ua li cas tshem tawm kev nyeem ntawv los ntawm excel . Thov nco ntsoov tias tej zaum yuav muaj ntau yam laj thawj vim li cas koj tsis tuaj yeem nkag mus rau Excel daim ntawv, txawm hais tias ib qho ntawm feem ntau yog thaum cov ntaub ntawv "cim kawg." Passper rau Excel tso cai rau koj kom yooj yim nkag mus rau cov ntaub ntawv tsis hais txog kev txwv txwv, suav nrog cov ntaub ntawv tiv thaiv tus password.