Maitiro ekuseta uye kugadzirisa nzvimbo yekudhinda muExcel

Kazhinji, mushure mekupedza kushanda netafura muExcel, unoda kudhinda chigumisiro chakapedzwa. Paunenge uchida gwaro rese, zviri nyore kutumira data rese kune anodhinda. Zvisinei, dzimwe nguva pane mamiriro ezvinhu apo zvakakosha kusarudza zvimwe zvikamu zvekudhinda kubva mufaira rose. Muchiitiko ichi, iwe unofanirwa kushandisa zvakavakwa-mukati maficha echirongwa, isa zvigadziriso zvenguva pfupi kana zvechigarire zvekudhinda zvinyorwa.

Nzira dzeKugadzirisa Nzvimbo Yekudhinda muExcel

Pane nzira mbiri dzekugadzira uye kugadzirisa nzvimbo inodhindwa yeExcel spreadsheets:

1. Kurongwa kwechirongwa chimwe chete usati watumira gwaro kuti ridhindwe. Muchiitiko ichi, maparameter apinda achadzokera kune ekutanga pakarepo mushure mokunge faira yadhindwa. Iwe uchafanirwa kudzokorora nzira yacho isati yadhindwa inotevera.
2. Kugadzirisa inogara ichidhindwa nzvimbo, saka haufanirwe kugadzirisa zvakare mune ramangwana. Nekudaro, kana iwe uchida kudhinda akasiyana matafura nenzvimbo dzakasiyana, uchafanirwa kugadzirisa zvakare chirongwa.

Imwe neimwe yenzira idzi ichakurukurwa zvakadzama pazasi.

Kugadziriswa nguva dzose kwenzvimbo dzekudhinda

Iyi nzira ichave yakakosha kana matafura aunoshanda nawo achigara achida kuchinja nzvimbo dzekudhinda.

Teerera! Hatifanire kukanganwa kuti kana mune ramangwana uchida kudhinda zvakare gwaro rekutanga, zvese zvigadziriso zvinofanirwa kuiswa zvakare.

Nzira:

1. Sarudza maseru ane ruzivo rwaunoda kudhinda. Izvi zvinogona kuitwa nemakiyi ekhibhodi (mabhatani ekufambisa) kana nekubata LMB uye zvishoma nezvishoma uchifambisa mbeva ichidzika kunzvimbo yaunoda.

2. Kana huwandu hunodiwa hwemasero hwakanyorwa, unofanirwa kuenda kune "Faira" tab.
3. Mune menyu inovhura, sarudza iyo "Printa" basa.
4. Tevere, unofanirwa kuseta sarudzo dzekudhinda dzemhando yakasarudzwa yemasero. Pane zvinhu zvitatu zvingasarudzwa: dhinda bhuku rose rekushanda, dhinda mapepa anoshanda chete, kana kudhinda sarudzo. Iwe unofanirwa kusarudza yekupedzisira sarudzo.
5. Mushure meizvozvo, iyo yekutarisa nzvimbo yeyakadhindwa vhezheni yegwaro icharatidzwa.

Kana ruzivo rwakaratidzwa ruchienderana nerunoda kudhindwa, chinosara kudzvanya bhatani rekuti "Printa" uye kumirira kudhindwa kwapera kuburikidza neprinta. Kana kudhinda kwapera, zvigadziriso zvichadzokera kune zvigadziriso zvekutanga.

Kugadzirisa yunifomu parameters kune ese magwaro

Paunenge uchida kudhinda iyo yakafanana nzvimbo yetafura (makopi mazhinji panguva dzakasiyana dzenguva kana kushandura ruzivo mumaseru akasarudzwa), zviri nani kuseta yakagadzika dhinda marongero kuti usashandure marongero kakawanda. Maitiro:

1. Sarudza huwandu hunodiwa hwemasero kubva patafura yakajairika (uchishandisa chero nzira dziri nyore).
2. Enda kune "Peji Layout" tab pane huru toolbar.
3. Dzvanya pa "Print Area" sarudzo.
4. Pachave nesarudzo mbiri dzezvimwe zviito - "Bvunza" uye "Bvisa". Unofanira kusarudza yekutanga.

5. Iyo purogiramu ichagadzirisa otomatiki nzvimbo yakasarudzwa. Icharatidzwa pese apo mushandisi anofamba achienda kuchikamu chekudhinda.

Kuti utarise kurongeka kwedata, unogona kuita preview kuburikidza nekudhinda marongero. Iwe unogona kuchengetedza iyo yakatarwa paramita nekudzvanya pane iyo floppy disk icon mukona yekumusoro kuruboshwe kana kuburikidza ne "Faira" menyu.

Kuisa nzvimbo dzakawanda dzekudhinda

Dzimwe nguva unofanirwa kudhinda akawanda clippings kubva kune imwechete spreadsheet muExcel. Kuti uite izvi, iwe unofanirwa kushandura zvishoma kurongeka kwezviito nekuwedzera imwe yepakati nhanho:

1. Sarudza nzvimbo yekutanga kudhinda nemabhatani embeva kana makiyi ekufambisa pakhibhodi. Muchiitiko ichi, zvakakosha kubata bhatani re "CTRL".
2. Pasina kuburitsa bhatani re "CTRL", sarudza nzvimbo dzasara dzaunoda kudhinda.
3. Enda kune "Peji Layout" tab.
4. Kubva muboka reKugadzira Peji, sarudza iyo Dhinda Nzvimbo chishandiso.
5. Inoramba ichiwedzera mitsara yakambotarwa, sezvatsanangurwa pamusoro apa.

Zvinokosha! Usati watanga kudhinda nzvimbo dzinoverengeka dzetafura, unofanirwa kufunga kuti imwe neimwe yadzo ichadhindwa pane imwe pepa. Izvi zvinokonzerwa nekuti kudhindwa kwekubatana pane rimwe pepa, mitsara inofanira kunge iri pedyo.

Kuwedzera Sero kune Set Area

Imwe mamiriro anogoneka ndeyekuwedzera sero riri padyo nenzvimbo yakatosarudzwa. Kuti uite izvi, hapana chikonzero chekugadzirisa zvirongwa uye kuchinja kune zvitsva.. Iwe unogona kuwedzera sero nyowani uchichengetedza iyo yakatosetwa renji. Nzira:

1. Sarudza maseru akatarisana kuti awedzere kune iripo.
2. Enda kune "Peji Layout" tab.
3. Kubva pachikamu che "Page Options", sarudza "Print Area" basa.

Pamusoro pezvakajairwa sarudzo, mushandisi achapihwa chiitiko chitsva "Wedzera kune inodhinda nzvimbo". Inosara yekutarisa mhedzisiro yapera kuburikidza nehwindo rekuona.

itangezve

Apo mapepa ose ane chiyero chinodiwa akadhindwa kana iwe unoda kuchinja zvirongwa, unoda kugadzirisa zvirongwa. Kuti uite izvi, ingoenda kune "Page Layout", sarudza "Print Area" chishandiso, tinya bhatani rekuti "Bvisa". Mushure maizvozvi, unogona kuseta mitsva mitsva maererano nemirairo inotsanangurwa pamusoro apa.

mhedziso

Nekudzidza maitiro atsanangurwa pamusoro, unogona kudhinda zvinyorwa zvinodiwa kana zvikamu zvawo kubva kuExcel nenguva shoma. Kana tafura iri static, nhamba huru yemasero matsva haawedzerwi kwairi, zvinokurudzirwa kuti pakarepo uise mitsara inodiwa pakudhinda kuitira kuti iwe ugone kuchinja ruzivo mumasero akasarudzwa pasina kugadzirisa zvakare mune ramangwana. Kana gwaro racho richiramba richichinja, marongero acho achafanira kudzokororwa kune imwe neimwe itsva yakadhindwa.