Kubasebenzisi abaningi be-Excel, ukukopisha amatafula kulula. Kepha, akuwona wonke umuntu owaziyo amanye ama-nuances enza le nqubo isebenze ngempumelelo yezinhlobo ezahlukahlukene zedatha nezinhloso ezahlukahlukene. Ake sihlolisise ezinye izici zokukopisha idatha ku-Excel.
Ikhophi ku-Excel
Ukukopisha itafula ku-Excel kuyimpinda yayo. Akukho mehluko kunqubo, kuya ngokuthi uzofaka ini idatha: kwenye indawo eshidini elifanayo, ekhasini elisha noma kwenye incwadi (ifayela). Umehluko omkhulu phakathi kwezindlela zokukopisha ukuthi ufuna ukukopisha kanjani imininingwane: kanye namafomula noma ngedatha ebonisiwe kuphela.
Isifundo: Ikopisha amatafula ku-Mirosoft Word
Indlela yoku-1: ikhophi ngokwakhona
Ukukopisha okulula ngokuzenzakalelayo ku-Excel kuhlinzeka ngokwakha ikhophi yetafula kanye nawo wonke amafomula nefomathi efakwe kuyo.
- Khetha indawo ofuna ukuyikopisha. Sichofoza endaweni ekhethiwe ngenkinobho yegundane elifanele. Imenyu yokuqukethwe iyavela. Khetha into kuyo Kopisha.
Kukhona ezinye izindlela zokwenza lesi sinyathelo. Owokuqala ukucindezela isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + C ngemuva kokuqokomisa indawo. Inketho yesibili ifaka ukucindezela inkinobho Kopishaetholakala kubambo kuthebhu "Ikhaya" eqenjini lamathuluzi Ibhodi yokunamathisela.
- Vula indawo lapho sifuna ukufaka khona idatha. Lokhu kungaba yishidi elisha, elinye ifayela le-Excel, noma enye indawo yamaseli ekhasini elilodwa. Qhafaza esitokisini, okufanele sibe yiseli ephezulu kwesokunxele yetafula elifakiwe. Kumenyu yokuqukethwe, kukhetho lokufaka, khetha into ethi "Faka".
Kukhona futhi ezinye izinketho. Ungakhetha iseli ngokucindezela isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + V. Ngenye indlela, ungachofoza inkinobho. Namathisela, etholakala emaphethelweni wesobunxele wobambo ngqo eduze kwenkinobho Kopisha.
Ngemuva kwalokho imininingwane izofakwa ngokulondolozwa kokufomathwa namafomula.
Indlela 2: Kopisha Izindinganiso
Indlela yesibili ifaka ukukopisha amanani wethebula kuphela aboniswa esikrinini, hhayi amafomula.
- Sikopisha imininingwane ngenye yezindlela ezichazwe ngenhla.
- Qhafaza kwesokudla endaweni lapho ufuna ukunamathisela khona idatha. Kumenyu yokuqukethwe, kukhetho lokufaka, khetha "Amanani".
Ngemuva kwalokho, itafula lizongezwa kwishidi ngaphandle kokugcina ukufomatha namafomula. Okusho ukuthi, yidatha eboniswe esikrinini kuphela ezokopishwa.
Uma ufuna ukukopisha amanani, kodwa ngasikhathi sinye ukugcina okufomethiwe, udinga ukuya entweni yemenyu ngesikhathi sokufakwa "Faka okhethekile". Lapho kubhulokhi Faka Amanani isidingo sokukhetha "Amanani nokufomethwa komthombo".
Ngemuva kwalokho, itafula lizokwethulwa ngendlela yalo yasekuqaleni, kodwa kuphela esikhundleni semafomula amaseli azogcwalisa amanani aqhubekayo.
Uma ufuna ukwenza lo msebenzi kuphela ngenkathi kulondolozwa ukufomatha kwezinombolo, hhayi lonke ithebula, lapho ukufaka okhethekile udinga ukukhetha "Amanani namafomethi ezinombolo".
Indlela 3: dala ikhophi ngenkathi ugcina ububanzi bekholomu
Kepha, ngeshwa, ukusebenzisa ifomethi yangempela akuvumeli ukuthi wenze ikhophi yetafula ngobubanzi bekholomu yoqobo. Okusho ukuthi, kuvame ukuba nezimo lapho, ngemuva kokufakwa, idatha ingangeni kumaseli. Kepha u-Excel unamandla okusebenzisa isenzo esithile ukugcina ububanzi bokuqala bekholomu.
- Kopisha itafula nganoma yiziphi izindlela ezijwayelekile.
- Endaweni lapho ufuna ukufaka idatha, shayela imenyu yokuqukethwe. Sihamba ngamaphuzu "Faka okhethekile" futhi "Gcina Ububanzi Bekholomu Yangempela".
Ungakwenza ngenye indlela. Ukusuka kumenyu yokuqukethwe, yiya kabili entweni enegama elifanayo "Faka okhethekile ...".
Kuvulwa iwindi. Ebhokisini lamathuluzi "Namathisela", shintsha switch uye esikhundleni Amakholomu Ububanzi. Chofoza inkinobho "Kulungile".
Noma iyiphi indlela oyikhethayo kulezi zinketho ezimbili ezingenhla, kunoma yikuphi, itafula elikopishiwe lizoba nobubanzi bekholomu efanayo nomthombo.
Indlela 4: faka njengesithombe
Kunezikhathi lapho itafula lidinga ukufakwa hhayi ngefomethi ejwayelekile, kepha njengesithombe. Le nkinga ixazululwa ngosizo lokufakelwa okhethekile.
- Sikopisha uhla olufunayo.
- Khetha indawo ozoyifaka bese ubiza imenyu yokuqukethwe. Iya kukhomba "Faka okhethekile". Ebhlokini "Ezinye izinketho zokufaka" khetha into "Umdwebo".
Ngemuva kwalokho, imininingwane izofakwa eshidini njengesithombe. Ngokwemvelo, ukuhlela itafula elinjalo ngeke kusenzeka.
Indlela yesi-5: kopisha ishidi
Uma ufuna ukukopisha lonke ithebula ngokuphelele kwelinye iphepha, kodwa ngasikhathi sinye lifane ngokuphelele nomthombo, khona-ke kuleli cala, kungcono ukukopisha lonke iphepha. Kulokhu, kubalulekile ukunquma ukuthi ufuna ngempela ukudlulisa konke okuseshidi lomthombo, ngaphandle kwalokho le ndlela ngeke isebenze.
- Ukuze ungakhethi ngesandla wonke amaseli eshidi, futhi lokhu kungathatha isikhathi esikhulu, chofoza kusikwele esikhona phakathi kwamaphaneli aqondile naphezulu aqondile. Ngemuva kwalokho kuzoqokonyiswa lonke ishidi. Ukukopisha okuqukethwe, sithayipha kukhibhodi inhlanganisela I-Ctrl + C.
- Ukufaka idatha, vula ishidi elisha noma incwadi entsha (ifayela). Ngendlela efanayo, chofoza kusikwele esisekuxhumaneni kwamapaneli. Ukuze ufake idatha, sithayipha inhlanganisela yezinkinobho I-Ctrl + V.
Njengoba ubona, ngemuva kokwenza lezi zinyathelo, sikwazile ukukopisha iphepha kanye netafula nokunye okuqukethwe kwalo. Ngaso leso sikhathi, bekungenzeka ukugcina hhayi kuphela ukufomatha kwasekuqaleni, kepha nosayizi wamaseli.
Umhleli wespredishithi i-Excel unethuluzi elibanzi lokukopisha amatafula kahle ngendlela umsebenzisi ayidingayo. Ngeshwa, akuyena wonke umuntu owaziyo ngama-nuances wokusebenza ngokunamathisela okukhethekile namanye amathuluzi wokukopisha, angakhulisa kakhulu amandla okudlulisa idatha, kanye nezenzo zomsebenzisi ezizenzakalelayo.
