Indlela yokudala itafula ku-Excel

Ukusebenza ngamatafula kuwumsebenzi oyinhloko wohlelo lwe-Excel, ngakho-ke amakhono okwakha amatafula anekhono kuwulwazi oludingekayo kakhulu ukusebenza kulo. Futhi yingakho ukutadisha uhlelo lwe-Microsoft Excel, okokuqala, kufanele kuqale ngokuthuthukiswa kwamakhono ayisisekelo ayisisekelo, ngaphandle kwalokho ukuthuthukiswa okwengeziwe kwamakhono ohlelo akunakwenzeka.

Kulesi sifundo, sizosebenzisa isibonelo ukukhombisa indlela yokudala ithebula ku-Excel, ugcwalise uhla lwamaseli ngolwazi, futhi uguqule uhla lwedatha lube ithebula eligcwele.

Ukugcwalisa Ibanga Lamaseli Ngolwazi

1. Okokuqala, ake sifake idatha edingekayo kumaseli wedokhumenti, lapho itafula lethu lizobe lihlanganisa khona.
2. Ngemva kwalokho, ungakwazi ukumaka imingcele idatha. Ukuze wenze lokhu, khetha uhla olufunayo lwamaseli ngekhesa, bese uya kuthebhu "Ekhaya". Lapha sidinga ukuthola ipharamitha ethi "Borders". Sichofoza eduze kwayo kumcibisholo oya phansi, ozovula uhlu olunezinketho zemingcele bese ukhetha into ethi "Yonke imingcele".
3. Ngakho, indawo ekhethiwe ngokubukeka yaqala ukufana netafula.

Kodwa lokhu, yiqiniso, akukabi itafula eligcwele. Ku-Excel, lokhu kusewuhla lwedatha, okusho ukuthi uhlelo luzocubungula idatha, ngokulandelana, hhayi njengethebula.

Ungaguqula kanjani ububanzi bedatha ibe ithebula eligcwele

Isinyathelo esilandelayo esizothathwa ukuguqula le ndawo yedatha ibe yithebula eligcwele, ukuze ingabonakali njengetafula kuphela, kodwa ibonwe uhlelo ngaleyo ndlela.

1. Ukuze wenze lokhu, sidinga ukukhetha ithebhu "Faka". Ngemuva kwalokho, khetha indawo oyifunayo ngekhesa, bese uchofoza into ethi "Ithebula".

   

   Qaphela: uma usayizi wewindi lapho i-Excel ivuliwe mncane, kungenzeka ukuthi kuthebhu ethi "Faka" esikhundleni sento ethi "Ithebula" kuzoba nesigaba esithi "Amathebula", okuvula lapho ngomcibisholo ophansi, ongayithola. ngqo into ethi “Ithebula” esiyidingayo.

   

2. Ngenxa yalokho, iwindi lizovuleka, lapho izixhumanisi zendawo yedatha ekhethwe yithi kusengaphambili izoboniswa. Uma konke kukhethwe kahle, akukho lutho oludinga ukushintshwa bese uchofoza inkinobho ethi "OK". Njengoba kungenzeka ukuthi ubonile, leli windi libuye libe nenketho ethi "Ithebula Elinezihloko". Ibhokisi lokuhlola kufanele lishiywe uma ithebula lakho linamaheda ngempela, ngaphandle kwalokho ibhokisi lokuhlola kufanele lingaqokwa.

   

3. Lokho, empeleni, yikho konke. Ithebula liphelele.

   

Ngakho ake sifinyeze ulwazi olungenhla. Akwanele nje ukubona ngeso lengqondo idatha ngesimo sethebula. Kudingeka ukufometha indawo yedatha ngendlela ethile ukuze uhlelo lwe-Excel luyibone njengetafula, hhayi nje njengohlu lwamaseli aqukethe idatha ethile. Le nqubo ayikhandleki nhlobo futhi yenziwa ngokushesha okukhulu.