Ogwiritsa ntchito ambiri a Excel ali ndi zovuta zambiri kuyesa kuyika dash pa pepala. Chowonadi ndi chakuti pulogalamuyo imamvetsa dash ngati chizindikiro chochepa, ndipo nthawi yomweyo imatembenuza mfundo zomwe zili mu selo kukhala njira. Choncho funso ili ndi lofunika kwambiri. Tiyeni tione momwe tingagwiritsire ntchito dash mu Excel.
Dash mu Excel
Kawirikawiri mukamadzaza malemba, mauthenga, mauthenga osiyanasiyana, muyenera kusonyeza kuti selo lolingana ndi chizindikiro china alibe mfundo. Pazinthu izi ndi mwambo kugwiritsa ntchito dash. Pulogalamu ya Excel, mwayi uwu ulipo, koma ndizovuta kwambiri kumasulira kwa wosakonzekera, popeza dash imasinthidwa mwamsanga. Kuti mupewe kusintha uku, muyenera kuchita zina.
Njira 1: Range Formatting
Njira yodalirika kwambiri yoyika dash mu selo ndikuyikira ma fomu. Zoona, chisankho ichi sichithandiza nthawi zonse.
- Sankhani selo yomwe mungaike dash. Dinani pa ilo ndi batani lamanja la mouse. M'ndandanda wamakono imene ikuwonekera, sankhani chinthucho "Cell Format". Mungathe m'malo momasulira njira yachinsinsi pa kambokosi Ctrl + 1.
- Fesitimu yokongoletsa ikuyamba. Pitani ku tabu "Nambala"ngati itatsegulidwa mu tabu ina. Muzitsulo zamkati "Maofomu Owerengeka" sankhani chinthu "Malembo". Timakanikiza batani "Chabwino".
Pambuyo pake, selo losankhidwa lidzapatsidwa katundu wa malemba. Malingaliro onse omwe alowe mmenemo adzawonekeratu osati monga zinthu zowerengera, koma ngati mawu omveka. Tsopano, muderali, mukhoza kulowa "" "khalidwe kuchokera pa kibokosilo ndipo idzawonekera ngati dash, ndipo pulogalamuyo sidzawonedwa ngati chizindikiro chosasintha.
Palinso njira ina yosinthira selo muwonekedwe. Kwa ichi, pokhala mu tab "Kunyumba", muyenera kutsegula mndandanda wa ma deta, womwe uli pa tepi mu bokosi lazamasamba "Nambala". Mndandanda wa mafomu omwe alipo alipo. Mndandanda uwu muyenera kungosankha chinthucho "Malembo".
Phunziro: Mmene mungasinthire selo mtundu mu Excel
Njira 2: Dinani Bulu lolowera
Koma njira iyi sagwira ntchito nthawi zonse. Kawirikawiri, ngakhale mutatha kuchita izi, ngati mutalowa "-" khalidwe, mmalo mwa chizindikiro chomwe mukusowa, mafotokozedwe ofanana a mndandanda zina awoneka. Kuonjezera apo, sizimakhala bwino nthawi zonse, makamaka ngati patebulo liri ndi dashes mwina ndi maselo odzaza ndi deta. Choyamba, mu nkhani iyi muyenera kupanga maonekedwe awo payekha, ndipo kachiwiri, maselo a tebulo awa adzakhala ndi mtundu wosiyana, womwe suli wolandiridwa nthawizonse. Koma zingatheke mosiyana.
- Sankhani selo yomwe mungaike dash. Timakanikiza batani "Gwirizanitsani Chigawo"yomwe ili pa katoni mu tab "Kunyumba" mu gulu la zida "Kugwirizana". Ndiponso dinani pa batani "Gwirizanitsani pakati", ziri pamalo omwewo. Izi ndi zofunikira kuti mzerewo ukhale pakati pa selo, momwe ziyenera kukhalira, osati kumanzere.
- Timayika mu selo kuchokera pa kambokosi chizindikiro "-". Pambuyo pa izi, sitimapanga kayendedwe kalikonse, koma nthawi yomweyo dinani pa batani Lowanikupita kumzere wotsatira. Ngati mmalo mwake wogwiritsa ntchito akugwiritsira ntchito ndondomeko, ndiye kuti ndondomekoyi idzawonekanso mu selo komwe dash iyenera kuima.
Njira iyi ndi yabwino kuti ikhale yophweka komanso imagwira ntchito ndi mtundu uliwonse. Koma, panthawi yomweyi, mukuigwiritsira ntchito, muyenera kusamala ndi kusinthira zomwe zili mu selo, chifukwa, chifukwa cha chinthu chimodzi cholakwika, ndondomeko ikhoza kuwonekera mmalo mwa dash.
Njira 3: Yesani khalidwe
Malembo ena a dash mu Excel ndi kuyika chikhalidwe.
- Sankhani selo kumene mukufuna kuika dash. Pitani ku tabu "Ikani". Pa tepiyi mu chida cha zipangizo "Zizindikiro" dinani pa batani "Chizindikiro".
- Kukhala mu tab "Zizindikiro", ikani munda pazenera "Khalani" parameter Zikwangwani za maziko. Pakatikatikati pawindo, fufuzani chizindikiro "─" ndikusankha. Kenaka dinani pa batani Sakanizani.
Pambuyo pake, dash imawonetsedwa mu selo losankhidwa.
Palinso njira ina yogwiritsira ntchito motere. Kukhala pawindo "Chizindikiro", pitani ku tabu "Zizindikiro Zapadera". M'ndandanda yomwe imatsegula, sankhani chinthucho "Dash yaitali". Timakanikiza batani Sakanizani. Chotsatira chidzakhala chofanana ndi muyeso lapitalo.
Njirayi ndi yabwino chifukwa simukuyenera kuopa kayendetsedwe kolakwika kamene kamapangidwa ndi mbewa. Chizindikirocho sichimasintha ku chikhomo. Kuphatikizanso, dash yowonekera mwa njirayi ikuwoneka bwino kusiyana ndi khalidwe lalifupi lopangidwa kuchokera ku kambokosi. Chosavuta chachikulu cha njirayi ndizofunikira kuchita zingapo nthawi yomweyo, zomwe zimaphatikizapo kutaya kwa kanthawi.
Njira 4: onjezani khalidwe linalake
Kuwonjezera pamenepo, pali njira yina yoyika dash. Komabe, chithunzichi sichivomerezeka kwa ogwiritsa ntchito onse, popeza akuganiza kuti pali khalidwe limodzi mu selo, kupatula chizindikiro "-".
- Sankhani selo limene mukufuna kupanga dash, ndipo ikani mkati mwabokosilo chikhalidwe "" ". Lili pa batani womwewo monga kalata "E" mu chigawo cha Cyrillic. Ndiye mwamsanga popanda danga kukhazikitsa khalidwe "-".
- Timakanikiza batani Lowani kapena sankhani ndi chithunzithunzi ndi mbewa iliyonse selo. Kugwiritsa ntchito njirayi sikofunikira kwenikweni. Monga mukuonera, zitatha izi, chizindikiro cha dash chinayikidwa pa pepala, ndipo chizindikiro chowonjezera "'" chikuwonekera pokhapokha mu selo lachindunji pamene selo lasankhidwa.
Pali njira zingapo zowonjezeramo dera mu selo, kusankha komwe mtumiki angapange mogwirizana ndi cholinga chogwiritsa ntchito chilemba china. Anthu ambiri amayesa kusintha mawonekedwe a maselo pamene ayamba kuyika khalidwe lofunikila. Mwatsoka, izi sizigwira ntchito nthawi zonse. Mwamwayi, pali zina zomwe mungachite kuti muchite ntchitoyi: kusamukira ku mzere wina pogwiritsa ntchito batani Lowani, kugwiritsiridwa ntchito kwa zilembo kupyolera mu batani pa tepi, kugwiritsa ntchito chidziwitso chowonjezera "'". Njira iliyonseyi ili ndi ubwino ndi kuipa kwake, zomwe zafotokozedwa pamwambapa. Palibe njira iliyonse yomwe ingakhale yabwino kwambiri pakuika dashito ku Excel nthawi zonse.
