Nā Pūnaewele huna ma Excel - 5 mau ala e hōʻike ai i nā huna huna ma Excel

I ka hana ʻana me nā papa ʻokoʻa i ka format Excel, ma hope a i ʻole e pono e hūnā i kekahi mau ʻikepili a hūnā i nā helu waena a me nā formula. I ka manawa like, ʻaʻole ʻae ʻia ka holoi ʻana, no ka mea hiki ke koi ʻia ka hoʻoponopono ʻana i nā ʻikepili huna e hoʻokō pono ai nā ʻōkuhi. No ka hūnā ʻana i kēia a i ʻole kēlā ʻike, aia kahi hana e like me ka huna ʻana i nā cell.

Pehea e hūnā ai i nā cell ma Excel?

Nui nā ala e hūnā ai i nā cell i nā palapala Excel:

• hoʻololi i nā palena o kahi kolamu a lālani paha;
• ka hoʻohana ʻana i ka mea hana;
• hoʻohana i ka papa kuhikuhi wikiwiki;
• hui pū;
• hiki i nā kānana;
• huna i ka ʻike a me nā waiwai i loko o nā cell.

Loaʻa i kēlā me kēia o kēia mau ʻano kāna mau hiʻohiʻona:

1. No ka laʻana, ʻo ka hūnā ʻana i nā cell ma ka hoʻololi ʻana i ko lākou mau palena ʻo ia ka maʻalahi. No ka hana ʻana i kēia, e hoʻoneʻe wale i ka cursor i ka palena lalo o ka laina ma ke kahua helu a kauo i luna a paʻi nā palena.
2. I mea e hōʻailona ʻia ai nā huna huna me ka "+", pono ʻoe e hoʻohana i ka "Grouping", hiki ke loaʻa ma ka papa kuhikuhi "Data". E hōʻailona ʻia nā huna huna me kahi unahi a me kahi hōʻailona "-", ke kaomi ʻia, hūnā ʻia nā cell a ʻike ʻia kahi hōʻailona "+".

Mea nui! Ke hoʻohana nei i ke koho "Grouping", hiki iā ʻoe ke hūnā i kahi helu palena ʻole o nā kolamu a me nā lālani i ka papaʻaina.

3. Inā pono, hiki iā ʻoe ke hūnā i ka wahi i koho ʻia ma o ka pop-up menu ke kaomi ʻana i ke pihi ʻiole ʻākau. Maanei mākou e koho ai i ka mea "Hūnā". ʻO ka hopena, nalowale nā ​​​​pūnaewele.
4. Hiki iā ʻoe ke hūnā i nā kolamu a i ʻole nā ​​lālani ma o ka pā "Home". No ka hana ʻana i kēia, e hele i ka ʻāpana "Format" a koho i ka ʻāpana "Hūna a hōʻike". E hōʻike ʻia kahi papa inoa ʻē aʻe, kahi e koho ai mākou i ka hana e pono ai:

• huna i na kolamu;
• huna laina;
• pepa huna.

5. Ke hoʻohana nei i ke ʻano kānana, hiki iā ʻoe ke hūnā i ka ʻike ma nā lālani a i ʻole nā ​​kolamu i ka manawa like. Ma ka ʻaoʻao "Main", koho i ka ʻāpana "Sort and Filter". I kēia manawa i ka papa kuhikuhi i hōʻike ʻia, hoʻāla i ka pihi "Filter". Pono e hōʻike ʻia kahi pahu pahu me ka pua e kuhikuhi ana i lalo i ke kelepona i koho ʻia. Ke kaomi nei ʻoe i kēia pua ma ka papa kuhikuhi iho, wehe i nā pahu ma ka ʻaoʻao o nā waiwai uXNUMXbuXNUMXb āu e makemake ai e hūnā.
6. Ma Excel, hiki ke hūnā i nā cell me ka ʻole o nā waiwai, akā i ka manawa like ʻaʻole e hōʻino i ke ʻano o ka helu ʻana. No ka hana ʻana i kēia, e hoʻohana i ka hoʻonohonoho "Cell Format". E kāhea koke i kēia papa kuhikuhi, e kaomi wale i ka hui "Ctrl + 1". Ma ka ʻaoʻao hema o ka puka aniani, e hele i ka ʻāpana "(nā ʻano āpau)", a ma ke kahua "Type", e iho i lalo i ka waiwai hope, ʻo ia hoʻi, ";;;". Ma hope o ke kaomi ʻana i ke pihi "OK", e nalowale ka waiwai i loko o ke kelepona. ʻAe kēia ʻano iā ʻoe e hūnā i kekahi mau waiwai, akā e hana pono nā ʻōkuhi āpau.

Huli i nā pūnaewele huna

Inā hana kekahi mau mea hoʻohana i kahi palapala, pono ʻoe e ʻike pehea e ʻike ai i ka hele ʻana o nā cell huna i kahi faila Excel. No ka huli ʻana i nā kolamu huna a me nā lālani, akā ʻaʻole e hōʻike iā lākou, pono ʻoe e nānā i ke kaʻina o nā kolamu a me nā poʻomanaʻo lālani. Hōʻike ka leka a i ʻole ka helu i nalowale.

Inā ʻoi aku ka nui o ka papaʻaina, a laila paʻakikī loa kēia ʻano hana. No ka maʻalahi o ke kaʻina hana o ka ʻimi ʻana i nā cell huna i kahi palapala, pono ʻoe e hele i ke kauoha "Editing" i hoʻonohonoho ʻia ma ka papa kuhikuhi "Home". Ma ka mahele "E ʻimi a koho", koho i ke kauoha "E koho i kahi hui o nā cell ...".

Ma ka puka aniani e wehe ai, e nānā i ka ʻāpana "Nā pūnaewele ʻike wale ʻia". Ma hope o kēlā, i loko o ka papaʻaina, hiki iā ʻoe ke ʻike ʻaʻole wale i ka wahi i koho ʻia o nā cell, akā nā laina mānoanoa hoʻi, e hōʻike ana i ke alo o nā lālani huna a i ʻole nā ​​kolamu.

Hōʻike i nā huna huna ma Excel

E like me ia, ʻaʻole e hana nā cell wehe i hūnā ʻia mai ka prying eyes. Pono mua ʻoe e hoʻomaopopo i nā ʻano i hoʻohana ʻia e hūnā iā lākou. Ma hope o nā mea a pau, e hilinaʻi ʻia ka koho o kā lākou hōʻike. Eia kekahi laʻana, hiki i kēia:

• ka neʻe ʻana o nā palena cell;
• ungrouping o nā pūnaewele;
• e hoʻopau ana i ke kānana;
• hoʻopololei i kekahi mau pūnaewele.

E noʻonoʻo kākou i kēlā me kēia o lākou i nā kikoʻī.

Ka Papa Hana 1: Hoʻololi i nā Palena Pūnaewele

Inā hoʻohana ʻia ke ʻano o ka hoʻololi kino ʻana i nā palena o kahi kolamu a i ʻole laina e hūnā i nā cell, a laila e hōʻike ʻia ua lawa ia e hoʻihoʻi i nā palena i ko lākou kūlana mua me ka hoʻohana ʻana i ka ʻiole kamepiula. Akā, pono ʻoe e hoʻomalu pono i kēlā me kēia neʻe o ka cursor. A i ka hihia o ka nui o nā cell huna, hiki i kā lākou hōʻike ke lōʻihi loa. Akā hiki ke hana i kēia hana i loko o kahi mau kekona:

1. Pono e koho i ʻelua mau pūnaewele pili, a pono e loaʻa kahi huna huna ma waena o nā pūnaewele. A laila ma ka pahu hana "Cells" i ka papa kuhikuhi "Home" ʻike mākou i ka "Format" parameter.

2. Ke hoʻā ʻoe i kēia pihi ma ka papa kuhikuhi pop-up, e hele i ka ʻāpana "Hūna a hōʻike". A laila, koho i kekahi o nā hana - "Hōʻike Rows" a i ʻole "Hōʻike i nā Columns". ʻO ke koho e pili ana i nā pūnaewele huna. I kēia manawa, e hōʻike koke ʻia nā huna huna.

'Lelo Aʻoaʻo! ʻO ka ʻoiaʻiʻo, hiki ke maʻalahi kēia ʻano maʻalahi, a ʻo ka mea nui loa, e wikiwiki. No ka hoʻomaka ʻana, koho mākou ʻaʻole wale nā ​​​​pūnaewele pili, akā i nā lālani a i ʻole nā ​​kolamu e pili ana, ma ke kaomi ʻana i ka pihi ʻākau o ka ʻiole kamepiula, e ʻike ʻia kahi papa pop-up, kahi e koho ai mākou i ka "Show" parameter. E ʻike ʻia nā cell huna ma ko lākou wahi a hiki ke hoʻoponopono ʻia.

E kōkua kēia mau ʻano ʻelua i ka hōʻike ʻana a hōʻike i ka ʻikepili huna wale nō i ka hihia o ka huna lima ʻana o nā cell i ka pāpalapala Excel.

Ka Papa Hana 2: Wehe i nā Pūnaewele

ʻO kahi mea hana Excel i kapa ʻia ʻo ka hui ʻana e hiki ai iā ʻoe ke hūnā i kahi kikoʻī o nā cell ma ka hui pū ʻana iā lākou. Hiki ke hōʻike ʻia a hūnā hou ʻia nā ʻikepili huna me ka hoʻohana ʻana i nā pōkole kīwī kūikawā.

1. ʻO ka mea mua, nānā mākou i ka pepa Excel no nā pūnaewele ʻike huna. Inā loaʻa kekahi, a laila e ʻike ʻia kahi hōʻailona hoʻohui ma ka hema o ka laina a i ʻole ma luna o ke kolamu. Ke kaomi ʻoe i ka "+" e wehe ʻia nā pūʻulu hui āpau.

2. Hiki iā ʻoe ke hōʻike i nā wahi huna o kahi faila ma kahi ʻano ʻē aʻe. Ma ka wahi like o ka "+", aia kekahi mau helu. Maanei ʻoe e koho i ka waiwai nui. E hōʻike ʻia nā cell ke kaomi ʻoe i ka helu me ka pihi ʻiole hema.

3. Ma waho aʻe o nā ana manawa no ka hōʻike ʻana i nā cell, hiki ke hoʻopau loa ʻia ka hui ʻana. Koho mākou i kahi hui kūikawā o nā lālani a i ʻole nā ​​kolamu. A laila, ma ka ʻaoʻao i kapa ʻia ʻo "Data" ma ka "Structure" tool block, koho i ka ʻāpana "Ungroup".

4. No ka wehe koke ʻana i kahi hui, e hoʻohana i ka ʻaoʻao pōkole Alt+Shift+Left Arrow.

Kaʻina 3: E hoʻopau i ka kānana

ʻO kahi ala ikaika e ʻimi a hoʻonohonoho i ka nui o ka ʻike, ʻo ia ke kānana i nā waiwai papa. Pono e hoʻomanaʻo i ka wā e hoʻohana ai i kēia ʻano, hele kekahi mau kolamu i ka papa waihona i ke ʻano huna. E ʻike kākou i ka hōʻike ʻana o nā cell huna ma kēia ʻano i kēlā me kēia ʻanuʻu:

1. E koho i kahi kolamu i kānana ʻia e kekahi ʻāpana kikoʻī. Inā ʻeleʻele ka kānana, a laila hōʻike ʻia ia e kahi lepili funnel, aia ma ka ʻaoʻao o ka pua ma ka cell luna o ke kolamu.

2. Ke kaomi ʻoe i ka "funnel" o ka kānana, e ʻike ʻia kahi puka aniani me nā hoʻonohonoho kānana i loaʻa. No ka hōʻike ʻana i ka ʻikepili huna, koho i kēlā me kēia waiwai a i ʻole hiki iā ʻoe ke hoʻāla i ke koho "Select All". Kaomi "OK" e hoʻopau i nā hoʻonohonoho āpau.

3. Ke hoʻopau ʻia ke kānana ʻana, e hōʻike ʻia nā wahi huna a pau i ka pāpalapala Excel.

E makaʻala! Inā ʻaʻole e hoʻohana hou ʻia ka kānana, a laila e hele i ka ʻāpana "Sort and filter" i ka papa kuhikuhi "Data" a kaomi i ka "Filter", hoʻopau i ka hana.

Keʻano 4: Hōʻuluʻulu Pūnaewele

I kekahi mau hihia, makemake ʻoe e hūnā i nā waiwai i loko o kēlā me kēia cell. No ka hana ʻana i kēia, hāʻawi ʻo Excel i kahi hana formatting kūikawā. Ke hoʻohana nei i kēia ʻano, hōʻike ʻia ka waiwai i loko o ke kelepona ma ke ʻano ";;;", ʻo ia hoʻi, ʻekolu semicolons. Pehea e ʻike ai i ia mau cell a laila e hoʻolako iā lākou no ka nānā ʻana, ʻo ia hoʻi, hōʻike i kā lākou mau waiwai?

1. I loko o kahi faila Excel, ʻike ʻia nā cell me nā waiwai huna me he blank. Akā inā hoʻololi ʻoe i ke kelepona i ke ʻano hana, a laila e hōʻike ʻia ka ʻikepili i kākau ʻia i loko o ka laina hana.

2. No ka loaʻa ʻana o nā waiwai huna i loko o nā cell, koho i ka wahi i makemake ʻia a kaomi i ke pihi ʻiole ʻākau. I ka pukaaniani pop-up, koho i ka laina "Format Cells ...".

3. E hōʻike ʻia nā hoʻonohonoho hoʻonohonoho kelepona Excel ma ka puka aniani. Ma ka ʻaoʻao "Number", ma ke kolamu hema "Number formats", e hele i ka "(nā format āpau)", e ʻike ʻia nā ʻano āpau i loaʻa ma ka ʻākau, me ka ";;;".

4. I kekahi manawa hiki ke koho hewa ʻia ke ʻano kelepona - alakaʻi kēia i ka hōʻike hewa ʻana o nā waiwai. No ka hoʻopau ʻana i kēia hewa, e hoʻāʻo e koho i ke ʻano "General". Inā ʻike pono ʻoe i ka waiwai i loko o ke kelepona - kikokikona, lā, helu - a laila ʻoi aku ka maikaʻi o ke koho ʻana i ke ʻano kūpono.
5. Ma hope o ka hoʻololi ʻana i ke ʻano kelepona, hiki ke heluhelu ʻia nā waiwai i nā kolamu a me nā lālani i koho ʻia. Akā inā hōʻike hewa ʻia, pono ʻoe e hoʻāʻo me nā ʻano like ʻole - e hana maoli kekahi o lākou.

Video: Pehea e hōʻike ai i nā huna huna ma Excel

Aia kekahi mau wikiō maikaʻi loa e kōkua iā ʻoe e noʻonoʻo pehea e hūnā ai i nā cell i kahi faila Excel a hōʻike iā lākou.

No laila, i mea e aʻo ai pehea e hūnā ai i nā cell, manaʻo mākou e nānā i ke wikiō ma lalo nei, kahi e hōʻike pono ai ka mea kākau o ke wikiō i nā ala e hūnā ai i kekahi mau lālani a i ʻole nā ​​kolamu, a me ka ʻike i loko o ia mau mea.

Paipai mākou iā ʻoe e hoʻomaʻamaʻa iā ʻoe iho me nā mea ʻē aʻe e pili ana i ke kumuhana:

Ma hope o ka nānā pono ʻana i kekahi mau wikiō e pili ana i kēia kumuhana, hiki i kēlā me kēia mea hoʻohana ke hoʻokō i kahi hana e like me ka hōʻike ʻana a huna paha i kahi kelepona me ka ʻike ma nā papa Excel.

Panina

Inā pono ʻoe e hōʻike i nā cell huna, pono ʻoe e hoʻoholo ma ke ʻano o nā kolamu a me nā lālani i hūnā ʻia. Ma muli o ke ʻano i koho ʻia no ka hūnā ʻana i nā cell, e hoʻoholo ʻia i ke ʻano o ka hōʻike ʻana. No laila, inā hūnā ʻia nā cell ma ka pani ʻana i nā palena, a laila ʻaʻole e hoʻihoʻi ʻia ka palapala.

Inā hana ʻia ka palapala e kekahi mea hoʻohana, a koi ʻia kekahi e hoʻoponopono, a laila pono ʻoe e hoʻāʻo i kekahi mau ala a hiki i ka hōʻike ʻia ʻana o nā kolamu, nā lālani a me nā cell me nā ʻike āpau e pono ai.