Contents
Ke manaʻo nei mākou he nui nā cell, nā mea a mākou e makemake ai e hūnā mai ka nānā ʻana o kahi malihini, me ka hūnā ʻole i nā lālani a i ʻole nā kolamu me ka ʻikepili iā lākou iho a me ka ʻole o ka hoʻonohonoho ʻana i kahi ʻōlelo huna hiki ke poina. Hiki iā ʻoe, ʻoiaʻiʻo, ke hoʻopololei iā lākou i ke ʻano o "keʻokeʻo keʻokeʻo ma ke ʻano keʻokeʻo", akā ʻaʻole ia he haʻuki loa, a ʻaʻole keʻokeʻo mau ke kala piha o nā cell. No laila, e hele mākou ma ke ala ʻē aʻe.
ʻO ka mea mua, e hana kākou i kahi ʻano kelepona maʻamau e hūnā i kāna mau mea me ka hoʻohana ʻana i kahi ʻano maʻamau. Ma ka pā Home i ka papa inoa o nā ʻano e ʻike i ke ʻano Normal, kaomi ʻākau a koho i ke kauoha nānā me:
Ma ka puka aniani e kū mai ana ma hope o kēia, e hoʻokomo i kekahi inoa no ke ʻano (no ka laʻana huna), wehe i nā pahu pahu a pau koe ka mea mua (i ʻole e hoʻololi ke ʻano i ke koena o nā ʻāpana cell) a kaomi Format:
Ma ka ʻaoʻao kiʻekiʻe Number koho koho Nā ʻano āpau (Maʻamau) a komo i ke kula ʻAno ʻekolu semicolons i ka lālani me ka ʻole o nā hakahaka:
E pani i nā puka makani a pau ma ke kaomi ʻana OK… Ua hana mākou i kahi ʻano maʻamau e hūnā i nā ʻike o nā cell i koho ʻia a e ʻike wale ʻia ma ka pahu formula ke koho ʻia kēlā me kēia cell:
Pehea maoli kona hana ʻana
ʻOiaʻiʻo, maʻalahi nā mea a pau. Hiki i nā ʻāpana maʻamau ke komo i nā ʻāpana mask 4 i hoʻokaʻawale ʻia e nā semicolons, kahi e hoʻohana ʻia ai kēlā me kēia ʻāpana i kahi hihia kikoʻī:
- ʻO ka mea mua inā ʻoi aku ka nui o ka helu ma ke kelepona ma mua o ka ʻole
- ʻO ka lua - inā emi
- ʻEkolu - inā ʻaʻohe ʻole i loko o ke kelepona
- ʻEhā - inā he kikokikona i loko o ke kelepona
Hana ʻo Excel i ʻekolu semicolons i ka lālani ma ke ʻano he ʻehā mau huna huna no nā hihia ʻehā, ʻo ia hoʻi, hoʻopuka i ka nele no kekahi waiwai kelepona.
- Pehea e hana ai i kāu mau palapala maʻamau (kanaka, kg, tausani rubles, etc.)
- Pehea e kau ai i ka pale ʻōlelo huna ma nā cell Excel, nā pepa a me nā puke hana