Mhlawumbe, abasebenzisi abaningi abangenalwazi bazame ukukopisha idatha ethile ku-Excel, kodwa ngenxa yezenzo bathola inani elihluke ngokuphelele noma iphutha. Lokhu kungenxa yokuthi ifomula yayisesigabeni sokuqala sokukopisha, futhi yiyo eyayibekwa, hhayi inani. Izinkinga ezinjalo zingagwenywa uma laba basebenzisi bewazi umqondo onjengokuthi "Faka okhethekile". Ngosizo lwayo, futhi ungenza eminye imisebenzi eminingi, kubandakanya izibalo. Ake sibheke ukuthi liyini leli thuluzi nokuthi ungasebenza kanjani nalo.
Sebenza ngokufaka okhethekile
Ukufakwa okukhethekile kuhloselwe ukufaka isabizwana esithile kwishidi le-Excel ngendlela umsebenzisi ayidingayo. Ngaleli thuluzi, unganamathisela esitokisini akuyona yonke idatha ekopishiwe, kepha kuphela izakhiwo ezizimele (amanani, amafomula, ifomethi, njll). Ngaphezu kwalokho, usebenzisa amathuluzi, ungenza imisebenzi ye-arithmetic (ukwengeza, ukuphindaphinda, ukususa nokukhipha), kanye nokudlula kwetafula, okungukuthi, ukushintshana kwemigqa namakholomu kuyo.
Ukuze uye kufakwe okhethekile, okokuqala, udinga ukwenza isenzo sekhophi.
- Khetha iseli noma ibanga ofuna ukulilingisa. Yikhethe ngesikhombisi ngenkathi ubambe inkinobho yegundane kwesobunxele. Chofoza ekukhetheni ngenkinobho yegundane elifanele. Imenyu yokuqukethwe icushiwe lapho udinga khona ukukhetha into Kopisha.
Futhi, esikhundleni senqubo engenhla, ungakwazi, ukuba kuthebhu "Ikhaya"chofoza isithonjana Kopishaelibekwe etheyipini eqenjini Ibhodi yokunamathisela.
Ungakopisha i-expression ngokuyikhetha bese uthayipha inhlanganisela ye-hotkey I-Ctrl + C.
- Ukuqhubeka ngqo nenqubo, khetha indawo eshidini lapho sihlela khona ukunamathisela izinto ezikopishwe ngaphambilini. Sichofoza kukhetho ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe eqala, khetha isikhundla "Faka okhethekile ...". Ngemuva kwalokho, kuvulwa uhlu olungeziwe, lapho ungakhetha khona izinhlobo ezahlukahlukene zezenzo, zihlukaniswe ngamaqembu amathathu:
- Faka ("Faka", "Transpose", "amafomula", "amafomula nezinombolo zezinombolo", "Ngaphandle kwezinhlaka", "Gcina ububanzi bekholomu yokuqala" kanye "Gcina ukufomathwa kwasekuqaleni");
- Namathisela amanani ("I-Value and Source formtinging", "Amanani" kanye "namavelu namafomethi ezinombolo");
- Ezinye izinketho zokufaka (Ukufometha, Umdwebo, Faka Isixhumanisi, kanye Nomfanekiso Oxhunyiwe).
Njengoba ubona, amathuluzi eqembu lokuqala akopisha inkulumo equkethwe esitokisini noma ibanga. Iqembu lesibili lihloselwe ikakhulu ukukopisha amanani, hhayi amafomula. Iqembu lesithathu lidlulisela ukufomatha nokubukeka.
- Ngaphezu kwalokho, kwimenyu efanayo eyengeziwe kunenye into enegama elifanayo - "Faka okhethekile ...".
- Uma uchofoza kuso, kuvulwa iwindows eliyisipesheli elikhethekile ngamathuluzi ahlukaniswe ngamaqembu amakhulu: Namathisela futhi "Ukusebenza". Okungukuthi, ngenxa yamathuluzi eqembu lokugcina, kungenzeka ukwenza imisebenzi yokubala, okuxoxwe ngayo ngenhla. Ngaphezu kwalokho, kule windi kunezinto ezimbili ezingafakwanga ngamaqembu ahlukene: Yeqa Amaseli Angenalutho futhi "Transpose".
- Ungangena kokufakelwa okhethekile hhayi ngemenyu yokuqukethwe kuphela, kodwa nangamathuluzi kubambo. Ukuze wenze lokhu, kokuba kuthebhu "Ikhaya", chofoza isithonjana ngesimo sonxantathu oqondiswe phansi, otholakala ngaphansi kwenkinobho Namathisela eqenjini Ibhodi yokunamathisela. Ngemuva kwalokho, uhlu lwezenzo ezingenzeka luyavulwa, kufaka phakathi ukushintshela ewindini elihlukile.
Indlela yoku-1: sebenza ngamanani
Uma udinga ukudlulisela amanani amaseli, umphumela wawo ukhonjiswa kusetshenziswa amafomula wokuhlanganiswa, lapho-ke ukufakwa okukhethekile kumakhelwe leli cala. Uma usebenzisa ukukopisha njalo, ifomula iyakopishwa, futhi ivelu eboniswe kuyo kungenzeka ingabi yilokho okudingayo.
- Ukuze ukopishe amanani, khetha ibanga eliqukethe umphumela wokubala. Siyikopisha nganoma yiziphi izindlela ebesikhuluma ngazo ngenhla: imenyu yokuqukethwe, inkinobho kubambo, inhlanganisela yezinkinobho ezishisayo.
- Khetha indawo eshidini lapho sihlela ukufaka khona idatha. Siqhubekela emenyu ngenye yezindlela ezixoxwe ngenhla. Ebhlokini Faka Amanani khetha isikhundla "Amanani namafomethi ezinombolo". Le nto ifaneleka kakhulu kulesi simo.
Inqubo efanayo ingenziwa ngewindi elichazwe ngaphambilini. Kulokhu, ku-block Namathisela shintsha switch uye esikhundleni "Amanani namafomethi ezinombolo" bese uchofoza inkinobho "Kulungile".
- Noma iyiphi inketho oyikhethayo, imininingwane izodluliselwa ebangeni elikhethiwe. Umphumela uzokhonjiswa ngaphandle kokudlulisa amafomula.
Isifundo: Ungayisusa kanjani ifomula ku-Excel
Indlela 2: ikhophi amafomula
Kepha futhi kunesimo esiphambene lapho udinga ukukopisha ngqo amafomula.
- Kulokhu, senza inqubo yokukopisha nganoma iyiphi indlela engenzeka.
- Ngemuva kwalokho, khetha indawo eshidini lapho ufuna ukufaka khona itafula noma enye imininingwane. Senza isebenze imenyu yokuqukethwe bese ukhetha into Amafomula. Kulokhu, kuzofakwa amafomula namavelu kuphela (kulawo maseli lapho zingenawo amafomula), kepha ngasikhathi sinye ukufometha nokusethwa kwamafomethi ezinombolo kuzolahleka. Ngakho-ke, ngokwesibonelo, uma ifomethi yosuku ibikhona endaweni yomthombo, khona-ke ngemuva kokukopisha izokhonjiswa ngokungalungile. Amaseli ahambisanayo azodinga ukufomethiwa ngokungeziwe.
Ewindini, lesi senzo sihambelana nokuhambisa okushintshiwe kusikhundla Amafomula.
Kepha kungenzeka ukuthi udlulise amafomula ngenkathi kulondolozwa ukufomatha kwenombolo, noma kulondolozwe ngokuphelele ukufomatha kwasekuqaleni.
- Esimweni sokuqala, khetha into kumenyu "Amafomula nezinhlobo zezinombolo".
Uma ukusebenza kwenziwa ngewindi, khona-ke kulokhu, udinga ukuhambisa ukushintshela kuye "Amafomula nezinhlobo zezinombolo" bese uchofoza inkinobho "Kulungile".
- Esimweni sesibili, lapho udinga ukugcina hhayi amafomula nezinombolo zezinombolo kuphela, kepha futhi nokufomatha okugcwele, khetha into yemenyu "Gcina Ukufomathwa Kwangempela".
Uma umsebenzisi enquma ukwenza lo msebenzi ngokuya ngewindi, khona-ke kuleli cala udinga ukuhambisa inkinobho uye esikhundleni "Ngengqikithi yangempela" bese uchofoza inkinobho "Kulungile".
Indlela 3: ukudlulisa ukufomatha
Uma umsebenzisi engadingi ukudlulisa imininingwane, kepha ufuna ukukopisha ithebula ukugcwalisa imininingwane ehluke ngokuphelele, khona-ke kuleli cala, ungasebenzisa iphuzu elithile lokufakelwa okhethekile.
- Kopisha itafula lomthombo.
- Eshidi, khetha isikhala lapho sifuna ukufaka khona kwetafula. Sibiza imenyu yokuqukethwe. Kuyo esigabeni "Ezinye izinketho zokufaka" khetha into Ukufometha.
Uma inqubo yenziwa ngewindi, khona-ke kuleli cala, sishintshela isikhundla esimweni "Amafomethi" bese uchofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, ngemuva kwalezi zinyathelo, ukwakheka kwetafula lasekuqaleni kudluliswa ngokufometha okulondoloziwe, kepha akuligcwalisiwe ngokuphelele nedatha.
Indlela 4: kopisha ithebula ngenkathi ugcina usayizi wamakholomu
Akuyona imfihlo ukuthi uma senza ikhophi elula yetafula, akulona iqiniso ukuthi wonke amaseli etafula elisha azokwazi ukwamukela yonke imininingwane yomthombo. Ungasilungisa lesi simo lapho ukopisha usebenzisa unamathisela okhethekile.
- Okokuqala, usebenzisa noma yiziphi izindlela ezingenhla, kopisha ithebula lomthombo.
- Ngemuva kokuqala imenyu eseyivele yazi, khetha inani "Gcina Ububanzi Bekholomu Yangempela".
Inqubo efanayo ingenziwa ngewindows ekhethekile yokufaka. Ukuze wenze lokhu, hambisa ukushintshela esimweni Amakholomu Ububanzi. Ngemuva kwalokho, njengokujwayelekile, chofoza inkinobho "Kulungile".
- Ithebula lizofakwa ngenkathi kugcinwa ububanzi bokuqala bekholomu.
Indlela yesi-5: faka isithombe
Ngenxa yamakhono wokufaka okhethekile, ungakopisha noma iyiphi idatha ekhonjiswe eshidini, kufaka phakathi itafula, njengesithombe.
- Kopisha into usebenzisa amathuluzi ajwayelekile okukopisha.
- Sikhetha indawo eshidini lapho umdwebo uzobekwa khona. Sibiza imenyu. Khetha into ekuyo "Umdwebo" noma "Umdwebo Oxhunyiwe". Esimweni sokuqala, isithombe esifakiwe ngeke sixhunywe nganoma iyiphi indlela netafula lomthombo. Esimweni sesibili, lapho amanani asetafuleni eshintshwa, isithombe siyovuselelwa ngokuzenzakalelayo.
Ewindini lokufakelwa elikhethekile, umsebenzi onjalo awunakwenziwa.
Indlela 6: amakhophi wokukopisha
Usebenzisa ukunamathisela okukhethekile, ungakopisha amanothi ngokushesha.
- Khetha amaseli aqukethe amanothi. Sibakopisha ngemenyu yokuqukethwe, sisebenzisa inkinobho kubambo noma ngokucindezela inhlanganisela yokhiye I-Ctrl + C.
- Khetha amaseli okufanele afakwe kuwo amanothi. Iya ewindini lokufaka elikhethekile.
- Ewindini elivulayo, shintsha inkinobho uyibeke "Amanothi". Chofoza inkinobho "Kulungile".
- Ngemuva kwalokho, amanothi azokopishelwa kumaseli akhethiwe, futhi yonke imininingwane izosala ingashintshiwe.
Indlela 7: transpethe itafula
Usebenzisa ukufaka okuyisipesheli, ungahambisa amatafula, umatikuletsheni, nezinye izinto ofuna ukushintshanisa nezinsika.
- Khetha itafula ofuna ukulijika bese ulikopisha usebenzisa enye yezindlela esivele sazi.
- Khetha ibanga eshidini lapho uhlela ukubeka khona uhlobo lwangaphakathi lwethebula. Senza isebenze imenyu yokuqukethwe bese sikhetha into ekuyo "Transpose".
Lokhu kusebenza nakho kungenziwa kusetshenziswa iwindi elijwayelekile. Kulokhu, kuzodingeka uhlole ibhokisi eliseduze "Transpose" bese uchofoza inkinobho "Kulungile".
- Kuzona zozimbili lezi zivivinyo, okuphumayo kuzoba yitafula elivunululwe, okungukuthi, itafula lapho amakholomu nemigqa kubuyiselwa khona.
Isifundo: Ungaphendulela kanjani itafula ku-Excel
Indlela 8: sebenzisa izibalo
Usebenzisa ithuluzi esilichaza ku-Excel, futhi ungenza imisebenzi ejwayelekile yokubala:
- Isengezo;
- Ukuphindaphindeka;
- Ukuzikhipha
- Isigaba.
Ake sibheke ukuthi leli thuluzi lisebenza kanjani kwisibonelo sokuphindaphindeka.
- Okokuqala, sifaka iseli elilodwa elingenalutho inombolo esihlela ngayo ukuphindaphinda ububanzi bemininingwane ngokufaka okukhethekile. Okulandelayo, siyakopisha. Lokhu kungenziwa ngokucindezela inhlanganisela yokhiye I-Ctrl + C, nokubiza imenyu yokuqukethwe noma ukusebenzisa amathuba amathuluzi wokukopisha kwitheyipu.
- Khetha ibanga eshidini okufanele siliphindaphinde. Chofoza ekukhetheni ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe evulayo, chofoza kabili ezintweni "Faka okhethekile ...".
- Iwindows liyasebenza. Eqenjini lepharamitha "Ukusebenza" beka inkinobho eshintshiwe Kakhulu. Ngokuchofoza inkinobho "Kulungile".
- Njengoba ubona, ngemuva kwalesi senzo onke amanani ebanga elikhethiwe andiswa ngenombolo ekopishiwe. Kithi, le nombolo 10.
Ngomqondo ofanayo, ukwahlukaniswa, ukwengeza nokukhipha kungenziwa. Kuphela kwalokhu, ewindini uzodinga ukuhlela kabusha switch, ngokulandelana, esikhundleni "Hlukanisa", Songa noma Susa. Ngaphandle kwalokho, zonke izenzo ziyafana ngamanothi angenhla.
Njengoba ukwazi ukubona, ukufakwa okukhethekile kuyithuluzi eliwusizo kakhulu lomsebenzisi. Ukuyisebenzisa, awukwazi ukukopisha yonke i-data block esitokisini noma ebangeni, kodwa ngokuyihlukanisa ibe izingqimba ezahlukahlukene (amanani, amafomula, ukufometha, njll.). Kulokhu, kungenzeka ukuhlanganisa lezi zingqimba nomunye. Ngaphezu kwalokho, usebenzisa ithuluzi elifanayo, izibalo zingenziwa. Vele, ukutholwa kwamakhono wokusebenza nalobu buchwepheshe kuzosiza kakhulu abasebenzisi abasendleleni yokufunda i-Excel ngokuphelele.
