Ungayiphrinta kanjani itafula le-Excel eshidini elilodwa. Ukushintsha ukuqondiswa, ukubeka imingcele yamakholomu nemigqa, ikhasi kanye namapharamitha okuphrinta

Ekupheleni komsebenzi eMicrosoft Office Excel, abasebenzisi banesidingo sokuphrinta idokhumenti. Amathuluzi akhiwe ohlelweni akuvumela ukuphrinta ithebula ngokuphelele ephepheni le-A4. Kodwa-ke, lokhu kuzodinga ukuthi kube nokukhohlisa okuzoxoxwa ngakho kulesi sihloko.

Ukusetha Ikhasi Lepharamitha

Okokuqala, kufanele uhlole izilungiselelo zeshidi elisebenzayo lamanje bese uzishintsha uma kunesidingo. Kunamapharamitha ambalwa anjalo ku-Excel, ngokuqonda okuphelele kwesihloko, kuyadingeka ukubheka imininingwane ngayinye ngayinye.

Indlela eya ewindini le- "Page Parameters". I-algorithm efanelekile kuzo zonke izinhlobo zamathebhu we-Excel

Lesi yisibonisi esivela ngaphezulu kwewindi lohlelo. Ezinye izinto zalo kuzodingeka zisebenzise lapho setha amapharamitha eshidi.

Ikhasi

Ukuhlola ukuqondiswa kweshidi bese ululungisa, kuyadingeka ukwenza izenzo ezilandelayo kwi-algorithm:

1. Shintshela ku- "MarkUP yekhasi" phezulu kwe-Microsoft Excel.
2. Ngezansi kokuhlukaniswa ukuze uthole ikhasi "izilungiselelo zekhasi" bese uqhafaza kumdala, osekoneni elifanele. Iwindi elihambisanayo kufanele livule.
3. Hambisa engxenyeni ethi "Ikhasi" ukwenza izilungiselelo ezifanele.

Izenzo ezidinga ukwenziwa esigabeni "ekhasini" ukubeka itafula ekhasini elilodwa lomsebenzi

Lapho ukuphrinta amatafula ku-Excel, kubalulekile ukubheka usayizi wensimu. Leli ibanga elinokusuka onqenqemeni lweqabunga ngaphambi kokuqala kombhalo. Bheka amanani aboniswe amasimu ngalendlela elandelayo:

1. Ngokwesikimu esifanayo okuxoxwe ngaye esigabeni esedlule, hambisa esigabeni "umaki wekhasi" ngaphezulu kohlelo, bese uqhafaza i-LKM ku- "Izilungiselelo Zekhasi".
2. Ewindini elijwayelekile, elizokhonjiswa ngemuva kokwenza lokhu kusebenza, udinga ukuya kuthebhu ethi "Fields".
3. Lesi sigaba somsebenzisi sinentshisekelo entweni "ekhasini elisemakhasini". Ngokuya ngesembozo seshidi lapha udinga ukubeka uphawu noma okuphambene nenkambu "ngokuqondile" noma eduze kwenani elifanele ".
4. Shintsha amanani we-tooter ephezulu nangaphansi uma kunesidingo. Kodwa-ke, lokhu ngeke kwenziwe ngalesi sigaba.

Shintsha amanani we-Upper and Footer kuma-Fields Tab. Kuyanconywa futhi ukusebenzisa umsebenzi wokugxila kweshidi.

Le yithebhu yokugcina ekhasini elithi "Izilungiselelo Zekhasi", ezibhekele ikhwalithi yemibhalo ephrintiwe. Kulesi sigaba, ungacacisa enye yezinhlobo zokuphrinta: igridi, igridi, emnyama nomhlophe, izihloko ezinolaka, izintambo namakholomu. Kungenzeka futhi ukucacisa ingxenye yetafula kuphela yokuphrinta uma lonke ipuleti lingafakwanga eshidini elilodwa ngokubhala ubukhulu obufunayo ku- "Phrinta Ibanga" umugqa womugqa.

Isigatshana sokubukeka "ishidi" ewindini "lePhaphamathi"

Lezi yizici ezithile zedokhumenti ezizophrintwa ngokuzenzakalela esiqeshini ngasinye. Yehlisa inani lezinyoni, umsebenzisi ukhulula isikhala esingeziwe ekhasini lomsebenzi, elizosiza ukugqamisa uphawu. Ukususa ngokuphelele ngokubhala kuwo wonke amadokhumenti azovela lapho ukuphrinta, kufanele wenze ngokwemiyalo:

1. Iya kuthebhu ethi "Ikhasi Markup" ngaphezulu kwemenyu enkulu yohlelo.
2. Cindezela inkinobho ethi "Izilungiselelo Zekhasi".
3. Chofoza igama elithi "ama-footer" egrafu elingaphezulu elibonakalayo elibonise amawindi.
4. Emasimini "unyawo olungaphezulu" kanye "nonyathi" setha inani "(cha)" ukukhipha ngokuphelele ngemibhalo.

Ukucisha amakhanda esigatshaneni esifanele

Lapho umsebenzisi ekhombisa wonke amapharamitha adingekayo, kuzokwazi ukushintshela kudokhumenti yokuphrinta. Ngale njongo, kufanele wenze lezi zinyathelo ezilandelayo:

1. Ngokufanayo, ngena ku- "Izilungiselelo Zekhasi".
2. Ewindini elivula, iya ethebhu "ekhasini".
3. Ngezansi kwemenyu, kufanele uchofoze inkinobho ethi "View", ngemuva kwalokho imenyu yokuphrinta ephambili iyavula.
4. Ngakwesokudla kwewindi elivuliwe kuzokhonjiswa indawo yetafula ekhasini lokusebenzela. Uma konke kufanela lapha, kufanele uchofoze inkinobho ethi "Phrinta" etholakala ekhoneni eliphezulu kwesokunxele. Uma kunesidingo, kule windi, ungalungisa amapharamitha wokuphrinta bese ubheka ngokushesha ushintsho.

Ukukhishwa kombhalo wokuphrinta ngokubuka kuqala

Unganciphisa kanjani (i-compress) Ithebula elikhulu lokuphrinta eshidini elilodwa lefomethi ye-A4

Kwesinye isikhathi itafula elikhulukazi elikhulu ku-Excel alilingani ephepheni elilodwa. Esimweni esikhona njengamanje, unganciphisa i-tafula i-array kusayizi oyifunayo ukuze lilingane nephepha elilodwa le-A4. Le nqubo yenziwa ngezigaba eziningana, ngalinye elizochazwa ngezansi.

Faka ishidi ekhasini elilodwa

Le ndlela iyasebenza uma enye ingxenye encane yetafula idlula ngaphezulu kwephepha elisebenzayo lefomethi ye-A4. Ukuze uvumelane neplate eshidini elilodwa, kuzodingeka wenze inani lezenzo ezingelula:

• Nwebisa isigaba sefayela ekhoneni eliphezulu kwesokunxele sohlelo ngokuchofoza kulo kanye nge-LKM.
• Kumenyu yokuqukethwe, chofoza umugqa "wokuphrinta".

Indlela eya ewindini elithi "Phrinta Parameters" ku-Excel

• Ngakwesokunene sewindi kukhombisa lonke ulwazi ngokuphrinta kwedokhumenti. Lapha umsebenzisi uzodinga ukuthola isigatshana esithi "Sethaup".
• Chofoza kumdala nge-radom ngephuzu "lamanje" bese uqhafaza kukhetho "Faka ishidi lekhasi elilodwa."
• Linda kuze kube yilapho i-Microsoft Office Excel iqeda inqubo yokufanela itafula bese ivala iwindi ngesilungiselelo.
• Bheka umphumela.

Ukushintshwa Kwensimu

Inani lensimu ejwayelekile eboniswe ku-Educale ithatha indawo eningi ephepheni. Ukukhulula isikhala, le pharamitha kufanele incishiswe. Ngemuva kwalokho itafula lingafakwa ngaphakathi eshidini elilodwa. Kuyadingeka ukwenza ngokulandelayo:

• Ngokusho kohlelo okuxoxwe ngalo ngenhla, iya engxenyeni ethi "Markup Ikhasi" bese uchofoza inkinobho ethi "Izilungiselelo Zekhasi".

Ukuvula ikhasi "Izilungiselelo Zekhasi". Isinyathelo ngesinyathelo algorithm

• Ewindini elibonisiwe, shintshela engxenyeni ethi "amasimu".
• Yehlisa umkhakha we-Top, Ophansi, kwesobunxele nakwesokudla kwamasimu noma wenze lezi zinhlaka zero, bese uqhafaza u- "KULUNGILE".

Ukushintsha usayizi wezinkambu kuthebhu ehambisanayo yemodi ye- "Page Parameters"

Le nketho ku-Excel, ekuvumela ukuthi ubone ngokubona umngcele weshidi lokusebenza, alinganise usayizi wawo. Inqubo yokucindezela itafula usebenzisa imodi yekhasi ihlukaniswe izigaba eziningana, ngasinye esifanelwe isifundo ngokucophelela:

• Vula ishidi lamanje bese ushintshela kuthebhu ethi "View", etholakala ngaphezulu kwemenyu yohlelo main.
• Kubha yamathuluzi evulekile, chofoza inkinobho "Imodi yegebe" ukuze usebenzise inketho.

Izenzo zokusebenzisa imodi yekhasi ku-Excel

• Ewindini elisha, thola umugqa wesibili obhalwe phansi bese ulihambisa kusuka endaweni yesobunxele uye kwesokudla. Njengoba le strip ihamba, usayizi wethebula uzokwehla.

Ukuqondiswa kwamaqabunga

Ukuze uvumelane ne-tafula array eshidini elilodwa, kubalulekile ukukhetha ukuqondisisa kwalo kahle. I-algorithm elandelayo izosiza ekushintsheni ukuqondiswa kwamanje kwedokhumenti:

1. Vula imodi yomgwaqo, lapho kuzokwenzeka khona ukuze uqonde uhlobo lwe-Plance ekhasini lomsebenzi. Ukuze usebenzise imodi, kufanele uye kwithebhu ethi "View" ngaphezulu kwemenyu enkulu yohlelo, bese kubha yamathuluzi ngezansi, chofoza inkinobho ethi "Ikhasi PlakUp".
2. Manje udinga ukuya engxenyeni ethi "MarkUp ikhasi" bese uqhafaza kulayini we- "Orientation".
3. Shintsha ukuqondiswa kwamanje bese ubheka indawo yetafula. Uma i-array ifakwe ephepheni lomsebenzi, khona-ke ukuqondiswa okukhethiwe kungasala.

Ukushintsha ukuqondiswa kweshidi ku-Excel kushintsha osayizi amaseli

Kwesinye isikhathi ipuleti ayiphazamisi ishidi elifanayo le-A4 ngenxa yamaseli amakhulu. Ukulungisa inkinga yamaseli, kuyadingeka ukunciphisa noma kungaba senkomba eqondile noma evundlile ngokuya ngesimo esithile. Ukuze uguqule usayizi wezakhi zohlu lwethebula, ukubhala okulandelayo kufanele kwenziwe:

• Khetha ngokuphelele ikholomu oyifunayo noma intambo etafuleni ngokhiye wesobunxele we-manipulator.
• Chofoza iseli ye-LKM emngceleni wekholamu eliseduze noma imigqa bese uyihambisa endaweni efanele: mpo yesokunxele noma ngokuvundlile. Kuyaqondakala okucatshangelwa ngokwengeziwe esikrinini esingezansi.

Ukwehla kwesandla ngosayizi weseli ku-Microsoft Office Excel

• Uma kunesidingo, shintsha usayizi wawo wonke amaseli. Ngale njongo, okokuqala udinga ukushintshela kuthebhu "Yasekhaya", bese uya engxenyeni ethi "Amaseli".
• Okulandelayo, faka isigatshana "sefomethi" futhi kumenyu yokuqukethwe, chofoza kulayini "Line Height Line".

Kusebenze umsebenzi wokugcwalisa wokuphakama kokuphakama

Phrinta ingxenye noma isiqeshana esizinikezele

Ku-Excel, ungaphrinta kuphela ingxenye yomsebenzisi yetafula. Ukuze wenze lokhu, kuzodingeka wenze izinyathelo eziningana kwi-algorithm:

1. Khetha indawo oyifunayo yenkinobho ye-Table Array yesobunxele.
2. Chofoza inkinobho ethi "Ifayela" ekhoneni eliphezulu kwesobunxele kwesikrini.
3. Cindezela umugqa we- "Phrinta".
4. Esigatshaneni, ukusetha ohlangothini lwesokunene kwesikrini, cindezela i-LKM ngokuya ngenketho ethi "Phrinta Ezinikezele Zinikezelwe".
5. Bheka umphumela. Kukhethwe ngaphambili ingxenye yetafula kufanele kuphrintiwe.

Ukuphrinta kuphela izimpawu ezikhethiwe

Ungayiphrinta kanjani itafula elingenalutho ukugcwalisa amaseli ekhasini lonke

Ukwenza umsebenzi owudingayo:

1. Yenza ngokufanayo kusebenze imodi "yekhasi" ngokuguqula ithebhu ethi "Buka". Imigqa emihlanu yendawo izomakwa yimingcele yamashidi omsebenzi.
2. Khetha noma yisiphi iseli ngokucindezela ukhiye wesobunxele we-manipulator.
3. Chofoza kwiseli ye-PCM bese ukhetha inketho ye- "Cell format" ewindini lesimo.
4. Imenyu eyengeziwe izovulwa, lapho udinga khona ukushintshela engxenyeni ethi "umngcele" kusuka phezulu.
5. Cindezela izinkinobho ze- "zangaphandle" ne "zangaphakathi" ngokukhetha ama-pictograph afanele.

Ukwenza kusebenze ama-pictographs angaphandle neyangaphakathi wokuphrinta etafuleni elingenalutho

1. Cindezela u- "Kulungile" ezansi kwewindi bese uhlola umphumela.

Phrinta amakhasi amabili edokhumenti ye-Exel eshidini elilodwa

Lesi senzo sibandakanya ukwenza kusebenze kokuphrinta okuhlanganayo. Ukuze usebenzise leli khono lokudinga:

1. Chofoza i-LKM inkinobho ethi "Ifayela" ngaphezulu kwemenyu enkulu.
2. Iya esigabeni esithi "Phrinta".
3. Nweba isigatshana esithi "I-Bilateral Phrinta" bese ukhetha enye yezinketho ezingenzeka ngokufunda incazelo yazo.

Ukwenza kusebenze kokuphrinta okuhlangene kabili ku-Excel

Ukugcina

Ngakho-ke, ku-Excel, lilingane netafula elinenani elikhulu ledatha eshidini elilodwa kulula. Into esemqoka yokwenza okuningana kokukhohlisa, okuyinhloko kwalokho okuchazwe ngenhla.

Umlayezo wokuthi ungaphrinta kanjani itafula le-Excel eshidini elilodwa. Ukushintsha ukuqondiswa, ukubeka imingcele yamakholomu nemigqa, amapharamitha ekhasi bese ephrinta avele kuqala kubuchwepheshe bolwazi.