Mukamagwira ntchito ku chikalata ku Excel, nthawi zina muyenera kukhazikitsa mzere wautali kapena wamfupi. Itha kuzitcha, zonse ngati chizindikiro cha malembawo, komanso mawonekedwe. Koma vuto ndikuti palibe chizindikiro chotere pa kiyibodi. Mukadina chizindikiro pa kiyibodi chomwe chimawoneka ngati chovala, timapeza lingaliro lalifupi kapena opanda. Tiyeni tiwone momwe mungakhazikitsire chithunzi pamwambapa mu Microsoft Excel.
Werengani komanso:
Momwe mungapangire kuzungulira mu Mawu
Momwe mungayikire mzere mu Esquel
Njira Zokhazikitsira Dash
Mu Excel pali mitundu iwiri yosankha yopanga mzere: yayitali komanso yochepa. Wotsirizayo amatchedwa "average" muzinthu zina, zomwe zimakhala zachilengedwe poyerekeza ndi chizindikiro "-" (hyphen).
Mukamayesera kukhazikitsa mzere wautali ndikanikizira fungulo "-" pa kiyibodi timapeza "-" - chizindikiro chokhazikika opanda. Kodi timatani?
M'malo mwake, mulibe njira zambiri zakukhazikitsa chipangizo mu Excel. Amangolekeredwa ndi zosankha ziwiri zokha: makina amtundu wabizinesi pa kiyibodi komanso kugwiritsa ntchito zilembo zapadera.
Njira 1: gwiritsani ntchito kuphatikiza kiyi
Ogwiritsa ntchito omwe amakhulupirira kuti ku Excel, monga mu Mawu, mutha kuyika pang'onopang'ono polemba pa kiyibodi "2014"kenako ndikanikiza kuphatikiza kiyi Alt + X, kuyembekezera zokhumudwitsa: piritsi la purosesa njirayi siyigwira ntchito. Koma chinyengo china chimagwira ntchito. Gwirani fungulo Alt ,, osachimasula, timayimba chikuto cha manambala "0151" opanda mawu. Tikangotulutsa kiyi Alt.
Ngati akugwira batani Alt, lembetsani kuchuluka kwa khungu "0150"ndiye tidzagawana.
Njirayi ndiyachilengedwe chonse ndipo imagwira ntchito osati ku Excel, komanso m'Mawu, komanso m'malemba ena, pagome ndi html-akonzi. Chofunikira ndikuti zilembo zomwe zalowetsedwa mwanjira iyi sizisinthidwa kukhala mawonekedwe, ngati mutachotsa chidziwitso ku cell ya malo awo, ikonzaninso ku chinthu china cha pepalalo, monga zimachitika ndi chizindikirocho opanda. Ndiye kuti, zilembozi ndi zolemba chabe, osati zowerengeka. Gwiritsani ntchito mawonekedwe ngati chizindikiro opanda sizigwira ntchito.
Njira 2: zenera laudindo lapadera
Muthanso kuthana ndi vutoli pogwiritsa ntchito zenera lapadera.
- Sankhani khungu lomwe mukufuna kuloza mzere, ndikusunthira ku tabu Ikani.
- Kenako dinani batani "Chizindikiro"ili mu chipangizo "Zizindikiro" pa tepi. Ichi ndiye chithunzithunzi choyenera pa riboni patsamba Ikani.
- Pambuyo pake, zenera linayitanidwa "Chizindikiro". Pitani ku tabu yake "Otchulidwa mwapadera".
- Masamba otchulidwa otseguka amatsegulidwa. Choyamba pamndandanda ndi Dash Yaitali. Kuti muyike chizindikirochi mu cell osankhidwa, sankhani dzinali ndikudina batani Ikaniili pansi pazenera. Pambuyo pake, mutha kutseka zenera la kukhazikitsa zilembo zapadera. Timadina pachizindikiro chotseka zenera mu mawonekedwe amtanda woyera pabwalo lofiira, lomwe lili pakona yakumanja ya zenera.
- Kachidindo kadzalowetsedwa mu pepalalo muchipinda chosankhidwa kale.
Dash yochepa imayikidwa kudzera pazenera la chizindikiro pogwiritsa ntchito algorithm yofananira.
- Pambuyo popita ku tabu "Otchulidwa mwapadera" mawindo achizindikiro sankhani dzinalo Pazifupiyachiwiri pamndandanda. Kenako dinani bwino batani Ikani ndi pazenera chotseka.
- Dash yochepa imayikidwa mu pepala lomwe lidasankhidwa kale.
Zilembozi ndi zofanana ndendende ndi zomwe tidayika mu njira yoyamba. Njira yokhayo yokhayo ndiyomwe ili yosiyana. Chifukwa chake, zilembo izi sizingagwiritsidwenso ntchito m'njira ndipo ndi zilembo zomwe zitha kugwiritsidwa ntchito ngati zilembo zopumira kapena kuwonekera m'maselo.
Tidazindikira kuti kuwonekera kwakutali komanso kwakanthawi mu Excel kumatha kuyikidwamo m'njira ziwiri: ndikutsata njira yaying'ono pa kiyibodi ndikugwiritsa ntchito zenera laudindo lapadera, ndikupita kudzera mu batani la riboni. Zilembo zomwe zimapezeka ndikugwiritsa ntchito njirazi ndi zofanana ndendende, zimakhala ndi kutsata komweko ndikugwira ntchito. Chifukwa chake, chitsimikiziro pakusankha njira ndikungogwiritsa kwa wogwiritsa ntchito. Monga momwe masewera amasonyezera, ogwiritsa ntchito omwe nthawi zambiri amafunika kuyika mapepala pazokonda amakonda kukumbukira kuphatikiza kiyi, chifukwa njirayi imathamanga. Omwe amagwiritsa ntchito chizindikirochi pogwira ntchito ku Excel nthawi zina amakonda kukhala ndi mwayi wogwiritsa ntchito zenera.
