- Madhinda nzvimbo, miganho, kutaridzika, uye saizi yepepa kudzivirira kucheka.
- Shandisa kuyera kwakaringana (1x1, makoramu kana mitsetse) uye gara uchisimbisa mukutarisa.
- Misiyano yakakosha muExcel webhu uye Google Mashizha: kusarudzwa kwepeji, miganhu, uye manhamba.
- Sarudzo dzekudhinda akawanda mapepa / mabhuku, chaiwo matafura uye kugadzira PDF kucheneswa.
Kukwanisa kudhinda muExcel hakusi kwekungodzvanya bhatani nekuyambuka zvigunwe zvako; kana pepa razara nedata, chero miganho yakarasika, kutarisa kusiri iko, kana chikero chisina kururama zvinogona kukanganisa chigumisiro. Kana wakasangana nematafura akatyoka, mapeji asingakwane, kana kusvetuka kusinganzwisisike, heino maitiro ekuadzivirira nhanho nhanho.
Mugwaro rino rakazara, rinoshanda, takanyora zvakakosha pakudhinda kubva kuExcel (desktop newebhu) neGoogle Sheets. Iwe uchadzidza kugadzira pepa, tsanangura nzvimbo dzekudhinda, gadzirisa miganho uye maitiro, kuyera kune peji, nyora chete sarudzo kana tafura chaiyo, dhinda mapepa akawanda kana mabhuku ekushanda panguva imwe chete, uye kunyange kuchinja kupi muExcel yewebhu. Uyezve, isu tinowedzera matipi emhando, kuchengetedza inki, uye maitiro ekugadzira PDF yakachena.
Zvirongwa zvekutanga usati wadhinda muExcel
Usati wadhinda, zvakakosha kutora miniti kugadzirira. MuExcel yedesktop, nzira inokurumidza yekuwana preview uye sarudzo ndeye Faira > Dhinda (kana Ctrl+P), uko iyo interface inovhura ine preview kurudyi uye zvigadziriso kuruboshwe. Ikoko unogona kusarudza printer, makopi, uye tarisa kuti peji yacho ichataridzika sei.
Kuti unyatso dhizaini, enda kuKuronga Kwepeji kana Kudhinda Zvivakwa: kutaridzika (mufananidzo / mamiriro), saizi yepepa, uye miganho“Yakajairika” kana “Nhete” miganho inoshanda nemazvo zvichienderana nezviri mukati; kana uchida kukwenenzvera zvigadziriso, shandisa Tsika Margins kusvika mamilimita-saizi padivi rega rega.
Kutarisa kwakakosha: kana bhodhi rako rakafara, yakatwasuka yakatarisana Izvi zvinodzivirira kucheka; kana iri kureba kudarika yakapamhama, yakatwasuka inozonyatso verengwa. Chinja sarudzo kubva Peji Kurongeka> Oriental uye tarisa preview kuti uone kuti hapana makoramu akarembera.
Kana iwe uchitsvaga kuti zvese zvikwane pane rimwe pepa, tarisa kuyera. MuExcel unogona kusarudza "Fit sheet kune rimwe peji”, “Gadzirisa makoramu ese kune rimwe peji” kana kuti “Isa mitsara yese kune rimwe peji”Imwe neimwe sarudzo inomanikidza zvakasiyana; dzora saizi yemavara kuti irege kutaridzika kunge microscopic.
Tsika yakanaka kutsanangura nzvimbo chaiyo yekudhinda kana usingadi kudhinda pepa rose. Sarudza rudzi uye enda ku Kurongeka kwepeji> Nzvimbo yekudhinda> Seta Nzvimbo Yekudhinda. Nenzira iyi iwe unodzivirira miganho isina kunaka kana nzvimbo isina kufanira chena.
Dhinda akawanda mapepa nemabhuku panguva imwe chete
Kana iwe uchida kubvisa akati wandei ma tabo kubva kune imwechete faira, haufanirwe kuzviita imwe neimwe. Mubhuku rekushanda reExcel, sarudza mapepa ose ekudhinda (Ctrl + tinya pamatabu) uye vhura Faira > Dhinda. Nenzira iyi, mashizha anoshanda anotumirwa kune printer pamwe chete mubatch imwe chete.
Ko kana uchida kudhinda mabhuku akati wandei panguva imwe chete? Zvinogoneka kana unoisa mafaera ese mufodhi imwecheteKubva kuExcel, enda kuFaira> Vhura, bata pasi Ctrl, uye sarudza bhuku rega rega rebasa raunoda kudhinda, wozosarudza Dhinda. Iyi ndiyo nzira yekudimbudzira yemwedzi nemwedzi mishumo kana mishumo yakatevedzana.
Paunodhinda musanganiswa wemashiti, tarisa preview kuti uone kana mamwe awo asara kumashure. chikero chakasiyana kana kutariswaMuzviitiko izvi, batanidza iwo akakosha ma paramita (kutarisisa, saizi yepepa, uye kuyera) usati watumira batch kumudhinda.
Kana iwe uchifarira kuchengetedza zvese kufaira pachinzvimbo chekunanga pabepa, unogona kusarudza kugadzira inobuda faira. Mumutsara wekudhinda, sarudza Printer > Dhinda kuFaira, dzvanya Prinda uye isa zita refaira kana wakumbirwa. Izvi zvinobatsira pakuongorora kwemukati kana kuchengetedza maitiro.
Dhinda pepa rose, chikamu charo chete, kana tafura chaiyo
Kana iwe usingade bhuku rese rebasa, Excel inokuita kuti unyatso-tune izvo zvinoenda kuprinta. Mune inodhinda panel, unogona kusarudza pakati Sarudzo, Anoshanda Sheets, Yese Bhuku Rebasa, kana Tafura. Rongedza iyi sarudzo zvinoenderana nechinangwa chako kuti udzivise kurasika bepa.
Kudhinda mutsara chete, tanga wasarudza maseru uye, muFaira > Dhinda, sarudza Prinda kusarudzwa. Tarisa uone kufanoona: Kana chirimwa chisiri sezvawaida, vhara preview, gadzirisa chiyero, uye dzokorora. Ndiyo nzira yakachena yekuwana chete zvakakosha ruzivo.
Iwe unoshanda nematafura eExcel (Isa> Tafura)? Kana ukasarudza chero sero patafura, unogona kuisarudza paunodhinda. “Prinda tafura yakasarudzwa” muSettings. Nenzira iyi, iwe unongoona iyo tafura, yakanyatsogadzirwa uye isina chero ekunze zvinhu.
MuExcel yewebhu iwe unogona zvakare kudhinda sarudzo kana shizha rese kubva Faira > Dhinda > DhindaKana wakamaka maseru wobva wachinja pfungwa dzako, chinja sarudzo kuti uite "Entire Workbook" usati wadzvanya bhatani rakadhinda; iyo preview ichakuratidza ipapo kuti ichataridzika sei.
Kana tafura yako kana huwandu hwakakura kwazvo, yeuka zvisingakwanisi: muExcel yewebhu, kudhinda tafura kunokurudzirwa. kana uine maseru asingasviki gumiKune akakura rondedzero, zviri nani kuvhura iyo faira mudesktop app uye kuigadzirisa kubva ipapo.
Ongorora, dhinda nzvimbo, uye kuwedzera kune peji
Preview ishamwari yako yepamoyo: vhura Faira> Prinda kana kushandisa Ctrl+P kuti utarise gwaro sekutambirwa kwarichaita nemudhindi. Sezvo iwe uchiisa shanduko kune kutaridzika, miganho, kana chiyero, zvigunwe zvinogadziridza kuti usazopfura murima.
Kana iwe ukaseta nzvimbo yekudhinda uye wozoda kuichinja, ingosarudzazve maseru uye dzokorora. Kurongeka kwepeji> Nzvimbo yekudhinda> Seta Nzvimbo YekudhindaImwe neimwe sarudzo nyowani inodarika iyo yapfuura, uye yekutarisa inosimbisa sarudzo yako.
Kana paine mitsara yakavanzika kana makoramu, chengeta izvi mupfungwa: muExcel yewebhu, zvemashiripiti hazvina kudhindwaKana iwe uchida kuabatanidza, sunungura iwo mitsetse/makoramu asati adhinda. Iwe unozoona izvi nekushayikwa misoro kana mitsetse yakapetwa kaviri mune zvinyorwa; sarudza misoro iri padyo, tinya-kurudyi, uye sarudza Unhide.
Kana bhuku rako rekushanda riine mapepa akavanzwa, haaonekwe mune zvakabuda kusvika waabuditsa. Tinya-kurudyi chero tab, uye kana iwe ukaona sarudzo Ratidza, zvinoreva kuti pane tabo dzakavanzika; varatidze, sarudza dzaunoda, wodhinda zvakare.
Kuti ikwane pane rimwe pepa pane maitiro akati wandei: "Fit sheet kune rimwe peji" inoderedza zvese zvirimo;Gadzirisa makoramu ese papeji imwe chete" inobatanidza hupamhi uye inoparadzira mitsetse pamapeji akati wandei; "Isa mitsara yese papeji imwe chete" inoita zvinopesana. Kana pasina imwe yesarudzo inoita kuti chinyorwa chako chibude, gadzirisa sikero nechikamu chemaoko.
Mamwe akati wandei marongero anoita mutsauko: iyo saizi chaiyo yepepa (semuenzaniso, A4) uye miganho. Muganho wakatetepa unokupa imwe nzvimbo yedata, asi chenjera kuti usasiye misoro kana tsoka dziri padyo nemupendero; kana uchida kunyatsoita, shandisa Custom Margins.
Muzvinyorwa zvekudhinda iwe unogonawo kusarudza kudhinda kune rumwe rutivi kana mativi ose. The print mode mupendero wakareba inogadzirira kuverenga sebhuku (kutenderedza mapeji kudivi), uku pfupi kumucheto Iyo yekarenda-maitiro (yakadzoserwa kumusoro). Sarudza iyo inonyatsoenderana nerudzi rwegwaro.
Kana uri kudhinda makopi akawanda egwaro remapeji akawanda, isa sarudzo yacho interleavedNekubatanidzwa, printer inodhinda yakazara seti 1-2-3, 1-2-3; pasina kubatanidzwa, inodhinda 1-1-1, 2-2-2, 3-3-3, izvo zvinokanganisa kurongedza kunotevera.
Tsanangudzo yakakosha muExcel yeWebhu: hazvigoneke isa, ona, kana kuprinda nhamba dzepeji kubva kubrowser. Kana iwe uchida misoro ine nhamba kana tsoka, vhura iyo faira mudesktop app, wedzera nhamba muPeji Kurongeka, uye printa kubva ipapo.
Excel yeWebhu neGoogle Sheets: Misiyano uye Madhinda Zvakanaka
MuExcel yeWebhu, inokurudzirwa Shandisa Excel's Print command uye kwete yebrowser. Enda kuFaira> Dhinda> Dhinda uye sarudza pakati peSarudzo Yazvino kana Bhuku Rese. Chero shanduko kusarudzo inoda kuvhara preview, kugadzirisa sarudzo, uye kudhinda zvakare.
Kana iwe uchida kuve nechokwadi chekuti zvese zvinokwana, sarudza chikero chakakodzera uye simbisa neiyo yekutarisa thumbnail. Kunyangwe izvo zvirimo zvinokodzera, kana iwe ukaona izvozvo saizi yemavara inodonha zvakanyanyaUngangoda kupatsanura rondedzero yako kuita mapeji akawanda uye shandisa misoro yakadzokororwa kumusoro kuti iverengeke.
MuGoogle Sheets, nzira yakafanana: Faira> Dhinda kana chiratidzo cheprinta. Kubva ipapo, iwe unosarudza saizi yebepa, kutaridzika, miganho, uye kuyera. Kana uchingoda dunhu chete, sarudza “Prinda nzvimbo yakasarudzwa”Kana iwe uchida kuisa zvese pane imwe peji, shandisa iyo "Fit kuPeji" sarudzo.
Mashiti anokuita kuti usarudze kuti ndeapi mashizha ekudhinda, kugadzirisa mafomati uye kurongeka, uye kuona zvabuda zvichirarama. Kungofanana neExcel, Kune matafura akafara kwazvo, zvakakodzera kuchinjira kune yakachinjika yekutarisa. uye dzvanya makoramu zvishoma kudzivirira kurasikirwa kuverenga.
Kuti upedze maitiro nehunyanzvi mhedzisiro, jaira kushandisa preview uye kumisa marongero ako: saizi yebepa yakafanana, miganho inowirirana, uye chiyero chisingapira saizi yefonti. Kubatana pakati pemashizha Inovandudza kuverenga zvakanyanya paunodhinda bhuku rine ma tabo akawanda.
Anobatsira mapfupi uye sarudzo: preview, kukurumidza kusarudza, uye zvivakwa
Iyo keyboard yekudimbudzira Ctrl + P inovhura yakananga iyo yekudhinda maonero ne thumbnail kurudyiNdiyo inokurumidza nzira yekutarisa mabhureki, misoro, uye mabreak pasina kusiya pepa. Kana chimwe chinhu chisingakwane, dzokera shure nhanho, gadzirisa, uye tarisa zvakare.
MuPrinters panel, unogona kushandura chishandiso chinoshanda kubva ku "Printer" yekudonha-pasi menyu. Kana iwe uchigadzirisa akawanda maprinta (semuenzaniso, ruvara uye monochrome), mutengi anokuchengetedza iwe kuuya nekuenda. Pamusoro pezvo, bhatani reZvivakwa rinovhura printa-chaiyo mutyairi sarudzo (mhando, tireyi, bepa rudzi).
Kumatafura, ipfungwa yakanaka kusarudza chimiro chese usati wadhinda. Dzvanya sero yekutanga, bata Shift, uye sarudza yekupedzisira yekuivhara. makoramu ose nemitsara patafura pasina kupuruzira kure. Nenzira iyi unogona kuve nechokwadi kuti haucheke netsaona mbiru.
Kana iyo pepa iine maonero akawanda kana mafirita, teerera kune zviri kuratidzwa pachiratidziri. Excel inodhinda izvo zvinoonekwa zvichibva pane zvakasarudzwa uye nzvimbo yakatarwa, saka kana iripo mbiru dzakasefa kana dzakavanzwa, tarisa kana uchinyatsoda kuabvisa pabepa kana kuti uchida kuaratidza tisati tadhinda.
Hunhu, kuchengetedza, uye PDF: matipi ekupedzisira anoita mutsauko
Kana gwaro racho riri rekutumira kana kuchengetedza, funga kugadzira PDF. MuExcel pane desktop, unogona kushandisa Faira> Chengetedza Sezvo kana Tumira kune pepa PDF Mushure mekugadzirisa basa rekudhinda (kutarisisa, miganho, chiyero, uye nharaunda), iwe unowana yakatendeka, iri nyore-kugova faira isingatyoke kana yavhurwa.
MuGoogle Sheets zvakatonyanya kutwasuka: Faira> Dhawunirodha> PDF. Iyo mapaneru ekuseta akafanana zvakanyanya nedhinda pani, saka unogona shandisa zvakare marongero mamwe chete kuti uwane PDF yakachena pakuedza kwekutanga.
Kana iwe uchida yepakati kudhinda faira pane bepa, sarudza sarudzo Dhinda kufaira Muchinyorwa cheprinta, baya Dhinda uye utumidze zita kana wakurudzirwa. Nenzira iyi, unogona kuchengeta chaizvo zvaungadai wakatumira kune anodhinda.
Kuti uvandudze mhando pasina kuwedzera mutengo, isa iyo yekudhinda ku "Draft" paunenge uchidhinda. unongoda bvunzo dzekukurumidza uye chengetedza mhando yepamusoro kune yekupedzisira vhezheni. Kusarudza bepa rinoenderana negwaro rako (semuenzaniso, bepa rakajairwa rematafura uye pepa gobvu remharidzo) rinovandudza zvakanyanya kunzwa uye kuverenga.
Kana ukadhinda kakawanda, funga kushandisa zvinhu zvinovimbika, zvinoenderana uye chete kudzora ruvara kana ichiwedzera kukosha. Kune mareports enhamba chete, monochrome nekusiyana kwakanaka kazhinji inokwana uye ine mari yakawanda.
Kune masevhisi ekudhinda epamhepo anokutendera kuti uise iyo PDF, sarudza rudzi rwebepa (ruvara kana dema nechena), uye kupera. Izvi zvinobatsira kana Hauna printer pedyo Kana kuti unoda zvepakati nepakati anodhinda anomhanya nemhando inowirirana; kugadzirira faira rako nemazvo (marinji, chiyero, kutariswa) kunovimbisa mhedzisiro isina mhosva.
Nezvese zviri pamusoro apa, iwe unotova nemidziyo yekudhinda pasina matambudziko: gadzira pepa, tsanangura nzvimbo, gadzirisa miganho uye kutungamira, sarudza kana kuyera kune rimwe peji kana kupararira pane akati wandei, shandisa preview kuti usimbise uye, kana nguva yasvika, shandura kuita PDF kana faira kuchengetedza yekutanga yakakwana yekugovana kana kudhinda.
Kudhinda maspredishiti kunova kushoma kwemarwadzo kana iwe ukapinda mumaitiro: preview, yakajeka paramita, uye kuwirirana pamapepa. Kugadzirisa kusarudzwa, kuyera, uye miganho, Iwe uchawana zvakachena, zvinonzwisisika uye zvehunyanzvi kubuda zvese zviri muExcel (desktop newebhu) neGoogle Sheets, pasina zvinoshamisa kana "kurumwa" mapeji.
Anofarira munyori nezve nyika yemabytes uye tekinoroji zvakazara. Ini ndinoda kugovera ruzivo rwangu kuburikidza nekunyora, uye ndizvo zvandichaita mune ino blog, kukuratidza zvinhu zvese zvinonyanya kufadza nezve gadget, software, hardware, tekinoroji maitiro, nezvimwe. Chinangwa changu ndechekukubatsira kufamba munyika yedhijitari nenzira iri nyore uye inonakidza.