- Umehluko phakathi kokukopisha okujwayelekile, ukunyakaza kwedatha, kanye nokusetshenziswa kwama-paste akhethekile ezicini ezithile.
- Ukwazi izinqamuleli zekhibhodi, amamenyu womongo, kanye namasu okudonsa nokulahla ukuze kuthuthukiswe ukuhamba komsebenzi.
- Ukuphathwa kwefomula okuthuthukisiwe kusetshenziswa izinkomba ezihlobene, eziphelele, nezixubile ukuze kugwenywe amaphutha lapho kukopishwa idatha.
Cishe uke wabhekana nalokhu: kungakhathaliseki ukuthi usebenza ngespredishithi esilula noma ucubungula izigidi zamaphuzu edatha, kunemisebenzi oyiphinda ngokuphindaphindiwe uze ukhathale ngokuphelele. Enye yalezi ngokungangabazeki ukuhambisa ulwazi kusuka endaweni eyodwa kuya kwenye. Uma ufunda ukuhambisa idatha kahle , uzonga isikhathi esiningi futhi ugweme ukwenza umsebenzi ofanayo kabili ngenxa yokungaqapheli.
Ngaphambi kokuthi uqale ukukopisha amaseli, kubalulekile ukuqonda ukuthi i-Excel ayikopishi nje umbhalo noma izinombolo ozibonayo. Empeleni ikopisha konke okuqukethwe : kusukela ekufomeni okunemibandela kanye nokuqinisekiswa kwedatha kuya kumazwana afihliwe. Ngokuyisisekelo, inqubo ihlukaniswe ngezinyathelo ezimbili: ukulondoloza ulwazi ebhodini lokunamathisela bese ulukopisha endaweni oyifunayo.
Izindlela zokukopisha nokunamathisela ulwazi
Uma ukhetha ukusebenzisa igundane, iribhoni lingumngani wakho omkhulu. Vele uye kuthebhu ethi Ikhaya, thola isigaba se-Clipboard, bese uchofoza okuthi Kopisha. Bese ukhetha iseli lapho uya khona bese uchofoza okuthi Namathisela. Icebiso elisheshayo ukuthi ngemva kokukopisha, ungacindezela u-Enter ukuze unamathisele idatha ngokushesha, yize lokhu kuzosula ibhodi lokunamathisela, ngokungafani nokusebenzisa inkinobho yeribhoni.
Kulabo abafuna isivinini esikhulu, imenyu yokuqukethwe iyindlela efanelekile. Chofoza ngakwesokudla kububanzi obukhethiwe bese ukhetha okuthi Kopisha noma Sika. Bese, hamba uye endaweni oya kuyo, chofoza kwesokudla futhi, bese ukhetha inketho ethi Namathisela. Njengoba kunjalo ngendlela yangaphambilini, ukusebenzisa inkinobho ethi Enter kuyasheshisa inqubo kodwa kusula ikhophi yesikhashana.
Uma ijubane liyinto eza kuqala kuwe futhi uzonda ukubeka phansi ikhibhodi yakho, izinqamuleli ziyindlela okufanele uhambe ngayo. Indinganiso evamile esebenza cishe kuzo zonke izinhlelo zokusebenza i -Ctrl + C ukukopisha , i-Ctrl + X ukusika (lokhu kususa okwangempela), kanye ne-Ctrl + V ukunamathisela okuqukethwe endaweni ekhethiwe.
Kukhona futhi indlela ebonakalayo nesheshayo: ukudonsa nokulahla. Uma ukhetha ububanzi bese uhudula kusukela emaphethelweni ngenkinobho yegundane lesobunxele, uzobe uhambisa idatha. Kodwa uma ubamba ukhiye we-Ctrl ngenkathi uhudula , uzobona uphawu oluncane lokuhlanganisa (+) eduze kwesikhombisi, okubonisa ukuthi ukopisha ulwazi esikhundleni sokuluhambisa.
Ubuciko Bokunamathela Okukhethekile
Ngezinye izikhathi asifuni ukukopisha konke, kodwa ingxenye kuphela. Kulokhu, i-Excel inikeza i-Paste Special. Uma uya kuthebhu ethi Ikhaya bese uchofoza umcibisholo othi Namathisela, uzobona ukuthi ungakhetha ukunamathisela amafomula, ukufometha, noma amanani kuphela . Isibonelo, uma uneseli elinomphumela obalwe kodwa ufuna inombolo yokugcina kuphela, khetha i-Paste Values.
Phakathi kwezinketho ezithuthukisiwe, ungathola imisebenzi enamandla njenge-Transpose, ekuvumela ukuthi ujikeleze ukuqondiswa kwedatha , uguqule imigqa ibe amakholomu futhi okuphambene nalokho. Unganamathisela futhi ukuqinisekiswa kwedatha noma amazwana kuphela, ugweme ukushintsha ukwakheka okubonakalayo kweseli yendawo oya kuyo.
Uma uvula ibhokisi lengxoxo elithi Paste Special, uzothola ukuthi ungenza imisebenzi yezibalo eqondile . Lokhu kusho ukuthi ungangeza, ususe, uphindaphinde, noma uhlukanise amanani endaweni yokukopisha ngalawo asevele ekhona endaweni oya kuyo. Ngaphezu kwalokho, inketho ethi "yeqa izikhala ezingenalutho" ibaluleke kakhulu, njengoba ivimbela amaseli angenalutho emthonjeni ukuthi angabhali idatha ekhona endaweni oya kuyo.
Ukuphathwa kwefomula kanye nomlawuli wokugcwalisa
Uma sikopisha amafomula, izinto ziyathakazelisa. Ngokuzenzakalelayo, i-Excel isebenzisa izinkomba ezihlobene, okusho ukuthi uma ukopisha ifomula phansi, amaseli abhekiselwe kuwo nawo aya phansi. Uma udinga iseli ukuthi lihlale lizinzile, kufanele usebenzise izinkomba eziphelele ngokucindezela u-F4 bese wengeza uphawu lwe-$ (isibonelo: $A$1). Kukhona nezinkomba ezixubile, lapho ulungisa khona umugqa noma ikholomu kuphela.
Isibambo sokugcwalisa, leso sikwele esincane ekhoneni elingezansi kwesokudla seli, sihle kakhulu ekukopisheni okuqukethwe ngokushesha ngokuqondile . Uma usichofoza kabili, i-Excel izolula ifomula noma idatha phansi ize ithole iseli elingenalutho. Nokho, qaphela ngoba uma ukopisha izinsuku noma izinombolo, uhlelo lungase luzame ukudala uchungechunge olunengqondo esikhundleni sekhophi eqondile.
Uma udinga ukuhambisa idatha kwamanye amathuluzi, njenge-WP Sheet Editor, inqubo ilula: yikopishe ku-Excel bese usebenzisa i-Ctrl + V yakudala kolunye uhlelo lokusebenza. Khumbula ukuthi uma usika iseli, liyanyamalala endaweni yalo yokuqala, kanti uma ukopisha, ububanzi bomthombo buhlala bunjalo.
Ukwazi kahle wonke la mathuluzi, kusukela ezinqamuleli ezisheshayo kanye nokuhudula nokulahla okuhlakaniphile kuya ekuqondeni kwe-Paste Special kanye nokukhiya ifomula ngophawu lwedola ($), kukuvumela ukuthi uphathe noma yiliphi inani ledatha ngokulawula okuphelele. Kungakhathaliseki ukuthi ufuna ukushintsha amathebula, ukwenza imisebenzi yezibalo esheshayo ngokunamathisela, noma umane uvimbele ukufometha ukuthi kungaphuki lapho uhudula amaseli, i-Excel inikeza ukuguquguquka okukhulu komsebenzi obushelelezi nochwepheshe.