Ogwiritsa ntchito ambiri a Excel amakumana ndi zovuta zambiri poyesa kuyika chizolowezi papepala. Chowonadi ndi chakuti pulogalamuyo imamvetsetsa mzere ngati chizindikiritso, ndipo nthawi yomweyo amasintha mfundo zomwe zili mu cell kukhala formula. Chifukwa chake, nkhaniyi ndi yofunika kuchitapo kanthu. Tiyeni tiwone momwe tingaikire mzere mu Excel.
Dash ku Excel
Nthawi zambiri mukadzaza zikalata zosiyanasiyana, malipoti, kulengeza, ndikofunikira kuwonetsa kuti khungu lolingana ndi chisonyezo china mulibe zofunika. Pazifukwa izi, chimodzimodzinso ndi chikhalidwe. Pulogalamu ya Excel, izi zimakhalapo, koma kuyika kugwiritsa ntchito kwa wosakonzekera kuli kovuta kwambiri, chifukwa mzerewo umasinthidwa kukhala fomula. Kuti mupewe kusinthaku, muyenera kuchita zinthu zina.
Njira 1: fotokozani mtundu
Njira yodziwika kwambiri yodziwika kuti mu cell mu kuyipanga ndi mtundu wa malembedwe. Zowona, kusankha kumeneku sikuthandiza nthawi zonse.
- Sankhani selo yomwe mukufuna kuyika mzere. Timadulira pomwepo ndi batani la mbewa. Pazosankha zomwe zikuwoneka, sankhani Mtundu Wa Cell. M'malo mwa izi, mutha kukanikiza njira yaying'ono pa kiyibodi Ctrl + 1.
- Tsamba losintha likuyamba. Pitani ku tabu "Chiwerengero"ngati idatsegulidwa mu tsamba lina. Pakadutsa magawo "Mawerengero Amanambala" sankhani "Zolemba". Dinani batani "Zabwino".
Pambuyo pake, selo losankhidwa lidzapatsidwa gawo la zinthu zolemba. Malingaliro onse omwe adalowetsedwa mmenemo sazindikirika monga zinthu zowerengera, koma monga mawu omveka. Tsopano m'derali mutha kuyika chizindikiro "-" kuchokera ku kiyibodi ndipo kuwonetsedwa ndendende, ndipo sikudzazindikira pulogalamuyo ngati chizindikiro chotsitsa.
Pali njira inanso yosinthira maselo kuti iwone mawu. Kuti tichite izi, kukhala tabu "Pofikira", muyenera dinani pamndandanda wotsitsa-mafayilo amtundu wa data, womwe umapezeka kumbali yazida "Chiwerengero". Mndandanda wa zosankha zomwe zikupezeka zimatsegulidwa. Pamndandanda uno mukungofunika kusankha "Zolemba".
Phunziro: Momwe mungasinthire mawonekedwe amtundu mu Excel
Njira 2: Press Press
Koma njirayi imagwira ntchito nthawi zonse. Nthawi zambiri, ngakhale mutatha kuchita izi, mukalowetsa chizindikiro cha "-", ulalo womwewo wamagulu ena umawonekera m'malo mwa mawonekedwe omwe mukufuna. Kuphatikiza apo, izi sizikhala zophweka nthawi zonse, makamaka ngati mu maselo a tebulo omwe ali ndi mapokoso akusinthana ndi maselo odzazidwa ndi deta. Choyamba, mu nkhani iyi muyenera kupanga mtundu uliwonse wa iwo payekhapayekha, ndipo chachiwiri, maselo omwe ali patebulopo adzakhala ndi mtundu wina, womwe sivomerezeka nthawi zonse. Koma zitha kuchitidwa mosiyanasiyana.
- Sankhani selo yomwe mukufuna kuyika mzere. Dinani batani Phatikizaniili pa nthiti mu tabu "Pofikira" pagulu lazida Kuphatikiza. Komanso dinani batani "Gwirizanani pakati"ili pabedi lomweli. Izi ndizofunikira kuti mzindawo ukhale pakatikati pa foni, momwe ziyenera kukhalira, osati kumanzere.
- Timayimira mu cell ndi chikwangwani "-". Pambuyo pake, sitimayenda chilichonse ndi mbewa, ndipo nthawi yomweyo dinani batani Lowanikupita kumzere wina. Ngati wogwiritsa ntchito adadina mbewa, ndiye kuti chilinganizo chikuwonekeranso mu cell momwe mzerewo uyenera kukhalapo.
Njira iyi ndiyabwino kuphweka kwake ndikuti imagwira ntchito ndi mtundu uliwonse wa mitundu. Koma, nthawi yomweyo, ndikuigwiritsa ntchito, muyenera kusamala ndikusintha zomwe zili mu chipangizocho, chifukwa chifukwa cha chinthu chimodzi cholakwika, m'malo mopanga phokoso, mawonekedwewo akhoza kuwonetsedwanso.
Njira 3: ikani mawonekedwe
Njira ina yolembetsera kachidindo mu Excel ndikuyika dzina.
- Sankhani khungu komwe mukufuna kuyika mzere. Pitani ku tabu Ikani. Pa nthiti yomwe ili m'bokosi la chida "Zizindikiro" dinani batani "Chizindikiro".
- Kukhala mu tabu "Zizindikiro", ikani minda pazenera "Khazikitsani" gawo Zizindikiro Zamtundu. Pakati pazenera, yang'anani chikwangwani cha "─" ndikusankha. Kenako dinani batani Ikani.
Pambuyo pake, mzerewo umawonetsedwa mu foni yosankhidwa.
Palinso njira ina pamakina a njirayi. Kukhala pawindo "Chizindikiro"pitani ku tabu "Otchulidwa mwapadera". Pamndandanda womwe umatsegulira, sankhani Dash Yaitali. Dinani batani Ikani. Zotsatira zake zidzakhala zofanana ndi zomwe zidasinthidwa kale.
Njira iyi ndi yabwino chifukwa simudzafunika kuopa kuyendetsa mbewa zolakwika. Chizindikiro sichimasinthabe ku formula. Kuphatikiza apo, mzera wowoneka bwino wokhazikitsidwa ndi njirayi umawoneka bwino kuposa chithunzi chachifupi chojambulidwa kuchokera kubuloko. Choyipa chachikulu cha njirayi ndikufunika kuchita kangapo kamodzi, komwe kumabweretsa kuchepa kwakanthawi.
Njira 4: onjezerani munthu wina
Kuphatikiza apo, pali njira inanso yoyika mzere. Zowona, mwanjira iyi sizovomerezeka kwa ogwiritsa ntchito onse, chifukwa zimangoyang'ana kupezeka kwa khungu, kupatula chizindikiro chomwe "-", chizindikiro china.
- Sankhani khungu lomwe mukufuna kukhazikitsa mzere, ndipo ikani chizindikiro "'" mwa icho kuchokera pa kiyibodi. Ili pa batani lomwelo monga zilembo "E" mumawonekedwe a Korezo. Kenako, nthawi yomweyo, popanda malo, khazikitsani chizindikiro "-".
- Dinani batani Lowani kapena sankhani khungu lina lililonse ndi chowunika mbewa. Pogwiritsa ntchito njirayi, izi sizofunikira kwenikweni. Monga mukuwonera, izi zitachitika mzere waikidwa papepala, ndipo chizindikiro china "" "chimawoneka mu mzere wa njira mukasankha khungu.
Pali njira zingapo zokhazikitsira kachidindo mu khungu, chisankho pakati pomwe wosuta angapange malinga ndi cholinga chogwiritsa ntchito chikalata china. Anthu ambiri koyamba osayesa kuyesa kuyika mawonekedwe omwe akufuna amayesa kusintha mawonekedwe a maselo. Tsoka ilo, izi sizigwira ntchito nthawi zonse. Mwamwayi, pali njira zina zantchitoyi: pitani ku mzere wina pogwiritsa ntchito batani Lowani, kugwiritsa ntchito zilembo kudzera pa batani pa riboni, kugwiritsa ntchito kwa munthu wina "" ". Iliyonse mwanjirazi ili ndi zabwino komanso zovuta zake, zomwe zidafotokozedwa pamwambapa. Njira yonse yomwe ingakhale yoyenera kwambiri kukhazikitsa mzere mu Excel m'malo onse momwe mulibe.
