Kopisha, hambisa futhi ushintshe umbala wephepha lokusebenza ku-Excel

I-Excel ikuvumela ukuthi ukopishe amashidi enziwe kakade, uwahambise ngaphakathi nangaphandle kwebhuku lokusebenza lamanje, futhi ushintshe umbala wamathebhu ukuze kube lula ukuzulazula phakathi kwawo. Kulesi sifundo, sizohlaziya zonke lezi zici ngemininingwane eminingi ngangokunokwenzeka futhi sifunde ukukopisha, ukuhambisa nokushintsha umbala wamashidi ku-Excel.

Kopisha amashidi ku-Excel

Uma udinga ukukopisha okuqukethwe kusuka kwelinye ishidi ukuya kwelinye, i-Excel ikuvumela ukuthi udale amakhophi amashidi akhona.

1. Chofoza kwesokudla kuthebhu yeshidi ofuna ukulikopisha, bese ukhetha kumenyu yokuqukethwe Hambisa noma kopisha.
2. Ibhokisi lengxoxo lizovuleka Hambisa noma kopisha. Lapha ungacacisa ngaphambi kokuthi yiliphi ishidi ofuna ukulifaka ishidi elikopishiwe. Esimweni sethu, sizocacisa Hambisa ekupheleniukubeka ishidi kwesokudla seshidi elikhona.
3. Khetha ibhokisi lokuhlola Dala ikhophibese uchofoza OK.
4. Ishidi lizokopishwa. Izoba negama elifanayo ncamashi neshidi lokuqala, kanye nenombolo yenguqulo. Thina, sikopishe ishidi elinegama January, ngakho ishidi elisha lizobizwa Januwari (2). Konke okuqukethwe eshidini January izokopishwa futhi eshidini Januwari (2).

Ungakwazi ukukopisha ishidi kunoma iyiphi incwadi yokusebenzela ye-Excel, inqobo nje uma livuliwe okwamanje. Ungakhetha ibhuku elidingekayo ohlwini lokudonsela phansi ebhokisini lengxoxo. Hambisa noma kopisha.

Hambisa ishidi ku-Excel

Kwesinye isikhathi kuba nesidingo sokuhambisa ishidi ku-Excel ukuze ushintshe ukwakheka kwencwadi yokusebenzela.

1. Chofoza ithebhu yeshidi ofuna ukulihambisa. Ikhesa izophenduka isithonjana seshidi elincane.
2. Bamba phansi igundane bese uhudula isithonjana seshidi kuze kuvele umcibisholo omncane omnyama endaweni oyifunayo.
3. Dedela inkinobho yegundane. Ishidi lizosuswa.

Shintsha umbala wethebhu yeshidi ku-Excel

Ungashintsha umbala wamathebhu ephepha lokusebenzela ukuze uwahlele futhi wenze kube lula ukuzulazula encwadini yokusebenzela ye-Excel.

1. Chofoza kwesokudla kuthebhu yekhasi lomsebenzi olifunayo bese ukhetha into kumenyu yokuqukethwe Umbala welebula. Isikhethi Sombala sizovuleka.
2. Khetha umbala oyifunayo. Lapho uhambisa phezulu kwezinketho ezihlukahlukene, ukubuka kuqala kuzovela. Esibonelweni sethu, sizokhetha okubomvu.
3. Umbala welebula uzoshintsha.

Uma ishidi likhethiwe, umbala wethebhu cishe ungabonakali. Zama ukukhetha noma yiliphi elinye ishidi encwadini yokusebenzela ye-Excel futhi uzobona ngokushesha ukuthi umbala ushintsha kanjani.