Matambudziko kudhinda muExcel: maitiro ekuagadzirisa nhanho nhanho

Kune vakawanda vashandisi vanoona imwe mhando ye Dambudziko kana uchidhinda yako Excel sheets: kubva pakuona kukanganisa, kupesana kwemahombekombe, maprinta asingateereri, kana zvinyorwa zvisingaite sezvawaitarisira. Sezvineiwo, pane inenge nguva dzose a mhinduro.

Muchinyorwa chino, tichaongorora zvese zvinowanzoitika uye mhinduro dzezvinetso zvekudhinda muExcel, tichibatanidza matanho uye kurudziro kubva kune inotungamira rutsigiro uye ruzivo rwevashandisi masosi.

Zvinowanzokonzera matambudziko ekudhinda muExcel

Seri kwechikanganiso chega chega chekudhinda muExcel pane kazhinji chikonzero chaicho chatinogona kuziva uye kugadzirisa. Zvimwe zvinonyanya kuzivikanwa ndezvi:

• Zvirongwa zvisirizvo zveprinta. Izvi zvinogona kunge zvichikonzerwa nemadhiraivha echinyakare, loose connections, kana zvigadziriso zvisingaenderani.
• Zvikanganiso mukudhinda marongero eExcel faira pachayo. Miganho isina kutsanangurwa zvakanaka, kutariswa, nzvimbo yekudhinda, kana saizi yepepa zvinowanzova mhatsa.
• Magwaro akakuvadzwa kana huori. Dzimwe nguva mafaera ekare kana mafaera akashandiswa pamidziyo yakasiyana anogona kupa matambudziko emukati.
• Software haina kuvandudzwa. Kuve neshanduro dzekare dzeHofisi kana sisitimu yekushandisa zvinogadzira kusapindirana kwekudhinda.
• Kuganhurirwa kweshanduro dzekare dzeExcel. Compatibility mode inogona kukanganisa kuratidzwa uye kudhindwa kwezvimwe zvinhu.
• Kurongeka kwakananga kwemapuratifomu epamhepo kana masevhisi ekunze. Semuenzaniso, kana uchidhinda mapepa kubva kumasevhisi emakore.

Basic Preliminary Matanho: Yakakosha Cheki Usati Wadhinda

Usati wasvetuka kuita shanduko dzakaoma, zvakakosha ongorora zvinhu zvakakosha, Eya, kazhinji chinetso chokudhinda inhau yokusangwarira kana kuti iduku mhosho Zvekugadziriswa.

• Printer yakabatidzwa uye yakabatana nemazvo here?
• Pane bepa rakakwana neingi kana toner here?
• Tambo dzose dzakabatanidzwa zvakanaka here?
• Ko printer yambomira here kana kumirira basa rekare?
• Wakagadziridza system yako yekushandisa, Hofisi, uye madhiraivha?

Kusimbisa aya mapoinzi kunodzivirira kutambisa nguva kutsvaga mhinduro dzakaoma kune izvo dzimwe nguva zviri nyore kutarisa.

Edzai kudhinda mune mamwe mapurogiramu

Imwe yematanho ekutanga anokurudzirwa neMicrosoft nyanzvi ndeye Tarisa kana printer yako ichishanda nemazvo nemamwe maapplication, kunze kweExcel.

Unogona kuita bvunzo iri nyore:

1. Vhura chinyorwa chekunyora senge WordPad, Notes (paMac), kana Notepad pachayo.
2. Nyora chimwe chinhu chiri nyore, semuenzaniso, "Uyu muedzo."
3. Sevha faira uye edza kuriprinda.

Kana iwe usingakwanise kudhinda kubva kune mamwe mapurogiramu, dambudziko riri neprinta, vatyairi vayo, kana kutaurirana nekombuta, kwete Excel. Wobva waedza kuvandudza madhiraivha uye kutarisa marongero eprinta mune yekushandisa system. Kana uchikwanisa kudhinda pasina dambudziko, ramba uchiverenga nekuti mhinduro iri muExcel kana yako chaiyo faira.

Kuedza nemamwe mafaera eExcel

Imwe cheki yakakosha ndeye edza kudhinda rimwe Excel workbook. Gadzira faira idzva risina chinhu, nyora chero chinhu, richengete, uye ridhinde. Kana ikashanda zvakanaka, asi faira rako rekutanga hariite, zvingangoita kuti faira rekutanga rakashatiswa kana kuti rine matambudziko.

Zano: Kopa zvirimo mufaira rine dambudziko kune idzva uye edza zvakare. Kana zvikanganiso zvichiramba zvichiripo, tarisa mafonti, mifananidzo, matafura, uye zvinhu zvakamisikidzwa: dzimwe nguva chinhu chakaora chinogona kuvharira kudhinda.

Key Print Settings muExcel

Excel inochengetedza zvigadziriso zvekudhinda mufaira rega rega. Izvi zvinoreva kuti unogona kuita kuti zvese zvigadziriswe nenzira kwayo mubhuku rimwe chete rebasa, asi mune rimwe, ona kuti miganho, saizi, kana nzvimbo dzinodhinda hadzina kunaka.

Aya ndiwo maitiro akakosha aunofanirwa kuongorora:

• Nzvimbo yekudhinda: Tsanangura kuti ndeapi maseru nemapoka aunoda kudhinda. Sarudza nzvimbo uye, pane Peji Kurongeka tebhu, tinya "Set Print Area."
• Margins uye orientation: Ongorora madhizaini ekutanga uye sarudza kana iwe uchida mufananidzo kana mamiriro ekutarisa.
• saizi yepepa: Ita shuwa kuti inoenderana neyawakarodha muprinta uye neinotsanangurwa muprinta zvivakwa.
• Grid mitsetse: Kana iwe uchida kuti zvidhindwe, shandisa bhokisi rinoenderana mumasetirwo emapepa.
• Prinda preview: Gara shandisa iyo "Print Preview" sarudzo usati watumira gwaro, nekuti zvikanganiso zvekugadzirisa zvinowanzobuda pachena ipapo.
• Dhinda neruvara kana dema nechena: Tarisa kana iwe waita netsaona kugonesa kudhinda kwemavara matema nechena muhwindo reSetup Peji.

Mamwe matambudziko, senge preview isingaenderane nezvakadhindwa, anowanzo enderana nazvo Saizi yemapepa isingaenderane kana marongero emuganho pakati peExcel neprinta yako chaiyo.

Zvidzoreso uye vatyairi: iyo huru yakakanganwa

Zvinetso zvakawanda zvokudhinda zvinongonyangarika kugadzirisa softwareKwete chete Office yako software, asiwo Windows kana macOS, uye kunyanya madhiraivha ako. Microsoft inokurudzira kugara uchiisa zvigadziriso zvichangoburwa, sezvo mazhinji acho achigadzirisa tsikidzi dzinonyanya kukanganisa kuenderana neshanduro itsva dzesystem kana Excel.

Kana printer yako isingaonekwe mukati Windows UpdateEnda kune webhusaiti yemugadziri uye dhawunirodha yazvino mutyairi wepamutemo. Isa uye wotangazve komputa yako usati waedza zvakare.

Faira harisi kuzodhinda kana fomati yakarasika? Nzira yekuona mafaira akaora

Dzimwe nguva, iyo Excel faira yakaora Izvi zvinokanganisa zvakananga kudhinda. Izvi zvinogona kunge zvakakonzerwa nekushanda neshanduro dzekare dzeHofisi kana kushandisa faira pamakombuta akasiyana.

Iyo application pachayo inopa basa rekuyedza kugadzirisa aya mafaera:

1. Vhura Excel asi kwete iyo faira parizvino.
2. Enda ku "Faira"> "Vhura" uye sarudza bhuku rine dambudziko.
3. Mune yakavhurika yekudonha-pasi menyu, sarudza "Vhura uye gadzirisa ...".

Kana izvi zvikasashanda, kopira zvirimo kufaira idzva, uchinyatsoongorora chero zvinhu zvakadzimirirwa zvingave zvakashatiswa.

Mac-chaiyo mhinduro uye matanho

Kana iwe uri kushanda paMac uye uine dambudziko kudhinda yako Excel spreadsheets, matanho akafanana asi ane system-chaiwo nuances:

• Gara uchivandudza yako Apple software kubva kuApple icon menyu, kusarudza "Software Update."
• Tarisa kuti printer haina kumbomira kana kuti ine mabasa akamira mumutsetse.Dzvanya chiratidzo cheprinta muDock uye, kana ukaona bhatani re "Resume", tinya. Dzima chero mabasa akamirira avharisa mutsetse wekudhinda.
• Edza kudhinda kubva kune imwe chirongwa (Manotsi, Shoko, nezvimwewo). Kana ikashanda, dambudziko riri neExcel kana Hofisi.Kana zvakadaro, funga kugadzirisa kana kuisazve Microsoft Office.
• Bvisa uye dzorera printer: Kubva ku "System Preferences"> "Printers & Scanners." Bvisa printer ine "-" chiratidzo uye wedzera zvakare ne "+" chiratidzo.
• Reinstall vatyairiKana danho rapfuura risingabatsire, gadzirisa zvakare dhinda yako. Dzora-tinya pane printa list uye sarudza "Reset Printing System." Tangazve Mac yako uye dzorera printer yako.
• Delete Printer preferencesMafaira ekuda akashatiswa anogona kukonzera kukanganisa. Zvitsvage uye uzviendese kune imwe folda, wobva watangazve uye edza zvakare.

Aya matanho anofanirwa kugadzirisa nyaya dzakawanda dzekudhinda paMac (kusanganisira Hofisi yeMac).

Maitiro ekugadzirisa preview yekudhinda isingaenderane neprintout chaiyo

Imwe yematambudziko anokatyamadza inoitika kana Chitarisiko chakarurama, asi bepa rakadhindwa rinoratidza chimwe chinhu chakasiyana zvachose.Muzviitiko izvi, tarisa kunyanya:

• Saizi yepepa yakaiswa mune zvese Excel uye printer. Nguva dzose dzinofanira kufanana.
• Peji micheto. Shandisa presets kana kugadzirisa kuti zvienderane nezvako nebepa.
• Nzvimbo yekudhinda. Ita shuwa kuti unotsanangura zvakajeka huwandu hwemasero kana matafura aunoda kutumira kune anodhinda.
• Iyo grid mitsetse sarudzo, kana iwe uchida kuti zvidhindwe, inofanira kushandiswa mu "Peji Setup", "Sheet" tab.

Edza neshanduko diki kune zvigadziriso kuti uwane iyo chaiyo.

Mazano ekuona kuti zvese zviri mukati mesero zvinoonekwa pabepa

Uri kuona zviri mukati memamwe maseru achigurwa kana kushaikwa pakudhinda? Izvi zvinowanzoenderana ne:

• Kugadziriswa kwemavara: Sarudza sero, enda kuFormat Cell, uye gonesa iyo "Wrap Text" sarudzo yekuita kuti zvirimo zvikwane hupamhi.
• Autofit mitsara nemakoramu: PaKumba tab, shandisa otomatiki-fit sarudzo dzemaspredishiti anoenderana zviri nani.
• Mapeji anotsemuka: Isa mabreak kuti ugovane zvirimo paunoda.

Rangarira kuti, Muzvinyorwa zvekare zveExcel (compatibility mode), maseru ane muganhu wekuona uye kudhinda.Somuenzaniso: chete 1024 mavara anogona kudhindwa, kunyangwe sero richichengeta kusvika 32.767.

Mhinduro kana zvese zvatadza: gadzirisa Hofisi kana dzosera printa

Kana mushure mekuedza zvese zviri pamusoro dambudziko rikaramba, unogona kushandisa:

• Ita gadziriso yepamhepo yeHofisi: Kubva pachirongwa chepurogiramu mune yekushandisa system, sarudza Microsoft Office uye sarudza "Gadzirisa."
• Uninstall uye dzorera printer uye vatyairi vayo kubva pakutanga. Izvi zvinova nechokwadi chekuti zvese zvakachena kubva kune akaora mafaira kana kuseta.
• Bvisa printa zvaunofarira (paMac), kutonga mafaira akaora ari kupindira.

Muzviitiko zvakanyanyisa, dzorera Office zvachose, kunyanya kana dambudziko rikaitika muExcel uye mamwe mapurogiramu anodhinda zvakakwana.

Nenhanho idzi, Mazhinji ematambudziko patinoda kudhinda muExcel anogona kugadziriswa nemazvo Kana kuongororwa kwakarongeka kwega kwega kwega kunoitwa, kiyi ndeyekuziva chikonzero uye kushandisa zvigadziriso zvinoenderana, kubva pakutarisa masisitimu ekutanga kusvika pakuvandudza vatyairi kana kugadzirisa mafaera akaora.