txheem
Thaum lub rooj hauv Excel ntev ntev thiab muaj ntau cov ntaub ntawv nyob rau hauv nws, koj tuaj yeem siv cov haujlwm ua rau hauv qhov kev pab cuam uas qhia cov lus headers ntawm txhua nplooj ntawv. Qhov no yog qhov tseeb tshwj xeeb tshaj yog thaum luam tawm cov ntaub ntawv loj. Xws li ib tug muaj nuj nqi yog hu ua los ntawm kab.
Txoj kab uas hla yog dab tsi?
Yog tias koj xav tau luam tawm ntau nplooj ntawv, ces feem ntau yuav tsum muaj tib lub npe lossis header ntawm txhua nplooj ntawv. Txhim kho cov ntaub ntawv no hauv Excel spreadsheet yog ib txoj kab. Qhov no feature tsis tsuas yog txo cov nqi ntawm kev ua hauj lwm, tab sis kuj yuav pab kom cov nplooj ntawv tsim zoo nkauj dua.. Tsis tas li ntawd, ua tsaug rau cov kab nws tuaj yeem kos cov ntawv yooj yim.
Yuav ua li cas los ntawm kab?
Txhawm rau kom tsis txhob manually ua qhov kev mob siab ua haujlwm xws li ntxig cov ntaub ntawv tib yam hauv ntau qhov chaw ntawm cov ntaub ntawv, ib qho kev ua haujlwm yooj yim tau tsim - ib kab dhau los. Tam sim no, tsuas yog nias ib zaug xwb, koj tuaj yeem tsim ib lub header thiab nqe lus, kos npe lossis nplooj ntawv cim ntawm txhua daim ntawv, thiab lwm yam.
Ua tib zoo mloog! Muaj ib tug variant ntawm cov kab, uas yog tsau nyob rau hauv lub screen, tab sis nyob rau hauv luam nws yog reproduced ib zaug xwb ib nplooj ntawv. Nyob rau hauv cov ntaub ntawv no, cov ntaub ntawv nyob rau hauv qhov kev pab cuam yuav scrolled los ntawm. Thiab muaj kev ua haujlwm ntawm cov kab, uas tuaj yeem tshwm sim ntawm txhua nplooj ntawv nyob rau hauv daim ntawv ntawm header ib tug xaiv ntawm lub sij hawm. Kab lus no yuav xav txog qhov kev xaiv tom kawg.
Qhov zoo ntawm cov kab yog pom tseeb, vim tias nrog kev pab los ntawm lawv koj tuaj yeem txo cov sij hawm ua haujlwm ntawm lub computer, thaum ua tiav cov txiaj ntsig xav tau. Yuav kom ua tau ib txoj kab kawg-rau-kawg, nws yog ib qho tseem ceeb uas yuav tau ua raws li qee qhov kev ua ntu zus, xws li:
- Mus rau Excel header hauv ntu "Page Layout", xaiv "Print Headers" thiab "Page Setup".
Nws yog ib qho tseem ceeb kom paub! Thaum tsis muaj lub tshuab luam ntawv thiab hauv cov txheej txheem kho cov hlwb, qhov teeb tsa no yuav tsis muaj.
- Tom qab cov khoom "Page Setup" tshwm nyob rau hauv lub functionality, koj yuav tsum mus rau nws thiab nyem rau ntawm lub "Sheet" tab nrog tus nas, raws li qhia nyob rau hauv daim duab. Nyob rau hauv lub qhov rais no, cov kev ua "Los ntawm kab" twb pom lawm. Nyem rau ntawm qhov chaw nkag.
- Tom qab ntawd koj yuav tsum xaiv cov kab hauv lub phaj uas yuav tsum tau kho. Koj yuav tsum xaiv ib tug los ntawm kab horizontally. Koj tseem tuaj yeem nkag mus rau kab zauv manually.
- Thaum kawg ntawm kev xaiv, nyem rau ntawm lub pob "OK".
Yuav txheeb xyuas cov kab li cas?
Kev tshuaj xyuas qhov tshwj xeeb no hauv cov ntxhuav kuj tseem ceeb. Txhawm rau kom tsis txhob lwj ntau cov ntaub ntawv, peb yuav ua qhov kev kuaj zaum kawg. Txhawm rau ua qhov no, ua raws li ntu ntu ntawm kev ua:
- Ua ntej, mus rau ntu "Cov ntaub ntawv", uas nyob rau hauv lub rooj header nyob rau sab laug ces kaum. Tom qab ntawd nyem rau ntawm lub pob "Print", uas tuaj yeem pom hauv daim duab 2.
- Kev saib ua ntej ntawm cov ntaub ntawv yuav qhib rau sab xis, qhov twg koj tuaj yeem tshawb xyuas qhov ua tau raws li qhov ntsuas qhov ntsuas. Scroll los ntawm tag nrho cov nplooj ntawv thiab xyuas kom tseeb tias cov kab dhau los tsim ua ntej yog qhov tseeb.
- Txhawm rau mus rau daim ntawv tom ntej, tsuas yog nyem rau ntawm lub log scroll ntawm sab xis. Koj tuaj yeem ua qhov no nrog lub log nas.
Ib yam li los ntawm kab, koj tuaj yeem khov cov kab tshwj xeeb hauv ib daim ntawv. Qhov kev ntsuas no yog teem rau tib theem raws li txoj kab dhau los, tsuas yog ib qho taw qhia, raws li pom hauv daim duab 2.
xaus
Nyob rau hauv Excel spreadsheet processor, lub complex yuav yooj yim, thiab xws li ib tug ntev txoj hauj lwm xws li luam lub npe los yog nplooj ntawv header thiab xa mus rau lwm tus yog yooj yim automated. Ua los ntawm cov kab yog ceev thiab yooj yim, tsuas yog ua raws li cov lus qhia saum toj no.