Lapho usebenza ngamadokhumenti ngegama, kuvame ukudingeka ukudala itafula, ngaphakathi okudingeka ubeke imininingwane ethile. Isihleli sombhalo esivela kuMicrosoft, yize singanikeli amathuba anjalo okuhle okudala nokulungisa amatafula, njengephakethe lehhovisi le-Excel Offect, kodwa namanje linesethi eyanele yamathuluzi okufanele asebenze kuyo i-arsenal yayo. Kulesi sihloko, sizobheka ngokuningiliziwe ukuthi ungawakha kanjani.
Ukwakha amatafula egameni
Kunezindlela eziningana zokwakha itafula kudokhumenti yombhalo ngegama. Ngokufanelekile, njengoba nje kungenye indlela, kepha imiphumela yokubulawa kwayo ingehluke ngokuphelele - konke kuya ngokuthi yiphi injongo kudingekile ukufeza. Futhi, ungangeza itafula "kusuka ngaphandle" - Isicelo sehhovisi le-Excel ehambisanayo noma, ngokwesibonelo kusuka kuwebhusayithi.Indlela 1: Itafula eliyisisekelo
Ukudala kanye / noma ukungeza egameni cishe nanoma yikuphi, okuhlukile embhalweni wezinto, kwenziwa ngethebhu ethi "Insert". Kuyena, kuzodingeka ukuthi sithinte ukudala itafula eliyisisekelo.
- Cindezela inkinobho yegundane kwesobunxele (LKM) endaweni yombhalo lapho ufuna ukufaka khona ithebula, bese uya kuthebhu ethi "Insert".
- Nweba imenyu ethi "Ithebula" leZebhulani, etholakala kubha yamathuluzi egama elifanayo, bese ukhetha inombolo oyifunayo yemigqa namakholomu, uhambisa igundane phezu kwesithombe ngokubuka kuqala kwetafula, bese kuba khona kuqokonyiswe nge-orange). Chofoza i-LKM ukuqinisekisa.
- Uzovela osayizi abakhethiwe etafuleni.
- Konke ithebhu efanayo "Faka" sebenzisa inkinobho ethi "Uhlu" bese ukhetha "Faka etafuleni" kumenyu yayo.
- Ebhokisini lengxoxo encane, okuyinto uzovulelwa, usethe nemingcele wazifunela etafuleni. Lokho, ucacise inani elidingekayo lemigqa namakholomu, ungakwazi ngaphezu kwalokho ukuthi ukhethe ububanzi (nakuba akusiyo olufanele kakhulu ithebula elingenalutho). Izinketho ezilandelayo ziyatholakala:
- njalo: Ngokuzenzakalelayo, ukubaluleka "Auto" kusethelwe, okungukuthi, ububanzi amakholomu uzobe ngokuzenzakalelayo washintsha, njengoba bebizwa ukugcwalisa;
- Ngu okuqukethwe: Ekuqaleni, amakholomu ewumngcingo izokwakhiwa, ububanzi okwandisa nokuqukethwe unezela;
- Ngu ububanzi iwindi: Ithebula ngeke ngokuzenzakalelayo ukushintsha ububanzi yakho ngokuhambisana ubukhulu idokhumenti nisebenza.
Qaphela: Uma udinga amatafula ukuthi izokwakhiwa esikhathini esizayo, kubukeka nje kanje, faka uqhwishi ebhokisini phambi nto yomngani amathebula amasha.
- Ngokubeka imingcele ezidingekayo kule "Faka Ithebula" ifasitela, chofoza "KULUNGILE" ukuze uqinisekise kubo.
Ithebula izovela ekhasini dokhumenti, ububanzi kukholomu lomzila ukuphakama okuyizinto cishe ishintshwe, futhi ngemva kwalokho (noma inqubo), ugcwalise ulwazi.
- Ethebuleni Ukufakwa menu, khetha "Dweba Table". Isikhombi isikhombisi ngemva kwalesi senzo kuthatha ukubukeka ipensela.
- Khombisa imingcele sangaphandle etafuleni, okungukuthi, nje ukudweba isikwele nge ukuphakama ezidingekayo futhi ububanzi (esikhathini esizayo lezi nemingcele kungashintshwa kalula).
Ngokulandelayo, ukudweba umugqa namakholomu ngaphakathi kuwo, ngepeniseli sabe imigqa enezingqimba futhi mpo. Njengoba usukwenzile lokhu, futhi ukhethe "Dweba ithebula" kwimenyu faka ukuphuma imodi umdvwebo.
Njengoba cishe kungenzeka kakade ukuyichaza, ukuphakama imigqa kanye ububanzi amakholomu ekuqaleni kungaba ngokungenasizathu (noma nje oyifunayo), engabulawa kuchazwe, njengoba kwenzeka lapho ufaka itafula eziyisisekelo futhi ngezifiso. Ungase futhi ngokushesha ukudweba lohlanganisiwe amakholomu, imigqa, amaseli, uma onjalo isidingo iyatholakala.
Bheka futhi: Ungahlanganisa kanjani amaseli etafuleni egameni
- Njengasezigabeni okuxoxwe ngakho ngenhla, wonke asebenza netafula, izinto zalo nokuqukethwe, kwenziwa kuthebhu "yokusebenza ngamathebula",
okubandakanya "umakhi wetafula" kanye ne- "Layout".
- Nweba imenyu ethi "Ithebula" le-Inkinobho bese ukhetha u- "Express Tables".
- Khetha ithempulethi efanelekile ohlwini oluncane "eyakhelwe ngaphakathi" ngokuchofoza kuyo nge-LKM.
- Ithebula lizongezwa kudokhumenti yombhalo futhi ligcwele okuqukethwe kwethempulethi. Konke lokhu idatha can futhi isidingo esikhundleni owakho.
- Khetha itafula kanye nakho konke okuqukethwe kwalo bese uya kuthebhu ethi "Insert".
- Kumenyu yenkinobho yetafula, hover isikhombisi entweni yetafula ekhombisa.
- Khetha into "Gcina isiqeshana esikhethiwe eqoqweni lamatafula aveza ..."
Efasitezini entsha ye-Block Creation evelayo, nikeza igama elithi "igama" lakho futhi, ngokuzithandela engeza "incazelo". Izinkambu ezisele zingcono ukushiya okuzenzakalelayo. Ukugcina ithempulethi, chofoza Kulungile.
- Ukuze uqale ukuphindukuzalwa kombhalo osevele ukhona etafuleni, kufanele unikeze amandla okuboniswa kwezinhlamvu ezifihliwe. Ungakwenza ngokucindezela inkinobho ekhonjiswe esithombeni esingezansi (ithebhu enkulu, iqembu le-Gragraph Tool) noma inhlanganisela yokhiye "i-CTRL + * ilungisiwe ngemuva kwayo.
Bheka futhi: Khombisa izinhlamvu ezifihliwe egameni
- Manje kudingeka ucacise indawo yokwephula etafuleni oseza amakholomu. Ukuze wenze lokhu, faka izimpawu ezifanele zokwahlukana, ezingaba ama-commas, ukutholwa noma i-semicolon, kanye nanoma yiluphi olunye uphawu lokuphikisana. Kepha, kusukela umbhalo ojwayelekile uvame ukuqukethe ama-commas, ukuhlukanisa izakhi zetafula elizayo, kungcono ukusebenzisa amathebhu esikwenzile esibonelweni sethu (isithombe-skrini esigabeni esilandelayo).
- Ngokwehlukaniswa kombhalo ngentambo, konke kulula - kungenzeka kakhulu, sekuqoshwe kahle, okusho ukuthi ihlukaniswe (ikakhulukazi uma kunguhlu noma kungaba khona). Izimpawu zezigaba (incwadi "PI", okufanayo nenkinobho yokubiza izimpawu ezifihliwe kubha yamathuluzi), esekupheleni komugqa, futhi kuzosebenza lesi sikhombi ukuze sibhidlizele.
Qaphela: Qiniseka ukuthi uqiniseka ukuthi ekugcineni kwemigqa akunazimpawu ezengeziwe zokwahlukanisa, futhi uma ngabe kukhona kuzotholakala, qiniseka ukuthi uyayisusa. Uma kukhona ukuma futhi, ngokwesibonelo, ithebhu yethebhu, kanye nekholomu yesigaba, ikholomu eyodwa (yokugcina (yokugcina) yetafula izoba yinhle futhi ingenalutho.
Uma kungekho okunjalo embhalweni noma kungeyona yonke indawo, vele uchofoze ku-LKM ekugcineni komugqa, ukufaka inqola (isikhombisi senkohliso), bese ucindezela u- "Faka" ukudlulisa wonke umbhalo uye entanjeni elandelayo . Ingabe lokhu ukuphela umugqa ngamunye okwalandela ukuze uthumele lowo uya ngemuva kokuthi. Okungukuthi, umugqa owodwa wombhalo nge "Enter" ucindezelwe ekugcineni kwayo - lo umugqa owodwa wethebula elizayo.
Qaphela: Ngokwesibonelo esingenhla, izimpawu zethebhu (ezibonisa umcibisholo ofanele) zibonisa amakholomu etafula elizayo, nezimpawu zesigaba - izintambo. Ngenxa yalokho, leli thebula kuyodingeka 6 amakholomu kanye imigqa 8.
- Manje khetha umbhalo olungiselelwe bese uya kuthebhu ethi "Faka". Chofoza isithonjana esithi "Ithebula" kanye nohlu lwezinketho, khetha u- "Guqula etafuleni".
- Kuzovulwa ibhokisi lengxoxo elincane lapho ungabeka khona amapharamitha afiselekayo etafuleni. Kepha, uma ngaphambi kwalokho konke kwenziwa kahle, okuyinhloko yazo kuzonqunywa ngokuzenzakalelayo.
- Okokuqala, qiniseka ukuthi amanani achazwe kwinani lamakholomu kanye "nenombolo yezintambo" ahambelana nalokho okudingayo (kithi kungu-6 no-8, ngokulandelana).
- Okulandelayo, nquma i-parameter "iqoqo le-auto of colomnic" (sabhekwa ngendlela yesibili yalesi sihloko). Isixazululo esifanele "ngokusho kokuqukethwe", ngoba le pharamitha inquma ububanzi bekholomu yetafula ngokuya ngosayizi wombhalo ophethwe.
Qaphela: IZwi likhetha ngokuzenzakalela ububanzi bamakholomu wethebula. Uma usadinga ukusetha amapharamitha akho, ensimini "njalo" Faka inani elifunekayo. Ipharameter "Ngobubanzi bewindi" Ikuvumela ukuthi ushintshe ngokuzenzakalelayo usayizi wethebula lapho ububanzi besikhala esikhona bushintsha (ngokwesibonelo, ku-Web Dock Viewer noma nge-Landscape Ariental).
- Esivikelweni se- "Susator", faka umaki obhekene nalokho okufana nesithonjana sokuhlukanisa osibekile. Esibonelweni sethu, le "ithebhu yethebhu."
Ukuvala i- "Guqula ebhokisini lengxoxo" yengxoxo bese wenza ngokuqondile lo msebenzi, cindezela inkinobho ethi "KULUNGILE". Ngezansi kukhonjiswa okwenzekile esibonelweni sethu.
Ngokusobala, kuzodingeka okungenani zidlale ukudlala okuncane ngosayizi wemigqa namakholomu kanye / noma amaseli ngamanye (noma ngenketho yokukhetha okuzenzakalelayo) ngokuqondanisa kwawo.
- Iya kumenyu yokufaka itafula, chofoza inkinobho ehambisanayo bese ukhetha "Ithebula Le-Excel".
- Lo mbhalo uzovela kudokhumenti, noma kunalokho, iqabunga elivela ku-Excel, igama elithi I-Interface uqobo ngokwalo (iphaneli eliphakeme) liguqulwa futhi lizobe lifana nomhleli wombhalo, kodwa ku-processor yetafula elivela kwiphakheji yeMicrosoft.
- Ezinye zezenzo azihlukile kulabo abase-Excel, okungukuthi, umane wakhe itafula losayizi olifunayo eshidini, gcwalisa, uhlele futhi ufomethi, usebenzisa amathuluzi wegama lakho konke, kanye nesethi ethuthukisiwe ye-Excel. Umyalo owethulwe ngezansi kwesixhumanisi uzokusiza uqonde wonke ama-nuances.
Bheka futhi: Ungawakha kanjani itafula ku-Microsoft Excel
Ngasikhathi sinye, uzokudala kwiphaneli yokulawula (itheyiphu) yegama, ithebhu "Ukusebenza namathebhu" aqukethe amathebhu "aqukethe amathebhu" kanye "nokuhlelwa" nokuqukethe iqoqo elidingekayo lamathuluzi okusebenza namatafula , Izinguquko kanye nemihlobiso.
Uyisebenzisa, unganikeza itafula lakho umbono nesitayela osifunayo, engeza noma ususe imingcele, wenze amafreyimu, ugcwalise, faka amafomula ahlukahlukene, njll.
Bheka futhi: Faka ifomula etafuleni egameni
Kwakuyinto elula, kepha hhayi ukuphela kwendlela yokwakha itafula ngegama.
Indlela 2: Ithebula elinamapharamitha alungisekayo
Uma unombono oqondile noma ongaphansi wokuthi itafula lakho kufanele libukeke kanjani nokuthi yiluphi usayizi olinganisiwe okufanele ngabe lunalo, la mapharamitha angachazwa ngqo lapho kudalwa.
Indlela 3: Umdwebo ozimele
Uma udinga usayizi okungahleliwe etafuleni kanye nohlobo, isibonelo, nge amaseli elihlangene, noma nge ukuphakama ezahlukene futhi ububanzi enjalo (kanye imigqa kanye / noma amakholomu), kuyodingeka ukudweba ngesandla usebenzisa isithombe esifanele umbhalo umhleli.
Imvamisa, umdwebo wokuphikisana, umdwebo wethekji wetafula egameni yisisombululo esihle kakhulu futhi ukuvumela ukuthi wenze lokho okudingekayo (noma ukufuna nje).
Indlela 4: Itafula elivezayo
Ngenguqulo ngayinye entsha yegama lomhleli, kwavela eminye imibhalo. Ungazikhethela uma uqala uhlelo noma ngemenyu yefayela - "Dala". Kukhona kuhlelo futhi izifanekiso amathebula, futhi ungekho window ukuqala, kodwa kukho konke menu efanayo, kakade ajwayelekile kithi faka.
Ngeshwa, iqoqo isifanekiso amatafula eZwini kunalokho nesizotha, kodwa kungenziwa kalula Akunwetshiwe ngu imiklamo yayo. Okungukuthi, noma yimuphi ithebula wadala kungaba ukungezwa kule isethi, okuyiwona udinga ukwenza okulandelayo.
Kusukela manje, etafuleni lakho azoboniswa ku "Express Ithebula" uhlu.
Bheka futhi: Indlela ukwakha isifanekiso idokhumenti eZwini
Indlela 5: Ithebula lokuguqula umbhalo
Zonke izindlela ezithathwe yithi ngenhla zikuvumela ukuthi udale itafula, elizogcwaliswa ngokuhamba kwesikhathi ngedatha edingekayo. Kodwa kuthiwani uma kudingeka ahambe kusukela okuphambene - okungukuthi, idatha isivele ikhona, futhi manje badinga ezoguqulwa etafuleni? I-Microsoft Word ibanikeza nawe nethuba elinjalo, okungukuthi, uhlelo likuvumela ukuthi uguqule umbhalo uye etafuleni. Indlela elula yokwethula uhlu ngale ndlela (kaningi kakhulu - ilebula), kepha lokhu akuyona ukuphela kokusebenza komsebenzi.
Izenzo eziqhubekayo zokuhlela zenziwa ngendlela efanayo nasezindleleni okuxoxwe ngazo ngenhla - usebenzisa ithebhu yethebhu yethebhu "esebenza ngamatafula".
Kuhlala kukhubaza kuphela ukuboniswa kwezinhlamvu ezifihliwe kudokhumenti (lezi ziboniswa etafuleni ngalinye letafula ngemuva kombhalo naphezu komngcele wayo ofanele). Yenza lokhu kuzosiza isihloko esilandelayo:
Funda kabanzi: Ungawavala kanjani izinhlamvu ezingaphrintwa egameni
Indlela 6: Faka futhi uthumele kusuka ku-Excel
Njengoba wazi, izwi kungenye yezicelo eziningi ezifakiwe ehhovisi leMicrosoft. Njengengxenye yesethi efanayo, kukhona iprosesa ye-thobular egqamile, egxile kakhulu ekwakheni amatafula futhi isebenze nabo kunesihleli sombhalo esisibonayo namuhla. Ngenxa yobudlelwano obusondelene bezakhi zephakethe lehhovisi kusuka kuMicrosoft nomunye nomunye, akumangazi ukuthi cishe noma iyiphi ithebula elenziwe nge-Excel lingadluliselwa egameni nakanjani eZwini. Ungakwenza lokhu usebenzisa ukukopisha okulula, ukufaka okukhethekile noma ukufaka kusuka kufayela. Ngemininingwane engaphezulu ngezindlela ezithile ezikhona, satshela kwi-athikili esehlukile kwiwebhusayithi yethu.
Funda kabanzi: Ukudluliswa kwetafula kusuka ku-Excel kuya kwegama
Ngaphezu kokuthumela itafula kusuka ku-Excel, lingadalwa ngezwi futhi likwazi ukuzimela (izinhlobo abanalo ku-processor yetafula kusuka kuMicrosoft, hhayi njengamacala abhekwe ngenhla). Kwalokhu:
Ukuze uphume kwimodi yokusebenza ngethebula le-Excel, vele uchofoze kunoma iyiphi indawo engenalutho ekhasini ledokhumenti - uzophinda uvele igama elijwayelekile, kodwa ngethebula elimbalwa elingajwayelekile ngalo.
Indlela 7: Ukufaka amatafula kusuka kwi-Intanethi
I-Microsoft Word Arsenal inezitayela eziningi nezifanekiso zokwakha kanye / noma ukuguquka, ukuguqula amatafula. Noma ngabe yini umsebenzi ophambi kwakho awuzange ume, noma ngabe yini uphefumulelwe, ungahlala unikeza itafula elidalwe kumhleli wombhalo, ukubuka okufunwayo (kungakapheli umkhawulo ogcwele namatafula kufanele kubhekiswe kuwo njengoba I-Excel). Kepha kwenzeka ukuthi etafuleni lezinhlobo ezifanele olitholile ihhovisi lesicelo sehhovisi, naku-Intanethi noma umane nje udinga ukufaka ukushicilelwa etafuleni lewebhu. Kulula ukukwenza, okungukuthi, itafula elivela kusayithi lingakopishwa, bese lifaka ekhasini elifunayo. Kuliqiniso, kuzofanela kusebenze okuthe xaxa. Mayelana nokuthi kuzodingeka yini ukukwenza kulokhu, sabhala futhi.
Funda kabanzi: Ukukopisha itafula kusuka kuwebhusayithi kuya kudokhumenti yamagama
Ukugcina
Ngemuva kokufunda le ndatshana, kungenzeka ukuthi wabona ukuthi iMicrosoft Word ihlinzeka ngamathuba abanzi okwakha amatafula, futhi noma ngabe kuhlelo lwe-arsenal ngeke uthole amathuluzi adingekayo kanye / noma imisebenzi, umane ufake itafula kusuka ngaphandle I-Excel noma kwi-Intanethi.