Kwabasebenzisi abaningi abahamba phambili, inqubo yamatafula okukopisha akayona ubunzima obukhulu. Kepha, akuyena wonke umuntu owazi ama-nuances avumela ukuthi wenze le nqubo ibe khona kahle ngohlobo oluhlukile lwedatha nezinhloso ezihlukile. Ake sibheke ngokuningiliziwe ezinye izici zokukopisha idatha ohlelweni lwe-Excel.
Ukukopisha ukufundela
Ukukopisha itafula ku-Excel kungukudalwa kwempinda yawo. Ngenqubo yo kanye, awekho umehluko ngokuya ngokuthi uzofaka kuphi idatha: kwenye indawo yeshidi elifanayo, eshidini elisha noma enye incwadi (ifayela). Umehluko omkhulu phakathi kwezindlela zokukopisha yindlela ofuna ukukopisha ngayo imininingwane: Ngokubambisana namafomula noma kuphela ngedatha ekhonjisiwe.Isifundo: Ukukopisha amatafula ku-Mirosoft Word
Indlela 1: Kopisha okuzenzakalelayo
Ukukopisha okulula ngokuzenzakalelayo ku-Excel kufaka phakathi ukudala ikhophi yetafula kanye nawo wonke amafomula abekwe kuwo nokufomatha.
- Sigqamisa indawo esifuna ukuyikopisha. Chofoza endaweni eyabelwe ngenkinobho yegundane efanele. Imenyu yomongo iyavela. Khetha kuyo "Kopisha".
Kukhona ezinye izinketho zokwenza lesi sinyathelo. Owokuqala wabo uqukethe ukucindezela ikhibhodi yezinkinobho ze-CTRL + C ngemuva kokukhethwa kwendawo. Inketho yesibili ifaka ukucindezela inkinobho ethi "Kopisha", etholakala ethepheni kuthebhu "Yasekhaya" ku-ToolBu "Exchange Buffer".
- Vula indawo lapho sifuna ukufaka khona idatha. Kungaba ishidi elisha, elinye ifayela le-Excel noma enye indawo yamaseli ekhasini elifanayo. Chofoza esitokisini okufanele kube yiseli eliphezulu kwesokunxele elifakiwe. Kumenyu yokuqukethwe kumapharamitha wokufaka, khetha u- "Namathisela".
Kukhona nezinye izinketho zezenzo ezihlukile. Ungaqokomisa ikhibhodi ye-CTRL + V kwikhibhodi. Ngaphezu kwalokho, ungachofoza inkinobho ethi "Namathisela", okutholakala emaphethelweni kwesobunxele weteyipu eduze kwenkinobho ethi "Kopisha".
Ngemuva kwalokho, ukufakwa kwedatha kuzokwenziwa ngenkathi kugcinwa ukufomatha namafomula.
Indlela 2: Amanani wokukopisha
Indlela yesibili ihlinzekela ukopisha amanani ethebula aboniswa esikrinini, hhayi amafomula.
- Kopisha imininingwane kwenye yezindlela ezichazwe ngenhla.
- Ngokuchofoza inkinobho yegundane efanele endaweni lapho udinga ukufaka khona idatha. Kumenyu yokuqukethwe kumapharamitha wokufaka, khetha into ethi "Amanani".
Emva kwalokho, itafula lizongezwa ephepheni ngaphandle kokulondolozwa kokufomatha namafomula. Okungukuthi, idatha ekhonjiswe kuphela esikrinini esizokopishwa.
Uma ufuna ukukopisha amanani, kepha ngasikhathi sinye gcina ukufometha kwangempela, khona-ke udinga ukuya entweni yemenyu "Faka okukhethekile" ngesikhathi sokufakwa. Lapho, ku- "Insert Values" block, udinga ukukhetha "amanani kanye nokufomatha kwangempela".
Ngemuva kwalokho, itafula lizokwethulwa ngendlela yokuqala, kepha kuphela esikhundleni samafomula weseli azogcwalisa amanani aqhubekayo.
Uma ufuna ukwenza lokhu kusebenza kuphela ngokulondolozwa kokufomatha kwezinombolo, hhayi lonke ithebula, bese kufakwa okukhethekile okudingayo ukukhetha into "namanani ezinombolo".
Indlela 3: Dala ikhophi ngenkathi ukonga ububanzi bekholomu
Kepha, ngeshwa, ngisho nokusetshenziswa kokufomatha komthombo akukuvumeli ukuthi wenze ikhophi yetafula ngobubanzi bekholomu lokuqala. Okungukuthi, kaningi kunezimo lapho idatha ingafakwa kumaseli ngemuva kokufaka. Kepha ku-Excel, kungenzeka ukuthi ulondoloze ububanzi bekholomu yangempela usebenzisa izenzo ezithile.
- Kopisha ithebula nganoma iyiphi indlela ejwayelekile.
- Endaweni lapho udinga ukufaka khona idatha, shayela imenyu yokuqukethwe. Ngokuqhubekayo sidlula ezintweni "Faka okukhethekile" futhi "Gcina ububanzi bekholomu yasekuqaleni."
Ungabhalisa ngenye indlela. Kusuka kumenyu yomongo kabili iya entweni enegama elifanayo "ukufakwa okukhethekile ...".
Iwindi liyavula. Ku-"Faka" yamathuluzi, sihlele kabusha ukushintshela esimweni esithi "COLOMNLIN 'isikhundla. Chofoza inkinobho ethi "KULUNGILE".
Noma ngabe iyiphi indlela oyikhethile kumakhekhe amabili afakwe kuhlu ngenhla, kunoma yikuphi, itafula lokukopisha lizoba nobubanzi bekholomu efanayo nomthombo.
Indlela 4: Faka njengesithombe
Kunamacala lapho itafula lidinga ukufakwa hhayi ngefomethi ejwayelekile, kodwa njengesithombe. Lo msebenzi uxazululwa futhi usebenzisa ukufaka okukhethekile.
- Yenza ukukopisha uhla olufunayo.
- Khetha indawo ongayifaka futhi ushayele imenyu yokuqukethwe. Iya entweni ethi "Ukufaka Okukhethekile". In the "Okunye Faka izilungiselelo" block, khetha into ethi "Umdwebo".
Emva kwalokho, imininingwane izofakwa ephepheni njengesithombe. Ngokwemvelo, kuzokwenzeka ukuhlela itafula elinjalo.
Indlela 5: Ukukopisha ishidi
Uma ufuna ukukopisha lonke itafula kwelinye ishidi, kodwa ngasikhathi sinye ukuligcina umthombo ofanayo, khona-ke kulokhu, kungcono ukukopisha ishidi lonke. Kulokhu, kubalulekile ukunquma ukuthi ufuna ngempela ukudlulisela konke okuseshidini lomthombo, ngaphandle kwalokho le ndlela ngeke ilunge.
- Ukuze unikeze ngesandla wonke amaseli eshidi, futhi lokhu kuzothatha isikhathi esikhulu, chofoza kusikwele esisendaweni evundlile ne-vertical coordite Panel. Emva kwalokho, lonke ishidi lizoqokonyiswa. Ukukopisha okuqukethwe, thayipha inhlanganisela ye-CTRL + C kwikhibhodi.
- Ukufaka imininingwane, vula ishidi elisha noma incwadi entsha (ifayela). Ngokufanayo, chofoza unxande obekwe ekuxhumaneni kwamaphaneli. Ukuze ufake imininingwane, thayipha inhlanganisela ye-CTRL + V.
Njengoba ubona, ngemuva kokwenza lezi zenzo, sikwazile ukukopisha ishidi ndawonye netafula nokunye okuqukethwe kuyo. Kwavela ukuthi akugcinelwe hhayi ukufometha kokuqala kuphela, kodwa futhi nobungako bamaseli.
Isihleli sethebula le-Exel sinethuluzi elibanzi lokukopisha amatafula njengoba nje umsebenzisi adingeka. Ngeshwa, akuyena wonke umuntu owaziyo ngama-nuances okusebenza ngokufakwa okukhethekile namanye amathuluzi okukopisha akuvumela ukuthi ukhulise kakhulu amathuba okudluliswa kwedatha, kanye nokushintsha isenzo somsebenzisi.