Maitiro ekuverengera mapeji muexcel. Kubva pane imwe peji, kubva papepa rechipiri, uchifunga nezvehuwandu hwemapeji mufaira

Kuverengera inzira iri nyore yekugadzira yakasununguka kufamba iyo inokutendera iwe kukurumidza kufamba kuburikidza negwaro. Kana basa richiitwa mune imwe tafura, saka hapana chikonzero chekuverenga. Ichokwadi, kana ukaronga kuidhinda mune ramangwana, zvino zvichave zvakakosha kuiverenga pasina kukanganisa kuitira kuti urege kuvhiringidzika muhuwandu hwemitsara nemakoramu. Pane zvakawanda zvingasarudzwa zvepagination, zvatichavhara zvakadzama munyaya ino.

Nyore pagination

Iyi nzira ndiyo yakapfava pane yese iripo uye inobvumidza iwe kukurumidza kuverenga mapeji. Kuti aite izvi, unofanira kuita zvinotevera:

1. Iwe unofanirwa kumisa iyo "Musoro uye Footers", nekuda kweizvi iwe unofanirwa kuenda kuExcel pane toolbar muchikamu che "Insert". Mariri, unofanira kusarudza "Text" chinhu uye chete ipapo kushandisa "Headers uye Footers". Chinhu chinonakidza ndechekuti misoro netsoka zvinogona kuiswa zvese pamusoro uye pazasi, nekusarudzika ivo havana kuratidzwa, uye panguva yekutanga kuseta, unogona kuseta kuratidzwa kweruzivo pane imwe neimwe peji yetafura.

2. Mushure mekuenda kune chikamu chaunoda, chinhu chakakosha "Misoro uye makumbo" chichaonekwa, umo iwe unogona kugadzirisa zvirongwa zviripo. Pakutanga, nzvimbo inowanikwa, yakakamurwa kuita zvikamu zvitatu kumusoro kana pasi.

3. Iye zvino yasara kusarudza chikamu chemusoro apo ruzivo rucharatidzwa. Zvakakwana kuti tinya pairi neLMB uye tinya pane "Page nhamba" chinhu.

4. Mushure mekupedza matanho, ruzivo rwunotevera ruchaonekwa mumusoro: &[Peji].

5. Inosara kudzvanya panzvimbo isina chinhu mugwaro kuitira kuti ruzivo rwawakaisa rushandurwe kuita nhamba yepeji.

6. Zvinokwanisika kugadzira ruzivo rwakapinda. Kuti uite izvi, ingosarudza data zvakananga mumusoro uye, mushure mekusarudza, enda ku "Home" tab, iyo iwe unogona kuchinja font, kuwedzera ukuru, kana kuchinja mamwe mapeji.

7. Kana shanduko dzese dzaitwa, inoramba ichidzvanya pane isina chinhu nzvimbo yefaira, uye inozoiswa kumusoro.

Kuverengera zvichienderana nenhamba yese yemapeji mufaira

Pane imwe nzira yekuverenga mapeji mugwaro zvichienderana nehuwandu hwemapeji ari patafura. Kuti aite izvi, unofanira kuita zvinotevera:

1. Pakutanga, iwe unofanirwa kushandisa kurudziro kubva kune yekutanga nzira kusvika panguva yaunoenda kune "Musoro uye tsoka" chikamu.
2. Pakangoonekwa zita rekutanga mumusoro nepasi, unofanira kuzvigadzirisa zvishoma kuti uwane zvinotevera: Peji &[Peji] kubva.

3. Mushure mekupedza kunyorwa "kubva", tinya pane "Nhamba yemapeji" bhatani riri patoolbar kumusoro.

4. Kana zvese zvikaitwa nemazvo, ipapo mushure mekudzvanya pane isina chinhu nzvimbo yepeji, iwe uchaona musoro unozoratidza ruzivo nezve nhamba yepeji uye huwandu hwese hwemashiti.

Kuverenga kubva papepa rechipiri

Kana iwe wakambonyora pepa rezwi kana thesis, saka iwe unogona kunge uchiziva mutemo mukuru wekugadzira: iyo peji nhamba haina kuiswa pane peji remusoro, uye peji rinotevera rakanamirwa kubva kune deuce. Matafura anogona zvakare kuda iyi dhizaini sarudzo, saka tinokurudzira kuti uite zvinotevera:

1. Iwe unofanirwa kumisa misoro uye tsoka, nekuda kweizvi, shandisa kurudziro kubva kune yekutanga nzira.
2. Iye zvino muchikamu chinooneka, enda kune "Parameters" chinhu, maunogona kutarisa bhokisi riri pedyo ne "Special header for the first page" chinhu.

3. Chinosara kunhamba mapeji neimwe yenzira dzakambofungwa. Chokwadi, pakuverenga, unofanira kutosarudza peji rechipiri kuti umise musoro.
4. Kana iwe ukaita zvese nemazvo, iwe uchawana mhedzisiro yaunoda. Muchokwadi, musoro uri papeji yekutanga uchange uripo, haungoratidzike. Dhizaini yekuona inototanga kubva papeji yechipiri, sezvayaidiwa pakutanga.

Iyi sarudzo yenhamba inokodzera kugadzirwa kweakasiyana mapepa esainzi uye mune yekupa tafura sechinhu chekuisa mubepa rekutsvagisa.

Kuverengera kubva papeji chaiyo

Mamiriro ezvinhu anogoneka zvakare kana zvichidikanwa kuti utange kuverenga kwete kubva papeji yekutanga, asi kubva kune yechitatu kana kunyange peji regumi. Kunyangwe izvi zvisingaite zvakanyanya, hazvizove zvakapusa kuziva nezve kuvapo kweiyo nzira, iyo algorithm yezviito ndeyotevera:

1. Kutanga, zvinodikanwa kugadzira manhamba ekutanga uchishandisa imwe yenzira dzakurukurwa pamusoro apa.
2. Mushure mekupedza matanho ekutanga, iwe unofanirwa kuenda pakarepo kuchikamu che "Page Layout" pane iyo toolbar.
3. Nyatsodzidza chikamu uye teerera kune chinyorwa "Peji Setup" pazasi pasi pezvinhu "Print Area", "Breaks", etc. Pedyo nechisiginecha ichi unogona kuona museve, tinya pairi.

4. Hwindo rine mamwe marongero richaonekwa. Muhwindo iri, sarudza chikamu che "Peji", uye wozowana chinhu che "First Peji Nhamba". Mariri iwe unofanirwa kutsanangura kubva kune peji ipi yaunoda manhamba. Kana zvese zvagadziriswa, tinya "OK".

5. Mushure mekupedza nhanho, iyo manhamba ichatanga chaizvo nenhamba yawakatsanangura mumaparamita.

Kana iwe uchida kubvisa manhamba, wobva wasarudza ruzivo rwuri mukati memusoro wobva wadzvanya pakanzi "Kudzima".

mhedziso

Maitiro ekuverenga haatore nguva yakawanda uye anobvumidza iwe kuti ugone hunyanzvi uhu hunobatsira pasina matambudziko. Zvakakwana kushandisa mazano aripo anoratidzwa pamusoro kuti apedze basa racho.