Ngaba ukhe waprinta i-spreadsheet, emva koko wakhubeka kuyo kwiinyanga ezimbalwa kamva, kuphela ukuba uzibuze ukuba yeyantoni i-spreadsheet, yeyiphi umhla eshicilelweyo, okanye loluphi ulwazi ekufuneka ulukhathalele? Oku kuxhaphake kakhulu, ngakumbi ukuba uhlala uprinta iinguqulelo ezihlaziyiweyo zesipredishithi esifanayo.
Ukusebenza kunye nespreadsheets, nokuba usebenzisa i-Google Apps ukhetho, i-Google Sheets, okanye i-Microsoft Office ukhetho, i-Microsoft Excel, idla ngokuba yinzame ezimbini. Inxalenye yokuqala kukufumana yonke idatha efakwe kwaye ifomathiwe ngokuchanekileyo, ngoko inxalenye yesibini kukwenza ngokwezifiso zonke iinketho zokuseta iphepha ukwenzela ukuba i-spreadsheet ibonakale ilungile xa ishicilelwe.
Iifayile zeGoogle Sheets zilula kancinci ukuprinta ngokungagqibekanga, kodwa zombini usetyenziso luya kufuna ukuba wongeze ulwazi kwisihloko okanye uhlengahlengise iinketho ezahlukeneyo ukuze ukuprintwa kwedatha kube lula ukuyiqonda.
Enye indlela yokusombulula le ngxaki kukusebenzisa igama lefayile kwiheda. Oku kongeza ulwazi lokuchonga kwiphepha ngalinye lespredishithi ukuba loo maphepha ahlulwe, ngelixa unikezela ngolwazi oluxabisekileyo olunokukunceda ukuchonga ukuprintwa kamva. Isikhokelo sethu esingezantsi siya kukubonisa indlela yokongeza isihloko sencwadi yomsebenzi kwisihloko kuMashidi kaGoogle.
Ungaprinta njani igama lencwadi yomsebenzi phezulu kwiphepha kwiiShedi zikaGoogle
- Vula ifayile yespreadsheet.
- Cofa kwithebhu ifayile .
- Khangela .باعة .
- Khetha isithuba Okubhalwe ngasentla kwekhasi kunye nemibhalo engezantsi .
- ibhokisi yokukhangela Isihloko sencwadi yomsebenzi .
- Cofa elandelayo Emva koko .باعة .
La manyathelo angasentla athatha ukuba sele ungenile kwiakhawunti kaGoogle equlathe ifayile ofuna ukongeza isihloko kuyo kwizicwangciso zoshicilelo.
Isikhokelo sethu esingezantsi siyaqhubeka nolwazi oluninzi malunga nokubeka idilesi kwi-spreadsheet sikaGoogle, kuquka nemifanekiso yala manyathelo.
Ulongeza njani igama lefayile kwiphepha xa ushicilela kuGoogle Sheets (IsiKhokelo ngeMifanekiso)
Amanyathelo akweli nqaku aya kukubonisa indlela yokutshintsha isethingi yencwadi yakho yokusebenza yeGoogle Sheets ukuze isihloko sencwadi yomsebenzi siprintwe kwisihloko, kwiphepha ngalinye lespredishithi. Olu seto lusebenza kuphela kwincwadi yangoku, ke kuya kufuneka wenze olu tshintsho kwezinye iispreadsheets ofuna ukuprintela igama lefayile.
Inyathelo 1: Yiya kuGoogle Drive on https://drive.google.com/drive/my-drive Vula ifayile enegama lencwadi yomsebenzi ofuna ukongeza phezulu ephepheni xa ushicilela.
Inyathelo 2: Cofa kwisithuba ifayile Phezulu kwefestile.
Inyathelo lesi-3: Khetha ukhetho ushicilelo emazantsi kuluhlu.
Inyathelo 4: Khetha ukhetho Okubhalwe ngasentla kwekhasi kunye nemibhalo engezantsi kwikholamu kwicala lasekunene lefestile.
Inyathelo lesi-5: Khetha ukhetho Isihloko sencwadi yomsebenzi . Emva koko ungacofa iqhosha " elandelayo phezulu ngasekunene kwefestile kwaye uqhubeke nokushicilela i-spreadsheet.
Umqolo ongasentla wespredishithi unokubizwa ngokuba ngumqolo wesihloko, ngoko ke unokuba uyazibuza ukuba uyenza njani na loo nto.
Ngaba ndingaprinta idilesi kwezinye iiapps zikaGoogle ezinje ngeGoogle Docs?
Ukongeza ulwazi kwisihloko kuGoogle Docs kwahluke kancinane.
Kuba unokuhlela okubhalwe ngasentla ngokuthe ngqo kuxwebhu lukaGoogle Amaxwebhu, awuzukufumana zonke iinketho zoshicilelo ezongezelelweyo zeheader kunye nefooter oyifumene kuGoogle Sheets.
Ukuba ufuna ukongeza isihloko kwisihloko kwiGoogle Docs, kuya kufuneka ucofe kabini ngaphakathi kweheader, emva koko uchwetheze isihloko soxwebhu kwisihloko. Naluphi na ulwazi olongeza kuxwebhu lwesihloko luya kuphinda-phindwa kwiphepha ngalinye elishicilelweyo loxwebhu.
IZilayidi zikaGoogle azinayo indlela yokongeza ulwazi kwiheda, ke eyona ndlela isebenzayo yokwenza oko inokuba kukuya Isilayidi> Hlela umxholo Emva koko yongeza ibhokisi yokubhaliweyo phezulu kwesinye seziyilo apho kuquka nesihloko somboniso wesilayidi. Ungacofa emva koko kwisilayidi kwaye ukhethe ukhetho Isilayidi> uYilo lwe-App Kwaye ukhethe uyilo olunesihloko.
Indlela yokongeza umqolo weheader kwiGoogle Sheets ngokufaka umqolo ongenanto phezulu
Ukuba i-spreadsheet sakho asisenawo umqolo weheader okanye umqolo wesihloko kodwa ufuna ukongeza enye ukuze ukwazi ukuphinda-phinda kwiphepha ngalinye, usenokuba uyazibuza ukuba uyenza njani na.
Ukuba ucofa umqolo we-header kwicala lasekhohlo lefestile, umqolo wonke wokuqala uya kukhethwa. Unganqakraza-ekunene kumqolo okhethiweyo kwaye ukhethe Faka i-1 ukhetho ngasentla ukongeza umqolo ongenanto phezu kwedatha yakho ekhoyo.
Emva koko kufuneka udibanise isihloko sekholamu kwiseli nganye kumqolo ochaza uhlobo lwedatha kulo kholamu.
Ungacofa emva koko imboniselo ithebhu phezulu kwefestile, khetha i-Freeze ukhetho, kwaye emva koko ukhethe u-Freeze Umqolo oPhezulu okanye naluphi na olunye ukhetho olusuka kwimenyu eyehlayo.
Funda ngakumbi malunga nokubeka isihloko kwi-spreadsheet sikaGoogle
La manyathelo angasentla akubonisa indlela yokutshintsha isethingi xa uprintwa kwi-Google Sheets ukuze isihloko sencwadi yomsebenzi sibandakanywe kwiheda yephepha ngalinye eliprintiweyo.
Ezinye zezinto onokuthi uGoogle azifake kwidilesi ziquka:
- Amanani ephepha
- Isihloko sencwadi yomsebenzi
- igama lephepha
- umhla wangoku
- ixesha langoku
Isihloko sencwadi yomsebenzi kunye negama lephepha linokubonakala lifana, ngoko kuyanceda ukwazi ukuba uGoogle uyahlula njani phakathi kwabo.
Isihloko sencwadi yomsebenzi yefayile ye-Google Sheets ligama elivela phezulu kwifestile. Ungayihlela le nanini na ngokucofa nje kwaye uyitshintshe njengoko kufuneka.
Igama lephepha ligama elivela kwisithuba ezantsi kwefestile. Unako kwakhona ukucofa kuloo nto ukuyiguqula.
Ukuba udale igrafu okanye itshati kuMashidi kaGoogle, njengetshathi yepayi, wenze njalo ngokukhetha uluhlu lweeseli kwispreadsheet sakho kwaye ukhethe isitayile setshati onokuthi usidale ukusuka kuloo datha.
Ukuba ufuna ukutshintsha isihloko setshathi esetyenziswe kuMashidi kaGoogle kule tshati, unokucofa kabini isihloko, esiya kuvula ikholamu yoMhleli weTshati kwicala lasekunene lefestile. Emva koko unokukhetha isihloko setshathi kuluhlu oluhlayo kwaye ufake isihloko sakho setshathi osithandayo kwindawo yokubhaliweyo yesihloko.
