Pehea e hūnā ai a hui pū i nā kolamu ma Excel

Mai kēia alakaʻi e aʻo ai ʻoe a hiki iā ʻoe ke aʻo pehea e hūnā ai i nā kolamu ma Excel 2010-2013. E ʻike ʻoe i ka hana ʻana o ka hana maʻamau Excel no ka hūnā ʻana i nā kolamu, a e aʻo pū ʻoe pehea e hui pū ai a wehe i nā kolamu me ka hoʻohana ʻana i ka "Ka Hoʻohui".

ʻO ka hiki ke hūnā i nā kolamu ma Excel he mea pono loa. Nui nā kumu e hōʻike ʻole ai i kekahi ʻāpana o ka papa (pepa) ma ka pale:

• Pono e hoʻohālikelike ʻia ʻelua kolamu a ʻoi aku paha, akā ua hoʻokaʻawale ʻia lākou e kekahi mau kolamu ʻē aʻe. No ka laʻana, makemake ʻoe e hoʻohālikelike i nā kolamu A и Y, a no kēia mea ʻoi aku ka maʻalahi o ka waiho ʻana iā lākou ma kahi ʻaoʻao. Ma ke ala, ma kahi o kēia kumuhana, makemake paha ʻoe i ka ʻatikala Pehea e hoʻokuʻu ai i nā ʻāpana ma Excel.
• Nui nā kolamu kōkua me nā helu waena a i ʻole nā ​​ʻōlelo hoʻohālikelike e hiki ke huikau i nā mea hoʻohana ʻē aʻe.
• Makemake ʻoe e peʻe mai ka nānā ʻana i nā maka a pale paha mai ka hoʻoponopono ʻana i kekahi mau ʻōlelo koʻikoʻi a i ʻole ka ʻike pilikino.

E heluhelu e aʻo pehea e wikiwiki a maʻalahi ai ʻo Excel e hūnā i nā kolamu makemake ʻole. Eia kekahi, ma kēia ʻatikala e aʻo ʻoe i kahi ala hoihoi e hūnā i nā kolamu me ka hoʻohana ʻana i ka "Ka Hoʻohui", e hiki ai iā ʻoe ke hūnā a hōʻike i nā kolamu huna i hoʻokahi ʻanuʻu.

• Hūnā i nā kolamu i koho ʻia ma Excel
• E hoʻohana i ka mea hana "Group" e hūnā a hōʻike i nā kolamu i hoʻokahi kaomi

Hūnā i nā kolamu i koho ʻia ma Excel

Makemake ʻoe e hūnā i hoʻokahi kolamu a ʻoi aku paha i loko o ka pākaukau? Aia kahi ala maʻalahi e hana ai i kēia:

1. E wehe i kahi pepa Excel a koho i nā kolamu āu e makemake ai e hūnā.

mana'o kōkua: No ke koho ʻana i nā kolamu pili ʻole, e kaha iā lākou ma ke kaomi ʻana i ka pihi ʻiole hema me ka paʻa ʻana i ke kī Ctrl.

2. Kaomi ʻākau ma kekahi o nā kolamu i koho ʻia e hoʻopuka i ka papa kuhikuhi pōʻaiapili a koho Hūnā i (Hūnā) mai ka papa inoa o nā hana i loaʻa.

mana'o kōkua: No ka poʻe makemake i nā pōkole keyboard. Hiki iā ʻoe ke hūnā i nā kolamu i koho ʻia ma ke kaomi ʻana CTRL+0.

mana'o kōkua: Hiki iā ʻoe ke loaʻa kahi hui Hūnā i (Hūnā) ma ka Lipine Menu Home > Nā Pūnaewele > Kūkulu > Hūnā a hōʻike (Home > Pūnaewele > Hōʻano > Hūnā a wehe ʻole).

Voila! I kēia manawa hiki iā ʻoe ke waiho maʻalahi i ka ʻikepili pono no ka nānā ʻana, a hūnā i nā mea pono ʻole i ʻole lākou e hoʻohuli i ka hana o kēia manawa.

E hoʻohana i ka mea hana "Group" e hūnā a hōʻike i nā kolamu i hoʻokahi kaomi

Hoʻohana pinepine ka poʻe hana nui me nā papa i ka hiki ke hūnā a hōʻike i nā kolamu. Aia kekahi mea hana e hana nui me kēia hana - e mahalo ʻoe! ʻO kēia mea hanaKa Hoʻohui“. Aia ma ka pepa hoʻokahi he mau pūʻulu kolamu pili ʻole e pono e hūnā a hōʻike ʻia i kekahi manawa - a hana pinepine. Ma ia kūlana, hoʻomāmā nui ka hui ʻana i ka hana.

Ke hōʻuluʻulu ʻoe i nā kolamu, ʻike ʻia kahi pā ākea ma luna o lākou e hōʻike i nā kolamu i koho ʻia no ka hui ʻana a hiki ke hūnā ʻia. Ma hope o ka dash, e ʻike ʻoe i nā kiʻi liʻiliʻi e hiki ai iā ʻoe ke hūnā a hōʻike i ka ʻikepili huna i hoʻokahi kaomi wale nō. I ka ʻike ʻana i ia mau kiʻi ma ka pepa, e hoʻomaopopo koke ʻoe i kahi o nā kolamu huna a me nā kolamu hiki ke hūnā ʻia. Pehea i hana ʻia ai:

1. E wehe i kahi pepa Excel.
2. E koho i nā pūnaewele e hūnā.
3. Press Shift+Alt+Puʻu ʻākau.
4. E hōʻike ʻia kahi pahu kamaʻilio Ka Hoʻohui (Puʻupuʻu). E koho kolamu (Nā Kolu) a kaomi OKe hōʻoia i ke koho.

mana'o kōkua: ʻO kahi ala ʻē aʻe i ka pahu kamaʻilio like: 'Ikepili > Group > Group (ʻIkepili > Pūʻulu > Pūʻulu).

mana'o kōkua: No ka wehe ʻana i ka hui, koho i ka laulā i loaʻa nā kolamu i hui ʻia a kaomi Shift+Alt+Arrow hema.

4. mea hana «Ka Hoʻohui»e hoʻohui i nā huaʻōlelo hoʻolālā kūikawā i ka pepa Excel, e hōʻike pono i nā kolamu i hoʻokomo ʻia i loko o ka hui.
5. I kēia manawa, e koho i nā kolamu āu e makemake ai e hūnā, a no kēlā me kēia kaomi Shift+Alt+Puʻu ʻākau.

'Ōlelo Aʻo: Hiki iā ʻoe ke hui pū i nā kolamu pili. Inā makemake ʻoe e hūnā i nā kolamu pili ʻole, pono ʻoe e hana i nā hui ʻokoʻa.

5. E like me kou kaomi ʻana i ka hui kī Shift+Alt+Puʻu ʻākau, e hōʻike ʻia nā kolamu huna, a me kahi ikona kūikawā me ka hōʻailona "-» (emi).
6. Keleʻia nei hua e hūnā i nā kolamu, a "-' e lilo i '+“. Ke kaomi ʻana eia e hōʻike koke i nā kolamu a pau i hūnā ʻia ma kēia pūʻulu.
7. Ma hope o ka hui ʻana, ʻike ʻia nā helu liʻiliʻi ma ka ʻaoʻao hema hema. Hiki iā lākou ke hoʻohana e hūnā a hōʻike i nā hui āpau o ka pae like i ka manawa like. No ka laʻana, ma ka papa ma lalo, ke kaomi ʻana i kahi helu 1 e hūnā i nā kolamu a pau i ʻike ʻia ma kēia kiʻi, a kaomi i ka helu 2 e huna i na kolamu С и Е. He mea maʻalahi kēia ke hana ʻoe i kahi hierarchy a me nā pae he nui o ka hui.

ʻo ia wale nō! Ua aʻo ʻoe pehea e hoʻohana ai i ka hāmeʻa e hūnā i nā kolamu ma Excel. Eia hou, ua aʻo ʻoe pehea e hui a wehe i nā kolamu. Manaʻo mākou ʻo ka ʻike ʻana i kēia mau hoʻopunipuni e kōkua iā ʻoe e hana maʻalahi i kāu hana maʻamau ma Excel.

E holomua me Excel!