Cov txheej txheem:

Kuv yuav tsis tiv thaiv phau ntawv ua haujlwm Excel hauv Windows 10 li cas?
Kuv yuav tsis tiv thaiv phau ntawv ua haujlwm Excel hauv Windows 10 li cas?

Video: Kuv yuav tsis tiv thaiv phau ntawv ua haujlwm Excel hauv Windows 10 li cas?

Video: Kuv yuav tsis tiv thaiv phau ntawv ua haujlwm Excel hauv Windows 10 li cas?
Video: yuav tau tsim kho tus kheej lub neej thiaj yuav vam meej tau 2024, Tej zaum
Anonim

Cov kauj ruam

  1. Qhib lub phau ntawv ua haujlwm nrog ib daim ntawv tiv thaiv hauv MicrosoftExcel . Feem ntau koj tuaj yeem ua qhov no los ntawm ob-nias cov ntaub ntawv lub npe ntawm koj lub computer.
  2. Right-click lub tab rau daim ntawv tiv thaiv. Txhua daim ntawv tabappears raws hauv qab ntawm Excel .
  3. Nyem Tsis tiv thaiv Daim ntawv.
  4. Sau tus password thiab nyem OK.

Kuj paub, koj yuav tshem tawm kev tiv thaiv los ntawm Excel li cas?

Qhib lub phau ntawv ua haujlwm uas koj xav hloov los yog tshem tawm tus password rau. Nyob rau ntawm Saib Xyuas tab, nyem Tiv thaiv Daim ntawv los yog Tiv thaiv Phau Ntawv Qhia . Nyem UnprotectSheet los yog Tiv thaiv Phau Ntawv Qhia thiab sau tus password. Nyem Unprotect Sheet yuav tshem tawm tus password ntawm daim ntawv.

Ib yam li ntawd, kuv yuav tiv thaiv phau ntawv ua haujlwm li cas hauv Excel 2010 yam tsis muaj tus password? Tshuaj 1: Unprotect Excel 2010 Cov ntaub ntawv tsis muaj Password siv VBA Code

  1. Ib lub thawv sib tham yuav tshwm nyob rau hauv txoj cai pane.
  2. Tam sim no nyem rau ntawm Run khawm kom ua tiav code.
  3. Koj yuav raug ceeb toom raws li tus password tau tawg.
  4. Siv 7-Zip software qhib koj cov ntaub ntawv thiab mus rau xl>workbook.xml thiab qhib lossis rho tawm workbook. XML cov ntaub ntawv.

Ib yam li ntawd, yuav ua li cas kuv thiaj li tiv thaiv Excel phau ntawv ua haujlwm yam tsis muaj tus password 2016?

Ua li no, ua raws li cov txheej txheem hauv qab no. Kauj ruam 1: Nkag mus rau qhov chaw ntawm lub Excel file thiab qhib lub Excel ntaub ntawv. Kauj ruam 2: Nyem Xyuas nyob rau hauv lub ribbon ces, nyob rau hauv lub Hloov pab pawg, nyem Tsis tiv thaiv daim ntawv . Kauj ruam 3: Nkag mus rau Unprotect Sheet password hauv lub dialog box uas tshwm thiab nyem OK.

Yuav ua li cas koj qhib ib tug spreadsheet?

Xauv lossis qhib qhov chaw tshwj xeeb ntawm daim ntawv tiv thaiv

  1. Ntawm Kev Tshawb Xyuas tab, nyem Unprotect Sheet (hauv Cov Pab Pawg Hloov). Nyem lub khawm Tiv Thaiv Daim Ntawv kom Tsis Tiv Thaiv Daim Ntawv thaum daim ntawv ua haujlwm raug tiv thaiv.
  2. Yog tias muaj lus nug, sau tus password kom tsis txhob tiv thaiv daim ntawv ua haujlwm.

Pom zoo: