Lapho ushicilela amatafula kanye neminye idatha kumqulu we-Excel, zivame ukubhekana nezimo lapho idatha ihamba ngaphezu kwemida yeshidi. Kuyinto engathandeki ikakhulukazi uma itafula lingavumelani nendawo. Ngempela, kulokhu, amagama omugqa azovela engxenyeni eyodwa yedokhumenti ephrintiwe, namakholomu ngamanye - ngakolunye uhlangothi. Kuyamanga nakakhulu uma kukhona isikhala esincane esisele ukubeka ngokuphelele ithebula ekhasini. Kodwa indlela yokuphuma yalesi simo ikhona. Ake sibone ukuthi singayinyathelisa kanjani idatha ekhasini elilodwa ngezindlela ezihlukahlukene.
Phrinta ekhasini elilodwa
Ngaphambi kokuqhubeka nombuzo wokuthi ungabeka kanjani idatha kwelinye ishidi, kufanele unqume ukuthi ungayenza yini nhlobo. Kufanele kuqondwe ukuthi iningi lezindlela ezichazwe ngezansi lisho ukunciphisa ukulinganisa kwedatha ukuze uzivumelanise nento eyodwa ephrintiwe. Uma ingxenye yetshe isincane ngobukhulu, lokhu kuyamukeleka. Kodwa uma ulwazi oluningi lungavumelani, umzamo wokubeka yonke idatha kushidi elilodwa kungaholela ekunciphiseni kwabo ukuze bangafundiwe. Mhlawumbe kulokhu, indlela engcono kakhulu ukuphrinta ikhasi ephepheni elikhudlwana, glue amashidi noma uthole enye indlela yokuphuma.
Ngakho umsebenzisi kufanele azikhethele yena ukuthi uzama ukulinganisa idatha noma cha. Siya phambili ekuchazeni izindlela ezithile.
Indlela 1: shintsha ukuma
Le ndlela ingenye yezinketho ezichazwe lapha, lapho akudingeki usebenzise khona ukunciphisa izinga lemininingwane. Kodwa kufanelekile kuphela uma idokhumenti inezinamba ezincane, noma akubalulekile kakhulu kumsebenzisi ukuthi ihambisana nekhasi elilodwa ubude, kepha kuzanele ukuthi idatha ibekwe ebubanzi beshidi.
- Okokuqala, udinga ukuhlola ukuthi itafula lihambisana yini nemingcele yephepha eliphrintiwe. Ukuze wenze lokhu, shintsha kwimodi "Ukuhlelwa Kwekhasi". Ukuze wenze lokhu, chofoza isithonjana segama elifanayo, elitholakala kubha yomumo.
Ungaya futhi kuthebhu "Buka" bese uchofoza inkinobho ku-ribbon "Ukuhlelwa Kwekhasi"okuyinto itholakala ku-tape ebhodini lamathuluzi "I-Book View Modes".
- Kunoma yikuphi kwalokhu okukhethwa kukho, uhlelo luyashintsha kwimodi yokuhlela ikhasi. Ngesikhathi esifanayo, imingcele yento ngayinye ephrintiwe ibonakala. Njengoba sibona, kithi, itafula lihlukaniswa ngokulinganisa libe ngamashidi amabili ahlukene, angeke amukeleke.
- Ukuze ulungise isimo, iya kuthebhu "Ukuhlelwa Kwekhasi". Sicindezela inkinobho "Ukuqonda"okuyinto itholakala ku-tape ebhodini lamathuluzi "Izilungiselelo zekhasi" futhi kusukela ohlwini oluncane olubonakalayo khetha into "Emazweni".
- Ngemuva kwezinyathelo ezingenhla, itafula lafakwa ngokuphelele eshadini, kodwa ukuqondisa kwalo kushintshiwe kusukela encwadini kuya emazweni.
Kukhona futhi okunye okukhethwa kukho kokushintsha ukuma kwekhasi.
- Iya kuthebhu "Ifayela". Okulandelayo, hamba kusigaba "Phrinta". Eyingxenyeni engaphakathi yefasitela evulekayo, kukhona i-block yokuprinta izilungiselelo. Chofoza egameni "Ukuma kwencwadi". Emva kwalokho, uhlu luvulwa ngokukhetha kwesinye inketho. Khetha igama "Ukuma komhlaba".
- Njengoba ubona, endaweni yokubuka kuqala, emva kokusebenza okungenhla, ishidi liye lashintsha ukuma kwalo ku-landscape futhi manje yonke idatha ingaphakathi kwendawo ephrintiwe yento eyodwa.
Ngaphezu kwalokho, ungashintsha ukuma ngokusebenzisa iwindi yemingcele.
- Ukuba ngaphakathi kuthebhu "Ifayela"esigabeni "Phrinta" chofoza kulebula "Izilungiselelo zekhasi"elitholakala phansi kakhulu kwezilungiselelo. Iwindi yemingcele ingafinyelelwa ngokusebenzisa ezinye izinketho, kodwa sizoxoxa ngazo ngokuningiliziwe uma kuchaza Indlela 4.
- Iwindi yemingcele iqalisiwe. Iya kuthebhu yayo ebizwa "Ikhasi". Ebhokisini lesethingi "Ukuqonda" shintsha ushintsho kusuka endaweni "Incwadi" esimweni "Emazweni". Bese uchofoza inkinobho. "Kulungile" phansi kwefasitela.
Ukuhlelwa kwedokhumenti kuzoguqulwa, futhi ngenxa yalokho, indawo yenkampani ephrintiwe yanda.
Isifundo: Indlela yokwenza i-landscape sheet ku-Excel
Indlela 2: I-Border Border Shift
Ngezinye izikhathi kwenzeka ukuthi isikhala seshidi sisetshenziswe ngokungasebenzi. Okusho ukuthi, kwezinye izinsika kukhona isikhala esingenalutho. Lokhu kwandisa ubukhulu bekhasi ngobubanzi, okusho ukuthi kuthatha ngaphezu kwemingcele yeshidi elilodwa eliphrintiwe. Kulesi simo, kunengqondo ukunciphisa usayizi wamaseli.
- Faka isikhombisi ku-panel ye-coordinate emngceleni wekholomu ukuya kwesokudla kwekholomu ocabanga ukuthi kungenzeka ukunciphisa. Kulesi simo, isikhombisi kufanele sibe yisiphambano ngemicibisholo ekhomba izinkomba ezimbili. Bamba inkinobho yegundane lesokunxele bese uhambisa umngcele ngakwesokunxele. Siqhubeka nokunyakaza kuze kube semngceleni ufinyelela idatha yeseli yekholomu egcwala kakhulu kunezinye.
- Senza ukufana okufanayo namanye amakholomu. Emva kwalokho, amathuba okuba yonke idatha etafuleni ivumelane nento eyodwa ephrintiwe yanda kakhulu, ngoba ithebula ngokwalo iba yinkimbinkimbi kakhulu.
Uma kunesidingo, ukusebenza okufanayo kungenziwa ngezintambo.
Ukungahambi kwalendlela ukuthi akusebenzi ngaso sonke isikhathi, kodwa kuphela ezimweni lapho isikhala sephepha lokusebenzela se-Excel lisetshenziswe ngokungasebenzi. Uma idatha itholakale ibe yinkimbinkimbi ngangokunokwenzeka, kepha ayihambisani nalokho okushicilelwe, ngakho-ke ezimweni ezinjalo udinga ukusebenzisa ezinye izinketho, esizoxoxa ngezansi.
Indlela 3: Izilungiselelo zokuphrinta
Ungenza futhi yonke idatha ifinyelele kwisici esisodwa uma ushicilela, futhi nakuzilungiselelo zokuphrinta ngokukhipha. Kodwa kulokhu, udinga ukucabangela ukuthi idatha ngokwayo iyohliswa.
- Iya kuthebhu "Ifayela". Okulandelayo, hamba kusigaba "Phrinta".
- Khona-ke siyakuqaphela ibhodi yokuhlela okuprinta engxenyeni ephakathi kwewindi. Ngaphansi kakhulu kunenkambu yezilungiselelo zokulinganisa. Ngokuzenzakalelayo, ipharamitha kufanele isethwe lapho. "Okwamanje". Chofoza kunsimu ecacisiwe. Uhlu luvuleka. Khetha isikhundla kuso "Bhala ishidi ekhasini elilodwa".
- Ngemuva kwalokho, ngokunciphisa isikali, yonke idatha emadokhumenti wamanje izobekwa endaweni eyodwa ephrintiwe, engabonwa efasiteleni lokubuka kuqala.
Futhi, uma kungadingeki ukunciphisa yonke imigqa kwelinye ishidi, ungakhetha okukhethwa kukho kukho okukhethwa kukho "Faka amakholomu ekhasini elilodwa". Kulokhu, lawa amathebula azobekwa endaweni eyodwa ephrintiwe, kodwa ekuqondeni okuqondile ngeke kube khona ukuvinjelwa okunjalo.
Indlela 4: I-Window Izilungiselelo zekhasi
Ungaphinde ufake idatha kwento eyodwa ephrintiwe usebenzisa iwindi elinalo igama "Izilungiselelo zekhasi".
- Kunezindlela eziningana zokuqalisa iwindi lezilungiselelo zekhasi. Okokuqala ukuya kuthebhu "Ukuhlelwa Kwekhasi". Okulandelayo udinga ukuchofoza kusithonjana ngesimo somcibisholo oblique, esisekhoneni elingezansi elingakwesokudla kwibhokisi lamathuluzi. "Izilungiselelo zekhasi".
Umphumela ofanayo nokushintshela efasiteleni esiyidingayo kuyoba lapho uqhafaza kwisithonjana esifanayo ekhoneni elingezansi kwesokudla sebha yamathuluzi. "Faka" kwi-tape.
Kukhona futhi ongakhetha ukungena kule window ngokusebenzisa izilungiselelo zokuphrinta. Iya kuthebhu "Ifayela". Okulandelayo, chofoza igama "Phrinta" kwimenyu engakwesokunxele yefasitela evuliwe. Esikhathini sokuvimba izilungiselelo, esitholakala enkabeni yefasitela, chofoza okubhalwe phansi "Izilungiselelo zekhasi"efakwe phansi.
Kukhona enye indlela yokuqalisa iwindi yamapharamitha. Hambisa kusigaba "Phrinta" amathebhu "Ifayela". Okulandelayo, chofoza kwenkambu yezilungiselelo zokukala. Ngokuzenzakalelayo ipharamitha icacisiwe lapho. "Okwamanje". Kulolu hlu oluvula, khetha into "Izinketho zokwenza ngokwezifiso ...".
- Yiziphi izenzo ezingenhla ongayikhethi, uzobona iwindi "Izilungiselelo zekhasi". Hambisa kuthebhu "Ikhasi"uma iwindi livuliwe kwelinye ithebhu. Ebhokisini lesethingi "Isikali" setha inkinobho ukuma "Beka okungaphezu kokuthi". Emasimini "P. Wide" futhi "Ikhasi elide" Izinombolo kumele zibekwe "1". Uma kungenjalo, lezi zinombolo kufanele zihlelwe emasimini afanelekile. Emva kwalokhu, ukuze izilungiselelo zamukelwe uhlelo lokubulawa, chofoza inkinobho "Kulungile"elitholakala phansi kwefasitela.
- Ngemuva kokwenza lesi senzo, konke okuqukethwe kwencwadi kuzolungele ukuphrinta kwelinye ishidi. Manje iya kusigaba "Phrinta" amathebhu "Ifayela" bese uchofoza inkinobho enkulu ebizwa "Phrinta". Ngemuva kwalokho kuzoba nokuphrinta kokuqukethwe kwiphrinta ephepheni elilodwa lephepha.
Njengendlela eyedlule, efasiteleni lemingcele, ungenza izilungiselelo lapho idatha izobekwa khona eshadini kuphela esiqondisweni esinqunyiwe, futhi ngeke kube khona umkhawulo ekuqondeni okuqondile. Ngalokhu kudingekile ngokuhambisa umshini endaweni "Beka okungaphezu kokuthi"ensimini "P. Wide" setha inani "1"kanye nensimu "Ikhasi elide" shiya kungenalutho.
Isifundo: Ungaphrinta kanjani ikhasi ku-Excel
Njengoba ubona, kunendlela enkulu kakhulu yokuvumelanisa yonke idatha yokunyathelisa ekhasini elilodwa. Ngaphezu kwalokho, izinketho ezichazwe, empeleni, zihluke kakhulu phakathi kwazo. Ukufaneleka kwendlela ngayinye kufanele kulandelwe izimo ezithile. Isibonelo, uma ushiya isikhala esingenalutho kakhulu kumakholomu, okukhethwa kukho kungaba ukuhambisa umkhawulo wabo. Futhi, uma inkinga ingabeki ukubeka itafula kwenye into ephrintiwe ngobude, kodwa kuphela ngobubanzi, mhlawumbe kunengqondo ukucabanga ngokushintsha ukuma kwezwe elilodwa. Uma lezi zindlela zingakalungi, ungasebenzisa izindlela ezihlotshaniswa nokunciphisa ukulinganisa, kodwa kulokhu, usayizi wezandla uzoncishiswa.
