Ukuhambisa idatha kusuka endaweni eyodwa kuya kwenye ku-Excel cishe kungomunye wemisebenzi esiyenzayo ngomshini izikhathi eziyizinkulungwane ngosuku. Kungakhathaliseki ukuthi usebenza nespredishithi encane noma izizindalwazi ezinezigidi zamarekhodi, ukwazi ubuciko bokukopisha nokunamathisela kahle kuzokusindisa impilo futhi kukuvimbele ekuphindaphindeni umsebenzi ofanayo kabili ngenxa yephutha lokufometha.
Into yokuqala okufanele uyiqonde ukuthi uma sikopisha iseli, asigcini nje ngokuhambisa umbhalo noma inombolo esiyibonayo. I-Excel empeleni ipakisha konke okuqukethwe kusuka emthonjeni : kusukela kumafomula nokuqinisekiswa kwedatha kuya kumazwana kanye nokufometha okunemibandela. Uma singaqaphile, singagcina sinokudideka okubonakalayo kuspredishithi yethu.
Izindlela zokukopisha nokuhambisa ulwazi
Kuye ngokuthi uphuthuma kangakanani noma ukuthi yini elula kakhulu kuwe, kunezindlela eziningana zokwenza into efanayo. Indlela evamile kakhulu ukusebenzisa iribhoni kuthebhu ethi Ikhaya , lapho iqembu le-Clipboard likuvumela ukuthi ukopishe futhi unamathisele. Ngokuthakazelisayo, uma unamathisela ngokucindezela u-Enter, ibhodi lokunamathisela liyathululwa, kanti uma usebenzisa inkinobho yokunamathisela iribhoni, idatha igcinwa ukuze isetshenziswe kamuva.
Kulabo kithi abathanda igundane, imenyu yomongo yokuchofoza ngakwesokudla iyona eshesha kakhulu. Chofoza ngakwesokudla nje kububanzi obukhethiwe, khetha ukukopisha noma ukusika, bese uphinda inqubo yendawo oya kuyo. Ngaphandle kwalokho, kukhona indlela ebonakalayo ebizwa ngokuthi ukuhudula bese uphonsa : mane uchofoze bese uhudula unqenqema lokukhetha. Ukuze uhambise idatha, khipha inkinobho; ukuze uyikopishe, bamba inkinobho ye-Ctrl ngenkathi uhudula , futhi uzobona uphawu oluncane lokuhlanganisa eduze kwesikhombisi.
Uma ungumuntu ozondayo ukubeka phansi ikhibhodi, izinqamuleli zekhibhodi zingumngani wakho omkhulu. I -Ctrl + C yakudala ye-copy , i-Ctrl + X ye-cut, kanye ne-Ctrl + V ye-paste ziyinto evamile. Ngaphezu kwalokho, ukukhetha amabanga amakhulu ngaphandle kokuhlanya, ungasebenzisa okhiye be-Shift + Ctrl + Arrow , abazokhetha ngokuzenzakalelayo kuze kufike kuseli lokuqala elingenalutho uhlelo olutholayo.
Ukulawula ukugcwalisa kanye nokukhetha okuthuthukisiwe
Uma udinga ukukopisha ifomula noma idatha phansi kukholomu ende, isibambo sokugcwalisa siyithuluzi elingcono kakhulu. Ngokuchofoza kabili ekhoneni elingezansi kwesokudla leseli, i-Excel yandisa okuqukethwe kunoma yikuphi lapho ithola khona idatha kukholomu eseduze. Kodwa-ke, qaphela ngezinsuku noma izinombolo, njengoba uhlelo lungase luzame ukudala uchungechunge olunengqondo esikhundleni sekhophi eqondile—inkinga evamile uma ungazi ukuthi ungayivimbela kanjani i-Excel ekuguquleni izinombolo zibe izinsuku.
Uma uzithola udinga ukukopisha amaseli angekho eduze, akudingeki ukwenze ngalinye ngalinye. Ngokubamba ukhiye we-Ctrl, ungachofoza amaseli ahlukene asakazeke eshidini futhi, uma esekhethiwe wonke, wakopishe ngesikhathi esisodwa ukuze uwanamathisele ebhulokini elincane.
Ukwazi Iglue Ekhethekile
Yilapho umlingo wangempela uvela khona. Ukunamathisela okujwayelekile (Ctrl+V) kwenza umsebenzi, kodwa ngezinye izikhathi sifuna ingxenye yawo kuphela. Ukuze ufinyelele lezi zinketho ezithuthukisiwe, ungasebenzisa inkinobho yegundane yesokudla noma, okungcono nakakhulu, isinqamuleli se -Ctrl+Alt+V , esivula ibhokisi lengxoxo le-Paste Special.
- Amanani: Kuhle uma unefomula kodwa udinga kuphela umphumela wokugcina ngaphandle kokuthi kushintshe uma uhambisa iseli.
- Amafomula: Namathisela i-logic yokusebenza njengoba nje ibonakala kubha yefomula, ungayinaki idizayini.
- Amafomethi: Ikopisha umbala, imingcele, kanye nefonti kuphela, ishiya okuqukethwe kweseli yendawo okuyo kuyo kuphelele.
- Ukuqinisekiswa kanye namazwana: Bavumela ukudluliselwa kwe imithetho yokufaka idatha, usebenzisa i- ukuqinisekiswa kwedatha ku-Excel, noma amanothi achazayo ngaphandle kokushintsha inani leseli.
- Ububanzi bekholomu: Kuwusizo kakhulu ekuqinisekiseni ukuthi ithebula lendawo oya kuyo linesakhiwo esibonakalayo esifanayo nesokuqala.
- Konke ngaphandle kwemingcele: Igcina okuqukethwe kanye nefomethi, kodwa ivimbela ukuthi izinhlaka zingakopishwa.
Imisebenzi yezibalo namathuluzi engeziwe
I-Excel ikuvumela ukuthi wenze izinto ezimangalisayo lapho unamathisela, njengokwenza izibalo ngokushesha. Kumenyu ethi Namathisela Okukhethekile, ungakhetha umsebenzi wokubala (engeza, susa, phindaphinda, noma hlukanisa). Lokhu kusho ukuthi inani olikopishayo lizosetshenziswa ngokwezibalo kumanani akhona kumaseli okuya kuwo, okuzokusindisa ekudaleni amafomula esikhashana.
Enye igugu inketho ethi "Ignore blanks" , evimbela amaseli angenalutho emthonjeni ukuthi angabhali idatha osuvele unayo endaweni oya kuyo. Futhi, vele, asikwazi ukukhohlwa umsebenzi we-Transpose , oguqula idatha: okwakusemigqeni kuba amakholomu futhi okuphambene nalokho—kubalulekile ekuguquleni ku-Excel nasekuhleleni kabusha amathebula ngokushesha.
Ukuphathwa kwezinkomba kumafomula
Uma unamathisela ifomula, kubalulekile ukuhlola ukuthi amaseli abhekiselwe kuwo asalungile. Lokhu kuncike ekutheni usebenzisa izinkomba ezihlobene, eziphelele, noma ezixubile . Isibonelo, uma uhambisa ifomula kusuka ku-A1 uye ku-C3, inkomba ehlobene izoshintsha indawo yayo, kuyilapho inkomba ephelele (leyo enophawu lwe-$) izohlala igxilile endaweni efanayo.
Uma umphumela ungewona owawulindele, ungafaka ifomula bese ucindezela inkinobho ethi F4 ukuze ushintshe ngokushesha phakathi kwezinhlobo zokubhekisela uze uthole inhlanganisela efanele yespredishithi yakho.
Ukuba nawo wonke la mathuluzi aseduze, kusukela ezinqamuleli zekhibhodi kanye nesibambo sokugcwalisa kuya ku-Paste Special enamandla kanye nezinketho zokuguqulwa kwedatha, kukuvumela ukuthi uphathe ulwazi lwe-Excel ngokunemba kobungcweti, uqinisekise ukuthi ukufometha namafomula kuhlala kufana kungakhathaliseki ukuthi idatha ikuphi.
