Ka hui a me ka wehe ʻana i ka ʻikepili ma Excel. Nā ʻōlelo aʻo ʻanuʻu me ke kiʻi

ʻO kēia ka makahiki ʻike. Ke ulu nui nei ka nui o ka ʻikepili i hana ʻia e nā kānaka i kēlā me kēia lā. Pili kēia i nā wahi āpau o ke ola, me ka hana. I kēia manawa, nui aʻe nā wahi o ka hana a ke kanaka i makemake nui ai i ka hiki ke hana wikiwiki i ka nui o ka ʻike.

ʻO kekahi o nā hiʻohiʻona Excel e hiki ai iā ʻoe ke hana i kēia ʻo ka hui ʻana. ʻO ka ʻoiaʻiʻo ʻo ka hoʻonohonoho ʻana i ka ʻike e kōkua i ka hana ʻaʻole me nā ʻikepili āpau i loaʻa, akā me nā ʻāpana liʻiliʻi wale nō. Inā hoʻokomo ʻoe i ka ʻike like i loko o ka poloka hoʻokahi, a laila ʻoi aku ka maʻalahi no ke kamepiula a no ke kanaka ponoʻī. Aneane ʻaʻohe wahi i makemake ʻole ʻia ka hoʻonohonoho ʻana o ka ʻike:

1. Hoʻoponopono ʻikepili kūʻai. Loaʻa i nā hale kūʻai nā pūʻulu nui o nā ʻano waiwai like ʻole me nā kumukūʻai like ʻole, ke kaumaha, ka mea hoʻolako, ka inoa, a pēlā aku. ʻO ka hoʻonohonoho ʻana i ka ʻikepili e maʻalahi ke hoʻokele i kēia ʻano ʻike āpau.
2. Haʻawina. ʻO ka maikaʻi o ka hoʻonaʻauao a me ka hoʻonaʻauao pilikino e pili pono i ka maikaʻi o ka hoʻonohonoho ʻana o ka ʻike. No laila, inā ʻoe e hui pololei i ka ʻikepili o ka ʻano like ʻole i kēlā me kēia ʻaoʻao, e maʻalahi ka hana ʻana i nā hana kūpono e pili ana i nā helu, no ka laʻana, akā nā hana theoretical, hoʻonohonoho i nā haʻawina home, a pēlā aku.
3. Hoike Heluhelu. Pono nā mea helu helu e hana mau i nā helu, he pilina kēlā me kēia me nā helu ʻē aʻe. A i mea e maʻalahi ai ka hana ʻana me ka nui o nā waiwai uXNUMXbuXNUMX pili i kekahi i kekahi a me ka ʻike o kahi ʻano ʻano like ʻole, maʻalahi loa ka hoʻohana ʻana i ka hui ʻikepili.

Eia kekahi, hiki iā ʻoe ke hūnā i ka ʻike o ka wā kahiko. E ʻike kākou pehea e hana ai a pehea ʻoe e hoʻohana ai.

Pehea e hoʻonohonoho ai i nā ʻāpana hana

No ka hana ʻana me ka pūʻulu ʻikepili, pono ʻoe e hoʻonohonoho mua iā ia. No ka hana ʻana i kēia, e hele i ka pā "Data" a loaʻa i ka koho "Structure" ma laila. A laila, e ʻike ʻia kahi papa pop-up kahi e pono ai ʻoe e ʻimi i kahi pihi ma ke kihi ʻākau haʻahaʻa.

Ma hope o kēlā, e puka mai kahi puka e pono ai ʻoe e koho i nā pahu kūpono kūpono a kaomi i ke kī OK. Mālama kēia mau hoʻonohonoho i ke ʻano e hōʻike ʻia ai ka ʻikepili.

nui: i ka hoʻomaʻamaʻa ʻana, ʻike ka poʻe he mea paʻakikī ke hōʻike i nā huina ma lalo o ka ʻikepili. No laila, hiki iā ʻoe ke waiho i kēia pahu me ka nānā ʻole ʻia. Manaʻo ʻia e nānā i ka pahu "Automatic Styles".

Ma hope o ka pau ʻana i kēia mau ʻanuʻu, hiki iā ʻoe ke hoʻomaka koke i ka ʻike hui.

Pehea e hui pū ai i nā ʻikepili ma nā lālani

I kēia manawa e noʻonoʻo kākou i nā mea e pono ai e hana i nā lālani hui, ma ka hana.

1. E hana i kahi lālani hou ma luna a ma lalo paha o nā mea a mākou e makemake ai e hui. Pili ia i ke ʻano o ka hōʻike ʻana i nā hopena i koho ʻia ma ka pae mua.
2. ʻO ka hana aʻe, ʻo ia ka hana ʻana i ka inoa papa ma ka ʻaoʻao hema hema o ka lālani i hoʻohui ʻia. ʻO kēia ka inoa o ka hui e hui pū ʻia ai nā cell i maʻamau ma kekahi kumu.
3. E koho i nā pūnaewele a pau ma ka wahi ma lalo o ka lālani i hana hou ʻia a i ʻole ma luna o ia (e pili ana i ka mea a mākou i hana ai i ka hana mua). Ma hope o kēlā, ʻimi mākou i ka pihi "Structure" ma ka ʻikepili ʻikepili a ma laila mākou e ʻike ai i ka koho "Group". He mea nui ʻaʻole e kaomi i ka pua a i ʻole ka inoa o ke kauoha ma ka pop-up panel, akā ma ka ikona.

Inā kaomi mau ʻoe i ka pua i lalo, e hōʻike ʻia kahi papa kuhikuhi e hiki ai iā ʻoe ke koho i ka hana hui a i ʻole e hana i kahi hale. Makemake nui mākou i ka hui ʻana ma kēia pae.

Ma hope o kēlā, koho mākou i ka hiʻohiʻona nui e hoʻokō ʻia ai ka hui. Hiki i nā lālani a i ʻole nā ​​kolamu. Inā ʻaʻole ʻoe e hoʻololi i kekahi mea, a laila koho ʻia ka mea mua ma ka paʻamau. Ma hope o ka hōʻoia ʻana ua hoʻonohonoho ʻia nā hoʻonohonoho e like me ka mea e pono ai, pono mākou e hōʻoia i kā mākou mau hana ma ke kaomi ʻana i ke pihi OK. No ka mea e hui pū ana mākou ma ka lālani, ʻaʻole pono mākou e hoʻololi i kekahi mea, pono mākou e nānā pālua.

nui: inā, ma mua o ka hoʻomaka ʻana i ka hui ʻana i nā mea, ʻaʻole ʻoe e koho i ke kelepona, akā nā kolamu a i ʻole nā ​​lālani holoʻokoʻa ma ka panel coordinate, a laila ʻaʻole e ʻike ʻia kēia pahu kamaʻilio. E noʻonoʻo ka papahana i kāna mea e hana ai.

ʻO ka ʻoiaʻiʻo i hui pū ʻia nā laina, hiki iā mākou ke hoʻomaopopo i ka hōʻailona minus ma ka papa hoʻonohonoho. Hōʻike kēia iā mākou ua hōʻike ʻia ka ʻikepili. I kēia manawa hiki iā mākou ke hūnā iā lākou ma ke kaomi ʻana i kēia ikona a i ʻole ke kaomi ʻana i ka pihi 1 i kahi kiʻekiʻe iki (e hōʻike ana i ke kiʻekiʻe o ka hui).

ʻIke mākou ua hūnā ʻia nā laina, a ua hoʻololi ʻia ka hōʻailona minus i kahi hoʻohui. No ka wehe ʻana i ka laina i makemake ʻia, hiki iā ʻoe ke kaomi iā ia, a laila e hana ka polokalamu iā ia iho. Inā pono ʻoe e hoʻonui i nā laina āpau, a laila pono ʻoe e kaomi i ke pihi "2", aia ma luna o ka panel coordinate i kēia hihia.

Pehea e hui pū ai i nā kolamu

No ka hui ʻana i nā kolamu, ʻano like ka algorithm o nā hana:

1. Ma muli o nā koho a mākou i koho ai i nā hoʻonohonoho, pono mākou e hoʻokomo i kahi kolamu hou i ka hema a i ʻole ʻākau o ka wahi e hui pū ʻia.
2. Kākau mākou i ka inoa o ka hui ma ka ʻaoʻao kiʻekiʻe loa o ke kolamu i ʻike ʻia.
3. Koho mākou i nā kolamu āpau e pono ai mākou e hui (e waiho wale i ka mea a mākou i hoʻohui ai i ka pae mua), a laila kaomi i ke pihi "Group" e like me ka algorithm i hōʻike ʻia ma luna.
4. I kēia manawa pono mākou e kaomi i ka mea "Columns" ma ka puka makani liʻiliʻi a kaomi i ke pihi "OK".
5. Pōmaikaʻi iā ʻoe.

'Ōlelo Aʻo. E like me ka hui pū ʻana i nā lālani, inā mākou e koho i nā kolamu holoʻokoʻa i ka pae hoʻonohonoho hoʻopaʻapaʻa, ʻaʻole loaʻa iā mākou kahi pahu kamaʻilio liʻiliʻi.

Pehea e hana ai i ka hui multilevel

He polokalamu hana ʻo Excel, akā ʻaʻole i pau nā mea hiki me ka hui pū ʻana hoʻokahi, e like me ka mea i wehewehe ʻia ma nā hiʻohiʻona ma luna. Aia nō ka hiki ke hui pū i nā pūnaewele ma kekahi mau pae. Hana ʻia kēia ma ke ʻano penei:

1. I ka hoʻomaka ʻana, hana ʻia ka hui nui ma ke ʻano i hōʻike ʻia ma luna. E hoʻohui ʻia nā pūʻulu liʻiliʻi iā ia.
2. Ma hope o kēlā, ʻike mākou ua wehe ʻia ka hui nui. I loko o ia mea, hana pū mākou i nā hana i hōʻike ʻia ma luna. Aia nā ʻanuʻu kikoʻī i ka hana ʻana o ke kanaka me nā lālani a i ʻole nā ​​kolamu.
3. ʻO ka hopena, hiki ke hana ʻia nā hui o nā pae he nui.

Nā kuhikuhi no ka wehe ʻana i ka ʻikepili

Hiki mai ke kūlana inā ʻaʻole pono kahi hui i hana mua ʻia. Aia kahi hana kaʻawale no kēia - "Ungroup". No ka hoʻokō ʻana, pono ʻoe e hahai i kēia mau ʻanuʻu:

1. E koho i nā mea i ʻāpana o ka hui.
2. E wehe i ka pā "Data".
3. Loaʻa iā mākou ka hui "Structure" ma laila, wehe iā ia me ka pua ma lalo.
4. Ma laila, kaomi i ka pihi "Ungroup". He mea nui e kaomi i ka ikona, ʻaʻole ka palapala.

A laila, koho mākou i ka mea a mākou e makemake ai e wehe. Koho mākou i ka mea i kūpono ma muli o ka mea a mākou i hui mua ai. Ma hope o ka pau ʻana o ka hana, e kaomi i ke pihi OK.

E nānā! Inā ma mua o ka hana ʻia ʻana o ka hui ʻana a i ʻole i hana ʻia nā hui like ʻole, a laila pono lākou e hoʻoponopono ʻokoʻa.

Eia nō hoʻi mākou e loaʻa ai kēlā hopena.

He algorithm maʻamau kēia no ka ungrouping cell, akā e like me kēlā me kēia ʻoihana, nui nā nuances. E nānā hou aku kākou iā lākou.

Pehea e wehe ai i nā lau

Pono paha e wehe i nā lau i kēlā me kēia manawa. No ka hana ʻana i kēia, pono ʻoe e hana i kēia kaʻina hana:

1. I ka hoʻomaka ʻana, ʻike mākou i kēlā mau pepa i hui pū ʻia. Inā ua hui mua ʻia nā pepa, e hōʻike ʻia lākou ma ke kala like a i ʻole ka poʻo inoa me ka wiwo ʻole.
2. Ma hope o kēlā, pono ʻoe e kaomi ʻākau i kekahi o nā pepa mai ka hui, a laila kaomi i ka pihi "Ungroup sheets" ma ka papa kuhikuhi. I kēia manawa e hui ʻole ʻia lākou, a e hoʻololi ʻia nā hoʻololi a pau iā lākou ma ke kūʻokoʻa o nā mea ʻē aʻe.

ʻO kahi ala ʻē aʻe e wehe ai i nā pepa ma ka hoʻohana ʻana i ke kī Shift a laila kaomi i ka pepa hana i ka hui āu e makemake ai e wehe. ʻO ia hoʻi, pono ʻoe e wehewehe i ka pūʻulu e koi ʻia ana ka ungrouping, a laila kaomi ma luna o kekahi o nā ʻaoʻao, a laila kaomi iā ia me ka paʻa ʻana i ke kī Shift.

Ma hope o ka hoʻololi ʻana, hiki iā ʻoe ke hui pū i kekahi o nā lau. No ka hana ʻana i kēia, kaomi i ke kī Ctrl a i ʻole Cmd (ʻo ka mua no nā kamepiula e holo ana i ka Windows, a ʻo ka lua no ka ʻenehana Apple), a ʻoiai e paʻa ana i ke pihi, e kaomi i nā pepa āu e makemake ai e hui i kahi hui. Ma hope o kēlā, e hana ka polokalamu i nā mea a pau no ka mea hoʻohana.

Pehea e wehe ai i ka ʻikepili i hui pū ʻia

Ma mua o ka wehe ʻana i nā pūnaewele, pono ʻoe e hoʻomaopopo mua i ke ʻano o ka hui ʻana: ma ka lima a i ʻole. Manaʻo ʻia ka hui pū ʻana me ke ʻano i wehewehe ʻia ma luna. ʻO ka hana ʻakomi o nā pūʻulu ke hana ʻia me ka hoʻohana ʻana i kekahi mau hana. No ka laʻana, ma hope o ka hana ʻana i nā subtotal. ʻO ka ʻoiaʻiʻo i hoʻohana ʻia kēia manawa kūpono e hiki ke hoʻomaopopo ʻia mai ka laina "Nā hopena waena".

Inā ua hui pū ʻia ka ʻikepili ma o ka hana o ka inoa like Excel, a laila i mea e hoʻopau ai, pono ʻoe e hōʻoia i ka waiho ʻana o ka hui. Inā ʻaʻole, pono ʻoe e kaomi i ka pihi + ma ka ʻaoʻao ʻaoʻao ma ka hema. ʻO ka ʻoiaʻiʻo o ka hoʻonohonoho ʻana o ka hui, hiki iā mākou ke hoʻokolokolo ma ke pihi - ma kahi hoʻokahi. Ke hoʻonui mākou i kahi hui, hoʻomaka mākou e ʻike i nā lālani huna a me nā hui. Ma hope o kēlā, me ka hoʻohana ʻana i ka papa keyboard a i ʻole ka pihi hema hema, koho i nā cell āpau i ka hui, a laila - e like me ka algorithm i hōʻike ʻia ma luna.

Kakaikahi ka poʻe i ʻike aia he ala ʻē aʻe e wehe i nā pūnaewele hui lima - me ka hoʻohana ʻana i nā kī wela.

No ka hana ʻana i kēia, pono ʻoe e koho mua i kēlā mau kolamu i hui pū ʻia, a laila kaomi i nā kī Alt + Shift + Left arrow. Inā hana ʻia ka hana ma kahi kamepiula i hoʻomalu ʻia ma lalo o Mac OS, a laila pono ʻoe e hoʻohana i ka hui kī Command + Shift + J.

Pehea e wehe ai i ka ʻikepili i hui pū ʻia

Inā, ma muli o ka loiloi i hana ʻia ma ka paukū mua, ua ʻike ʻia ua hui pū ʻia ka ʻikepili, a laila ʻoi aku ka paʻakikī o nā mea āpau, no ka mea ʻaʻole e hana ka hana ungroup maʻamau i kēia hihia. Pili nā hana i ka mea i hoʻokō pono i ka hui ʻana o ka ʻikepili. Inā ʻo ia ka hana "Subtotals", a laila penei ke ʻano o nā hana:

1. Wehe mākou i ka pā like me ka ʻikepili ma ka papa nui (a i ʻole lipine, e like me ka mea i kapa pinepine ʻia).
2. Ma hope o kā mākou kaomi ʻana i ka pihi "Subtotals" (ʻo ia ka mea e pono ai mākou e hana ma ke ʻano he lua), e loaʻa iā mākou kahi pukaaniani. Aia ka pihi ma ka ʻāpana like - Structure. Ma hope o kēlā, e puka mai kahi puka e pono ai mākou e kaomi i ka pihi "Delete All". Hiki ke loaʻa iā ia ma ka ʻaoʻao hema hema o ka puka makani a i ʻole ma kahi ʻē aʻe (e pili ana i ka mana o Office a me ka papahana pālahalaha kikoʻī).

E nānā! Hoʻopau kēia ʻano i ka hui wale nō, akā pū kekahi subtotals. No laila, inā pono ʻoe e mālama iā lākou, ʻoi aku ka maikaʻi o ke kope ʻana i nā mea hui i kahi pepa ʻē aʻe a hoʻohana iā lākou ma ke ʻano he hui ʻole.

He ʻōlelo paipai ikaika no nā hana me ka papaʻaina e hui a wehe i ka ʻikepili. Ma mua o ka hana ʻana i kēia, pono ʻoe e hana i kope o ka pākaukau kumu. I kēia hihia, hiki iā ʻoe ke hoʻihoʻi i ka ʻike kumu o ka palapala inā ʻaʻole hele kekahi mea e like me ka hoʻolālā.

No laila, loaʻa i ka Excel kahi hana ākea loa no ka hoʻonohonoho ʻana i ka ʻikepili. ʻOiaʻiʻo, ʻaʻole hiki iā ia ke hana i nā mea āpau no ke kanaka, akā hiki iā ʻoe ke hoʻonohonoho maʻalahi i ka hana me ka ʻikepili i kūkulu ʻia. ʻO ke koena e hana ʻia e ke kanaka. Eia naʻe, he mea hana pono loa kēia e pono ai ka poʻe e hana me ka nui o nā ʻike helu a me nā kikokikona.