Wedzera Musoro uye Mhemberero kune Excel Worksheets

Wedzera Preset kana Custom Headers uye Footers kune Excel Worksheets

MuEccel, misoro nemakumbo mavara ndiwo mavara ekunyora pamusoro (musoro) uye pasi (footer) peji rimwe nerimwe mubasa rekushanda .

Iine zvinyorwa zvinotsanangurwa zvakadai sezita, mazita, uye / kana peji peji. Sezvo zvisingaoneki mumaonero evhesi yepamusoro pepaji, zvinyorwa nemakumbo zvinowanzowedzerwa kune pepa rekushandura riri kudhindwa.

Purogiramu inosvika yakagadzirirwa nepamusoro-soro misoro-yakadai sejiji peji kana zita rebhuku rebasa - zviri nyore kuwedzera kana iwe unogona kugadzira misoro yepamusoro uye zvitsika zvinogona kusanganisira mavara, mafirimu, kana imwe dharedheet data .

Kunyange zvazvo watermark yechokwadi isingagoni kusikwa muExcel, "pseudo" watermarks inogona kuwedzerwa pane pepa rekuwedzera nekuwedzera mifananidzo uchishandisa misoro yepamusoro kana zvitsika.

Musoro uye Nheyo Mzvimbo

• Musoro kana nheyo dzinogona kuva nemakatu matatu emashoko. Iyi ruzivo inogona kuonekwa munzvimbo nhatu pane peji;
• Pamusoro pemusoro, nzvimbo idzi dziri kumusoro kwekona yekona, nzvimbo yepamusoro, uye nepamusoro kwepamusoro pekona peji;
• Nokuda kwetsoka, nzvimbo dziri pasi rekona kona, pasi rezasi, uye pasi rekona rezasi kwe peji.

Preset Headers / Footers Codes

Nyaya dzepamusoro-soro uye zvinyorwa zvinowanikwa muInccel kupinda ma code - zvakadai se & & [Page] kana & [Date] - kuti uwane ruzivo rwaunoda. Aya maita anoita kuti misoro nemakumbo zvive nesimba - zvinoreva kuti zvinoshanduka sezvazvinenge zvichitarisirwa, asi tsika dzemisoro nemakumbo zvinodzika.

Somuenzaniso, & [Peji] kodeti inoshandiswa kuva nhamba dzepaji dzakasiyana pane peji rimwe nerimwe. Kana ukapinda manyore uchishandisa tsika yakasarudzika, peji rimwe nerimwe richava nenhamba imwe yemapeji

Kuona Musoro uye Mhemberero

Musoro uye zvitsika zvinowanikwa muPaji yeChirongwa maonero asi, sezvazvakataurwa, kwete muBurongwa hwemazuva ose. Kana iwe uwedzera misoro kana mabheji neji Page Setup dialog box, shandura kuIndaneti Layou t kana kuti shandisa Print Preview kuti uvaone.

Pane zvingasarudzwa zviviri zvekuwedzera maitiro ose uye mahedheni ekugadziridza uye zvitsika kune rimwe pepaji:

1. uchishandisa Page Layou t maonero;
2. uchishandisa Page Setup dialog box .

Kuwedzera Musoro weMusoro kana Mhemberero muDheji Rwekutanga

Kuti uwedzere musoro wemutambo kana kuti musoro wePeji yekuona maonero:

1. Dzvanya paZviona tab yebhoni;
2. Dzvanya pane Peji Yokugadzirisa mubhubhoni kuti uchinje kuhuturo hwekutsvaga peji sezvinoratidzwa mumufananidzo pamusoro apa;
3. Dzvanya nehomwe pane imwe yemabhokisi matatu ari kumusoro kana pasi peji kuti uwedzere musoro kana pasi;
4. Nyora musoro wemusoro kana zvigadziro mubhokisi rakasarudzwa.

Kuwedzera Preset Header kana Footer muDheji Rwekutanga

Kuti uwedzere chimwe chezvinyorwa zvakagadziridzwa kana zvinyorwa muPeji yekuona maonero:

1. Dzvanya paZviona tab yebhoni;
2. Dzvanya pane Peji Yokugadzirisa mubhubhoni kuti uchinje kuhuturo hwekutsvaga peji sezvinoratidzwa mumufananidzo pamusoro apa;
3. Dzvanya nehomwe mune rimwe remabhokisi matatu ari kumusoro kana pasi pepeji kuti uwedzere musoro kana tsoka kune iyo nzvimbo - kuita kudaro kunowedzerawo Design pane tab kubhoni sezvinoratidzwa mumufananidzo uri pamusoro;
4. Kuwedzera musoro wekugadzirisa musoro kana pasi petsoka kunzvimbo yakasarudzwa kunogona kuitwa ne:
   1. Kushandura ku Header kana Footer sarudzo paibhoni kuti uzarure mhando yezvinyorwa zvekusarudzwa kusarudzo;
   2. Kushanda pane imwe yezvinhu zvakasarudzwa kushandiswa pamabhoni - seNhamba yeNhamba , Current Date , kana Zita reFaira;
5. Nyora mumusoro wekanyorwa kana pasi.

Kudzokera kuNyama Yakatarisa

Kana uchinge wawedzera musoro kana tsoka, Excel inokusiya iwe paIndaneti Maonero. Kunyange zvazvo zvichikwanisika kushanda mumaonero aya, unogona kudzokera kuZviro zvemazuva ose . Kuita izvi:

1. Dzvanya pane chero sero riri mupepaiti yebasa kuti usiye musoro wepamusoro-nharaunda;
2. Dzvanya pane View View ;
3. Dzvanya paChinyo Chakanaka mubhubhoni.

Kuwedzera Mahedheni eChesetse neMakumbo muBhokisi reDeji reDeji reKutanga

1. Dzvanya pane Peji Itaiti tab yebhoni ;
2. Dzvanya paDheji rekuisa dialog box launcher kubva kumenu kuti uzarure Bhokisi rekuisa Page rebhokisi;
3. Mubhokisi rebhokisi, sarudza Musoro / Mutsara weTabvu;
4. Sarudza kubva pane zvakatemwa kana tsika yemaitiro - zvigadziro zvetsoka sezvinoratidzwa mumufananidzo uri pamusoro;
5. Dzvanya OK kuti uvhare bhokisi rebhokisi;
6. Nokusingaperi, zvinyorwa zvakagadziridzwa uye zvinyorwa zvinowanikwa pane pepa rekushanda;
7. Ongorora musoro / mutsara muChirangaridzo Chekuona .

Cherechedza : Musoro wepamusoro uye makumbo anokwanisawo kuwedzerwa mubhokisi rebhokisi kuburikidza nekusarudza Musoro wepamusoro kana mabheji - zvaratidzwa mumufananidzo uri pamusoro.

Kuona Musoro kana Mhemberi muKutarisa kweChirangaridzo

Cherechedza : Unofanirwa kuva ne printer yakaiswa pakombiyuta yako kushandisa Printing Preview.

1. Dzvanya paDhiyabhorosi menyu kuti uzarure mhando inodonha yezvasarudzo;
2. Dzvanya kuDhinda mu menu kuti uzarure hwindo rekupiritsa;
3. Iri pepa rekushanda riripo richaonekwa pane pepanho rekuona kurudyi kwehwindo.

Kubvisa Musoro kana Mhemberi

Kuti ubvise misoro yega yega uye / kana zvidimbu kubva pane pepa rekushanda, shandisa matanho ari pamusoro apa kuwedzera misoro uye mabheji uchishandisa Peji Yokuona maziso uye bvisa zviripo zviripo musoro / pasi.

Kuchenesa misoro uye / kana kuti mabheji kubva kumashizha akawanda emaoko kamwechete:

1. Sarudza mapepa okushanda;
2. Dzvanya pane Page Peji tab;
3. Dzvanya paDheji rekuisa dialog box launcher kubva kumenu kuti uzarure Bhokisi rekuisa Page rebhokisi;
4. Mubhokisi rebhokisi, sarudza Musoro / Mutsara weTabvu;
5. Sarudza (hapana) mu-header preset uye / kana bhokisi rezasi;
6. Dzvanya OK kuti uvhare bhokisi rebhokisi;
7. Zvose zvinyorwa uye / kana zvinyorwa zvitsvene zvinofanira kubviswa kubva pamashizha emahofisi akasarudzwa.