Hauv Excel, headers thiab footers yog kab ntawm cov ntawv sau rau saum (header) thiab hauv qab (footer) ntawm txhua nplooj ntawv hauv ib daim ntawv ua haujlwm. Headers thiab footers muaj cov lus piav qhia xws li lub npe, hnub tim, lossis nplooj ntawv tus lej. Txij li thaum lawv tsis pom hauv daim ntawv ua haujlwm ib txwm pom, headers thiab footers tau ntxiv rau daim ntawv ua haujlwm thaum nws luam tawm.
Cov lus qhia hauv kab lus no siv rau Excel 2019, 2016, thiab 2013.
Kev xaiv rau kev ua haujlwm nrog headers thiab footers
Excel los nruab nrog ntau lub taub hau preset, xws li nplooj ntawv tus lej lossis lub npe phau ntawv ua haujlwm, uas yooj yim ntxiv. Lossis koj tuaj yeem tsim cov headers thiab footers uas suav nrog cov ntawv nyeem, cov duab, thiab lwm cov ntaub ntawv nthuav dav.
Txawm hais tias tsis tuaj yeem tsim watermarks tseeb hauv Excel, "pseudo" watermarks tuaj yeem muab ntxiv rau hauv daim ntawv ua haujlwm los ntawm kev ntxiv cov duab rau cov headers lossis footers.
kab hauv qab
Ib lub taub hau lossis footer tuaj yeem muaj txog li peb daim ntaub ntawv. Cov ntaub ntawv no tuaj yeem tshwm sim hauv peb qhov chaw ntawm nplooj ntawv. Rau cov headers, cov chaw yog sab laug sab laug, sab saum toj nruab nrab, thiab sab xis sab xis ntawm nplooj ntawv. Rau cov footers, cov chaw nyob hauv qab yog kaum sab laug, hauv qab nruab nrab, thiab hauv qab sab xis ntawm nplooj ntawv.
preset headers thiab footers
Feem ntau ntawm preset headers thiab footers muaj nyob rau hauv Excel sau cov lej, xws li &[Page lossis &[Hnub, nkag mus rau cov ntaub ntawv xav tau. Cov lej no ua rau cov headers thiab footers dynamic. Qhov no txhais tau tias lawv hloov raws li qhov yuav tsum tau ua, qhov kev cai headers thiab footers yog zoo li qub.
Piv txwv, tus &[Pagecode qhia cov nplooj ntawv sib txawv ntawm txhua nplooj ntawv. Yog tias nkag los ntawm tus kheej siv qhov kev xaiv, txhua nplooj ntawv muaj tib nplooj ntawv tus lej.
Ntxiv ib tug Custom Header lossis footer hauv nplooj ntawv layout
Kho ntxiv ib qho kev cai header lossis header hauv Page layout saib:
- Select Saib.
- Select Page Layout to change to Nplooj ntawv layout saib.
-
Xaiv ib qho ntawm peb lub thawv nyob rau sab saum toj lossis hauv qab ntawm nplooj ntawv ntxiv rau lub taub hau lossis hauv qab.
- Hloov cov ntaub ntawv header lossis footer rau hauv lub thawv xaiv.
Ntxiv qhov Preset Header lossis footer hauv nplooj ntawv layout
Txhawm rau ntxiv ib qho ntawm cov headers preset lossis headers hauv Nplooj ntawv layout saib:
- Select View.
- Select Page Layout to change to Nplooj ntawv layout saib.
- Xaiv ib qho ntawm peb lub thawv nyob rau saum lossis hauv qab ntawm nplooj ntawv ntxiv cov ntaub ntawv header lossis footer. Daim ntawv ceeb toom tias lub tab tshiab, sau tias Design, tshwm.
- Nyob ntawm Design tab, xaiv qhov kev xaiv ua ntej. Xaiv los ntawm kev xaiv xws li Page Number, Hnub tam sim no, lossis File Name.
Returning to normal View From Page Layout View
Thaum koj tau ntxiv cov header lossis footer, Excel tso koj rau hauv Page Layout saib. Thaum nws tuaj yeem ua haujlwm hauv qhov kev pom no, tej zaum koj yuav xav rov qab mus rau Normal saib. Yuav ua li cas:
- Xaiv ib lub xovtooj ntawm daim ntawv ua haujlwm kom tawm ntawm thaj chaw header/footer.
- Select View.
- Select Ncosaib.
Ntxiv Preset Headers thiab Footers hauv Nplooj Ntawv Teeb Dialog Box
Yuav kom muaj kev tswj hwm ntau dua qhov zoo ntawm cov headers thiab footers, siv lub Page Setup dialog box. Nov yog li cas:
- Select Page Layout.
- Xaiv lub Page Setup launcher los qhib lub Page Setup dialog box.
- Nyob hauv lub dialog box, xaiv lub Header/Footer tab.
- Xaiv koj qhov preset header los ntawm ob lub Header los yog Footer cov npe poob.
-
Xaiv OK txhawm rau kaw lub dialog.
Image
Kev cai headers thiab footers tseem tuaj yeem muab ntxiv rau hauv lub thawv sib tham los ntawm kev xaiv Custom Header lossis Custom Footer.
Tshem tawm cov headers lossis footers
Txhawm rau tshem cov headers thiab footers ntawm ntau daim ntawv ua haujlwm ib zaug:
- Xaiv tus worksheets.
- Select Page Layout.
- Xaiv lub Page Setup launcher los qhib lub Page Setup dialog box.
- Nyob hauv lub dialog box, xaiv lub Header/Footer tab.
- Xaiv (tsis muaj) hauv ob lub preset header thiab footer drop-down lists.
- Xaiv OK txhawm rau kaw lub dialog.
- Tag nrho cov ntsiab lus header lossis footer raug tshem tawm ntawm cov ntawv ua haujlwm xaiv.
