Qee zaum thaum tsim cov ntaub ntawv nrog cov lus teb, tus neeg siv yuav tsum nkaum daim qauv ntawm qhov muag prying. Ua ntej tshaj plaws, kev xav tau yog los ntawm kev tsis pom zoo ntawm tus neeg siv rau tus neeg txawv to taub cov qauv ntawm daim ntawv. Hauv Excel, koj tuaj yeem nkaum daim qauv. Peb yuav to taub tias qhov no yuav ua tau li cas rau ntau txoj hau kev.
Txoj kev zais cov mis
Nws tsis yog ib daim card rau leej twg yog tias muaj mis nyob hauv ib lub xov tooj ntawm lub rooj ntawm Excel, ces nws tuaj yeem pom hauv qhov formula formula tsuas yog xaiv qhov ntawm tes. Hauv qee kis, qhov no yog qhov tsis zoo. Piv txwv, yog hais tias tus neeg siv xav zais cov lus qhia txog tus qauv ntawm cov lus teb, los yog tsuas tsis xav kom cov lus teb yuav hloov. Nyob rau hauv cov ntaub ntawv no, nws yog zajlus kom nkaum qhov muaj nuj nqi.
Muaj ob txoj hauv kev los ua qhov no. Thawj tug yog zais tus txheem ntawm lub xovtooj ntawm tes, ob hom yog ntau tshaj qhov qub. Thaum nws raug siv, txiav npluav yog hais txog kev faib lub hlwb.
Method 1: Zais Cov Ntsiab Lus
Txoj kev no zoo tshaj plaws rau cov haujlwm uas tau teev nyob rau hauv nqe lus no. Siv nws tsuas hides tus txheem ntawm lub hlwb, tab sis tsis txwv ntxiv kev txwv.
- Xaiv qhov ntev uas nws txheem koj xav nkaum. Nias lub pob nyem khawm ntawm qhov chaw xaiv. Lub ntsiab lus teb ntsiab lus opens. Xaiv ib yam khoom "Qib hlwb". Koj tuaj yeem ua tej yam txawv. Tom qab xaiv qhov ntau, cia li ntaus cov keyboard shortcut Ctrl + 1. Qhov no yuav zoo li qub.
- Qhov rais qhib "Qib hlwb". Mus rau lub tab "Kev Tiv Thaiv". Teem ib tus zuam ze rau yam khoom ntawd "Hide formula". Zuam tawm parameter "Kev tiv thaiv cell" yuav raug tshem tawm yog tias koj tsis npaj los thaiv qhov ntau ntawm kev hloov. Tab sis, feem ntau, kev tiv thaiv tawm tsam kev hloov yog qhov hauj lwm tseem ceeb, thiab nkaum qauv yog xaiv tau. Yog li, feem ntau ob qho checkboxes tseem tshuav tawm. Peb nias lub khawm "OK".
- Tom qab lub qhov rais kaw, mus rau lub tab "Kev Tshawb Xyuas". Peb nias lub khawm "Tiv thaiv daim ntawv"nyob hauv lub cuab yeej cuab tam "Hloov" ntawm daim kab xev.
- Lub qhov rais qhib hauv thaj chaw uas koj yuav tsum nkag mus rau ib qho password. Koj yuav xav tau yog tias koj xav tshem tawm kev tiv thaiv yav tom ntej. Tag nrho lwm qhov chaw raug pom zoo kom khiav tawm lub neej ntawd. Ces nyem rau ntawm lub pob. "OK".
- Lwm lub qhov rais qhib rau hauv uas koj yuav tsum tau rov qab sau dua tus password tshiab. Qhov no yog ua kom tus neeg siv, vim qhov qhia txog ib qho password (piv txwv li, hloov qhov kev hloov), tsis poob rau kev hloov daim ntawv. Ntawm no, kuj tom qab qhia txog qhov tseem ceeb qhia, nias qhov khawm "OK".
Tom qab cov kev ua no, cov qauv yuav muab zais. Tsis muaj dab tsi tshwm sim nyob rau ntawm qhov formula mis ntawm kev tiv thaiv thaum lawv raug xaiv.
Txoj kev 2: Txhob xaiv hlwb
Qhov no yog txoj kev xav paub ntau tshaj. Nws siv imposes ib tug txiav npluav tsis tas rau saib qauv lossis editing hlwb, tab sis txawm nyob rau lawv xaiv.
- Ua ntej tshaj, koj yuav tau xyuas seb qhov checkbox checked "Kev tiv thaiv cell" nyob rau hauv tab "Kev Tiv Thaiv" twb paub nrog cov qauv yav dhau los rau peb qhov formatting qhov rais ntawm qhov xaiv khwv. Yog vim li no, qhov kev tivthaiv no yuav tsum muaj kev pom zoo, tabsis kev kuaj xyuas nws qhov xwm txheej tsis raug mob. Yog tias, tom qab tag nrho, tsis muaj zuam ntawm qhov no, ces nws yuav tsum tau xaiv. Yog hais tias txhua yam yog zoo, thiab nws yog ntsia, ces cia li nias ntawm khawm "OK"nyob hauv qab ntawm qhov rais.
- Tsis tas li ntawd, raws li nyob rau hauv cov ntaub ntawv dhau los, nias lub khawm "Tiv thaiv daim ntawv"nyob rau ntawm tab "Kev Tshawb Xyuas".
- Zoo sib xws, txoj kev dhau los qhib qhov rais nkag teb chaws. Tab sis lub sij hawm no peb yuav tsum tsis xyuas qhov kev xaiv "Qee cov qia ntshav". Yog li, peb yuav txwv qhov kev ua tiav ntawm txoj haujlwm no rau ntawm ntau qhov kev xaiv. Tom qab ntawd sau tus password thiab nias rau ntawm lub pob "OK".
- Nyob rau hauv lub qhov rais tom ntej, as Well as kawg lub sij hawm, peb rov ua dua lo lus zais thiab nias rau ntawm lub pob "OK".
Tam sim no nyob rau yav dhau los ntawm daim ntawv, peb yuav tsis yog tsis muaj peev xwm saib tau cov ntsiab lus ntawm cov dej num hauv lub hlwb, tab sis txawm cia li xaiv lawv. Thaum koj sim ua qhov xaiv, cov lus yuav tshwm sim qhia tias qhov ntau yog kev tiv thaiv los ntawm cov kev hloov.
Yog li, peb pom tias koj tuaj yeem tua cov kev tso cai hauv lub mis thiab hauv ncaj qha ntawm ob txoj hauv kev. Nyob rau hauv cov ntsiab lus qiv, tsuas yog cov qauv raug muab zais, raws li ib qho ntxiv feature koj tuaj yeem tsim ib qho txiav npluav rau lawv qhov kev kho. Qhov thib ob txoj kev pom tau hais tias muaj ntau txoj kev txwv tsis pub muaj. Siv cov nplaum xwb tsis muaj peev xwm los saib cov ntsiab lus lossis hloov nws, tab sis txawm xaiv lub xov tooj ntawm tes. Qhov twg ntawm ob txoj kev xaiv no yog nyob ntawm, thawj zaug ntawm tag nrho cov, ntawm kev paub tab. Txawm li cas los xij, feem ntau, qhov kev xaiv thawj zaug tau txais kev tiv thaiv zoo ntawm kev tiv thaiv, thiab thaiv cov kev xaiv yog feem ntau yog qhov ntsuas tsis tseem ceeb.
