Txheeb xyuas cov haujlwm hauv tus account yog yooj yim dua los sau siv kos npe sau los ntawm Microsoft Excel. Koj tuaj yeem teeb tsa daim tshev sau npe txhawm rau txheeb xyuas cov nuj nqis yog li koj tuaj yeem taug qab txhua qhov kev them nyiaj ntsuab. Koj tuaj yeem tsim tus lej txhawm rau nrhiav kom paub qhov nyiaj tshuav hauv tus as khauj. Dhau li muaj txiaj ntsig, los ntawm kev tsim daim tshev sau npe hauv Excel koj tseem tuaj yeem paub qhov pib ntawm Excel.
Kauj ruam
Ntu 1 ntawm 5: Tsim Kab hauv Excel
Kauj Ruam 1. Paub txog Excel
Excel yog daim ntawv nthuav qhia software siv los tswj cov ntaub ntawv thiab ua cov lej suav nrog cov qauv. Cov ntawv nthuav qhia Excel tau teeb tsa los ntawm kab thiab kab.
- Lub desktop version ntawm Excel tuaj yeem teeb tsa ntawm PC lossis Mac. Kuj tseem muaj cov online pub dawb rau koj lub khoos phis tawj, ntsiav tshuaj lossis xov tooj. Kev ua haujlwm ntawm txhua version tsuas yog sib txawv me ntsis.
- Excel tau nyob ib puag ncig ntev, thiab ib txwm muaj qhov hloov tshiab txhua xyoo. Txoj kev uas txhua version ua haujlwm tsuas yog sib txawv me ntsis.
- Hauv Excel, kab yog kab rov tav thiab txheeb los ntawm tus lej. Kab ntawv yog ntsug thiab txheeb los ntawm tsab ntawv. Cov xwmfab uas kab thiab kab sib ntsib tau hu ua cell. Cells muaj npe tom qab kab thiab kab. Lub xovtooj ntawm kab tsib hauv kab D hu ua D5 (kab D, kab 5).
- Paub qhov sib txawv ntawm daim ntawv ua haujlwm thiab phau ntawv ua haujlwm. Daim ntawv ua haujlwm yog Excel cov ntaub ntawv uas muaj ib lossis ntau daim ntawv teev npe. Txhua daim ntawv nthuav tawm yog nyob rau hauv tab sib cais hauv phau ntawv ua haujlwm. Phau ntawv ua haujlwm feem ntau muaj peb tabs, tab sis tuaj yeem ntxiv yog tsim nyog.
- Koj tuaj yeem yooj yim siv ib lub tab los tsim cov ntawv sau npe yooj yim.
- Koj yuav siv ob lub tab los tsim cov khoom thauj khoom ua haujlwm hauv daim tshev sau npe.
Kauj Ruam 2. Qhib daim ntawv teev npe dawb
Yuav ua li cas qhib daim ntawv nthuav qhia nyob ntawm lub operating system thiab hom computer uas koj siv.
- Rau PCs uas ua haujlwm ua haujlwm nyob rau hauv Windows 7, nyem rau Start menu hauv kaum sab laug-laug ntawm lub desktop. Los ntawm cov ntawv qhia zaub mov uas tshwm, nyem rau Programs. Los ntawm cov ntawv qhia zaub mov uas tshwm tom ntej, nyem Microsoft Office, tom qab ntawd nyem Microsoft Office Excel. Txij ntawm no mus ib daim ntawv dawb paug tshwm ntawm koj lub desktop.
- Rau PCs ntawm Windows 7 lossis tom qab, nyem lub Windows icon nyob rau hauv kaum sab laug ntawm lub vijtsam, tom qab ntawd nyem rau Microsoft Excel nplais kom qhib Excel. Yuav muaj nplooj ntawv qhia cov ntaub ntawv tshiab ntawm sab laug thiab cov ntaub ntawv tshiab cov qauv xaiv ntawm sab xis. Nyem rau thawj qhov kev xaiv tus qauv, Phau Ntawv Ua Haujlwm Dawb los qhib daim ntawv tshiab.
- Txhawm rau qhib Excel ntawm Mac, nyem Excel hauv qhov khoom. Nyem "File" hauv cov ntawv qhia zaub mov. Nyem "Qhib" ces nyem "Tshiab". Koj yuav raug coj mus rau daim ntawv teev npe tshiab tshiab.
Kauj Ruam 3. Tsim kab ntawv
Siv daim ntawv lo uas feem ntau pom muaj hauv phau ntawv teev npe tshuaj xyuas. Tsim kab rau hnub tim, tsis muaj. kos, tus neeg them nyiaj, thiab kev piav qhia lossis memo. Tom qab ntawd tsim kab rau cov nuj nqis (piv txwv li kev them nyiaj lossis rho tawm), cov qhab nia (piv txwv li tso nyiaj) thiab cov nyiaj tshuav tom ntej.
- Sau "DATE" hauv cell B1 (kem B, kab 1). Hnub ua lag luam tau nkag rau ntawm no.
- Tsiv ib lub xov tooj mus rau sab xis, cell C1 (kem C, kab 1). Ntaus "ITEM #". Tus lej kos lossis hom kev pauv pauv tau nkag rau ntawm no, xws li "ATM" lossis "tso nyiaj".
- Tsiv ib lub xov tooj mus rau sab xis, cell D1 (kem D, kab 1). Ntaus hauv "PAYEE". Nov yog lub npe ntawm tus neeg txais daim tshev lossis tus neeg them nyiaj.
- Tsiv ib lub xov tooj mus rau sab xis, cell E1 (kem E, kab 1). Ntaus "DESCRIPTION". Cov ntsiab lus hais txog kev sib pauv tau nkag rau ntawm no.
- Tsiv ib lub xov tooj mus rau sab xis, cell F1 (kem F, kab 1). Ntaus "DEBIT". Cov nyiaj uas tawm ntawm tus as khauj (tawm mus) tau sau tseg ntawm no.
- Tsiv ib lub xov tooj mus rau sab xis, cell G1 (kem G, kab 1). Ntaus "EXPENSE CATEGORY". Tso qhov no tseg ua ntej. Cov kem xaiv no yuav raug tsim nyob rau theem tom ntej.
- Tsiv ib lub xov tooj mus rau sab xis, cell H1 (kem H, kab 1). Ntaus "CREDIT". Cov nyiaj uas nkag mus rau hauv tus as khauj (txhab nyiaj) tau sau tseg ntawm no.
- Tsiv ib lub xov tooj mus rau sab xis, cell J1 (kem J, kab 1). Ntaus "INCOME CATEGORY". Cov kab ntawv xaiv no tseem yuav raug tsim nyob rau qib tom ntej.
- Tsiv ib lub xov tooj mus rau sab xis, cell K1 (kem K, kab 1). Ntaus "BALANCE". Qhov no yog tus lej hauv tus account tom qab txhua qhov kev pauv pauv tau teev tseg.
Kauj Ruam 4. Hom ntawv kab ntawv
Ntxiv cov ntawv rau daim ntawv lo rau hauv kab ntawv tuab thiab muab cov ntawv sau npe kab sib txawv xim tom qab kom yooj yim nyeem. Ua ntej, xaiv thaj tsam ntawm cov cell koj xav ua hom ntawv, tom qab ntawd xaiv hom kev xaiv.
- Saib rau cov txheej txheem xaiv hauv "HOME" tab ntawm kab ntawv toolbar. Qhov "HOME" tab no twb tau qhib thaum koj qhib phau ntawv ua haujlwm tshiab.
- Xaiv cell B1 (DATE) tom qab ntawd rub tus cursor ntawm txhua daim ntawv cim mus txog ntawm cell K1 (BALANCE).
- Nyob rau sab saum toj sab laug ntawm lub cuab yeej, nyem "B" txhawm rau xaiv hom ntawv tawv.
- Nyem lub cim xim xim kom pom cov xim tom qab kom hloov xim tom qab.
Kauj Ruam 5. Hloov kho ntau kab
Feem ntau kab ntawv me me dhau los khaws cov ntaub ntawv koj nkag mus. Piv txwv, kab ntawv "PAYEE" thiab "DESCRIPTION" tuaj yeem tuav cov npe ntev lossis cov cim ntev. Kem A tsuas yog ua haujlwm sib cais, yog li nws qhov loj me me.
- Nyem rau kab ntawv kab ntawv A kom xaiv tag nrho kab ntawv. Nyob rau sab xis saum toj ntawm lub cuab yeej ntawm "HOME" ribbon, nyem rau "FORMAT" khawm. Los ntawm cov ntawv qhia zaub mov nco, nyem "Kab Dav", sau 2 ces nyem OK. Kab A yuav nqaim heev.
- Nthuav kab D, "PAYEE". Nyem rau kab lus header hauv kab D kom xaiv kab ntawv ntawd. Hover hla ciam teb ntawm kab D thiab E. Tus cursor yuav hloov mus rau tus cursor hloov pauv, nrog cov duab zoo li cov cim ntxiv nrog tus xub taw qhia. Thaum pom tus cursor no, nyem sab laug thiab rub tus nas mus rau sab xis kom ua kab kom dav raws li koj xav tau.
- Rov ua cov txheej txheem qub kom nthuav dav E, "DESCRIPTION".
Kauj Ruam 6. Nruab daim ntawv rau npe
Xaiv tag nrho thawj kab. Sab laug-nyem tus lej ib ntawm sab laug ntawm nplooj ntawv. Nyob rau sab saud sab laug ntawm lub cuab yeej ntawm "HOME" ribbon, nyem rau kab ntawv nruab nrab. Txhua cov ntaub ntawv hauv cov xov tooj uas tau xaiv yuav yog nyob hauv nruab nrab. Cov ntawv cim kab hauv txhua lub cell tam sim no nyob rau nruab nrab.
Ntu 2 ntawm 5: Kev Hloov Cov Xov Tooj
Kauj Ruam 1. Sau Ib co ntaub ntawv
Txhawm rau pom cov kev hloov pauv hloov pauv, nkag mus rau plaub kab ntawm cov ntaub ntawv rau hauv cov cell. Pib nrog qhov pib tshuav, tom qab ntawd nkag mus rau lwm qhov kev sib pauv.
- Ntxiv hnub rau qhib qhov sib npaug rau hauv cell B2, piv txwv li 9/27/15. Hauv kab ntawv "PAYEE" hauv cell D2, ntaus "Qhib Tshuav". Hauv kab "BALANCE" hauv cell K2, sau cov nyiaj hauv koj tus as khauj raws li hnub tim hauv cell B2.
- Ntxiv peb qhov kev lag luam ntxiv. Ua ke cov nyiaj rho tawm (xws li txheeb xyuas cov nyiaj them lossis rho nyiaj ATM) thiab qiv nyiaj qiv (xws li tso nyiaj).
- Pom daim ntawv tsis sib xws ntawm txhua tus lej hauv lub cell. Hnub ntawv hom ntawv yuav hloov mus rau "2015/09/27" lossis "27-Sept". Tus lej nyiaj daus las tuaj yeem qhia tus lej tsis raug ntawm cov lej zauv. Format nws kom txhua yam huv si.
Kauj Ruam 2. Hom hnub tim
Nco ntsoov tias kab ntawv no qhia hnub sib xws. Muaj ntau txoj kev xaiv rau kev sau hnub tim hauv Excel. Xaiv tus twg uas koj xav tau.
- Nyem lub taub hau hauv kab B, uas yog "DATE". Tag nrho kem yuav raug xaiv.
- Txoj cai-nyem rau ntawm kab ntawv thiab xaiv Format Cells. Lub Format Cells window yuav tshwm.
- Xaiv lub tab "Numbers". Xaiv "Hnub" hauv "Pawg". Xaiv hnub ntawv hom uas koj xav tau thiab nyem OK hauv lub kaum sab xis ntawm lub qhov rais.
- Thaum lub kem tseem raug xaiv, nruab nrab cov ntaub ntawv hauv cov cell no los ntawm txhaj rau lub cim nruab nrab nyob rau sab saum toj-sab laug ntawm lub cuab yeej, hauv kab "HOME".
Kauj Ruam 3. Format Column "ITEM #"
Cov ntaub ntawv hauv kab lus no yuav tsum yog nyob hauv nruab nrab. Nyeem tag nrho kab ntawm C los ntawm txhaj rau kab ntawv kab ntawv. Nyem qhov chaw nruab nrab icon. Ua tib zoo saib cov ntaub ntawv uas tau nkag rau hauv kab lus no. Kev sau ntawv yuav tsum yog nyob hauv nruab nrab.
Txheeb xyuas cov qauv ntawm kab D thiab E, "PAYEE" thiab "DESCRIPTION". Excel feem ntau tawm tswv yim cov cell kom cov ntaub ntawv raug tso ua ke. Hom ntawv no yuav haum rau kab ntawv no. Txheeb xyuas ob kab ntawv loj. Tam sim no muaj qee cov ntaub ntawv hauv cov xov tooj no, yog li hloov kho kab dav kom cov kem dav dua lossis nqaim dua, raws li xav tau
Kauj Ruam 4. Hloov cov txiaj hauv kab F, H thiab K, lossis "DEBIT," "CREDIT" thiab "BALANCE FORWARD"
Txiaj siv ob tug lej zauv. Muaj qhov kev xaiv los teeb tsa tus lej kos npe. Tus lej rho nyiaj tseem tuaj yeem ua liab yog tias koj xav tau.
- Xaiv kem F. Right-click hauv kab F thiab xaiv Format Cells. Lub Format Cells window yuav tshwm. Hauv tab "Tus lej", xaiv "Accounting". Xaiv "2" hauv qhov "Decimal places" xaiv. Xaiv cov nyiaj daus las kos npe hauv "Cim".
- Rov ua cov kauj ruam saum toj no rau kab H thiab K.
- Txhawm rau ua tus lej debit zoo li liab, nyem lub taub hau hauv kab F kom xaiv tag nrho kab. Txoj cai-nyem rau ntawm kab ntawv thiab xaiv Format Cells. Xaiv Font tab thaum lub Format Cells window tshwm. Ntawm lub tab no, nyem qhov nco-down nyob ib sab ntawm Cov Xim xaiv. Los ntawm cov palette, nyem rau xim liab.
Ntu 3 ntawm 5: Tsim Cov Qauv
Kauj Ruam 1. Tsim ib lub mis los xam qhov nyiaj tshuav tam sim no
Nkag mus rau tus lej lej ua haujlwm kom suav qhov sib npaug tam sim no hauv kab K. Koj tsis xav tau cov mis hauv cell K2. Koj qhov nyiaj tshuav pib tau nkag ntawm no.
- Nyem cell K3. Nyem rau kab ntawv formula nyob rau sab saum toj ntawm daim ntawv nthuav qhia. Ntaus hauv cov mis kom ua qhov suav. Nkag mus = SUM (K2-F3+H3). Cov mis no qhia rau daim ntawv nthuav qhia kom qhib qhov sib npaug (cell K2), rho cov nuj nqis yog tias muaj (cell F3), thiab ntxiv cov qhab nia yog tias muaj (cell H3).
- Yog tias qhib qhov nyiaj tshuav yog $ 200, thiab koj thawj zaug nkag yog kos rau $ 35, sau $ 35 raws li daim debit hauv cell F3. Cov mis koj tau nkag rau hauv cell H3 siv thawj qhov nyiaj tshuav thiab rho tawm tus nqi deb kom qhov nyiaj tshuav yog $ 165.
Kauj Ruam 2. Luam cov mis
Xaiv cell K3. Right -click thiab xaiv Luam. Xaiv cov cell K4 thiab K5, tom qab ntawv nyem rau thiab xaiv Muab tshuaj txhuam. Tam sim no tus qauv raug theej rau cov cell no. Tam sim no qhov nyiaj tshuav tam sim no tau suav hauv kab K rau txhua cov ntaub ntawv kab uas tau nkag mus.
Kauj Ruam 3. Tsim kom muaj tus lej raug cai txhawm rau tshem tawm kab seem tam sim no
Koj tuaj yeem luam cov qauv saum toj no rau cell K6. Txawm li cas los xij, txij li koj tsis tau nkag mus rau ib qho ntaub ntawv, qhov nyiaj tshuav tam sim no los ntawm cell K5 tseem yuav tshwm sim hauv cell K6. Txhawm rau tshem tawm qhov no, tsim cov qauv muaj txiaj ntsig uas yuav tshem tawm lub xov tooj ntawm tes yog tias tsis muaj kev hloov pauv nkag, tab sis yuav tso tawm qhov nyiaj tshuav yog tias muaj ib qho.
Hauv cell K6, sau cov mis = YOG (ISBLANK (B6), "", SUM (K5-F6+H6)). Qhov no yuav qhia rau Excel tias yog cell B6 hauv kab ntawv "DATE" tsis muaj dab tsi, cell H6 yuav tsum tsis muaj dab tsi, tab sis yog tias cell B6 tsis khoob, qhov nyiaj tshuav yuav tsum tau suav
Kauj Ruam 4. Nthuav cov mis nrog AutoFill
Qhov AutoFill muaj peev xwm ua tiav cov qauv ntawm cov cell uas nyob ib sab yog li tsis tas yuav nkag mus rau "BALANCE" cov mis ntau zaus.
- Saib rau AutoFill qib hauv lub cell nquag. Saib cov duab plaub me me nyob rau hauv kaum sab xis ntawm lub cell nquag. Hover hla kom txog thaum nws hloov mus rau AutoFill tus cursor, uas zoo li nyias ntxiv.
- Nyem rau ntawm tes K6. Hover hla tus AutoFill qib thiab tus cursor yuav hloov mus rau qhov nyias nyias ntxiv rau. Nyem rau sab laug thiab tuav lub AutoFill qib. Luag tus cursor rau cell K100 (kem K, kab 100).
- Tam sim no tus lej raug theej rau txhua lub cell kem K txog kab 100. Kab thiab kab lej hauv txhua lub xov tooj tau hloov kho kom tus lej tuaj yeem suav qhov raug.
Ntu 4 ntawm 5: Ntxiv Pawg
Kauj Ruam 1. Tsim kev lag luam
Cov pawg lag luam muaj txiaj ntsig zoo rau kev taug qab cov nyiaj tawm thiab cov nyiaj tau los. Pawg tuaj yeem cuam tshuam nrog se cov nyiaj tau los, xws li se vaj tse lossis kev pub dawb pub dawb. Pawg kuj tseem tuaj yeem siv los tsim cov kab kos uas pom tau yooj yim ntawm tus as khauj cov nyiaj txiag.
Kauj Ruam 2. Tsim "Pawg" tab
Cov ntawv no tau siv los khaws txhua pawg muaj peev xwm ntawm cov nyiaj tau los thiab cov nuj nqis sau npe txheeb xyuas. Hloov pauv ib qho ntawm cov tab hauv "Pawg" phau ntawv ua haujlwm. Nyem ob npaug rau lub npe tab uas twb muaj lawm kom nws ua kom pom lub npe. Lub npe yuav hloov mus rau "Sheet2" lossis "Sheet3". Thaum daim ntawv lub npe tau hais meej, ntaus lub npe tshiab rau lub tab, xws li "Pawg".
Hauv cell B4, ntaus "Pawg". Format lub cell kom ua siab loj thiab nruab nrab lawv
Kauj Ruam 3. Tsim pawg nyiaj tau los
Ntaus "*** Cov Nyiaj Tau Los ***" hauv cell B5. Txhua pawg ntawm cov nyiaj tau los uas koj muaj lossis tuaj yeem tau txais txiaj ntsig los ntawm yav tom ntej tau suav nrog ntawm no. Nkag mus rau tag nrho koj cov nyiaj tau los pib los ntawm cell B6 thiab ua haujlwm koj txoj hauv kev.
- Cov nyiaj khwv tau los feem ntau yog "Nyiaj Ua Haujlwm" (nyiaj hli). Txheeb cais pawg nyiaj them sib txawv yog tias muaj ntau dua ib txoj haujlwm.
- Koj qhov xwm txheej nyiaj txiag yog txiav txim siab rau lwm pawg nyiaj tau los. Tsim cov "Dividend" qeb yog koj muaj tswv. Kuj tsim pawg pab menyuam yog tias tsim nyog. Lwm pawg xws li "Cov Nyiaj Tau Los," "Khoom Plig", thiab "Lwm Yam".
Kauj Ruam 4. Tsim pawg pawg
Tshem cov cell hauv qeb nyiaj tau los kawg. Txav mus rau ib lub cell thiab tom qab ntawd ntaus "*** Cov Nqi ***". Txhua pawg thauj khoom muaj nyob hauv ntu no.
Tus naj npawb ntawm cov khoom thauj khoom tau raug kho raws li koj qhov xwm txheej, suav nrog "Mortgage," "Rent," "Insurance," "Car Payment," "Gas," "Electricity," "Phone", lossis "Entertainment"
Kauj Ruam 5. Muab lub npe rau ntawm cov kab mob uas muaj cov qeb
Xaiv cell B5, tom qab ntawd nthuav tawm los ntawm cell B5 rau txhua qhov nyiaj tau los thiab pab pawg. Saib rau lub npov lub npe ntawm lub cell nyob rau sab saud sab laug ntawm lub qhov rais, uas yog rau sab laug ntawm lub npov mis. Lub npe ntawm thawj lub xovtooj ntawm qhov tseem ceeb yuav tshwm "B5". Nyem rau ntawm lub npe cell box thiab ntaus "Pawg". Nov yog lub npe ntawm thaj tsam ntawm cov cell uas koj tuaj yeem siv hauv daim tshev sau npe.
Kauj Ruam 6. Siv cov nuj nqis thiab pawg nyiaj tau los hauv daim tshev sau npe
Rov qab mus rau lub tab koj tsim daim tshev sau npe. Tam sim no kab ntawv "EXPENSE CATEGORY" thiab "INCOME CATEGORY" yuav muab ntxiv rau hauv cov ntawv qhia zaub mov nco.
- Xaiv cell G2 hauv qhov kos npe tab kos. Nov yog thawj lub xov tooj ntawm kab ntawv "EXPENSE CATEGORY".
- Xaiv "DATA" ribbon hauv qhov toolbar. Nyem rau "Cov ntaub ntawv pov thawj" khawm. Xaiv "Cov ntaub ntawv pov thawj" los ntawm cov ntawv qhia zaub mov nco-down. Lub qhov rai "Txheeb Xyuas Cov Ntaub Ntawv" yuav qhib.
- Ntawm qhov "Settings" tab ntawm "Data Validation" window, nrhiav qhov "Allow" drop-down box. Nyem rau kab xub thiab xaiv "Sau". Nkag mus "= Pawg" hauv qab "Source". nyem OK
- Ib lub xub me me yuav tshwm nyob ib sab ntawm cell G2. Nyem qhov xub no los tso saib cov npe teev tseg. Nyem rau qeb uas sib haum rau kab kev sib pauv.
- Luam cov qauv ntawm cell G2 rau cell G100 siv AutoFill.
- Mus rau ntawm cell J2 kom rov ua cov txheej txheem hauv kab "INCOME CATEGORY".
Ntu 5 ntawm 5: Tiv Thaiv Tus Kheej Sau Npe
Kauj Ruam 1. Xauv cov qauv mis thiab tiv thaiv daim ntawv nthuav tawm
Tiv thaiv daim ntawv ua haujlwm txhais tau tias koj tsis tuaj yeem sau cov ntaub ntawv hauv cov cell xauv yog li koj tsis tas yuav txhawj xeeb txog yav tom ntej kev suav suav tsis raug vim yog cov mis tsis raug. Koj kuj tseem tuaj yeem ntxiv tus password los ua koj daim ntawv sau npe tiv thaiv ntau dua los ntawm lwm cov neeg siv. Xyuas kom tus password nkag tau yooj yim, lossis sau nws rau hauv qhov chaw nyab xeeb. Daim ntawv ua haujlwm yuav nkag tsis tau yog tias koj hnov qab koj tus password.
Kauj Ruam 2. Xauv lub xovtooj
Thaum daim ntawv ua haujlwm raug tiv thaiv, txhua lub cell yuav raug kaw. Yog li, koj yuav tsum qhib cov ntaub ntawv xov tooj kom nkag mus, txawm tias daim ntawv ua haujlwm raug tiv thaiv.
- Xaiv cov cell B2 rau J100. Cov no yog txhua lub cell ntawm txhua qhov txheeb xyuas sau npe, tshwj tsis yog kab ntawv kawg, K, uas yog kab ntawv "BALANCE". Cov ntaub ntawv tseem yuav tsum tau nkag mus rau hauv cov cell no txawm tias daim ntawv ua haujlwm raug tiv thaiv.
- Hauv qhov xaiv ntau ntawm cov cell, txoj cai-nyem. Xaiv Format Cells.
- Hauv Format Cells window, xaiv Kev Tiv Thaiv tab. Uncheck lub thawv "Xauv" ces nyem OK.
Kauj Ruam 3. Pab Kev Tiv Thaiv ntawm daim ntawv ua haujlwm
Qhov no txhais tau tias txhua lub cell yuav raug kaw, suav nrog cov cell hauv kab K ("BALANCE") yog li lawv tsis tuaj yeem sau dua.
- Qhib "REVIEW" ribbon hauv qhov toolbar. Nyem "Tiv Thaiv Ntawv" kom coj mus rau "Tiv Thaiv Ntawv" qhov rai.
- Yog tias koj xav tiv thaiv daim ntawv ua haujlwm, ntxiv tus password ntawm no. Yog tsis yog, tso nws tseg.
- nyem OK Tshawb xyuas cov npe tam sim no tsis muaj kev tiv thaiv.
Kauj Ruam 4. Unprotect daim ntawv ua haujlwm txhawm rau hloov pauv cov cell xauv
Koj tuaj yeem thim cov txheej txheem no tom qab yog tias koj xav hloov cov qauv hauv lub xovtooj kaw. Qhib "REVIEW" ribbon hauv qhov toolbar. Nyem "Unprotect Sheet" kom txog rau thaum "Unprotect Sheet" qhov rai tshwm. nyem OK
