Kubasebenzisi abaningi be-Excel, inqubo yokukopisha amathebula ayinzima. Kodwa akubona wonke umuntu owazi ezinye zezinto ezihamba phambili ezenza le nqubo ibe ngempumelelo ngangokunokwenzeka ngezinhlobo ezehlukene zedatha nezinhloso ezihlukahlukene. Ake sihlolisise ezinye zezici zokukopisha idatha ku-Excel.
Kopisha ku-Excel
Ukukopisha ithebula ku-Excel kungukudalwa kwempinda yayo. Kule nqubo ngokwayo, cishe akukho ukungafani kuye ngokuthi uya kuphi ukufaka idatha: kwenye indawo yeshidi elifanayo, eshadini elisha noma kwenye incwadi (ifayela). Umehluko omkhulu phakathi kwezindlela zokukopisha ukuthi ufuna ukukopisha kanjani ulwazi: ngefomula noma kuphela ngemininingwane ebonisiwe.
Isifundo: Ukukopisha amatafula ku-Wordrosoft Word
Indlela 1: Kopisha ngokuzenzakalelayo
Ukukopisha okuzenzakalelayo ngokuzenzakalelayo ku-Excel kunikeza ukudala ikhophi yetafula kanye nawo wonke amafomula kanye nokufometha okufakwe kuso.
- Khetha indawo esifuna ukuyikopisha. Chofoza endaweni ekhethiwe nge inkinobho yesinxele yegundane. Imenyu yomongo ivela. Khetha into kuwo "Kopisha".
Kunezinye izindlela ongakhetha ngazo zokwenza lesi sinyathelo. Owokuqala ukucindezela isinqamuleli sekhibhodi ekhibhodi. Ctrl + C ngemuva kokukhetha indawo. Inketho yesibili ihilela ukucindezela inkinobho. "Kopisha"okuyinto itholakala kwi Ribbon kuthebhu "Ikhaya" eqenjini lamathuluzi "Ibhodi lokunamathisela".
- Vula indawo esifuna ukufaka kuyo idatha. Lokhu kungaba ishidi elisha, elinye ifayela le-Excel, noma enye indawo yamaseli eshidi elifanayo. Chofoza kuseli, okufanele kube iseli eliphezulu ngakwesokunxele kwetafula elifakiwe. Emenyu yomongo ezenzweni zokufaka, khetha into "Faka".
Kukhona futhi okunye okukhethwa kukho kokusebenza. Ungakhetha iseli bese ucindezela inhlanganisela eyinhloko ekhibhodi Ctrl + V. Ngaphandle kwalokho, ungachofoza inkinobho. Namathiselaelitholakala engxenyeni engakwesokunxele yetayipi eceleni kwenkinobho "Kopisha".
Ngemuva kwalokho, idatha izofakwa ngenkathi igcina ukufometha namafomula.
Indlela 2: Kopisha Amanani
Indlela yesibili ihilela ukukopisha kuphela amanani wetafula aboniswa esikrinini, hhayi amafomula.
- Kopisha idatha ngenye yezindlela ezichazwe ngenhla.
- Chofoza inkinobho yegundane kwesokudla lapho ufuna ukufaka khona idatha. Emenyu yomongo ezinketho zokufaka, khetha into "Amanani".
Emva kwalokho, itafula lizofakwa eshadini ngaphandle kokwenza ukufometha nokufomula. Okusho ukuthi idatha kuphela ekhonjisiwe esibukweni izokwenziwa ngokukopishwa.
Uma ufuna ukukopisha amanani, kodwa ugcine ukufometha kwangempela, udinga ukuya entweni yemenyu ngenkathi ufaka "Namathisela Okukhethekile". Kulapho ku-block "Faka amanani" kudingeka ukhethe into "Izimiso nokufometha kwasekuqaleni".
Ngemuva kwalokho, itafula lizovela efomeni layo langempela, kodwa esikhundleni samafomula, amaseli azogcwalisa amanani ajwayelekile.
Uma ufuna ukwenza lo msebenzi kuphela ngokulondoloza ukufometha kwezinombolo, hhayi yonke itafula, bese kuyingxenye ekhethekile ukufaka udinga ukukhetha into "Amanani namafomethi wezinombolo".
Indlela 3: Yakha ikhophi ngenkathi ugcina ububanzi bekholomu
Kodwa, ngeshwa, ngisho nokusetshenziswa kokufometha kwangempela akuvumeli ukwenza ikhophi yetafula ngobubanzi bokuqala bamakholomu. Okungukuthi, kaningi kunezimo lapho emva kokufaka idatha ayifani namaseli. Kodwa ku-Excel kungenzeka ukugcina ububanzi bokuqala bekholomu usebenzisa izinyathelo ezithile.
- Kopisha ithebula nganoma iyiphi indlela evamile.
- Endaweni lapho udinga ukufaka khona idatha, shayela imenyu yokuqukethwe. Ngokulandelana kwethu siya phezu kwamaphoyinti "Namathisela Okukhethekile" futhi "Londoloza ububanzi bekholomu yokuqala".
Ungenza enye indlela. Kusukela kwimenyu yomongo, iya entweni enegama elifanayo kabili. "Faka okukhethekile ...".
Iwindi livula. Ku-"Faka" ithuluzi lokuvimba, thuthela ushintsho endaweni "Ububanzi bekholomu". Sicindezela inkinobho "Kulungile".
Kungakhathaliseki ukuthi iyiphi indlela oyikhethayo kulezi zindlela ezimbili ezingenhla, noma kunjalo, ithebula elikopishiwe lizoba nobubanzi obufanayo bekholomu njengomthombo.
Indlela 4: Faka njengesithombe
Kunezimo lapho ithebula lidinge ukungeniswa ngendlela ejwayelekile, kodwa njengesithombe. Le nkinga nayo ixazululwe ngosizo lwe-insert ekhethekile.
- Sikopisha ububanzi obufunayo.
- Khetha indawo ongayifaka bese ufonela imenyu yokuqukethwe. Iya endaweni "Namathisela Okukhethekile". Ku-block "Ezinye Izinketho Zokufaka" khetha into "Ukudweba".
Emva kwalokho, idatha izofakwa eshadini njengesithombe. Ngokuvamile, ngeke kwenzeke ukuhlela itafula elinjalo.
Indlela yesi-5: Kopisha Iphepha
Uma ufuna ukukopisha lonke ithebula kwenye ishidi, kodwa ngesikhathi esifanayo ugcine ngokufana ngokuphelele nekhodi yomthombo, bese kulesi simo, kungcono ukukopisha lonke ishidi. Kulesi simo, kubalulekile ukunquma ukuthi ufuna ngempela ukudlulisa konke okusemkhakheni womthombo, ngaphandle kwalokho le ndlela ngeke isebenze.
- Ukuze ungakhethi ngesandla ukhethe wonke amaseli eshidi, okungathatha isikhathi esiningi, chofoza etsheni elibekwe phakathi kwephaneli yokuxhumanisa enezingqimba futhi eziqondile. Emva kwalokho, lonke ishidi lizogqanyiswa. Ukuze ukopishe okuqukethwe, thayipha inhlanganisela kukhibhodi Ctrl + C.
- Ukufaka idatha, vula ishidi elisha noma incwadi entsha (ifayela). Ngokufanayo, chofoza kwitexeni esendaweni yezinhlangothi zamapaneli. Ukufaka idatha, thayipha inhlanganisela yezinkinobho Ctrl + V.
Njengoba ubona, ngemuva kokwenza lezi zenzo, sikwazi ukukopisha ishidi kanye netafula kanye nokunye okuqukethwe kwalo. Ngesikhathi esifanayo kuvele ukulondoloza ukufometha kwangempela kuphela, kodwa futhi ubukhulu bamaseli.
Umhleli we-Spreadsheet Excel unamathuluzi amaningi wokukopisha amatafula ngendlela edingekayo ngumsebenzisi. Ngeshwa, akubona wonke umuntu owaziyo mayelana nama-nuances okusebenza ngokufaka okukhethekile namanye amathuluzi okukopisha angakwazi kakhulu ukwandisa amathuba okudluliswa kwedatha, kanye nokuzenzelela izenzo zomsebenzisi.
