Mukamagwiritsa ntchito chikalata mu Excel, nthawi zina pamafunika kuyika dash yayitali kapena yayifupi. Ikhoza kudzinenedwa, zonse monga chizindikiro cholembera m'malemba, ndi ngati dash. Koma vuto ndiloti palibe chizindikiro chomwecho pa kibokosilo. Mukamalemba pa chikhalidwe pamakina omwe ali ngati dash, timapeza dashifupi kapena "sungani". Tiyeni tione momwe mungagwiritsire ntchito chikwangwani pamwambapa mu Microsoft Excel.
Onaninso:
Momwe mungapangire kadontho kakale mu Mawu
Momwe mungayikidwire mzere ku Esccel
Njira zothetsera dash
Mu Excel, pali zinthu ziwiri zomwe mungasankhe pamzerewu: motalika komanso wamfupi. Wotsirizirayo amatchedwa "owerengeka" m'mabuku ena, omwe ndi achilengedwe tikawayerekezera ndi chizindikiro "-" (kuganiza).
Pamene akuyesera kuyika dash yaitali mwa kukanikiza "-" pa keyboard yomwe timapeza "-" - chizindikiro chofala "sungani". Kodi tiyenera kuchita chiyani?
Ndipotu, palibe njira zambiri zowonjezeramo kadothi mu Excel. Zimangokhala ndi njira ziwiri zokha: seti yazitsulo zofikira ndi kugwiritsa ntchito zenera la anthu apadera.
Njira 1: Gwiritsani ntchito mgwirizano wachinsinsi
Ogwiritsa ntchito omwe amakhulupirira kuti mu Excel, monga mu Mawu, mukhoza kuyika dashati polemba pabokosi "2014"ndiyeno ndikukakamiza kuphatikiza kwachinsinsi Alt + x, zokhumudwitsa: muzithunzithunzi zapadera, njirayi sagwira ntchito. Koma njira ina imagwira ntchito. Gwiritsani chinsinsi Alt ndipo, popanda kumasula, lembani mu nambala ya chibokosilo "0151" popanda ndemanga. Titangomasula makiyiwo Alt, dash yaitali imapezeka mu selo.
Ngati, mutagwira batani Alt, yesani muyeso ya selo "0150"ndiye ife timapeza dashifupi.
Njira iyi ndiyonse ndipo imagwira ntchito ku Excel, komanso m'mawu, komanso m'malemba ena, tebulo ndi html okonza. Mfundo yofunikira ndi yakuti malemba omwe alowetsedwa mwa njirayi samasandulika fomu, ngati inu, mutachotsa chithunzithunzi mu selo la malo awo, yesani kupita ku chinthu china cha pepala, monga zimachitika ndi chizindikiro "sungani". Izi ndizo, zilembo izi ndizolemba, osati zolemba. Gwiritsani ntchito mafomu monga chizindikiro "sungani" iwo sangagwire ntchito.
Njira 2: Fayilo Yopatsa Makhalidwe Abwino
Mukhozanso kuthetsa vutoli, pogwiritsa ntchito zenera la anthu apadera.
- Sankhani selo limene muyenera kulemba dash, ndipo pita ku tabu "Ikani".
- Kenaka dinani pa batani. "Chizindikiro"yomwe ili mu chida chogwiritsa ntchito "Zizindikiro" pa tepi. Ili ndilo loyandikana kwambiri pa kavalo mu tabu. "Ikani".
- Pambuyo pake, kutsegulira zenera kuyitanidwa "Chizindikiro". Pitani ku tabu yake "Zizindikiro Zapadera".
- Makonda apadera tate akuyamba. Choyamba pa mndandanda ndi "Dash yaitali". Kuti muike chizindikiro ichi mu selo yosankhidwa, sankhani dzina ili ndipo dinani pa batani Sakanizaniili pansi pazenera. Pambuyo pake, mukhoza kutsegula zenera kuti muike anthu otchuka. Timakani pa chithunzi choyenera cha kutseka mawindo ngati mawonekedwe oyera pamtanda wofiira womwe uli kumbali yakumanja yawindo.
- Dash yaitali idzalowetsedwa mu pepala mu selo yoyamba yosankhidwa.
Dashifupi mwawindo lazitsulo imayikidwa ndi dongosolo lofanana.
- Mutasintha ku tabu "Zizindikiro Zapadera" Fayilo la khalidwe limasankha dzina "Dashifupi"ili lachiwiri mndandanda. Kenaka dinani pa batani Sakanizani ndi pazithunzi zowonekera.
- Dash yaifupi imalowetsedwera mu chinthu choyambirira chomwe wasankha.
Zizindikiro izi ndi zofanana kwathunthu ndi zomwe tinaziyika mu njira yoyamba. Njira yokha yolowera yokha ndiyo yosiyana. Choncho, zizindikirozi sizingagwiritsidwe ntchito m'mafomu ndipo ndizolemba zomwe zingagwiritsidwe ntchito monga zilembo zamakono kapena zosakaniza m'maselo.
Tapeza kuti kuthamanga kwautali ndi kochepa ku Excel kungapangidwe m'njira ziwiri: kugwiritsa ntchito njira yachitsulo ndikugwiritsa ntchito zenera la anthu apadera, kuyenderera kwa iyo kupyolera mu batani pamzere. Malemba omwe amapezeka pogwiritsira ntchito njirazi ndizofanana, ali ndi encoding yomweyi ndi ntchito. Choncho, njira yosankhira njirayi ndi yokhayokha yogwiritsa ntchito mwiniwakeyo. Monga momwe chiwonetsero chikuwonetsera, ogwiritsa ntchito omwe kawirikawiri amayenera kuyika chizindikiro pamasamba amakonda kukumbukira kuphatikizira, monga njirayi ikufulumira. Anthu amene amagwiritsa ntchito chizindikirochi pamene akugwira ntchito ku Excel kawirikawiri amakonda kukhala ndi chidziwitso pogwiritsa ntchito zizindikiro zowonekera.
