Cov txheej txheem:

Koj puas tuaj yeem tiv thaiv tus password excel?
Koj puas tuaj yeem tiv thaiv tus password excel?

Video: Koj puas tuaj yeem tiv thaiv tus password excel?

Video: Koj puas tuaj yeem tiv thaiv tus password excel?
Video: yuav tau tsim kho tus kheej lub neej thiaj yuav vam meej tau 2024, Hlis ntuj nqeg
Anonim

Kauj ruam 1: Hauv Excel , qhib cov ntaub ntawv koj xav kom ruaj ntseg nrog a tus password . Kauj ruam 2: Nyem Cov Ntaub Ntawv, ua raws li Cov Ntaub Ntawv. Kauj ruam 3: Tom ntej no, nyem qhov Tiv thaiv Phau ntawv khawm. Kauj Ruam 4: Excel ces mam hais koj ntaus ntawv a tus password.

Tsis tas li lo lus nug yog, koj puas tuaj yeem tiv thaiv tus password hauv Excel?

Rau tiv thaiv ib daim ntawv, xaiv a tab hauv koj Excel phau ntawv ua haujlwm, nyem rau ntawm Kev Tshawb Fawb tab thiab xaiv Tiv thaiv Daim ntawv qhia zaub mov xaiv. Qhov kev xaiv no tso cai rau kev tiv thaiv tshwj xeeb ntawm koj phau ntawv . Los ntawm lub neej ntawd, theoptions yuav luag tag nrho kaw qhov phau ntawv . Wb sadd a tus password thiaj li hais tias daim ntawv yog tiv thaiv.

Qhov thib ob, yuav ua li cas kuv xauv ib daim ntawv teev npe? Yuav Ua Li Cas Xauv Txhua Lub Cells hauv Excel Worksheet

  1. Coj mus rhaub rau Review tab.
  2. Nyem Tiv Thaiv Daim Ntawv.
  3. Nyem OK los tiv thaiv daim ntawv.
  4. Xaiv tag nrho cov hlwb uas koj tsis xav kom kaw.
  5. Txoj cai-nias ntawm koj xaiv, xaiv Format Cells, thiab nyem rau ntawm Kev Tiv Thaiv tab.

Tib neeg kuj nug, Kuv yuav tshem tus password li cas los qhib Excel cov ntaub ntawv?

Tshem tawm tus password phau ntawv ua haujlwm

  1. Qhib phau ntawv ua haujlwm uas koj xav tshem tawm tus password los ntawm.
  2. Ntawm Kev Tshawb Xyuas tab, hauv qab Kev Tiv Thaiv, nyem Passwords.
  3. Xaiv tag nrho cov ntsiab lus hauv tus password qhib lub npov lossis lub Passwordto hloov lub thawv, thiab tom qab ntawd nias DELETE.
  4. Nyem Txuag.

Yuav ua li cas tshem tawm Protected View hauv Excel yam tsis muaj lo lus zais?

Yuav ua li cas unprotect ib lo lus zais tiv thaiv worksheet

  1. Kauj ruam 1 Nias ALT + F11 los yog nyem Saib Code ntawm DevelopersTab.
  2. Kauj ruam 2 Ob npaug nyem rau ntawm daim ntawv ua haujlwm uas tiv thaiv tus password.
  3. Kauj ruam 3 Luam thiab paste cov cai hauv qab no rau hauv (Code) qhov rai.
  4. Kauj ruam 4 Nyem rau ntawm Run Button los yog nias F5.

Pom zoo: