Ntxiv Headers thiab Footers rau Excel Daim Ntawv Cuam Tshuam

Ntxiv Preset lossis Cov Ntiag Taws Tseg thiab Cov Footers rau Excel Cov Ntawv Cais

Nyob hauv Excel, cov headers thiab footers yog kab ntawm cov ntawv nyeem uas sau rau saum (hau) thiab hauv qab (footer) ntawm txhua nplooj ntawv hauv daim ntawv ua haujlwm .

Lawv muaj cov ntawv nyeem xws li lub npe, cov hnub, thiab / lossis cov nplooj ntawv. Txij li thaum lawv tsis pom nyob hauv daim ntawv ua haujlwm pom, headers thiab footers feem ntau ntxiv rau ib daim ntawv ua haujlwm uas tau luam tawm.

Qhov kev pab cuam muaj ib lub xov tooj ntawm preset headers - xws li nplooj ntawv los yog cov ntawv ua haujlwm - uas yooj yim los ntxiv los yog koj tuaj yeem tsim cov kev cai thiab cov footers uas muaj peev xwm muaj cov ntawv, graphics, lossis lwm cov ntaub ntawv khom nqi.

Txawm hais tias muaj tseeb tiag watermarks tsis tau tsim nyob rau hauv Excel, "pseudo" watermarks yuav muab ntxiv rau ib daim ntawv ua haujlwm los ntawm kev ntxiv cov duab uas siv cov kev cai headers lossis footers.

Headers thiab Footers Qhov Chaw

• Ib tug header lossis footer muaj peev xwm muaj txog li peb daim ntawm cov ntaub ntawv. Cov ntaub ntawv no tuaj yeem tshwm sim hauv peb qhov chaw ntawm nplooj ntawv;
• Rau cov headers, cov chaw yog saum toj kawg nkaus sab laug, lub chaw saum toj kawg nkaus, thiab sab saum toj ntawm phab sab xis;
• Rau cov footers, cov chaw yog cov ces kaum sab laug hauv qab, qis hauv qab, thiab hauv qab ntawm sab xis ntawm nplooj ntawv.

Preset Headers / Footers Codes

Feem ntau ntawm preset headers thiab footers muaj nyob rau hauv Excel sau cov cim - xws li & [Page] lossis & Hnub tim] - sau cov ncauj lus. Cov lis dej num no ua rau lub hau thiab cov footers dynamic - lub ntsiab lus lawv hloov raws li yuav tsum tau ua, qhov kev cai headers thiab footers yog static.

Piv txwv, & [Page] code yog siv cov nplooj ntawv sib txawv ntawm nplooj ntawv. Yog tias nkag mus rau kev siv tus qauv kev xaiv, txhua nplooj ntawv yuav muaj tib phab ntawv

Saib Headers thiab Footers

Cov headers thiab footers pom nyob rau hauv Page Layout saib, tiam sis, raws li tau hais, tsis nyob hauv Daim Ntawv Ua Haujlwm Nquag Pom. Yog tias koj ntxiv headers lossis footers nrog lub Page Setup dialog box, hloov mus rau Page Layou saib lossis siv Print Preview saib lawv.

Muaj ob qho kev xaiv rau kev ntxiv ob qho kev cai thiab preset headers thiab footers rau ib daim ntawv ua haujlwm:

1. siv Page Layou t saib;
2. siv lub Page Setup dialog box .

Ntxiv ib qho Header lossis Footer nyob rau hauv Page Layout

Ntxiv rau ib qho kev cai header lossis header nyob rau hauv nplooj ntawv layout saib:

1. Nias rau ntawm Daim Ntawv Txhawb ntawm txoj kab;
2. Nias rau ntawm nplooj ntawv Layout xaiv nyob rau hauv daim xov rau hloov mus rau phab layout saib raws li qhia hauv daim duab saum toj no;
3. Nyem nrog nas rau ntawm ib qho ntawm peb lub thawv nyob rau sab saum toj los yog hauv qab ntawm nplooj ntawv ntxiv ib qho header lossis footer;
4. Ntaus cov lus qhia losyog cov ntawv qhia rau hauv lub npov xaiv.

Ntxiv rau Preset Header lossis Footer nyob rau hauv Page Layout

Ntxiv rau ib qho ntawm cov preset headers lossis cov headers hauv nplooj ntawv saib:

1. Nias rau ntawm Daim Ntawv Txhawb ntawm txoj kab;
2. Nias rau ntawm nplooj ntawv Layout xaiv nyob rau hauv daim xov rau hloov mus rau phab layout saib raws li qhia hauv daim duab saum toj no;
3. Nyem nrog tus nas nyob hauv ib qho ntawm peb lub thawv nyob rau sab saum toj los yog hauv qab ntawm nplooj ntawv ntxiv ib qho header los yog lub footer rau qhov chaw - ua li ntawd ntxiv ntxiv Cov Kev Tsim Txuj rau qhov xov raws li muaj nyob hauv daim duab saum toj no;
4. Ntxiv ib qho preset header lossis footer mus rau qhov chaw xaiv tau ua tau los ntawm:
   1. Txhawm rau ntawm Header lossis Footer option ntawm txoj hlua qhib lub tshuab raj ntawm kev xaiv preset;
   2. Txhawm rau ntawm ib qho kev xaiv preset ntawm txoj kab xov - xws li Page Number , Hnub Tim , los yog Cov Ntaub Ntawv Npe;
5. Ntaus nyob rau hauv cov ntawv qhia lossis cov lus qhia ntxiv.

Rov qab mus rau Kev Pom Zoo

Thaum koj tau ntxiv lub hau los yog lub hau, Excel muab koj tso rau hauv Layout view. Thaum nws tseem tuaj yeem ua haujlwm rau hauv qhov kev pom no, koj yuav xav rov qab mus rau Kev Pom Zoo. Ua li no:

1. Nias rau ntawm ib lub xov tooj hauv daim ntawv ntawm daim ntawv ua haujlwm tawm mus rau sab nraud / lub tshav puam;
2. Ndliv lub Saib tab;
3. Nias rau ntawm txoj kev xaiv hauv qhov ribbon.

Ntxiv Preset Headers thiab Footers nyob rau hauv Page Setup Dialog Box

1. Nyem ntawm qhov Page Layout tab ntawm txoj kab ;
2. Nias rau ntawm Page Setup dialog box launcher los ntawm cov ntawv qhia zaub mov qhib lub Page Setup dialog box;
3. Hauv lub thawv ntawv, xaiv Header / Footer tab;
4. Xaiv ntawm qhov preset lossis custom header - xaiv kev xaiv raws li hauv daim duab saum toj no;
5. Nyem OK los kaw lub thawv dialog;
6. Yog vim, lub preset headers thiab footers yog nyob rau ntawm daim ntawv ua haujlwm;
7. Saib ua ntej cov header / footer hauv Print Preview .

Ceebtoom : Cov nias lub tsho thiab cov kab lus tseem tuaj yeem muab ntxiv rau hauv lub thawv uas txuas los ntawm Kev Ntaus Cov Ntiag Tug los yog cov nyom khawm ncoo - muaj nyob hauv daim duab saum toj no.

Saib cov Header lossis Footer hauv Sau Ua Ntej

Lus Cim : Koj yuav tsum muaj ib lub tshuab luam ntawv ntsia koj lub computer siv Print Preview.

1. Nias nyob rau hauv cov ntawv qhia zaub mov kom qhib cov khoom seem-down me me;
2. Nias ntawm Sau hauv cov ntawv qhia zaub mov qhib lub qhov rai sau;
3. Daim ntawv sau ua haujlwm tam sim no yuav tshwm sim nyob rau ntawm nplooj ntawv sab nrauv ntawm sab xis ntawm lub qhov rais.

Tshem tawm Headers los yog Footers

Tshem tawm cov tib neeg lub npe thiab / los yog hauv qab ntawm daim ntawv ua haujlwm, siv cov kauj ruam saum toj no los ntxiv cov headers thiab footers siv cov nplooj ntawv Layout saib thiab rho cov ntsiab lus uas muaj cov kab lus uas twb muaj lawm.

Tshem cov headers thiab / los yog hauv qab ntawm ntau daim ntawv khom nqi:

1. Xaiv cov ntawv ua haujlwm;
2. Nyem ntawm qhov Page Layout tab;
3. Nias rau ntawm Page Setup dialog box launcher los ntawm cov ntawv qhia zaub mov qhib lub Page Setup dialog box;
4. Hauv lub thawv ntawv, xaiv Header / Footer tab;
5. Xaiv (tsis muaj) hauv lub hau preset thiab / los yog lub thawv ntawv;
6. Nyem OK los kaw lub thawv dialog;
7. Tag nrho zaj header thiab / los yog cov ntawv qhia tawm yuav tsum tau muab tshem tawm ntawm cov ntawv ua haujlwm.