Ikopisha ithebula ku-Excel

Ukukopisha ithebula kungenye yamakhono abaluleke kakhulu okufanele wonke umsebenzisi we-Excel awazi kahle ukuze asebenze ngempumelelo. Ake sibone ukuthi le nqubo ingenziwa kanjani ohlelweni ngezindlela ezahlukene, kuye ngomsebenzi.

Kopisha bese unamathisela ithebula

Okokuqala, lapho ukopisha ithebula, kufanele unqume ukuthi yiluphi ulwazi ofuna ukuluphinda (amanani, amafomula, njll.). Idatha ekopishiwe inganamathiselwa endaweni entsha eshidini elifanayo, eshidini elisha, noma kwelinye ifayela.

Indlela 1: ikhophi elula

Le ndlela isetshenziswa kakhulu uma kuphinda amathebula. Ngenxa yalokho, uzothola ikhophi eqondile yamaseli anefomethi yoqobo namafomula (uma ekhona) agciniwe. I-algorithm yezenzo imi kanje:

1. Kunoma iyiphi indlela elula (isibonelo, usebenzisa inkinobho yegundane engakwesokunxele ecindezelwe), khetha uhla lwamaseli esihlela ukulibeka ebhodini lokunamathisela, ngamanye amazwi, kopisha.
2. Okulandelayo, chofoza kwesokudla noma yikuphi ngaphakathi kokukhethiwe futhi ohlwini oluvulayo, yima emyalweni "Kopisha".Ukuze ukopishe, ungamane ucindezele inhlanganisela Ctrl + C kukhibhodi (ngemuva kokukhethwa kukho). Umyalo odingekayo ungatholakala nakuribhoni yohlelo (ithebhu "Ikhaya", Iqembu "Ibhodi lokunamathisela"). Udinga ukuchofoza isithonjana, hhayi kumcibisholo oya phansi eduze kwaso.
3. Siya esitokisini eshidini esifunayo (kulamanje noma kwenye incwadi), siqala lapho sihlela ukunamathisela idatha ekopishiwe. Leli seli lizoba ingxenye ephezulu kwesokunxele yethebula elifakiwe. Sichofoza kwesokudla kuso futhi ohlwini lokudonsela phansi sidinga umyalo "Faka" (isithonjana sokuqala eqenjini "Namathisela Izinketho"). Esimweni sethu, sikhethe ishidi lamanje.Njengokukopisha idatha ukuze unamathisele, ungasebenzisa okhiye abashisayo - Ctrl + V. Noma sichofoza umyalo esiwufunayo kuribhoni yohlelo (kuthebhu efanayo "Ikhaya", Iqembu "Ibhodi lokunamathisela"). Udinga ukuchofoza isithonjana, njengoba kukhonjisiwe kusithombe-skrini esingezansi, hhayi ekubhalweni "Faka".
4. Kungakhathalekile ukuthi iyiphi indlela ekhethiwe yokukopisha nokunamathisela idatha, ikhophi yethebula izovela endaweni ekhethiwe. Ukufometha kweseli namafomula aqukethwe kuwo kuzogcinwa.

Qaphela: esimweni sethu, bekungadingeki silungise imingcele yeseli yethebula elikopishiwe, ngoba lifakwe phakathi kwamakholomu afanayo nelokuqala. Kwezinye izimo, ngemva kokuphinda idatha, kuzodingeka uchithe isikhathi esincane kokuthi .

Indlela yesi-2: Kopisha Amanani Kuphela

Kulokhu, sizokopisha kuphela amanani amaseli akhethiwe ngokwawo, ngaphandle kokudlulisela amafomula endaweni entsha (imiphumela ebonakalayo yawo izokopishwa) noma ifomethwe. Nakhu esikwenzayo:

1. Usebenzisa noma yiziphi izindlela ezichazwe ngenhla, khetha futhi ukopishe izakhi zangempela.
2. Chofoza kwesokudla kuseli esihlela ukunamathisela kulo amanani akopishiwe, futhi kumenyu yokuqukethwe evulayo, chofoza inketho “Amanani” (isithonjana sisesimweni sefolda enezinombolo 123).Ezinye izinketho zokunamathisela Okukhethekile nazo zethulwa lapha: amafomula kuphela, amanani namafomethi wezinombolo, ukufometha, njll.
3. Ngenxa yalokho, sizothola ithebula elifanayo ncamashi, kodwa ngaphandle kokulondoloza ifomethi yamaseli okuqala, ububanzi bekholomu namafomula (imiphumela esiyibona esikrinini izofakwa esikhundleni salokho).

Qaphela: Namathisela izinketho ezikhethekile nazo zethulwa kuribhoni yohlelo kuthebhu eyinhloko. Ungawavula ngokuchofoza inkinobho enombhalo "Faka" nomcibisholo waphansi.

Ukukopisha Amanani Ukugcina Ukufometha Kwangempela

Kumenyu yokuqukethwe yeseli okuhlelwa ngayo ukufakwa, nweba izinketho "Ukunamathisela Okukhethekile" ngokuchofoza umcibisholo oseduze kwalo myalo bese ukhetha into "Amanani Nokufometha Komthombo".

Ngenxa yalokho, sizothola ithebula elingeke lihluke ngokubonakalayo kwelasekuqaleni, nokho, esikhundleni samafomula, lizoqukatha amanani athile kuphela.

Uma sichofoza kumenyu yokuqukethwe kweseli hhayi kumcibisholo oseduze kwayo, kodwa kumyalo ngokwawo "Ukunamathisela Okukhethekile", iwindi lizovuleka elinikezela ngokukhethwa kwezinketho ezahlukene. Khetha inketho oyifunayo bese uchofoza OK.

Indlela yesi-3: kopisha ithebula ngenkathi ugcina ububanzi bamakholomu

Njengoba sixoxile ekuqaleni, uma ukopisha futhi unamathisele itafula endaweni entsha (hhayi ngaphakathi kwamakholomu afanayo) ngendlela evamile, khona-ke cishe kuzodingeka ulungise ububanzi bamakholomu, ucabangela okuqukethwe amaseli. Kodwa amandla e-Excel akuvumela ukuthi wenze inqubo ngokushesha ngenkathi ugcina ubukhulu bangempela. Nansi indlela okwenziwa ngayo:

1. Ukuze uqale, khetha bese ukopisha ithebula (sisebenzisa noma iyiphi indlela elula).
2. Ngemva kokukhetha iseli ukufaka idatha, chofoza kwesokudla kuyo nasezintweni ongakhetha kuzo "Ukunamathisela Okukhethekile" khetha into "Gcina ububanzi bekholomu yangempela".
3. Kithina, sithole lo mphumela (eshidini elisha).

Alternative

1. Kumenyu yokuqukethwe kweseli, chofoza umyalo ngokwawo "Ukunamathisela Okukhethekile" futhi efasiteleni elivulekayo, khetha inketho "ububanzi bekholomu".
2. Usayizi wamakholomu endaweni ekhethiwe uzolungiswa ukuze ulingane nethebula lokuqala.
3. Manje sesingakopisha-sinamathisele ithebula kule ndawo ngendlela evamile.

Indlela yesi-4: Faka itafula njengesithombe

Uma ufuna ukunamathisela ithebula elikopishiwe njengesithombe esijwayelekile, ungenza lokhu ngale ndlela elandelayo:

1. Ngemuva kokuthi ithebula likopishiwe, kumenyu yokuqukethwe kweseli ekhethelwe ukunamathisela, simisa entweni "Isithombe" ngezinhlobonhlobo "Ukunamathisela Okukhethekile".
2. Ngakho-ke, sizothola ithebula eliphindwe kabili ngesimo sesithombe, esinganyakaziswa, sijikelezwe, futhi sishintshwe usayizi. Kodwa ukuhlela idatha nokushintsha ukubukeka kwayo ngeke kusasebenza.

Indlela yesi-5: kopisha lonke ishidi

Kwezinye izimo, kungase kudingeke ukukopisha hhayi isiqeshana esisodwa, kodwa lonke ishidi. Kwalokhu:

1. Khetha konke okuqukethwe eshidini ngokuchofoza isithonjana ezimpambanweni zamabha wokuxhumanisa avundlile naqondile.Noma ungasebenzisa ama-hotkeys I-Ctrl+A: cindezela kanye uma ikhesa ikuseli elingenalutho noma kabili uma into egcwalisiwe ikhethiwe (ngaphandle kwamaseli owodwa, kulokhu, ukuchofoza okukodwa nakho kwanele).
2. Wonke amaseli eshidini kufanele agqanyiswe. Futhi manje zingakopishwa nganoma iyiphi indlela elula.
3. Yiya kwelinye ishidi/idokhumenti (dala elisha noma shintshela kwelikhona kakade). Sichofoza isithonjana ezimpambanweni zezixhumanisi, bese sinamathisela idatha, isibonelo, sisebenzisa isinqamuleli sekhibhodi. Ctrl + V.
4. Ngenxa yalokho, sithola ikhophi yeshidi elinosayizi beseli nokufometha kwangempela kulondoloziwe.

Enye indlela

Ungakopisha ishidi ngenye indlela:

1. Chofoza kwesokudla egameni leshidi ezansi kwewindi lohlelo. Kumenyu yokuqukethwe evulayo, khetha into "Hambisa noma kopisha".
2. Kuzovela iwindi elincane lapho simisa khona isenzo okufanele senziwe eshidini elikhethiwe, bese uchofoza OK:
   • ukuhambisa/ukukopisha encwadini yamanje nokukhetha indawo okwalandela;
   • ukuhambisa/ukukopisha encwadini entsha;
   • ukuze ukukopisha kwenziwe, ungakhohlwa ukumaka ibhokisi eliseduze nepharamitha ehambisanayo.
3. Thina, sikhethe ishidi elisha futhi sathola lo mphumela. Sicela uqaphele ukuthi kanye nokuqukethwe kweshidi, igama lalo nalo likopishiwe (uma kunesidingo, lingashintshwa - futhi ngokusebenzisa imenyu yokuqukethwe kweshidi).

Isiphetho

Ngakho-ke, i-Excel inikeza abasebenzisi izinhlobonhlobo zezinketho zokukopisha ithebula, kuya ngokuthi yini ngempela (futhi kanjani ngempela) abafuna ukuyiphinda idatha. Ukuchitha isikhathi esincane ufunda izindlela ezahlukene zokufeza lo msebenzi kungakongela isikhathi esiningi ohlelweni.