Dash mu Excel. Njira za 2 zoyika dash mu Excel

Pulogalamu ya Excel ili ndi ntchito zambiri zomwe muyenera kudziwa kuti mugwire ntchito zapamwamba ndi matebulo. Chifukwa chosowa chidziwitso, ogwiritsa ntchito ena sangathe kuyika chinthu chosavuta ngati dash. Chowonadi ndi chakuti kuyika chizindikiro kumakhala ndi zovuta zina. Kotero, mwachitsanzo, ikhoza kukhala yayitali komanso yayifupi. Tsoka ilo, palibe zizindikiro zapadera pa kiyibodi kuti zikuthandizeni kuyenda ndikuyika mawonekedwe olondola. Chifukwa chake, tiyeni tiwone momwe tingakhazikitsire dash moyenera pogwiritsa ntchito njira zingapo.

Kuyika dash mu cell

Kugwira ntchito kwa pulogalamu ya Excel kumapereka kuyika kwa mitundu iwiri ya dashes - yaifupi ndi yayitali. M'malo ena, mutha kupeza kutchulidwa kwa mzere ngati avareji. Titha kunena kuti mawuwa ndi olondola, chifukwa ngati simukudziwa malamulo oyika, mutha kuyika chizindikiro chaching'ono - "hyphen" kapena "minus". Pazonse, pali njira ziwiri zomwe mungakhazikitsire chizindikiro "-" patebulo. Mlandu woyamba umakhudza kukhazikitsa ndikulemba kuphatikiza kiyi. Yachiwiri imafuna kulowa pawindo la zilembo zapadera.

Kuthetsa vuto ndikuyika dash # 1: gwiritsani ntchito njira yachidule ya kiyibodi

Ogwiritsa ntchito ena olemba malemba amanena kuti kukhazikitsa dash mu spreadsheet kungathe kuchitidwa mofanana ndi Mawu, koma, mwatsoka, izi sizowona. Tiyeni tiwone momwe tingachitire izi mu Mawu:

1. Lembani "2014" pa kiyibodi yanu.
2. Gwirani makiyi a Alt + X.

Mukachita izi zosavuta, Mawu amangoyika mzere wa em.

Madivelopa a Excel adasamaliranso ogwiritsa ntchito ndikupanga njira yawoyawo yolowera patebulo:

1. Yambitsani selo lomwe likufunika kusinthanso.
2. Gwirani pansi kiyi iliyonse ya "Alt" ndipo, osamasula, lembani mtengo "0151" mu chipika cha manambala (chomwe chili kumanzere kwa kiyibodi).

Chenjerani! Ngati manambala azichitika pamwamba pa kiyibodi, ndiye kuti pulogalamuyo ikusamutsani ku menyu ya "Fayilo".

3. Pambuyo potulutsa kiyi ya Alt, tiwona mzere wowonekera mu cell pazenera.

Kuti muyimbe munthu wachidule, m'malo mophatikizana ndi digito u0151bu0150b"XNUMX", imbani "XNUMX".

Njirayi imagwira ntchito osati mu Excel, komanso mu Word editor. Malinga ndi akatswiri opanga mapulogalamu, njira yokhazikitsira dash pogwiritsa ntchito makiyi ophatikizira angagwiritsidwe ntchito mu html ndi okonza masamba ena.

Chidziwitso kuchokera kwa katswiri! Chizindikiro cholowetsamo chimasinthidwa kukhala chilinganizo, ndiko kuti, pamene selo lina patebulo lomwe lili ndi chizindikiro chotchulidwa litsegulidwa, adiresi ya selo yogwira ntchito imawonetsedwa. Pankhani ya ma en dashes ndi ma em dashes, izi sizichitika. Kuti muchotse kutsegulira kwa fomula, muyenera kukanikiza batani la "Enter".

Njira yothetsera dash #2: Kutsegula zenera la mawonekedwe

Palinso njira ina yomwe dash imalowetsedwa kudzera pawindo lothandizira ndi zilembo zapadera.

1. Sankhani selo lomwe lili patebulo lomwe likufunika kusinthidwa ndikukanikiza LMB.
2. Pitani ku tabu ya "Insert" yomwe ili pamwamba pa pulogalamuyo pazida.

3. Ngati ntchitoyo ili pamalo ochepa, dinani batani lakumanja kumtunda kwa chinsalu kuti mutsegule midadada yonse ndi zida.
4. Kumanja, pezani chida chomaliza "Zizindikiro", chomwe chili pagawo la "Text", ndikudina pamenepo.
5. Zenera latsopano lidzatsegulidwa pomwe muyenera dinani batani la "Symbol".

6. Kukanikiza batani ili kumatsegula zenera lokhala ndi zilembo. M'menemo muyenera alemba pa "Special zilembo".

7. Kenako, mutha kuwona mndandanda wautali wa zilembo zapadera. Monga mukuwonera pachithunzichi, malo oyamba momwemo ali ndi "Elong dash".

8. Dinani pamzere wokhala ndi dzina lachizindikiro ndikudina batani "Ikani". Mudzapeza pansi pa zenera.
9. Zenera ilibe ntchito yotseka yokha, choncho, mutatha kuyika khalidwe lofunika mu selo, tsekani zenera podina batani lofiira ndi mtanda woyera pakona yakumanja.
10. Mukatseka zenera, mutha kuwona kuti dash ya em idayikidwa ku cell yomwe tikufuna ndipo tebulo likukonzekera ntchito ina.

Ngati mukufuna kukhazikitsa en dash, tsatirani njira zomwe zili pamwambapa, koma sankhani "En dash" kumapeto. Musaiwale kuyambitsa chizindikiro kumapeto ndikudina batani la "Ikani" ndikutseka bokosi la zokambirana.

Chidziwitso kuchokera kwa katswiri! Zolemba zomwe zalowetsedwa mu njira yachiwiri zimagwirizana kwathunthu ndi zomwe zidalowetsedwa chifukwa cholemba makiyi ophatikizika. Kusiyana kungaoneke mu njira unsembe. Chifukwa chake, zilembozi sizingagwiritsidwe ntchito kupanga mafomula.

Kutsiliza

Mukawerenga nkhaniyi, zikuwonekeratu kuti pali njira ziwiri zolowera zoyika ma em ndi en dashes. Choyamba, muyenera kugwiritsa ntchito njira yachidule ya kiyibodi, ndipo chachiwiri, tsegulani zenera ndi zilembo zapadera, pomwe zilembo zofunika zimasankhidwa ndikuyikidwa mu cell yogwira. Njira zonsezi zimapanga zizindikiro zofanana - zokhala ndi encoding ndi magwiridwe antchito. Choncho, njira yomaliza yolowera dash patebulo imasankhidwa malinga ndi zomwe wogwiritsa ntchito amakonda. Ogwiritsa ntchito omwe amakonda kugwiritsa ntchito zilembozi amakonda kugwiritsa ntchito njira yachidule ya kiyibodi. Kwa iwo omwe samakumana nthawi zonse ndi kuyambika kwa dash patebulo, mutha kudziletsa ku njira yachiwiri.