Isici sokudibanisa iMeyili seMicrosoft ikuvumela ukuba uthumele umqulu ofanayo kunye noshintsho oluthile kwinani elikhulu labamkeli. Igama elithi "ukudibanisa" livela kwinto yokuba enye incwadi (ileta, umzekelo) idibaniswe kunye nedokhumenti yomthombo wedatha , njengesepredishithi.
Idilesi ye-imeyile yokudibanisa isebenza ngokugqithiseleyo kunye nedatha evela kwi-Excel. Nangona iLizwi likuvumela ukuba udale umthombo wayo weenkcukacha, ukhetho lokusebenzisa le datha lucacisiwe. Ngaphezu koko, ukuba sele unayo idatha yakho kwi-spreadsheet, akunakuqonda ukubuyisela zonke iinkcukacha kwi-data yedata ye-Word.
Ukulungiselela Iifayile Zakho zeMeyili Ukudibanisa
Ngokwemfundiso, ungasebenzisa nayiphi na iphepha lokusebenzela lase Excel kwi- imeyili ye-imeyili yokudibanisa umsebenzi ngaphandle kokulungiselela. Nangona kunjalo, kucetyiswa ukuba uthathe ixesha lokulungiselela iphepha lokusebenzela ukuze ulungise inkqubo yokudibanisa iposi .
Nazi izikhokelo ezimbalwa zokugcina oku kuya kunceda ukwenza i-imeyile inkqubo yokudibanisa ihambe kakuhle.
Hlela idatha yakho yeSpreadsheet
Esemngciphekweni wokuchazela ngokucacileyo, idatha yakho kufuneka ihlelwe ngokufanelekileyo kwimigca kunye neikholam. Cinga ngomqolo ngalunye njengerekhodi enye kunye nekholamu nganye njengentsimi oya kufaka kwixwebhu lakho. (Khangela i- Excel-entry-entry tutorial ukuba ufuna ukuhlaziywa.)
Yenza iRower Row
Yenza umgca weentloko kwiphepha oceba ukuyisebenzisa ukuze idibanise ifake. Umgca wenhloko ngumqolo oqulethwe ngamabhalana achaza idatha kwiiseli ezingezantsi. I-Excel ingahlawuliswa ngamanye amaxesha ngokumahluko phakathi kwedatha neebhaliweyo, ngoko yenza ukuba kucace ngokubhaliweyo, imizila yeseli kunye ne-shading yeselula ekhethekileyo kumgca wintloko. Oku kuya kuqinisekisa ukuba i-Excel iyahlula phakathi kwakho yonke idatha yakho.
Kamva xa udibanisa idatha kunye noxwebhu oluphambili, amalebula aza kubonakala njengamagama eenkalo zokudibanisa, ngoko akuyi kuba naludideko malunga noluphi idatha ofaka kuyo kumqulu wakho. Ukongezelela, yinto efanelekileyo yokubhala iikholomu zakho, njengoko inceda ukukhusela impazamo yomsebenzisi.
Faka zonke iiDatha kwiShidi elilodwa
Idata oceba ukuyisebenzisa ukuze idibaniselwano idibeneyo kufuneka ibe kwiphepha elilodwa. Ukuba isasazeka kumaphepha amaninzi, kuya kufuneka udibanise ama-sheets okanye wenze ukudibanisa iimeyili ezininzi. Kwakhona, qinisekisa ukuba amakhishithi acaciswe ngokucacileyo , njengoko kuya kufuneka ukuba ukhethe ukukhetha iphepha ozimisele ukuyisebenzisa ngaphandle kokulijonga.
Ukudibanisa uMthombo woLwazi kwiMeyili yokudibanisa
Isinyathelo esilandelayo kwinkqubo yokudibanisa iposi kukudibanisa i-spreadsheet yakho ye-Excel kunye nexwebhu lakho le-Word.
- Kwi-Imeyile ibhokisi yetshobo yokuhlanganisa, cofa iqhosha le- Open Data Source .
- Kwiphepha lebhokisi yencoko yeDatha yeDatha, vula kwiifolda uze ufumane incwadi yakho ye-Excel. Ukuba awukwazi ukufumana ifayile yakho ye-Excel, qiniseka ukuba "Yonke imithombo yedatha" ikhethiweyo kwimenyu ehlayo ibhalwe "Iifayile zohlobo."
- Chofoza kabini kwifayile yakho yomthombo we-Excel, okanye ukhethe kwaye uqhosha kwi- Open .
- Kwibhokisi yencoko yefayile yeTable, khetha icebo le-Excel equle idatha ofuna ukudibanisa kunye nexwebhu lakho.
- Qinisekisa ukuba ibhokisi yokukhangela ecaleni "Umqolo wokuqala weenkcukacha uqulethe iicatshulwa zekholomu" ihlolwe.
- Chofoza OK .
Ngoku ukuba umthombo wedatha unxulumene nombhalo ophambili, unokuqala ukufaka umbhalo kunye / okanye ukuhlela umbhalo wegama lakho. Kodwa awukwazi ukwenza utshintsho kumthombo wakho wedatha kwi-Excel; ukuba ufuna ukutshintsha idatha, kufuneka uvale iphepha eliphambili kwiLizwi ngaphambi kokuba uvule umthombo wedatha kwi-Excel.
Ukufakela amasimu kwi-document yakho kulula ngokulandela la manyathelo:
- Cofa iqhosha le- Merge Field Field kwi-bar bar toolbar. Ibhokisi yencoko yencoko yokuHlanganisa iya kubonakala.
- Khanyisa igama lensimi ofuna ukuyifaka kwiluhlu kwaye nqakraza Faka .
- Ibhokisi iya kuhlala ivulekile, ikuvumela ukuba ufakele ezinye iinkalo. Ukuba ufaka indawo engaphezu kweyodwa ngokulandelelana, iLizwi aliyi kubeka ngokuzenzekelayo indawo phakathi kwamasimu ekhompyutheni yakho; Kufuneka wenze oku ngokwakho emva kokuba uvale ibhokisi yencoko. Kwidokhumenti yakho uza kubona igama lefama elijikelezwe iintolo ezimbini.
- Xa usuqedile, qhafaza Vala .
Ukufaka iZibhloko zeeNdawo kunye nobuliso-Sebenzisa ngokufanelekileyo
IMicrosoft ithe yangenisa inkcazelo yokudibanisa i-imeyile evumela ukuba ufake iibhloko zeedilesi kunye nemigqa yokubulisa. Ngokuchofoza iqhosha elifanelekileyo kwibar yomthamo, iLizwi liya kukuvumela ukuba ufake iinkalo eziliqela ngokukhawuleza, ulungiswe ngokufanayo.
Inkinobho yokubamba idilesi yefayile yilekho ngakwesobunxele; Umgca wokubhengeza ungakwesokudla .
Ukongeza, xa ucofa kwiqhosha elithile, i-Word ibonisa ibhokisi yencoko eyinika inketho kwiindawo apho ungathanda ukufakela, ukuba ungathanda ukuba zilungiselelwe, ziphi iimpawu zokubhala ezibandakanya nabanye. Ngelixa eli lizwi lithe ngqo-kwaye ke ukuba usebenzisa umthombo wedatha owenziwe kwiLizwi-kunokudideka xa usebenzisa iphepha lokusebenzela lase Excel.
Khumbulani xa isinconywa malunga nokongeza umgca wekhanda kwiphepha lakho lokusebenzela kwiphepha 1 le nqaku? Ewe, ukuba uthetha insimu into ngaphandle kweyiphi iLizwi elisetyenzisiweyo njengegama lefowuni yeenkcukacha ezifanayo, iLizwi linokulinganisa amasimi ngokungalunganga.
Oko kuthetha ukuthini ukuba usebenzisa i- block address ye-block okanye faka iifowuni zomgca wokubulisa , idatha ingabonakala kwindlela ehlukile kunokuba ucacise-nje kuba iilebula azifani. Ngethamsanqa, iMicrosoft ikulindele oku kwaye yakhiwe kwiMpawu yeMidlalo yeMidlalo evumela ukuba ufanise amagama akho endle kwiiZwi esebenzisa kwiibhloko.
Ukusebenzisa iMida yeMatch ukuLungisa ngokuchanekileyo Imephu yeeLebhanki zeeNgingqi
Ukudibanisa amasimu, landela amanyathelo:
- Cofa kwiqhosha leMatch Fields kwibar yamathuluzi.
- Kwibhokisi yencoko yeeMidlalo, uza kubona uluhlu lwamagama endle yeLizwi ngakwesobunxele. Ngakwesokudla kwebhokisi, uza kubona ikholomu yeebhokisi ezenzakalisa. Igama ebhokisini ngalinye lokuhlahlayeka liyinksimi esebenzisa igama nganye kwintsimi nganye kwi-Adreck block okanye kwi-Breeting block block. Ukwenza nayiphi iinguqulelo, khetha nje igama lefayile kwibhokisi lehlayo.
- Xa usuyenziwe ukwenza iinguqu, nqakraza OK .
Ungakwazi kwakhona ukukhupha ibhokisi yencoko yeeMatshi ngokucofa iqhosha le Match Fields ngaphantsi kweNdawo yokuLungisa iNtloko okanye iBhokisi yoNxibelelwano yeeNgcaciso, zombini ezibonakala xa ucofa iqhosha lebarbar.
Ukujonga iMeyili Ukudibanisa Amaphepha
Ngaphambi kokuba siqhube phambili size sihlolisise kwaye sinyathelise amaxwebhu akho adibeneyo, inqaku malunga nokufometha: Xa ufaka iifayile zibe ngumbhalo, iZwi alithwali ukufomatha idatha kwi-data source.
Ukusebenzisa ukuFometha okuKhethekileyo kwiSpredishithi yomthombo
Ukuba ufuna ukufaka ifomathi ekhethekileyo njengetalicics, ngesibindi okanye phantsi, kufuneka wenze njalo kwiLizwi. Ukuba ukhangele loxwebhu kunye namasimi, kufuneka ukhethe iintolo ezimbini kumacala omabini endle ofuna ukuyisebenzisa ngayo ifomathi. Ukuba ukhangele idatha edibeneyo kwidokhumenti, qinisa kuphela umbhalo owufisa ukuwuguqula.
Khumbula ukuba nayiphi na inguqu iya kuthwala kuwo onke amaxwebhu ahlanganisiweyo, kungekhona nje umntu.
Ukuqwalasela amaxwebhu adibeneyo
Ukujonga kuqala amaxwebhu akho adibeneyo, nqakraza i- View Merged Data Data iqhosha kwi-Barbar yebar ye-toolbar. Le iqhosha isebenza njengenguqu yokuguqulela, ngoko ke ukuba ufuna ukubuyela emva ekubukeni kwimihlaba kwaye kungekhona idatha equlethe kuyo, nqakraza kwakhona.
Unako ukuhamba ngeemibhalo ezidibeneyo ngokusebenzisa iifayile zokuhamba nge-imeyile kwi-Barbar toolbar. Ziyiyo, ukusuka kwesobunxele kuya kwesokudla: IRekhodi yokuqala , Impendulo yangaphambili , Yiya kuRekhoda , Impendulo elandelayo, IRekhodi yokugqibela .
Ngaphambi kokuba udibanise amaxwebhu akho, kufuneka ubhekisele kuqala kubo bonke, okanye baninzi ukuba unako ukuqinisekisa ukuba yonke into idibene ngokuchanekileyo. Nika ingqalelo kwizinto ezifana neziphumlisi kunye nokwahlukana kwedatha edibeneyo.
Qedela i-imeyile yakho yokudibanisa idokhumenti
Xa ulungele ukudibanisa amaxwebhu akho, unokukhetha ezimbini.
Hlanganisa kwiprinta
Okokuqala kukudibanisa kumshicileli. Ukuba ukhetha olu khetho, amaxwebhu aya kuthunyelwa kumshicileli ngaphandle kokuguqulwa. Ungakwazi ukudibanisa kumshicileli ngokuchofoza ukudibanisa kwiKhowudi yebar yesixhobo sePrinta.
Hlanganisa kwiNcwadi entsha
Ukuba ufuna ukuzenza ezinye izinto okanye zonke iifayile (nangona kunjalo, kuya kuba bubulumko ukudibanisa insimu kwintsimi yenkcukacha kumanqaku ahlukeneyo), okanye wenze nayiphi enye inguqu ngaphambi kokuba uprinte, unokudibanisa noxwebhu olutsha; ukuba udibanisa nomqulu omtsha, i-imeyile idibanisa uxwebhu oluphambili kunye nomthombo wedatha liza kuhlala lihambelana, kodwa uya kuba nefayile yesibini equkethe amaxwebhu adibeneyo.
Ukwenza oku, nqakraza ukudibanisa ukudibanisa kwiqhosha lebar ye-toolbar entsha .
Naluphi na indlela okhethayo, uya kuboniswa kwibhokisi yencoko apho ungatshela iLizwi ukudibanisa zonke iirekhodi, irekodi yamanje, okanye uluhlu lweerekhodi.
Cofa iqhosha lokukhetha ngokukhetha kukhetho lwakho olukhethiweyo uze ukhethe Kulungile .
Ukuba ufuna ukudibanisa uluhlu, kuya kufuneka ubeke kwinamba yokuqala kunye nenombolo yokugqibela kwiirekhodi ozifunayo ukuba zibandakanye ukudibanisa ngaphambi kokuchofoza OK .
Ukuba ukhethe ukuprinta amaxwebhu, emva kokuba ibhokisi yencoko yebhodi yencoko ivela, uya kuboniswa ngebhokisi yencoko yokushicilela. Unokusebenzisana nayo ngendlela efanayo nangokwamnye uxwebhu.