Seta uye gadzirisa nzvimbo yekudhinda muExcel

Danho rekupedzisira pakushanda paExcel magwaro rinowanzovatumira kune anodhinda. Paunenge uchida kudhinda data yese pane pepa, kazhinji hapana matambudziko neizvi. Asi chii chatinofanira kuita kana tichibata netafura huru, uye chikamu chimwe chete chayo chinoda kudhindwa.

Iwe unogona kugadzirisa nzvimbo yekudhinda muExcel nenzira dzakasiyana:

• gadzirisa nguva imwe neimwe gwaro rinotumirwa kumudhinda;
• gadzirisa imwe nzvimbo mune zvinyorwa zvinyorwa.

Ngatitarisei nzira mbiri uye tione kuti dzinoitwa sei muchirongwa.

Method 1: Gadzirisa nzvimbo nguva imwe neimwe usati wadhinda

Iyi nzira yakakodzera kana tichida kudhinda gwaro kamwe chete, saka hapana chikonzero chekugadzirisa dzimwe nzvimbo dzenguva yemberi. Nekudaro, kana isu tikazofunga kudhinda iro gwaro rimwe chete, marongero anozofanirwa kuitwa zvakare.

Iyo algorithm yezviito zvinotevera:

1. Nenzira ipi zvayo yakanakira (semuenzaniso, kushandisa bhatani rekuruboshwe rakadzvanywa), sarudza huwandu hwemasero atinoronga kutumira kuti tidhindwe. Ngatitii tinoda kudhinda kutengesa chete kune yekutanga neyechipiri zvitoro. Mushure mekusarudza, tinya pane menyu "Faira".
2. Muchinyorwa chiri kuruboshwe, enda kuchikamu “Chisimbiso”. Muchikamu chekurudyi chehwindo, tinya pane yazvino yekudhinda sarudzo (iri ipapo pazasi pezita rebhuroko "Parameters").
3. Rondedzero yezvaungagona kuprinda ichavhurwa:
   • mashizha anoshanda;
   • bhuku rose;
   • chidimbu chakasarudzwa (tinochida).
4. Nekuda kweizvozvo, chikamu chetafura chakasarudzwa nesu chete ndicho chinoratidzwa munzvimbo yekutarisa gwaro, zvinoreva kuti kana bhatani radzvanywa. “Chisimbiso” mashoko aya chete ndiwo achadhindwa pabepa.

Method 2: Gadzirisa Constant Print Area

Mumamiriro ezvinhu apo basa negwaro rinoitwa nguva dzose kana nguva nenguva (kusanganisira kuitumira kuti idhindwe), zvinonyanya kukosha kugadzirisa nzvimbo yekudhinda nguva dzose. Izvi ndizvo zvatinoitira izvi:

1. Senge nzira yekutanga, tanga wasarudza nzvimbo yaunoda yemasero. Zvadaro chinja kune tab "Page layout"kwatinobaya bhatani “Print area” mubhokisi rematurusi "Peji zvigadziriso". Iyo sisitimu ichatipa mbiri sarudzo: set uye bvisa. Tinomira pane yekutanga.
2. Nokudaro, takakwanisa kugadzirisa nzvimbo yemasero, ayo acharamba achidhindwa kusvikira tasarudza kugadzirisa chero ipi zvayo. Unogona kutarisa izvi munzvimbo yekutarisa mune zvekudhinda sarudzo (menu "Faira" - chikamu “Chisimbiso”).
3. Inosara chete kuchengetedza shanduko mugwaro nekudzvanya bhatani rakakodzera mumenyu "Faira" kana nekudzvanya pane floppy disk icon pakona yepamusoro kuruboshwe yechirongwa.

Kubvisa pinning kubva munzvimbo inodhinda

Ngatitii tinoda kushandura nzvimbo yakadhindwa kana kuibvisa zvachose. Kuti uite izvi, dzokera kune tab "Page layout" mune sarudzo dzinovhura mushure mekudzvanya bhatani “Print area” sarudza nguva ino "Bvisa". Muchiitiko ichi, hazvidi zvachose kuti usarudze chero huwandu hwemasero ari patafura.

Isu tinodzokera kune zvakadhindwa marongero uye tinoita shuwa kuti dzadzokera kune yekutanga.

mhedziso

Nekudaro, hapana chakaomesesa pakuseta yakatarwa nzvimbo yekudhinda muExcel, uye maitiro aya anotora maminetsi mashoma uye nekudzvanya kuti upedze. Panguva imwecheteyo, kana tikaronga kugara tichishanda negwaro racho nekuridhinda, tinogona kugadzirisa nzvimbo chaiyo iyo ichatumirwa kunodhinda nguva imwe neimwe, uye hatizofaniri kupedza nguva pane izvi mune ramangwana.