Feem ntau, qhov teeb meem tshwm sim thaum, thaum luam tawm ib daim ntawv, ib nplooj ntawv raug txiav tawm ntawm qhov chaw tsis tsim nyog. Piv txwv, nyob rau ntawm ib phab ntawv yog qhov tseem ceeb ntawm lub rooj, thiab nyob rau ob - nws lub xeem zaum. Nyob rau hauv qhov no, qhov teeb meem ua rau txav lossis rho tawm qhov kis. Cia peb saib seb qhov no yuav ua tau thaum ua haujlwm nrog cov ntaub ntawv hauv Excel spreadsheet processor.
Saib kuj: Yuav tshem tawm cov nplooj ntawv cim hauv Excel
Hom ntawv xo thiab cov txheej txheem rau kev tshem tawm
Ua ntej tshaj, koj yuav tsum paub tias cov nplooj so yuav tsum yog ob hom:
- Manually tso los ntawm tus neeg siv;
- Tso los ntawm qhov kev zov me nyuam.
Raws li, txoj hauv kev tshem tawm ob hom kev sib thooj no txawv.
Thawj ntawm lawv tshwm hauv daim ntawv tsuas yog tias tus neeg siv nws tus kheej ntxiv nws siv lub cuab yeej tshwj xeeb. Nws tuaj yeem txav thiab tshem tawm. Qhov thib ob hom kev tawm tsam yog cia li nkag los ntawm qhov kev zov me nyuam. Nws tsis tuaj yeem raug tshem tawm, tab sis tuaj yeem hloov mus.
Yuav kom pom qhov twg cov chaw ntawm cov nplooj ntawv ntawm lub monitor nyob rau hauv, tsis tau luam tawm daim ntawv nws tus kheej, koj yuav tsum hloov mus rau nplooj ntawv hom. Qhov no yuav ua tau los ntawm txhaj rau lub icon. "Nplooj ntawv"uas yog txoj cai icon ntawm peb lub cim icons ntawm phab views. Cov cim no muaj nyob rau hauv txheej xwm ntawm sab laug mus rau sab laug ntawm lub cuab yeej zoom.
Kuj tseem nyob rau nplooj ntawv hom muaj qhov kev xaiv kom tau muaj los ntawm kev mus tab "Saib". Muaj koj yuav tsum tau nyem rau ntawm lub pob, uas yog hu ua - "Nplooj hom" thiab muab tso rau hauv kab xev hauv kev thaiv "Cov Ntawv Pom Saib Phau Ntawv".
Tom qab hloov mus rau phab hom, qhov kev txiav yuav pom. Cov uas tau txais kev tso cai los ntawm qhov kev zov me nyuam raug qhia los ntawm ib kab ntawv, thiab cov uas siv los ntawm cov neeg siv tau raug qhia los ntawm cov khoom xiav.
Peb rov qab mus rau txoj kev niaj hnub ua haujlwm nrog daim ntawv. Peb nias ntawm lub cim "Zoo" nyob rau hauv txheej xwm bar los yog los ntawm tib lub icon nyob rau hauv ribbon nyob rau hauv lub tab "Saib".
Tom qab hloov mus rau qhov kev pom hom ntawm hom phab ntawv, qhov khij ntawm qhov khoob tuaj yeem tshwm sim rau ntawm daim ntawv. Tab sis qhov no yuav tshwm sim tau tsuas yog tias tus neeg siv tau tsiv mus rau phab ntawv saib cov ntaub ntawv. Yog tias nws tsis ua qhov no, ces nyob rau hauv hom qee lub hom phiaj, qhov cim yuav tsis pom. Li ntawd, nyob rau hauv lub qub disection hom, lawv tso tawm kom pom me ntsis txawv. Cov ntawm lawv uas tau tsim cia los ntawm qhov kev zov me nyuam yuav pom nyob rau hauv daim ntawv ntawm ib kab me me, thiab artificially tsim los ntawm cov neeg siv - nyob rau hauv daim ntawv ntawm loj dashed kab.
Pom tau li cas daim ntawv "torn" yuav zoo li sau, mus rau lub tab "Cov Ntaub Ntawv". Ntxiv mus, mus rau seem "Sau". Nyob rau hauv txoj cai ib sab ntawm lub qhov rais yuav muaj thaj tsam ua ntej. Koj tuaj yeem saib tau daim ntawv pov tseg los ntawm kev txav lub khawm qhov chaw nce thiab nqis.
Tam sim no cia saib seb yuav kho qhov teeb meem no li cas.
Txoj kev 1: tshem tagnrho txhua qhov kev siv so
Ua ntej tshaj plaws, peb tau tsom mus rau kev tshem tawm cov nplooj ntawv so.
- Mus rau lub tab "Nplooj Layout". Peb nyem rau ntawm lub cim ntawm daim ntawv sau "So"muab tso rau hauv ib lub block "Nplooj Nplooj". Ib daim ntawv teev npe cia. Los ntawm cov kev xaiv ntawm cov kev ua uas tau nthuav tawm hauv nws, xaiv "Pib nplooj ntawv so".
- Tom qab qhov kev txiav txim no, tag nrho cov nplooj ntawv lov rau ntawm daim ntawv Excel uas tam sim no uas tau muab tso nrog los ntawm cov neeg siv yuav muab deleted. Tam sim no, thaum luam tawm, cov nplooj ntawv tsuas raug muab tshem tawm tsuas yog thaum daim ntawv teev npe qhia.
Txoj kev 2: Muab tshem tawm tus neeg siv qhov khoob khawm
Tab sis tsis yog nyob rau hauv tag nrho cov mob nws yog tsim nyog rau rho tawm tag nrho cov neeg siv-so so rau ntawm daim ntawv. Hauv qee qhov teeb meem, ib feem ntawm qhov kev txiav tawm yuav tsum tawm, thiab ib feem tawm. Cia peb pom tias qhov no yuav ua li cas.
- Xaiv ib lub xov tooj ntawm tes nyob hauv qhov sib txawv, uas yuav tsum tau muab tshem tawm ntawm daim ntawv. Yog hais tias kev sib cav yog vertical, ces qhov no peb xaiv lub caij mus rau sab xis ntawm nws. Tsiv mus rau qhov tab "Nplooj Layout" thiab nyem rau ntawm lub cim "So". Lub sijhawm no los ntawm daim ntawv teev npe cia koj yuav tsum xaiv qhov kev xaiv "Tshem tawm daim ntawv so".
- Tom qab qhov kev txiav txim no, tsuas yog qhov sib txawv saum toj no xaiv lub xov tooj yuav raug muab tshem tawm.
Yog tias tsim nyog, tib txoj kev, koj tuaj yeem tshem cov nyiaj seem rau ntawm daim ntawv, uas tsis tas siv.
Txoj kev 3: tshem tawm cov ntawv tso nkaum ntawm qhov muab los ntawm kev hloov
Tsis tas li ntawd, manually tso so tawm yuav raug tshem tawm thaum tsiv mus rau cov ntug ntawm daim ntawv.
- Mus saib nplooj ntawv. Muab tus cursor tso rau ntawm ib qho khoom sib txawv uas cim nrog cov khoom xiav. Tus cursor yuav tsum tau muab hloov mus rau hauv ib qho xub pib. Clamp rau sab laug nas khawm thiab cab no cov kab ncaj nraim rau cov npoo ntawm ntawv.
- Tom qab koj ncav cuag daim ntawv ciam, tso tus nas khawm. Qhov kev tawm tsam no yuav raug tshem tawm ntawm daim ntawv tam sim no.
Txoj Kev 4: Txav mus rau qhov chaw so haujlwm
Tam sim no cia saib seb cov nplooj ntawv lov li cas los ntawm qhov kev zov me nyuam yuav ua tau, yog tias tsis raug tshem tawm txhua qhov, ces kawg tsiv raws li qhov tsim nyog ntawm tus neeg siv.
- Mus rau phab hom. Hover tus cursor hla lub hlais, qhia los ntawm kab ntawv dotted. Tus cursor hloov dua siab tshiab rau tus xub kos. Peb ua ib qho yeeb yaj duab ntawm cov laug nas khawm. Tsav qhov sib txawv ntawm qhov uas peb xav tau. Piv txwv, kev xa tawm feem ntau yuav tsiv mus rau ciam teb ntawm daim ntawv. Ntawd yog, peb ua ib txoj kev zoo ib yam li ib qho uas tau ua yav dhau los ntawm kev nqis tes ua.
- Nyob rau hauv rooj plaub no, lub caij so tuaj yeem yuav raug tsiv mus rau cov ciam teb ntawm tag nrho daim ntawv no, los yog yuav tsiv mus rau qhov chaw rau tus neeg siv. Nyob rau hauv cov yav tas rooj plaub, nws yog hloov dua siab tshiab rau ib qho kev sib cav tswv yim. Tam sim no nws yog nyob rau ntawm qhov chaw no thaum luam tawm cov nplooj ntawv yuav raug dua.
Raws li koj tuaj yeem pom, ua ntej pib taug txoj kev ua kom tshem qhov sib txawv, koj yuav tsum paub seb yam ntsiab lus nws hais txog: tsis siv neeg lossis neeg tsim. Los ntawm qhov no yuav tsum yog nyob ntawm seb qhov kev tshem tawm zoo li cas. Tsis tas li ntawd, nws tseem ceeb heev kom nkag siab tias yuav tsum ua li cas nrog: tshem tawm nws lossis tshem nws mus rau lwm qhov chaw hauv daim ntawv. Lwm qhov taw qhia tseem ceeb yog qhov kev tshem tawm li cas nrog rau lwm cov kev txiav nyiaj. Tom qab tag nrho, yog tias muaj ib lub tsho raug muab tshem tawm los yog tsiv lawm, txoj hauj lwm ntawm daim ntawv thiab lwm yam kev pauv yuav hloov. Yog li no, qhov kev nuance no tseem ceeb heev kom coj mus rau hauv tus account tam sim ntawd ua ntej txoj kev tshem tawm.
