4 Txoj hauv kev los tiv thaiv daim ntawv Excel

Cov txheej txheem:

4 Txoj hauv kev los tiv thaiv daim ntawv Excel
4 Txoj hauv kev los tiv thaiv daim ntawv Excel

Video: 4 Txoj hauv kev los tiv thaiv daim ntawv Excel

Video: 4 Txoj hauv kev los tiv thaiv daim ntawv Excel
Video: Python! Writing pandas DataFrames to Multiple Tabs in a Spreadsheet 2024, Lub peb hlis ntuj
Anonim

Qhov wikiHow qhia koj li cas los tiv thaiv ib nplooj ntawv hauv Microsoft Excel phau ntawv ua haujlwm hauv Windows lossis macOS. Yog tias daim ntawv tau tiv thaiv los ntawm tus lej nkag thiab koj tsis paub meej tias nws yog dab tsi, koj tuaj yeem siv Google Ntawv lossis VBA tsab ntawv (hauv Excel ua ntej ua ntej) kom tshem kev tiv thaiv.

Yog tias koj phau ntawv Excel tseem raug tiv thaiv thiab koj tsis tuaj yeem qhib nws, kab lus Rov pib dua, Tshem tawm thiab Rov Qab Lo Lus zais ntawm Excel Cov Ntaub Ntawv yuav pab koj.

Cov kauj ruam

Txoj Kev 1 ntawm 4: Siv Microsoft Excel

6297644 1
6297644 1

Kauj Ruam 1. Qhib phau ntawv ua haujlwm nrog daim ntawv tiv thaiv hauv Microsoft Excel

Feem ntau koj tuaj yeem ua qhov no los ntawm ob npaug nyem rau ntawm lub npe ntawm koj lub computer.

6297644 2
6297644 2

Kauj Ruam 2. Txoj cai-nias lub tab rau daim ntawv tiv thaiv

Txhua daim ntawv tab pom nyob hauv qab ntawm Excel. Cov ntawv tiv thaiv feem ntau muaj lub cim ntsuas phoo hauv qee qhov hloov pauv ntawm Excel. Right-click lub tab (lossis lub cim xauv) kom qhib cov ntawv qhia zaub mov.

Yog tias muaj ntau daim ntawv raug tiv thaiv, koj yuav tsum tshem kev tiv thaiv ntawm txhua daim ntawv cais

6297644 3
6297644 3

Kauj Ruam 3. Nyem Unprotect Sheet

Yog tias daim ntawv tsis tiv thaiv tus password, nws yuav qhib tam sim. Yog tias tsis yog, koj yuav raug hais kom nkag mus rau tus password rau hauv lub qhov rai pop-up.

6297644 4
6297644 4

Kauj Ruam 4. Sau tus password thiab nyem OK

Yog tias lo lus zais raug, daim ntawv yuav dhau los tiv thaiv.

  • Yog tias koj tsis paub tus password, saib Siv Txoj Cai Google Sheets. Txoj hauv kev no cia koj rub cov ntawv mus rau Google Ntawv, uas tshem tawm txhua qhov kev tiv thaiv ntxiv hauv Excel.
  • Yog tias koj siv Excel 2010 lossis ua ntej thiab xav kom tsis txhob upload rau Google Sheets, saib Kev Siv VBA Code hauv Excel 2010 thiab Txheej Txheem Ua Ntej.

Txoj Kev 2 ntawm 4: Tshaj Tawm rau Google Cov Ntawv

6297644 5
6297644 5

Kauj Ruam 1. Mus rau https://drive.google.com hauv lub vev xaib

Yog tias koj muaj Google tus lej, koj tuaj yeem siv Google Cov Ntawv (pub dawb online app uas zoo ib yam li Excel) tshem tawm kev tiv thaiv los ntawm txhua nplooj ntawv hauv phau ntawv ua haujlwm-txawm tias koj tsis paub tus password.

  • Yog tias koj tseem tsis tau kos npe rau hauv koj tus lej Google, ua raws li cov lus qhia ntawm lub vijtsam kom nkag mus tam sim no.
  • Yog tias koj tsis muaj Google account, saib Yuav Ua Li Cas Rau Google Account.
6297644 6
6297644 6

Kauj ruam 2. Nyem + Tshiab

Nws nyob ntawm kaum sab laug saum toj ntawm nplooj ntawv.

6297644 7
6297644 7

Kauj Ruam 3. Nyem File Upload

Qhov no qhib koj lub computer's Open panel.

6297644 8
6297644 8

Kauj Ruam 4. Xaiv Excel cov ntaub ntawv koj xav kho thiab nyem Qhib

Qhov no uploads cov ntaub ntawv rau koj Google Drive.

6297644 9
6297644 9

Kauj Ruam 5. Nyem ob npaug rau Excel cov ntawv hauv koj Google Drive

Koj yuav zaum tau nqes los nrhiav nws. Qhov no qhib qhov saib ua ntej ntawm cov ntawv.

6297644 10
6297644 10

Kauj Ruam 6. Nyem Qhib nrog cov ntawv qhia zaub mov

Nws nyob rau sab saum toj ntawm kev saib ua ntej. Cov ntawv qhia zaub mov yuav nthuav dav.

6297644 11
6297644 11

Kauj Ruam 7. Nyem Google Ntawv

Tam sim no cov ntaub ntawv tau qhib rau kev kho hauv Google Sheets, ib daim ntawv tiv thaiv ntxiv hauv Excel tau raug tshem tawm.

6297644 12
6297644 12

Kauj Ruam 8. Rov rub cov ntawv rau hauv koj lub computer

Yog tias koj xav khaws ua haujlwm ntawm cov ntawv hauv Microsoft Excel ntau dua li Google Ntawv, koj tuaj yeem rub tawm qhov tshiab uas tsis muaj kev tiv thaiv ntawm koj phau ntawv ua haujlwm siv cov theem hauv qab no:

  • Nyem rau Cov ntawv qhia zaub mov ntawm lub ces kaum sab saud sab saud ntawm koj daim ntawv.
  • Nyem Download Raws li.

  • Nyem Microsoft Excel (.xlsx).
  • Xaiv ib daim nplaub tshev kom txuag cov ntawv. Yog tias koj xav khaws cov ntawv qub ntawm cov ntawv (ib qho uas muaj daim ntawv tiv thaiv) zoo, ntaus lub npe tshiab rau cov ntawv ib yam.
  • Nyem Txuag mus download tau cov ntaub ntawv.

Txoj Kev 3 ntawm 4: Siv kev pabcuam online

6297644 23
6297644 23

Kauj Ruam 1. Tshawb nrhiav "tus password nrhiav hauv online" thiab nrhiav kev pabcuam tshem tus password online

6297644 24
6297644 24

Kauj ruam 2. Nyem rau "Unprotect your file"

6297644 25
6297644 25

Kauj Ruam 3. Nyem "Xauj" thiab xaiv cov ntawv tiv thaiv

6297644 26
6297644 26

Kauj Ruam 4. Xaiv "Tshem tus password" khawm xov tooj cua

6297644 27
6297644 27

Kauj Ruam 5. Tos thaum qhov kev pabcuam tshem koj tus password

6297644 28
6297644 28

Kauj Ruam 6. Rub tawm cov ntawv uas tsis muaj kev tiv thaiv, yog tias koj cov ntaub ntawv me me

6297644 29
6297644 29

Kauj Ruam 7. Rub tawm qhov demo-file yog tias koj cov ntaub ntawv loj

Txhawm rau kom tau txais tag nrho cov ntawv, koj yuav tsum nkag mus rau daim ntawv tso cai.

Txoj Kev 4 ntawm 4: Siv VBA Code hauv Excel 2010 thiab Yav dhau los

6297644 13
6297644 13

Kauj Ruam 1. Qhib phau ntawv ua haujlwm uas muaj daim ntawv tiv thaiv hauv Excel

Feem ntau koj tuaj yeem ua qhov no los ntawm ob npaug nyem rau ntawm lub npe ntawm koj lub computer. Cov ntaub ntawv Excel feem ntau xaus nrog cov ntawv txuas ntxiv.xls lossis.xlsx.

  • Siv txoj hauv kev no yog tias koj twb tau sim qhib ib daim ntawv tab sis pom tias nws tau tiv thaiv tus password (thiab koj tsis paub tus password).
  • Txoj kev no yuav tsis ua haujlwm hauv Excel 2013 lossis tom qab.
6297644 14
6297644 14

Kauj ruam 2. Rov khaws cov ntaub ntawv hauv xls hom

Yog tias cov ntawv koj tab tom ua haujlwm muaj qhov ".xlsx" txuas ntxiv (ntau yog tias nws tau tsim lossis kho dua tshiab hauv Excel), koj tsuas yog tuaj yeem siv txoj hauv kev no yog tias koj xub hloov nws mus rau Excel 97- 2003 (.xls) hom ntawv. Nov yog yuav ua li cas:

  • Nyem rau Cov ntaub ntawv cov ntawv qhia zaub mov ntawm kaum sab xis saum toj.
  • Nyem Txuag As.
  • Mus rau daim nplaub tshev uas koj xav khaws cov ntawv.
  • Xaiv Excel 97-2003 (.xls) los ntawm "Txuag raws li hom" lossis "Cov Qauv Ntawv" cov ntawv qhia zaub mov.
  • Nyem Txuag.

    Ua raws li cov lus qhia ntawm lub vijtsam kom hloov pauv qhov tsim nyog.

6297644 15
6297644 15

Kauj Ruam 3. Nias Alt+F11 txhawm rau qhib Visual Basic Editor

6297644 16
6297644 16

Kauj Ruam 4. Nyem rau ntawm phau ntawv ua haujlwm lub npe cov ntaub ntawv hauv "Project - VBAProject" vaj huam sib luag

Nws nyob saum lub vaj huam sib luag sab laug. Xyuas kom tseeb tias koj nyem rau qhov xaiv uas muaj cov ntaub ntawv lub npe (xaus nrog ".xls"), uas yuav tsum nyob rau saum. Cov ntawv qhia zaub mov yuav nthuav dav.

6297644 17
6297644 17

Kauj Ruam 5. Nyem Ntxig rau ntawm cov ntawv qhia zaub mov

Lwm cov ntawv qhia zaub mov yuav nthuav dav.

6297644 18
6297644 18

Kauj Ruam 6. Nyem Module

Qhov no ntxig ib qho qauv tshiab uas koj yuav muab qee qhov chaws.

Kauj Ruam 7. Luam cov cai

Nyeem cov cai uas ua raws cov ntawv no, tom qab ntawd nyem Ctrl+C (PC) lossis ⌘ Command+C kom luam nws:

Sub PasswordBreaker () 'Ua txhaum daim ntawv ua haujlwm tiv thaiv tus password. Dim li As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Rov Mus Ntxiv Rau Kuv = 65 Rau 66: Rau j = 65 Rau 66: Rau k = 65 Rau 66 Rau l = 65 Rau 66: Rau m = 65 Rau 66: Rau i1 = 65 Rau 66 Rau i2 = 65 Rau 66: Rau i3 = 65 txog 66: Rau i4 = 65 txog 66 Rau i5 = 65 txog 66: Rau i6 = 65 txog 66: Rau n = 32 Rau 126 ActiveSheet. Unprotect Chr (i) & Chr (j) & Chr (k) & _ Chr (l) & Chr (m) & Chr (i1) & Chr (i2) & Chr (i3) & _ Chr (i4) & Chr (i5) & Chr (i6) & Chr (n) Yog ActiveSheet. ProtectContents = Cuav Ces MsgBox "Lo lus zais yog" & Chr (i) & Chr (j) & _ Chr (k) & Chr (l) & Chr (m) & Chr (i1) & Chr (i2) & _ Chr (i3) & Chr (i4) & Chr (i5) & Chr (i6) & Chr (n) Tawm Sub End Yog Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej kawg

6297644 20
6297644 20

Kauj Ruam 8. Right-click tus qauv tshiab thiab xaiv Paste

Cov cai theej tawm tam sim no tshwm nyob rau hauv lub qhov rai module.

6297644 21
6297644 21

Kauj Ruam 9. Nias F5 kom ua raws txoj cai

Tam sim no Excel yuav ua txoj cai, uas tuaj yeem siv sijhawm ob peb feeb. Thaum cov cai tau ua tiav, tus password tshiab yuav tshwm ntawm lub qhov rai pop-up.

Tus lej tshiab yuav yog tus lej "As" ntau dua li tus lej qub

6297644 22
6297644 22

Kauj ruam 10. Nyem OK ntawm tus Password pop-up

Tus lej tshiab yuav tshwm sim tab sis koj yuav tsis xav sau nws. Nyem OK yuav tshem daim ntawv tiv thaiv cia.

Yog tias koj yuav tsum hloov cov ntawv mus rau hom ntawv ua ntej, tam sim no koj tuaj yeem txuag phau ntawv ua haujlwm dua li.xlsx cov ntaub ntawv

Pom zoo: