Pehea e hoʻopaʻa inoa ai i kahi cell ma kahi pāpalapala Excel. Pehea e inoa ai i kahi laulā ma excel

No ka hoʻokō ʻana i kekahi mau hana ma ka pāpalapala, pono kahi ʻike kaʻawale o nā cell a i ʻole ko lākou mau pae. Hiki ke hāʻawi ʻia kēlā me kēia o lākou i kahi inoa, kōkua ka haʻawina i ka papa hana pālahalaha e hoʻomaopopo i kahi o kēia a i ʻole kēlā mea ma ka pepa haʻawina. E uhi ka ʻatikala i nā ala āpau e hāʻawi ai i kahi inoa i ke kelepona ma ka papaʻaina.

Kapa inoa

Hiki iā ʻoe ke hāʻawi i kahi inoa i kahi ʻāpana a i ʻole ka laulā ma kahi pālahalaha me ka hoʻohana ʻana i kekahi mau ala, a mākou e kūkākūkā ai ma lalo nei.

Hana 1: inoa string

ʻO ke komo ʻana i ka inoa ma ka laina inoa ʻo ia ke ala maʻalahi a maʻalahi. Aia ka laina o nā inoa ma ka hema o ke kahua no ka hoʻokomo ʻana i nā formula. ʻO ka ʻōlelo aʻoaʻo step-by-step e like me kēia:

1. Koho mākou i ka laulā a i ʻole hoʻokahi māhele o ka papaʻaina.

2. Ma ka laina o nā inoa mākou e hoʻokele i ka inoa pono no ka wahi i koho ʻia. I ke komo ʻana, pono ʻoe e noʻonoʻo i nā lula no ka hāʻawi ʻana i kahi inoa. Ma hope o ka hoʻokō ʻana i nā manipulations āpau, e kaomi i ke pihi "Enter" ma ka papa keyboard.

3. Mākaukau! Ua hana mākou i ka inoa ʻana i ke kelepona a i ʻole ka laulā o nā cell. Inā koho ʻoe iā lākou, a laila e ʻike ʻia ka inoa a mākou i hoʻokomo ai ma ka laina o nā inoa. Hōʻike mau ʻia ka inoa o ka wahi i koho ʻia ma ka laina inoa, me ka nānā ʻole i ke ʻano o ka hāʻawi ʻia ʻana o ka inoa.

Kaʻina 2: ka papa kuhikuhi pili

He mea kōkua ka papa kuhikuhi no ka hoʻokō ʻana i ka inoa kelepona. ʻO ka hele ʻana e like me kēia:

1. Hana mākou i kahi koho o ka wahi a mākou e manaʻo ai e hāʻawi i kahi inoa. Kaomi mākou iā RMB. Hōʻike ʻia kahi papa kuhikuhi liʻiliʻi ma ka pale. Loaʻa iā mākou ka mea "Assign a name ..." a kaomi ma luna.

2. Ua ʻike ʻia kahi pukaaniani liʻiliʻi hou ma ka pale i kapa ʻia ʻo "Creating a Name". Ma ka laina "Name" pono ʻoe e hoʻokomo i ka inoa āu e makemake ai e hoʻonohonoho i ka wahi i koho ʻia.
3. Ma ka laina "Region" hōʻike mākou i kahi kahi, i ka wā e kamaʻilio ai i kahi inoa i hāʻawi ʻia, e hoʻoholo ʻia ka ʻāpana i koho ʻia. Hiki i ka ʻāpana ke palapala holoʻokoʻa a i ʻole nā ​​​​pepa hana ʻē aʻe o ka palapala. ʻO ka maʻamau, waiho ʻia kēia ʻāpana me ka loli ʻole.
4. Aia ka laina "Note" i nā memo ʻokoʻa loa e wehewehe ana i kahi ʻikepili i koho ʻia. Hiki ke waiho hakahaka ʻia ke kahua no ka mea ʻaʻole i manaʻo ʻia kēia waiwai.
5. Ma ka laina "Range", e hoʻokomo i nā kikowaena o ka wahi ʻikepili kahi a mākou e kau ai i kahi inoa. Hoʻokomo ʻia nā koina o ka laulā i koho mua ʻia ma kēia laina.
6. Ma hope o ka hoʻokō ʻana i nā manipulations a pau, kaomi "OK".

7. Mākaukau! Ua hāʻawi mākou i kahi inoa i ka ʻikepili me ka hoʻohana ʻana i ka papa kuhikuhi kikoʻī spreadsheet Excel.

Kaʻina 3: E hoʻonoho i kahi poʻo inoa me ke pihi ma ka lipine

Me ke kōkua o nā mea hana kūikawā aia ma ka lipine, hiki iā ʻoe ke kuhikuhi i ka inoa o ka wahi ʻikepili. ʻO ka hele ʻana e like me kēia:

1. Hana mākou i kahi koho o ka wahi a mākou e manaʻo ai e hāʻawi i kahi inoa. Hele mākou i ka ʻāpana "Formulas". Loaʻa iā mākou ka poloka o nā kauoha "Na inoa i wehewehe ʻia" a kaomi i ka mea "E hāʻawi i kahi inoa" ma kēia papa.

2. Hōʻike ka pale i kahi puka liʻiliʻi i kapa ʻia "E hana i kahi inoa", a mākou i ʻike ai mai ke ʻano mua. Hana mākou i nā manipulations a pau e like me ka laʻana i manaʻo ʻia ma mua. Kaomi "OK".
3. Mākaukau! Ua hāʻawi mākou i ka inoa o ka ʻāpana ʻikepili me ka hoʻohana ʻana i nā mea i loaʻa ma ka lipine hāmeʻa.

Kaʻina 4: Luna inoa

Ma o kahi mea i kapa ʻia ʻo "Name Manager", hiki iā ʻoe ke hoʻonohonoho i kahi inoa no ka wahi ʻikepili i koho ʻia. ʻIke ʻia ka hele ʻana penei:

1. Hele mākou i ka ʻāpana "Formulas". E ʻimi i ka poloka kauoha "Defined Names" a kaomi ma ka "Name Manager" element ma kēia papa.

2. Ua hōʻike ʻia kahi pukaaniani liʻiliʻi "Name Manager ..." ma ka hōʻike. No ka hoʻohui ʻana i kahi inoa hou no ka wahi ʻikepili, kaomi i ka mea "Create ...".

3. Hōʻike ka hōʻike i kahi puka aniani i kapa ʻia ʻo "Assign a name." E like me nā ʻano i hōʻike ʻia ma luna nei, hoʻopiha mākou i nā kahua āpau me ka ʻike pono. Ma ka laina "Range" e hoʻokomo i nā kikowaena o ka wahi e hāʻawi i kahi inoa. No ka hana ʻana i kēia, pono ʻoe e kaomi mua ma ke kahua hakahaka kokoke i ka palapala "Range", a laila koho i ka wahi i makemake ʻia ma ka pepa ponoʻī. Ma hope o ka hoʻokō ʻana i nā manipulations a pau, kaomi i ka mea "OK".

4. Mākaukau! Hāʻawi mākou i kahi inoa i ka ʻikepili me ka hoʻohana ʻana i ka "Name Manager".

E makaʻala! ʻAʻole pau ka hana o ka "Name Manager" ma laila. Hāʻawi ka luna i ka hana ʻana i nā inoa wale nō, akā hiki iā ʻoe ke hoʻokele iā lākou, a me ka holoi ʻana iā lākou.

ʻO ka pihi "Change..." hiki iā ʻoe ke hoʻoponopono i ka inoa. No ka hana ʻana i kēia, pono ʻoe e koho mua i kahi komo mai ka papa inoa, kaomi ma luna, a laila kaomi "Edit ...". Ma hope o ka hoʻokō ʻana i nā hana āpau, e lawe ʻia ka mea hoʻohana i ka puka makani "Assign a name", kahi e hiki ai ke hoʻoponopono i nā ʻāpana i loaʻa.

ʻO ke pihi "Delete" hiki iā ʻoe ke hoʻopau i ke komo. No ka hana ʻana i kēia, koho i ke komo i makemake ʻia, a laila kaomi i ka mea "Delete".

Ma hope o ka pau ʻana o kēia mau ʻanuʻu, e ʻike ʻia kahi puka aniani hōʻoia liʻiliʻi. Kaomi mākou "OK".

I nā mea ʻē aʻe a pau, aia kahi kānana kūikawā ma ka Name Manager. Kōkua ia i nā mea hoʻohana e koho a koho i nā mea komo mai ka papa inoa o nā poʻo inoa. Pono ka hoʻohana ʻana i kahi kānana i ka wā e hana ai me ka nui o nā poʻo inoa.

Kapa inoa i ka mea mau

Pono ka hāʻawi ʻana i kahi inoa i ka mea mau inā he paʻakikī ka paʻakikī a hoʻohana pinepine paha. ʻO ka hele ʻana e like me kēia:

1. Hele mākou i ka ʻāpana "Formulas". ʻIke mākou i ka poloka o nā kauoha "Na inoa i wehewehe ʻia" a koho i ka mea "E hāʻawi i kahi inoa" ma kēia papa.
2. Ma ka laina "Name" komo mākou i ka mea mau, no ka laʻana, LnPie;
3. Ma ka laina "Range" e hoʻokomo i kēia ʻano: =3*LN(2*ROOT(PI()))*PI()^EXP(1)

4. Mākaukau! Ua hāʻawi mākou i inoa i ka mea mau.

Ka inoa ʻana i kahi cell a me ka formula

Hiki iā ʻoe ke inoa i ke ʻano. ʻO ka hele ʻana e like me kēia:

1. Hele mākou i ka ʻāpana "Formulas". ʻIke mākou i ka poloka o nā kauoha "Nā inoa i wehewehe ʻia" a kaomi i ka mea "Assign a name" ma kēia papa.
2. Ma ka laina "Name" komo mākou, no ka laʻana, "Day_of the week".
3. Ma ka laina "Region" waiho mākou i nā hoʻonohonoho āpau ʻaʻole i loli.
4. Ma ka laina "Range" komo ={1;2;3;4;5;6;7}.
5. Kaomi ma ka "OK" element.
6. Mākaukau! I kēia manawa, inā koho mākou i ʻehiku mau pūnaewele ma ka pae, paʻi mākou = La o ka pule i ka laina no nā formulas a kaomi "CTRL + SHIFT + ENTER", a laila e hoʻopiha ʻia ka wahi i koho ʻia me nā helu mai hoʻokahi a ʻehiku.

Kapa inoa ʻana i kahi pae

ʻAʻole paʻakikī ka hāʻawi ʻana i kahi inoa i ka laulā o nā cell. ʻO ka hele ʻana e like me kēia:

1. Koho mākou i ka laulā o nā ʻāpana i makemake ʻia.
2. Hele mākou i ka ʻāpana "Formulas". ʻIke mākou i ka poloka o nā kauoha "Na inoa i wehewehe ʻia" a kaomi i ka mea "Hana mai ke koho" ma kēia papa.
3. Nānā mākou i ka ʻaoʻao o ka māka ma ke ʻano "Ma ka laina ma luna."
4. Kaomi mākou ma "OK".
5. Me ke kōkua o ka "Name Manager", hiki iā ʻoe ke nānā i ka pololei o ka inoa.

Kapa inoa papa

Hiki iā ʻoe ke hāʻawi i nā inoa i ka ʻikepili papa. ʻO kēia nā papa i hoʻomohala ʻia me ke kōkua o nā manipulations i hana ʻia ma ke ʻano penei: Insert / Tables / Table. Hā'awi 'o ka papa hana papapalapala i nā inoa ma'amau (Table1, Table2, a pēlā aku). Hiki iā ʻoe ke hoʻoponopono i ke poʻo inoa me ka hoʻohana ʻana i ka Table Builder. ʻAʻole hiki ke hoʻopau ʻia ka inoa papa ma kekahi ʻano ma o ka "Name Manager". Aia ka inoa a hiki i ka waiho ʻana o ka pākaukau ponoʻī. E nānā i kahi hiʻohiʻona liʻiliʻi o ke kaʻina hana o ka hoʻohana ʻana i ka inoa papa:

1. No ka laʻana, loaʻa iā mākou kahi pā me ʻelua kolamu: Huahana a me ke kumukūʻai. Ma waho o ka papaʻaina, e hoʻomaka e hoʻokomo i ke ʻano: =SUM(Pakaukau1[koina]).
2. I kekahi manawa i ka hoʻokomo, e koi ʻia ka pāpalapala iā ʻoe e koho i kahi inoa papa.

3. Ma hope o ko mākou komo ʻana =SUM(Pakaukau1[, E koi ka polokalamu iā ʻoe e koho i kahi kahua. Kaomi "Cost".

4. I ka hopena, loaʻa iā mākou ka nui ma ke kolamu "Cost".

Nā rula syntax no nā inoa

Pono ka inoa e hoʻokō i nā lula syntactic penei:

• ʻO ka hoʻomaka ʻana he leka wale nō, kahi slash, a i ʻole kahi kaha lalo. ʻAʻole ʻae ʻia nā helu a me nā huaʻōlelo kūikawā ʻē aʻe.
• ʻAʻole hiki ke hoʻohana ʻia nā hakahaka ma ka inoa. Hiki ke pani ia lakou me ke ano underscore.
• ʻAʻole hiki ke wehewehe ʻia ka inoa ma ke ʻano he helu kelepona. I nā huaʻōlelo ʻē aʻe, ʻaʻole hiki ke hoʻohana i ka "B3: C4" ma ka inoa.
• ʻO ka lōʻihi o ke poʻo inoa he 255 huapalapala.
• Pono ka inoa ma ka waihona. He mea nui e hoʻomaopopo i ka wehewehe ʻana o nā leka like i kākau ʻia ma ka poʻokela a me ka liʻiliʻi e like me ke kaʻina hana pālahalaha. No ka laʻana, ʻo "hello" a me "hello" ka inoa like.

ʻIke a nānā i nā inoa i wehewehe ʻia i loko o kahi puke

Nui nā ʻano e ʻimi a nānā i nā poʻo inoa ma kahi palapala. ʻO ke ala mua e pili ana i ka hoʻohana ʻana i ka "Name Manager" aia ma ka ʻāpana "Name inoa" o ka ʻāpana "Formulas". Maanei hiki iā ʻoe ke ʻike i nā waiwai, nā manaʻo, a me ke ʻano. ʻO ke ala ʻelua e pili ana i ka hoʻokō ʻana i kēia algorithm o nā hana:

1. Hele mākou i ka ʻāpana "Formulas".
2. E hele i ka poloka "Defined Names".
3. Kaomi ma ka "Use formulas".
4. Kaomi "Insert Names".
5. Hōʻike ʻia kahi puka makani i kapa ʻia ʻo "Insert Name" ma ka pale. Kaomi "Na inoa a pau". E hōʻike ka pale i nā poʻo inoa āpau i loaʻa i ka palapala me nā pae.

ʻO ke ala ʻekolu e pili ana i ka hoʻohana ʻana i ke kī "F5". Ke kaomi ʻana i kēia kī e hoʻāla i ka hāmeʻa Jump, kahi e hiki ai iā ʻoe ke hoʻokele i nā cell i kapa ʻia a i ʻole nā ​​pae o nā cell.

Ka Inoa

Loaʻa i kēlā me kēia inoa kona laulā ponoʻī. Hiki ke ʻāpana he pepa hana a i ʻole ka palapala holoʻokoʻa holoʻokoʻa. Hoʻonohonoho ʻia kēia ʻāpana i ka puka aniani i kapa ʻia "E hana i kahi inoa", aia ma ka poloka "Na inoa i wehewehe ʻia" o ka ʻāpana "Formulas".

Panina

Hāʻawi ʻo Excel i nā mea hoʻohana i kahi helu nui o nā koho no ka inoa ʻana i kahi kelepona a i ʻole kahi ʻano o nā cell, i hiki i nā mea a pau ke koho i ke ala kūpono loa e kau inoa i ka wā e hana ai i kahi pālahalaha.