Tej zaum thaum luam phau ntawv Excel ua, lub tshuab luam ntawv tsis tsuas yog cov nplooj ntawv muaj cov ntaub ntawv, tab sis tseem khoob. Qhov no tshwm sim rau ntau yam. Piv txwv li, yog tias koj tsis muab ib lub cim rau hauv qhov chaw ntawm nplooj ntawv no, txawm yog qhov chaw, nws yuav raug muab luam tawm. Lawm, qhov teeb meem no cuam tshuam cov hnav lub tshuab luam ntawv, thiab tseem ua rau lub sijhawm poob. Nyob rau hauv tas li ntawd, muaj qee zaum thaum koj tsis xav sau cov nplooj ntawv uas muaj cov ntaub ntawv thiab koj tsis xav sau, tab sis rho tawm. Cia peb xav txog cov kev xaiv rau kev xa cov nplooj ntawv hauv Excel.
Nplooj tshem tawm txoj kev
Txhua daim ntawv ntawm ib phau ntawv Excel uas tau tawg cia hauv cov ntawv luam tawm. Lawv ciam teb rau tib lub sijhawm ua haujlwm ciam teb ntawm cov nplooj ntawv uas yuav luam tawm ntawm lub tshuab luam ntawv. Koj tuaj yeem pom li cas daim ntawv raug faib rau cov nplooj ntawv thaum hloov mus rau qhov tsim hom lossis rau Excel hom hom. Ua kom yooj yim zoo nkauj.
Sab xis ntawm tus txheej xwm bar, uas yog nyob hauv qab ntawm Excel qhov rais, muaj cov cim rau kev hloov hom pom ntawm daim ntawv. Yog vim, qhov hom ua tau zoo. Qhov kev cai icon yog qhov seem ntawm peb lub cim tseg. Thiaj li yuav hloov mus rau phab phab ntawv layout, nyem rau ntawm thawj lub cim rau sab xis ntawm lub cim qhia tseg.
Tom qab ntawd, cov nplooj ntawv qhov kev teeb tsa yog pib. Raws li koj tau pom, tag nrho cov nplooj ntawv yog sib cais los ntawm qhov chaw npliag. Mus rau phab hom, nyem rau ntawm lub pob rightmost hauv kab ntawm cov saum toj no icons.
Raws li koj tuaj yeem pom, hauv nplooj ntawv hom, koj tuaj yeem pom tsis tsuas yog cov nplooj ntawv lawv tus kheej, cov ciam teb uas tau qhia los ntawm ib kab ntawv dotted, tab sis kuj cov zauv.
Koj tuaj yeem hloov tau ntawm kev saib hom hauv Excel los mus rau lub tab "Saib". Muaj nyob rau hauv daim kab xev hauv lub nras cov cuab yeej "Cov Ntawv Pom Saib Phau Ntawv" yuav muaj hom nyees khawm uas sib txuas rau cov duab cim ntawm qhov xwm txheej.
Yog tias, thaum siv hom phab ntawv, qhov khwv yees yog cov lej uas tsis pom muaj qhov tsis pom kev, ces daim ntawv yuav seem sau rau ntawm daim luam. Tau kawg, los ntawm kev teeb tsa kev luam ntawv, koj tuaj yeem qhia meej rau ib phab kab uas tsis muaj kev sib nrauj, tab sis nws yog qhov zoo tshaj plaws rau kev rho tawm cov ntsiab lus tsis tseem ceeb. Yog li koj tsis tas yuav ua tib cov haujlwm ntxiv txhua zaus koj sau. Tsis tas li ntawd, tus neeg siv yuav cia li nco ntsoov ua kom tsim nyog nqis, uas yuav ua rau luam ntawm daim ntawv xoom dawb.
Ntxiv mus, yog tias muaj cov ntsiab lus npliag nyob hauv daim ntawv, koj tuaj yeem tshawb xyuas los ntawm cheeb tsam saib ua ntej. Yuav kom tau muaj koj yuav tsum txav mus rau lub tab "Cov Ntaub Ntawv". Ntxiv mus, mus rau seem "Sau". Nyob hauv txoj cai huab cua ntawm lub qhov rais qhib, yuav muaj kev saib ua ntej ntawm daim ntawv. Yog tias koj nqes mus rau hauv qab ntawm qhov chaw scroll thiab nrhiav hauv qhov rais saib ua ntej uas nyob rau qee cov nplooj ntawv tsis muaj xov xwm txhua, nws txhais tau tias lawv yuav muab luam tawm ua daim ntawv xoom.
Tam sim no peb yeej to taub tias yuav tshem tawm cov nplooj ntawv npliag los ntawm daim ntawv, yog pom, thaum ua cov kauj ruam saum toj no.
Txoj kev cai 1: muab lub cheeb tsam luam tawm
Yuav kom tsis txhob sau cov ntawv npliag los yog pliaj, koj tuaj yeem xa ib cheeb tsam luam. Xav seb qhov no ua tiav li cas.
- Xaiv qhov ntau ntawm cov ntaub ntawv ntawm daim ntawv uas koj xav sau.
- Mus rau lub tab "Nplooj Layout", nyem rau ntawm lub pob "Sau Cheeb Tsam"uas yog nyob rau hauv lub cuab yeej thaiv "Nplooj Nplooj". Ib daim ntawv qhia me me qhib, uas muaj ob yam khoom xwb. Nias ntawm yam khoom "Teeb".
- Peb txuag tau cov ntaub ntawv uas siv cov txheej txheem txheem los ntawm txhaj rau lub icon nyob rau hauv daim ntawv ntawm lub computer diskette nyob rau sab laug ces kaum ntawm lub qhov rais Excel.
Tam sim no, ib txwm thaum koj sim sau cov ntaub ntawv no, tsuas yog cheeb tsam ntawm daim ntawv uas koj xaiv tau xa mus rau lub tshuab luam ntawv. Yog li, cov nplooj ntawv dawb paug tsuas yog "txiav tawm" thiab yuav tsis muab luam tawm. Tab sis qhov no muaj nws cov teeb meem. Yog tias koj txiav txim siab ntxiv cov ntaub ntawv rau ntawm lub rooj, ces luam tawm lawv koj yuav tsum tau hloov cheeb tsam luam dua, vim tias qhov kev zov me nyuam tsuas pub rau qhov koj teev nyob rau ntawm qhov chaw.
Tab sis lwm qhov teeb meem yog thaum koj los yog lwm tus neeg siv tau sau ib cheeb tsam ntawm print, tom qab uas lub rooj tau kho thiab cov kab ntawd deleted los ntawm nws. Nyob rau hauv cov ntaub ntawv no, cov nplooj ntawv dawb paug, uas yog tsau ua ib cheeb tsam ntawm print, tseem yuav raug xa mus rau lub tshuab luam ntawv, txawm tias tsis muaj cov cim tau teev nyob hauv lawv qhov chaw, nrog rau qhov chaw. Txhawm rau tshem ntawm qhov teeb meem no, nws yuav txaus kom tshem tawm cheeb tsam.
Yuav kom tshem tawm cheeb tsam ntawm print txawm xaiv qhov ntau yog tsis tsim nyog. Cia li mus rau lub tab "Markup", nyem rau ntawm lub pob "Sau Cheeb Tsam" hauv kev thaiv "Nplooj Nplooj" thiab hauv cov ntawv qhia zaub mov uas tshwm sim, xaiv qhov khoom "Tshem tawm".
Tom qab ntawd, yog tias tsis muaj chaw lossis lwm tus cim rau hauv lub hlwb sab nraum lub rooj, khoob tsis txaus yuav tsis muab suav hais tias yog ib feem ntawm daim ntawv.
Zaj Lus Qhia: Yuav ua li cas los teeb tsa chaw sau hauv Excel
Txoj kev 2: ua tiav nplooj ntawv
Txawm li cas los xij, yog tias qhov teeb meem tsis yog hais tias cheeb tsam ntawm print nrog qhov khoob kos, tab sis yog vim li cas cov nplooj ntawv dawb paug muaj nyob rau hauv daim ntawv yog qhov muaj qhov chaw los yog lwm cov cim tsis tseem ceeb nyob hauv daim ntawv, tom qab ntawd qhov no yuav tsum tau muab cov ntawv tso tawm ntawm cheeb tsam yog ib nrab ntsuas xwb.
Raws li tau hais los saum no, yog hais tias lub rooj hloov tas li, ces tus neeg siv yuav tau teem caij tshiab tsis txhua zaus lawv sau. Nyob rau hauv cov ntaub ntawv no, cov kauj ruam uas yooj yim tshaj yog yuav tshem tag nrho tawm ntawm phau ntawv muaj ntau qhov chaw tsis muaj qhov tshwj xeeb lossis lwm qhov tseem ceeb.
- Mus saib nplooj ntawv ntawm phau ntawv hauv ib qho ntawm ob txoj kev uas peb tau piav qhia ua ntej.
- Tom qab cov hom kev qhia tiav, xaiv tag nrho cov nplooj ntawv uas peb tsis xav tau. Peb ua qhov no los ntawm daim lawv nrog tus cursor thaum tuav lub pob nyem khawm.
- Tom qab lub ntsiab raug xaiv, nias ntawm lub pob Rho tawm ntawm cov keyboard. Raws li koj tau pom, tag nrho cov nplooj ntawv ntxiv yog deleted. Tam sim no koj tuaj yeem nkag mus rau hauv ib qho kev pom hom.
Lub ntsiab yog vim li cas rau daim ntawv xoom dawb thaum luam ntawv yog los tsim ib qho chaw hauv ib lub hlwb ntawm cov dawb ntau. Tsis tas li ntawd, qhov teeb meem no yuav yog qhov chaw sau tsis raug. Hauv qhov no, koj tsuas yog xav muab rho tawm xwb. Tsis tas li ntawd, los daws qhov teeb meem ntawm cov ntawv npliag los yog lub npe tsis txaus siab, koj tuaj yeem tsim qhov kos cheeb tsam pes tsawg, tab sis nws yog qhov zoo tshaj los ua qhov no los ntawm kev tshem tawm cov khoob tsis txaus.
