txheem
Qee Microsoft Excel spreadsheets yuav tsum tau tiv thaiv los ntawm prying ob lub qhov muag, piv txwv li, qhov no muaj txiaj ntsig zoo rau cov ntaub ntawv nrog cov ntaub ntawv nyiaj txiag. Muaj kev pheej hmoo ntawm kev poob cov ntaub ntawv hauv cov ntxhuav tswj los ntawm ntau tus neeg, thiab txhawm rau tiv thaiv qhov no tshwm sim, koj tuaj yeem siv kev tiv thaiv built-in. Cia peb txheeb xyuas txhua qhov muaj peev xwm ntawm kev thaiv kev nkag mus rau cov ntaub ntawv.
Teem tus password rau nplooj ntawv thiab phau ntawv
Muaj ntau txoj hauv kev los tiv thaiv tag nrho cov ntaub ntawv lossis nws qhov chaw - nplooj ntawv. Cia peb xav txog txhua tus ntawm lawv ib kauj ruam. Yog tias koj xav ua kom nws thiaj li hais tias tus password tam sim ntawd tshwm thaum koj qhib ib daim ntawv, koj yuav tsum teeb tsa tus lej thaum koj khaws cov ntaub ntawv.
- Qhib "Cov ntaub ntawv" tab thiab nrhiav "Txuag Raws li" ntu. Nws muaj qhov "Xaiv" kev xaiv, thiab nws yuav tsum tau teeb tsa tus password. Nyob rau hauv cov laus versions, nyem rau ntawm "Txuag li" tam sim ntawd qhib lub qhov rai browser.
- Thaum lub qhov rais txuag tau tshwm rau ntawm qhov screen, koj yuav tsum nrhiav qhov "Tools" ntu hauv qab. Qhib nws thiab xaiv "General Options" kev xaiv.
- Lub qhov rais General Options tso cai rau koj txwv tsis pub nkag mus rau cov ntaub ntawv. Koj tuaj yeem teeb tsa ob lo lus zais - saib cov ntaub ntawv thiab hloov nws cov ntsiab lus. Read Only access yog teem raws li qhov nyiam nkag los ntawm tib lub qhov rais. Sau rau hauv lo lus zais nkag teb thiab nyem lub pob "OK" txhawm rau txuag cov kev hloov pauv.
- Tom ntej no, koj yuav tsum paub meej tias cov passwords - ib zaug ntxiv rau lawv hauv daim ntawv tsim nyog nyob rau hauv lem. Tom qab nias lub pob "OK" hauv lub qhov rais kawg, cov ntaub ntawv yuav raug tiv thaiv.
- Nws tseem tsuas yog khaws cov ntaub ntawv, tom qab teeb tsa passwords qhov kev pab cuam rov qab rau tus neeg siv rau lub qhov rais txuag.
Lwm zaus koj qhib Excel phau ntawv ua haujlwm, lub qhov rais nkag lo lus zais yuav tshwm. Yog tias ob lub lis piam tau teeb tsa - saib thiab hloov pauv - qhov nkag tau tshwm sim hauv ob theem. Nws tsis tas yuav tsum nkag mus rau tus password thib ob yog tias koj tsuas yog xav nyeem cov ntaub ntawv.
Lwm txoj hauv kev los tiv thaiv koj cov ntaub ntawv yog siv cov yam ntxwv hauv ntu Cov Ntaub Ntawv.
- Qhib "Cov ntaub ntawv" tab thiab nrhiav "Cov ntsiab lus" ntu hauv nws. Ib qho ntawm cov kev xaiv seem yog "Permissions".
- Cov ntawv qhia kev tso cai tau qhib los ntawm kev nyem rau ntawm "Protect Book" khawm. Qhov thib ob ntawm cov npe yuav tsum tau - "Encrypt nrog tus password". Xaiv nws los teeb tsa tus lej nkag.
- Sau tus password tshiab hauv lub thawv encryption. Tom ntej no, koj yuav tsum paub meej tias nws nyob rau hauv tib lub qhov rais. Thaum kawg, nias lub pob "OK".
Ua tib zoo mloog! Koj tuaj yeem nkag siab tias qhov kev xaiv tau qhib los ntawm cov kab txiv kab ntxwv uas nyob ib puag ncig ntawm ntu "Permissions".
Teem ib lo lus zais rau tus kheej lub hlwb
Yog tias koj xav tau los tiv thaiv qee lub hlwb los ntawm kev hloov lossis tshem tawm cov ntaub ntawv, kev nkag mus rau tus password yuav pab tau. Teem kev tiv thaiv siv "Protect Sheet" muaj nuj nqi. Nws ua rau tag nrho daim ntawv los ntawm lub neej ntawd, tab sis tom qab kev hloov me me hauv qhov chaw nws yuav tsom mus rau qhov xav tau ntau ntawm cov hlwb.
- Xaiv daim ntawv thiab right-click rau nws. Ib daim ntawv qhia zaub mov yuav tshwm nyob rau hauv uas koj yuav tsum nrhiav "Format Cells" muaj nuj nqi thiab xaiv nws. Lub qhov rais chaw yuav qhib.
- Xaiv lub "Kev Tiv Thaiv" tab nyob rau hauv lub qhov rais uas qhib, muaj ob lub checkboxes. Nws yog tsim nyog los deselect lub qhov rais saum toj kawg nkaus - "Protected cell". Lub cell tam sim no tsis muaj kev nyab xeeb, tab sis nws tsis tuaj yeem hloov pauv thaum tus password tau teeb tsa. Tom ntej no, nyem "OK".
- Peb xaiv cov hlwb uas yuav tsum tau tiv thaiv, thiab ua qhov thim rov qab. Koj yuav tsum qhib "Format cells" dua thiab kos lub thawv "Protected cell".
- Hauv "Tshawb xyuas" tab muaj ib lub pob "Tshwj xeeb daim ntawv" - nyem rau ntawm nws. Lub qhov rais yuav qhib nrog ib txoj hlua lo lus zais thiab cov npe tso cai. Peb xaiv cov kev tso cai tsim nyog - koj yuav tsum tau kos lub thawv nyob ib sab ntawm lawv. Tom ntej no, koj yuav tsum tuaj nrog tus password kom lov tes taw kev tiv thaiv. Thaum txhua yam ua tiav, nyem "OK".
Thaum sim hloov cov ntsiab lus ntawm lub xov tooj ntawm tes, tus neeg siv yuav pom cov lus ceeb toom tiv thaiv thiab cov lus qhia yuav ua li cas tshem tawm kev tiv thaiv. Cov uas tsis muaj tus password yuav tsis tuaj yeem hloov pauv.
Mloog! Koj tuaj yeem pom qhov "Protect Sheet" muaj nuj nqi hauv "Cov ntaub ntawv" tab. Koj yuav tsum mus rau ntu cov ntaub ntawv thiab nrhiav "Permissions" khawm nrog tus yuam sij thiab xauv.
Teem ib lo lus zais ntawm phau ntawv qauv
Yog tias cov qauv kev tiv thaiv raug teeb tsa, muaj ntau yam kev txwv rau kev ua haujlwm nrog cov ntaub ntawv. Koj tsis tuaj yeem ua cov hauv qab no nrog phau ntawv:
- luam, hloov npe, rho tawm cov nplooj ntawv hauv phau ntawv;
- tsim cov ntawv;
- qhib cov ntawv zais;
- luam lossis txav mus rau lwm phau ntawv ua haujlwm.
Cia peb ua ob peb kauj ruam los thaiv cov qauv kev hloov pauv.
- Qhib "Tshawb xyuas" tab thiab nrhiav "tiv thaiv phau ntawv" kev xaiv. Qhov kev xaiv no tuaj yeem pom nyob rau hauv "Cov Ntaub Ntawv" tab - "Cov Lus Qhia" ntu, "Kev Tso Cai" muaj nuj nqi.
- Lub qhov rais yuav qhib nrog kev xaiv ntawm kev tiv thaiv kev xaiv thiab ib daim teb rau nkag mus rau tus password. Muab tus zuam ib sab ntawm lo lus "Structure" thiab tuaj nrog tus password. Tom qab ntawd, koj yuav tsum nias lub pob "OK".
- Peb lees paub tus password, thiab cov qauv ntawm phau ntawv yuav raug tiv thaiv.
Yuav ua li cas tshem tus password hauv Excel daim ntawv
Koj tuaj yeem tshem tawm qhov kev tiv thaiv ntawm ib daim ntawv, lub hlwb lossis phau ntawv ua haujlwm hauv tib qhov chaw uas nws tau teeb tsa. Piv txwv li, kom tshem tawm tus password los ntawm cov ntaub ntawv thiab tshem tawm qhov txwv tsis pub hloov, qhib lub qhov rai txuag lossis encryption thiab tshem cov kab nrog cov lus teev tseg. Txhawm rau tshem tawm cov passwords los ntawm cov nplooj ntawv thiab cov phau ntawv, koj yuav tsum qhib "Tshawb xyuas" tab thiab nyem rau ntawm cov pob tsim nyog. Lub qhov rais hu ua "Tshem tawm kev tiv thaiv" yuav tshwm sim, xav kom koj sau tus password. Yog tias txoj cai raug raug, kev tiv thaiv yuav poob thiab cov kev ua nrog cov hlwb thiab cov nplooj ntawv yuav qhib.
Tseem ceeb! Yog tias tus password ploj lawm, nws tsis tuaj yeem rov qab tau. Qhov kev zov me nyuam ib txwm ceeb toom txog qhov no thaum txhim kho cov lej. Hauv qhov no, cov kev pabcuam thib peb yuav pab tau, tab sis lawv siv tsis yog ib txwm muaj kev nyab xeeb.
xaus
Kev tiv thaiv built-in ntawm Excel cov ntaub ntawv los ntawm kev kho yog qhov txhim khu kev qha - nws tsis tuaj yeem rov qab tau tus password, nws raug xa mus rau cov neeg ntseeg siab lossis tseem nyob nrog tus tsim lub rooj. Qhov yooj yim ntawm kev tiv thaiv kev ua haujlwm yog tias tus neeg siv tuaj yeem txwv tsis pub nkag mus rau tag nrho cov lus, tab sis kuj rau cov tib neeg lub hlwb lossis kho cov qauv ntawm phau ntawv.