Aia ma kahi pepa Excel pono ʻoe e hūnā i ka ʻike i loko o kekahi mau cell, a hūnā paha i kahi lālani a i ʻole kolamu. He ʻano ʻikepili koʻikoʻi paha kēia e pili ana i nā cell ʻē aʻe a ʻaʻole makemake ʻoe e hōʻike.
E aʻo mākou iā ʻoe pehea e hūnā ai i nā cell, nā lālani a me nā kolamu ma nā pepa Excel a laila e ʻike hou iā lākou.
huna huna
ʻAʻohe ala e hūnā i kahi kelepona i nalowale loa ia mai ka lau. Ke kū nei ka nīnau: he aha ka mea e noho ai ma kahi o kēia kelepona? Ma kahi, hiki iā Excel ke hana i ʻole e hōʻike ʻia kahi ʻike ma kēlā kelepona. E koho i hoʻokahi cell a i ʻole pūʻulu o nā cell e hoʻohana ana i nā kī Shift и Ctrl, e like me ke koho ʻana i nā faila he nui ma Windows Explorer. Kaomi ʻākau ma kekahi o nā cell i koho ʻia a ma ka papa kuhikuhi ʻatikala e kaomi Hōʻano kelepona (Hōʻano Pūnaewele).
E wehe ʻia kahi pahu kamaʻilio o ka inoa like. E hele i ka pā Number (Helu) a ma ka papa inoa Nā palapala helu (Category) koho Nā pepa āpau (Maʻamau). Ma ke kahua hoʻokomo ʻAno (Type) e hoʻokomo i ʻekolu semicolons – “;;;” (me ka ʻole o nā huaʻōlelo) a kaomi OK.
'Ōlelo Aʻo: Malia paha, ma mua o ka hoʻohana ʻana i ke ʻano hou i nā cell, pono ʻoe e waiho i kahi hoʻomanaʻo o nā ʻano helu i loko o kēlā me kēia cell, i hiki iā ʻoe ke hoʻihoʻi i ka ʻano kahiko i ke kelepona a ʻike hou ʻia kona mau mea.
Ua hūnā ʻia ka ʻikepili i loko o ke kelepona i koho ʻia, akā aia ka waiwai a i ʻole ke ʻano ma laila a hiki ke ʻike ʻia ma ka pahu formula.
No ka ʻike ʻia ʻana o nā ʻike o nā cell, e hahai i nā ʻanuʻu āpau ma luna a hoʻonohonoho i ka ʻano helu helu mua no ke kelepona.
'Ōlelo Aʻo: ʻO nā mea a pau āu e paʻi ai i loko o kahi kelepona i hūnā ʻia ka ʻike e hūnā ʻia ke kaomi ʻana komo. I kēia hihia, e hoʻololi ʻia ka waiwai i loko o kēia cell e ke kumu waiwai hou āu i hoʻokomo ai.
Hūnā lālani a me nā kolamu
Inā ʻoe e hana nei me kahi pākaukau nui, makemake paha ʻoe e hūnā i kekahi mau lālani a me nā kolamu o ka ʻikepili i pono ʻole i kēia manawa no ka nānā ʻana. No ka hūnā ʻana i kahi lālani holoʻokoʻa, kaomi ʻākau i ka helu lālani (header) a koho Hūnā i (Huna).
'Ōlelo Aʻo: No ka hūnā i nā laina he nui, koho mua i kēlā mau laina. No ka hana ʻana i kēia, kaomi ma ke poʻo o ka lālani a, me ka ʻole o ka hoʻokuʻu ʻana i ka pihi ʻiole hema, e kauo i ka pointer ma ka laulā holoʻokoʻa o nā lālani āu e makemake ai e hūnā, a laila kaomi pololei ma ka wahi i koho ʻia a kaomi. Hūnā i (Huna). Hiki iā ʻoe ke koho i nā lālani pili ʻole ma ke kaomi ʻana i ko lākou mau poʻomanaʻo me ka paʻa ʻana i ke kī Ctrl.
E lele ʻia nā helu ma nā poʻomanaʻo o nā lālani huna, a e ʻike ʻia kahi laina pālua ma nā āpau.
Ua like loa ke kaʻina hana o ka hūnā ʻana i nā kolamu me ke kaʻina hana o ka huna ʻana i nā lālani. E kaomi ʻākau ma ke kolamu āu e makemake ai e hūnā, a i ʻole e koho i nā kolamu he nui a kaomi i ka pūʻulu i hōʻike ʻia. Mai ka papa kuhikuhi i hōʻike ʻia, koho Hūnā i (Huna).
E lele ʻia nā leka ma nā poʻomanaʻo kolamu huna a ʻike ʻia kahi laina pālua ma ko lākou wahi.
No ka hōʻike hou ʻana i kahi lālani huna a i ʻole nā lālani he nui, koho i nā lālani ma kēlā ʻaoʻao kēia ʻaoʻao o ka (mau) lālani huna, a laila kaomi ʻākau i ka wahi i koho ʻia a koho mai ka papa kuhikuhi. hoike (Hōʻike).
No ka hōʻike ʻana i kahi kolamu huna a i ʻole nā kolamu he nui, koho i nā kolamu ma kēlā ʻaoʻao kēia ʻaoʻao o nā kolamu huna, a laila kaomi ʻākau ma ka wahi i hoʻohālikelike ʻia a koho mai ka papa kuhikuhi i hōʻike ʻia. hoike (Hōʻike).
Inā ʻoe e hana nei me kahi papaʻaina nui akā ʻaʻole makemake ʻoe e hūnā i nā lālani a me nā kolamu, hiki iā ʻoe ke pine iā lākou i ka wā e ʻōwili ai ʻoe i ka ʻikepili i ka papaʻaina, e mau nā poʻo i koho ʻia.