Kukho iimeko xa sisebenza kwiNkqubo ye-Excel, emva kwenani lenombolo kwiseli, ibonakaliswa njengomhla. Ingakumbi le meko iyacaphukisa ukuba ufuna ukufaka idatha yolunye uhlobo, kwaye umsebenzisi akakwazi ukuba wenza njani. Masiyibone ukuba kutheni kugqwesa endaweni yamanani umhla ubonisiwe, kunye nokuchaza indlela yokulungisa le meko.
Ukusombulula ingxaki yokubonisa inani le mihla
Esona sizathu sokuba i-data yedatha inokuboniswa njengoko umhlaba kukuba unefomathi efanelekileyo. Ke, ukuseka umboniso wedatha, njengoko kufuneka, umsebenzisi kufuneka ayitshintshe. Ungayenza le nto ngexesha elinye ngeendlela ezininzi.Indlela yoku-1: Imenyu yeMxholo
Uninzi lwabasebenzisi lusebenzisa imenyu yokusombulula lo msebenzi.
- Cofa ekunene kuluhlu ekufuneka uyitshintshe ngayo ifomathi. Kwimenyu yemeko, eya kuvela emva kwezi zenzo, khetha ifomathi "yefomathi yeseli ...".
- Ifestile yokufomatha ivuliwe. Yiya kwi-tab "yenombolo" ukuba ibivuliwe ngequbuliso kwenye ithebhu. Kufuneka sitshintshe iparameter "ye-fathoy" ngexabiso elithi "umhla" kumsebenzisi oyifunayo. Uninzi luyintsingiselo ye "uqhelekileyo", "amanani", "imali", kodwa kusenokubakho abanye. Konke kuxhomekeke kwimeko ethile kunye nenjongo yedatha yokufaka. Emva kokutshintsha ipharamitha, cofa kwiqhosha "Kulungile".
Emva koko, idatha kwiiseli ezikhethiweyo ayizukuboniswa njengomhla, kwaye iya kuboniswa kwifomathi oyifunayo. Oko kukuthi, injongo iya kufezekiswa.
Indlela 2: Ukutshintsha ifomati kwiRibbon
Indlela yesibini ilula kakhulu, nangona isizathu esithile sincinci esincinci siphindwe kabini.
- Khetha iseli okanye uluhlu lwefomathi yomhla.
- Ukuba "kwikhaya" kwithebhu "yenombolo" yesixhobo, vula intsimi yefomati ekhethekileyo. Inika ezona ntlobo zithandwayo. Khetha eyona ifanelekileyo kwidatha ethile.
- Ukuba ukhetho olufunwayo alufumaneki phakathi koluhlu olubonisiweyo, emva koko nqakraza kwinto ethi "Ezinye iifomathi zenombolo ..." kuluhlu olunye.
- Ivula ngokuthe ngqo iwindows yeefomathi, njengakwindlela yangaphambili. Inoluhlu olubanzi lotshintsho lwedatha olunokwenzeka kwiseli. Ngokuhambelana, ezinye izinto ziya kuba njalo kanye xa ingxaki sisisombululo sokuqala. Khetha into oyifunayo kwaye ucofe iqhosha "Kulungile".
Emva koko, ifomati kwiiseli ezikhethiweyo iya kutshintshwa iye kule uyifunayo. Ngoku amanani kuwo akazukuboniswa njengomhla, kodwa uya kuthatha ifom echaziweyo.
Njengoko ubona, ingxaki yokubonakalisa umhla kwiiseli endaweni yenani ayisiyonto inzima. Kulula ukuyisombulula, nje ukucofa nje ngemouse. Ukuba umsebenzisi uyayazi i-algorithm yezenzo, le nkqubo iba yinto eyimfuneko. Ungayenza ngeendlela ezimbini, kodwa zozibini zincitshisiwe ukuba zitshintshe ifomathi yeseli ukusuka kumhla wokutsho komnye.