6 Txoj hauv kev kom tsis txhob nyeem ntawv hauv Excel 2016

Cov ntaub ntawv Excel tuaj yeem muab tso rau hauv hom kev nyeem nkaus xwb thaum cov ntaub ntawv raug cim tias yog qhov kawg, thaum nws tau txais kev cawmdim raws li kev nyeem nkaus xwb, lossis thaum cov ntawv teev lus lossis phau ntawv ua haujlwm raug kaw, thiab lwm yam. Txawm li cas los xij, zoo li kev nyeem ntawv tuaj yeem ua tau, nws kuj tuaj yeem ua rau muaj kev cuam tshuam, tshwj xeeb tshaj yog thaum koj tsis paub yuav tshem tawm qhov kev txwv.

Hauv tsab xov xwm no, peb yuav saib qee yam ntawm txoj hauv kev lov tes taw nyeem ntawv hauv Excel 2016 seb koj puas muaj tus password lossis tsis.

Tshooj 1. Txoj Kev Ua Kom Tsis Muaj Kev Nyeem Ntawv hauv Excel 2016 Tsis Muaj Password

Disabling qhov kev nyeem ntawv nkaus xwb hauv Excel tuaj yeem nyuaj, txawm tias tsis yooj yim sua, thaum koj tsis paub tus password siv los tso qhov kev txwv. Txawm li cas los xij, muaj qee yam cuab yeej hauv kev ua lag luam uas tuaj yeem pab koj tshem tawm kev nyeem ntawv hauv Excel 2016 yooj yim. Ib qho zoo tshaj plaws yog Passper rau Excel .

Cov hauv qab no yog qee qhov nta uas Passper rau Excel muaj:

• Txhawb kom tshem tawm txhua hom los ntawm hom nyeem nkaus xwb tsis muaj tus password.
• Tshem tawm cov passwords qhib thiab tshem tawm kev tiv thaiv ntawm nyeem nkaus xwb nyob rau hauv cov ntaub ntawv / phau ntawv Excel 2016 tsis cuam tshuam cov ntaub ntawv cov ntaub ntawv.
• Xauv cov ntaub ntawv Excel thaum koj tsis nco qab lo lus zais, tsis tuaj yeem luam daim ntawv nthuav qhia lossis cov ntaub ntawv ua haujlwm, tsis tuaj yeem luam tawm daim ntawv nthuav qhia / phau ntawv ua haujlwm, lossis tsis tuaj yeem hloov kho cov ntsiab lus ntawm cov ntaub ntawv.
• Tsis tas li ntawd, nws yog yooj yim heev rau siv , vim nws tso cai rau koj rho tawm cov kev nyeem ntawv hauv ib nias.
• Txhawb nqa txhua yam ntawm Excel cov ntaub ntawv, suav nrog Excel 96-Excel 2019.

Sim nws dawb

Nov yog yuav ua li cas siv Passper rau Excel kom tshem tawm kev nyeem ntawv hauv ib daim ntawv Excel:

Kauj ruam 1: Rub tawm thiab nruab Passper rau Excel ntawm koj lub khoos phis tawj thiab tom qab ntawd qhib qhov program.

Kauj ruam 2: Nyem "Tshem Tawm" thiab tom qab ntawd nyem "Ntxiv" txhawm rau nrhiav cov ntaub ntawv Excel txwv hauv qhov program.

Kauj Ruam 3: Thaum cov ntaub ntawv tau ntxiv rau qhov program, nyem "Delete" thiab Passper rau Excel yuav pib tshem tawm cov kev txwv tam sim ntawd los ntawm cov ntaub ntawv. Hauv ob peb feeb, koj tuaj yeem nkag mus rau Excel 2016 cov ntaub ntawv yam tsis muaj kev txwv.

Sim nws dawb

Ntu 2. 5 Cov xwm txheej sib txawv kom tsis txhob nyeem ntawv hauv Excel 2016

Feem ntau muaj 5 qhov sib txawv qhov twg koj Excel 2016 raug cim tias nyeem nkaus xwb thiab lawv cov kev daws teeb meem yog los lov tes taw kev nyeem nkaus xwb.

Case 1: Thaum cov ntaub ntawv raug nyeem nkaus xwb thaum txuag

Koj tuaj yeem siv "Txuag Raws li" feature hauv qab no los tua hom kev nyeem hauv Excel 2016:

Kauj ruam 1: Pib los ntawm qhib Excel phau ntawv ua haujlwm thiab tom qab ntawd sau tus password yog tias tsim nyog. Nyem "Cov Ntaub Ntawv> Txuag Raws li" thiab tom qab ntawd xaiv qhov chaw tsim nyog ntawm koj lub khoos phis tawm kom txuag tau cov ntaub ntawv.

Dhau 2: Nias lub xub poob ib sab ntawm lub pob "Cov cuab yeej » thiab tom qab ntawd xaiv "Kev xaiv dav dav «.

Dhau 3: Rho tawm tus password uas tshwm nyob rau hauv "Password los hloov kho" lub thawv thiab nyem "OK" txhawm rau tshem qhov kev txwv nyeem nkaus xwb. Nyem "OK."

Dhau 4: Thaum kawg, nyem "Txuag" kom tiav cov txheej txheem.

Case 2: Thaum cov ntaub ntawv raug cim tias kawg

Kos koj cov ntaub ntawv Excel 2016 ua "Qhov Kawg" tuaj yeem tso qhov kev txwv nyeem nkaus xwb ntawm daim ntawv. Nov yog yuav ua li cas lov tes taw qhov kev txwv no ntawm ib daim ntawv uas tau raug cim tias yog qhov kawg.

Kauj ruam 1: Qhib cov ntawv txwv Excel 2016 ntawm koj lub computer.

Kauj ruam 2: Nyob rau sab saum toj ntawm daim ntawv, koj yuav tsum pom lub pob « Kho kom raug lawm «. Nyem nws thiab qhov kev txwv nyeem nkaus xwb yuav raug tshem tawm, tso cai rau koj hloov cov ntaub ntawv.

Case 3: Thaum cov ntawv teev lus lossis phau ntawv ua haujlwm raug kaw

Kev txwv nyeem nkaus xwb tuaj yeem tshwm sim thaum tus sau Excel 2016 daim ntawv tau kaw cov qauv ntawm daim ntawv ua haujlwm lossis phau ntawv ua haujlwm, tiv thaiv daim ntawv ua haujlwm los ntawm kev kho. Hauv qhov no, koj tuaj yeem daws qhov teeb meem hauv cov kauj ruam yooj yim hauv qab no:

Kauj ruam 1: Qhib Excel daim ntawv nrog kev txwv nyeem nkaus xwb, thiab tom qab ntawd nyem «Saib xyuas> Daim ntawv tsis tiv thaiv «.

Kauj ruam 2: Sau tus password rau hauv lub thawv tsim nyog thiab nyem "OK" txhawm rau tshem qhov txwv.

Case 4: Thaum cov ntaub ntawv muaj cov xwm txheej nyeem nkaus xwb

Kev nyeem ntawv tuaj yeem raug kaw hauv Excel 2016 siv Cov Ntaub Ntawv Cov Khoom Xaiv hauv Windows File Explorer. Nov yog qhov koj ua:

Kauj ruam 1: Hauv File Explorer, mus rau cov ntaub ntawv Excel txwv. Right-click cov ntaub ntawv, thiab ces xaiv "Properties" ntawm cov kev xaiv uas tau nthuav tawm.

Kauj ruam 2: Uncheck qhov kev xaiv "Nyeem nkaus xwb "hauv ntu «Tus cwj pwm » thiab nyem "OK" kom tsis txhob nyeem nkaus xwb.

Case 5: Thaum daim ntawv Excel 2016 xav tau tus password

Thaum koj xav tau nkag mus rau tus password kom nkag mus thiab kho cov ntaub ntawv Excel 2016, koj tuaj yeem ua raws li cov kauj ruam yooj yim no txhawm rau tshem qhov txwv:

Kauj ruam 1: Pib los ntawm kev qhib Excel 2016 cov ntaub ntawv koj xav kaw qhov kev nyeem nkaus xwb.

Kauj ruam 2: Thaum lub thawv lo lus zais tshwm, nyem "Nyeem nkaus xwb » hloov thiab cov ntaub ntawv yuav qhib hauv hom nyeem nkaus xwb.

Kauj Ruam 3: Tam sim no nyem "Archive > Txuag li » thiab sau lwm lub npe ntawm cov ntaub ntawv. Nyem rau « Khaws » khaws ib daim ntawv theej tshiab ntawm cov ntaub ntawv qub.

Cov ntaub ntawv tshiab tsim yuav hloov cov ntaub ntawv nyeem nkaus xwb thiab yuav tsis muaj kev txwv ntawm tus thawj.

Cov kev daws teeb meem saum toj no ua rau nws yooj yim rau koj los lov tes taw nyeem nkaus xwb hauv Excel 2016 txawm tias koj muaj lo lus zais lossis tsis. Xaiv txoj kev uas zoo tshaj plaws rau koj cov kev xav tau thiab koj qhov xwm txheej tshwj xeeb. Qhia rau peb paub yog tias koj tuaj yeem tshem qhov kev txwv nyeem nkaus xwb hauv cov lus hauv qab no.

Sim nws dawb