Qee zaum thaum koj luam tawm Excel phau ntawv ua haujlwm, lub tshuab luam ntawv luam tawm tsis tsuas yog cov nplooj ntawv muaj cov nplooj ntawv, tab sis kuj tseem muaj daim ntawv tsis pom. Qhov no tuaj yeem tshwm sim rau ntau yam. Piv txwv li, yog tias koj txhob txwm ua ib qho cim nyob hauv thaj chaw ntawm nplooj ntawv no, txawm tias yog qhov chaw, nws yuav ntes rau kev luam ntawv. Lawm, qhov no cuam tshuam rau kev hnav ntawm lub tshuab luam ntawv, thiab tseem ua rau lub sijhawm poob. Ib qho ntxiv, muaj qee kis thaum koj tsis xav sau nplooj ntawv tshwj xeeb sau nrog cov ntaub ntawv thiab tsis xav luam nws, tab sis tshem tawm nws. Cia peb saib cov kev xaiv rau kev tshem tawm nplooj ntawv hauv Excel.
Nplooj Ntawv Tus Txheej Txheem
Ib daim ntawv ntawm Excel Workbook tau muab faib ua cov nplooj ntawv luam tawm. Lawv cov ciam teb nyob rau tib lub sijhawm ua kev pabcuam ciam teb ntawm cov nplooj ntawv uas yuav luam tawm ntawm lub tshuab luam ntawv. Koj tuaj yeem pom raws nraim li cas daim ntawv tau muab faib ua nplooj ntawv los ntawm kev mus rau hauv txheej txheej lossis Excel nplooj ntawv hom. Qhov no yooj yim zoo nkauj ua.
Ntawm sab xis ntawm txoj cai bar, uas nyob rau hauv qab ntawm Excel qhov rai, muaj cov cim rau kev hloov daim ntawv saib hom. Los ntawm lub neej ntawd, hom kev ua tau qhib. Lub cim sib nug rau nws, sab laug ntawm peb lub cim. Txhawm rau hloov mus rau nplooj ntawv txheej hom, nyem rau thawj lub icon nyob rau sab xis ntawm lub cim daim duab.
Tom qab ntawd, nplooj ntawv txheej txheem hom yog qhib kom ua huaj. Raws li koj tuaj yeem pom, tag nrho cov nplooj ntawv cais los ntawm qhov chaw khoob. Txhawm rau nkag mus rau nplooj ntawv hom, nyem rau ntawm sab xis-feem ntau khawm hauv kab ntawm cov cim saum toj no.
Raws li koj tuaj yeem pom, hauv nplooj ntawv hom, tsis yog tsuas yog cov nplooj ntawv lawv tus kheej pom, cov ciam teb uas tau qhia los ntawm kab sau kab, tab sis lawv tus lej.
Koj tuaj yeem hloov ntawm kev saib hom hauv Excel los ntawm kev mus rau ntawm lub tab "Saib"Cov. Muaj nyob rau txoj xov xov hauv lub thawv Phau Ntawv Saib Cov Qauv yuav muaj khawm rau hloov hom uas sib raug rau cov cim ntawm cov xwm txheej bar.
Yog tias thaum siv hom nplooj ntawv nplooj ntawv, ntau tus lej suav uas tsis muaj dab tsi pom tawm, ces ib daim ntawv khij yuav luam tawm. Tau kawg, los ntawm kev teeb tsa luam ntawv koj tuaj yeem hais kom meej cov kab ntawv ntawm nplooj ntawv tsis suav nrog qhov tsis muaj txiaj ntsig, tab sis nws yog qhov zoo tshaj plaws los tshem tawm cov ntsiab lus ntxiv suav daws. Yog li koj tsis tas yuav ua cov kauj ruam txuas ntxiv txhua zaus koj luam tawm. Tsis tas li ntawd, tus neeg siv yuav cia li tsis nco qab ua lub chaw tsim nyog, uas yuav ua rau kev luam ntawv ntawm cov ntawv dawb.
Tsis tas li, txawm hais tias muaj khoob nyob rau hauv daim ntawv tuaj yeem nrhiav tau los ntawm thaj chaw saib ua ntej. Yuav kom mus txog rau qhov ntawd koj yuav tsum mus rau hauv lub tab Cov ntaub ntawvCov. Tom ntej no mus rau ntu ntawd "Luam Tawm"Cov. Cov cheeb tsam saib ua ntej ntaub ntawv yuav nyob ntawm sab xis ntawm lub qhov rais uas qhib. Yog tias koj kos cov kab ntawv ntu mus rau hauv qab heev thiab pom hauv qhov rais saib ua ntej uas ntawm qee cov nplooj ntawv tsis muaj cov ntaub ntawv txhua, ces lawv yuav luam tawm hauv cov ntawv dawb paug.
Tam sim no cia peb nkag siab yuav ua li cas tshem cov nplooj ntawv dawb paug los ntawm ib daim ntawv, yog tias kuaj tau, los ntawm kev ua raws cov theem saum toj no.
Txoj Kev 1: Tso Chaw Sau Ntawv
Txhawm rau tiv thaiv cov nplooj ntawv tsis muaj lossis tsis tsim los ntawm luam tawm, koj tuaj yeem muab thaj chaw luam tawm. Xav seb qhov no ua tiav li cas.
- Xaiv cov ntaub ntawv ntau ntawm daim ntawv yuav luam tawm.
- Mus rau hauv lub tab Nplooj Phaj Ntawvnyem rau ntawm lub pob "Luam Cheeb Tsam"nyob rau hauv lub twj thaiv Nplooj Ntawv ChawCov. Cov ntawv qhia zaub mov me me qhib, uas muaj li ntawm ob yam khoom xwb. Nyem rau ntawm yam khoom ntawd "Teeb".
- Peb txuag cov ntaub ntawv los ntawm cov qauv txheej txheem los ntawm txhaj rau lub cim nyob rau hauv daim ntawv ntawm lub koos pij tawj diskette nyob rau sab saud sab laug ntawm Excel qhov rai.
Tam sim no ib txwm thaum koj sim luam cov ntawv no, tsuas yog thaj tsam ntawm daim ntawv uas koj tau xaiv yuav raug pub rau lub tshuab luam ntawv. Yog li, nplooj ntawv dawb yuav tsuas yog "txiav" thiab yuav tsis luam tawm. Tab sis hom no tseem muaj qhov tsis zoo. Yog tias koj txiav txim siab ntxiv cov ntaub ntawv rau hauv lub rooj, tom qab ntawd los luam lawv koj yuav tsum hloov thaj chaw luam tawm ntxiv, vim tias qhov program yuav xa mus rau lub tshuab luam ntawv tsuas yog qhov ntau uas koj tau teev nyob hauv cov chaw.
Tab sis lwm qhov xwm txheej muaj peev xwm ua tau, thaum koj lossis lwm tus neeg siv teeb tsa thaj chaw luam tawm, tom qab uas cov lus tau kho lub rooj thiab cov kab tau muab txiav tawm ntawm nws. Hauv qhov no, cov nplooj ntawv tsis muaj ntawv pov thawj uas yog tus ntawv luam tawm tseem tseem yuav xa mus rau lub tshuab luam ntawv, txawm tias tsis muaj cov cim tau teev nyob hauv lawv qhov ntau, suav nrog qhov chaw. Txhawm rau tshem tawm cov teeb meem no, nws yuav txaus cia li tshem tawm thaj chaw luam tawm.
Txhawm rau tshem tawm thaj chaw luam tawm, txawm hais tias tseem ceeb ntau yam tsis tsim nyog. Tsuas yog mus rau ib sab Npavnyem rau ntawm lub pob "Luam Cheeb Tsam" hauv thaiv Nplooj Ntawv Chaw thiab hauv cov ntawv qhia zaub mov uas tshwm, xaiv "Tshem tawm".
Tom qab ntawd, yog tias tsis muaj qhov chaw lossis lwm cov cim hauv cov hlwb sab nraum lub rooj, cov kab tsis muaj nyob yuav tsis pom zoo ib feem ntawm daim ntawv.
Tshooj Lus: Yuav ua li cas teev thaj chaw luam hauv Excel
Txoj Kev 2: ua kom tshem tawm daim nplooj
Yog tias qhov teeb meem tseem tsis dag nyob rau hauv qhov tseeb tias thaj chaw luam tawm nrog thaj chaw tsis tau muab tso rau, tab sis qhov laj thawj tias cov nplooj ntawv tsis muaj nyob hauv daim ntawv yog vim tias muaj chaw lossis lwm cov cim ntxiv rau ntawm daim ntawv, tom qab no qhov chaw luam tawm raug yuam kom ua haujlwm. tsuas yog ib nrab ntsuas.
Raws li tau hais los saum no, yog tias lub rooj hloov pauv tas li, tom qab ntawd tus neeg siv yuav tsum tau tsim cov kev xaiv luam tawm tshiab txhua lub sijhawm thaum luam ntawv. Hauv qhov no, ib kauj ruam uas muaj kuab ntau dua yog qhov kom tshem tau ntau dhau los ntawm phau ntawv muaj cov chaw tsis tsim nyog lossis lwm yam txiaj ntsig.
- Mus rau nplooj ntawv saib ntawm phau ntawv hauv ob qho ntawm ob txoj kev uas peb tau piav qhia ua ntej.
- Tom qab hom qhia tshwj xeeb tau tsim tawm, xaiv tag nrho cov nplooj ntawv uas peb tsis xav tau. Peb ua qhov no los ntawm kev voj voos lawv nrog tus cursor thaum tuav tus laug nas khawm.
- Tom qab cov ntsiab tau xaiv, nyem rau ntawm lub pob Rho tawm ntawm cov keyboard. Raws li koj tuaj yeem pom, tag nrho cov nplooj ntawv ntxiv tau muab deleted. Tam sim no koj tuaj yeem hloov mus rau kev saib hom.
Cov laj thawj tseem ceeb rau qhov muaj cov kab uas tsis tas thaum luam ntawv yog kom teem chaw hauv ib qho ntawm cov hlwb hauv thaj chaw pub dawb. Ntxiv rau, qhov ua rau yuav yog qhov tsis raug sau npe thaj tsam luam tawm. Hauv qhov no, koj tsuas yog yuav tsum tau tshem nws. Tsis tas li ntawd, txhawm rau daws qhov teeb meem ntawm kev luam tawm nplooj ntawv lossis nplooj ntawv tsis tseem ceeb, koj tuaj yeem tsim qhov thaj chaw luam tawm, tab sis nws zoo dua los ua qhov no los ntawm kev tsuas ua kom tawg cov kab ntawv xwb.
