Hoʻohui i nā hyperlinklink Excel, nā kahamaʻi, a me nā memo Mailto

Ua noʻonoʻo pehea pehea e hoʻouka i nā leka uila, nā leka uila a me / a me nā leka uila i Excel? Eia nā pane maanei.

ʻO ka mea mua, e wehewehe i keʻano o kēlā me kēia hua'ōlelo.

Hiki iāʻoe ke kiliʻia kahi hyperlink e lele mai kahi pepa haʻawina i kahi pūnaewele pūnaewele, a hiki ke hoʻohanaʻia i Excel no ka hāʻawi wikiwiki a me ka maʻalahi i nā papa hana'ē aʻe Excel.

Hiki ke hoʻohanaʻia he kahakai e hana i kahi loulou i kekahi wahi ma ka pepa hana a iʻole i kahi papa hanaʻokoʻa ma loko o ka pūnaewele Excel e hoʻohana nei i nā kuhikuhi pūnaewele.

ʻO ka loulou loulou he loulou ia i kahi leka uila. Ke kāomi nei ma kahi leka uila e wehe i kahi leka uila hou ma ka papa kuhikuhi leka uila a hoʻokomo i ka leka uila ma hope o ka loulou i ka laina o ka leka.

Ma Excel, ua hoʻoholoʻia nā pūnaeweleʻelua a me nā hōʻailona e maʻalahi ai nā mea hoʻohana e hoʻokele i waena o nāʻikepili e pili ana. Hoʻomaopopo iā Mailto mau mea maʻalahi ke hoʻouna aku i ka leka uila i kekahi kanaka aiʻole hui. Ma nā hihia a pau:

• ʻAʻohe o nāʻano o ka loulou i hakuʻia - kelekahaka, bookmark, a me ka leka uila - ua hoʻokomoʻia i loko o ka pūkuhi pūnaeweleʻo Insert Hyperlink .
• E like me nā loulou i nā pūnaewele pūnaewele, ua louʻia nā loulou i Excel i kahi kuʻuna i nā mea i loko o ka pūnaewele pahukū.
• Hoʻohuiʻia kēia kikokikona heleuma ma mua o ka weheʻana i ka pahu pahu e hoʻohālike ana i ka hana o ka hanaʻana i ka loulou, akā hiki ke kākauʻia hoʻi ma hope o ka weheʻana o ka pahu dia.

E wehe i ka Insert Hyperlink Dialog Box

ʻO ka hui pūnaewele e wehe i ka pahuhopu Insert Hyperlink o Ctrl + K ma kahi PC a iʻole kauoha + K ma luna o ka Mac.

1. Ma kahi hana hana Excel, e kaomi i ka pūnaewele e komo i ka liʻikuʻi i mea e lilo ai i ka pūnaewele paʻa.
2. Kākau i kahi hua'ōlelo e hana i kahi moʻolelo pilina e like me "Pāpaʻi" a "June_Sales.xlsx" a pēhi i ka pihi komo ma ka papa keyboard.
3. E kaomi i ke kele me ka heleuma i ka manawaʻelua.
4. E kaomi a paomi i ke kī Ctrl ma ka papa keyboard.
5. E kaomi a hoʻokuʻu i ka kī palapala K i ka papa uila e wehe i ka pahu Kuhikau Laulua .

Pehea e wehe ai i ka hoʻokomoʻana i kahi pahuhoho diabolist me ka hoʻohanaʻana i kahi koho

1. Ma kahi hana hana Excel, e kaomi i ka pūnaewele e komo i ka liʻikuʻi i mea e lilo ai i ka pūnaewele paʻa.
2. E komo i ka pūkuhi kikokikona i loko o ke kele a pēhi i ka pihi komo ma ka papa keyboard.
3. E kaomi i ke kele me ka heleuma i ka manawaʻelua.
4. Kaomi iā Insert ma ka papa menu.
5. Kaomi ma ka pūnaewele Hyperlink e wehe i ka poʻi pūnaewele Hyperlink .

Hoʻohuiʻia nā Hyperlinks i Excel

Hiki iāʻoe ke hoʻonohonoho i kahi loulou loulou e lele i kahi pūnaewele aiʻole i kahi pūnaewele Excel. Eia keʻano:

Pākuʻi i kahi loulou pūnaewele i kahi pūnaewele pūnaewele

1. E wehe i ka pahuhopu Insert Hyperlink me ka hoʻohanaʻana i kekahi o nāʻano i ho'ākākaʻia ma luna nei.
2. Kaomi ma ka Pūnaewele Pūnaewele a iʻole ka Papa pūnaewele .
3. Ma ka lālani Address , e kaha i kahi kikowaena URL.
4. E kaomi iā OK e hoʻopiha i ka loulou pūnaewele a hoʻopau i ka pahu pahu.
5. Pono ka'ōkuhi ma ka pūnaewele hawina i kaʻulaʻula i ke kala a kuhikuhiʻia e hōʻike ana aia i loko o kahi loulou. I ka wā e kiliʻia ai, e wehe i kahi pūnaewele i waeʻia ma ka meaʻike pūnaewele paʻamau.

Hoʻohui i kahi Lē'ālua Honua i kahi Kōnae Excel

1. E wehe i ka pūkuhi pūnaeweleʻo kahi pūnaewele.
2. E kaomi i ka File Kuhi a i ka pūnaewele Pūnaewele paha .
3. Kaomi ma koho a koho i ka huliʻana i ka inoa o ka waihona Excel. Ke kāomi nei i ka inoa o ka inoa e hoʻohui i ka laina Address i loko o ka pahu kūkākūkā.
4. E kaomi iā OK e hoʻopiha i ka loulou pūnaewele a hoʻopau i ka pahu pahu.
5. Pono ka'ōkuhi ma ka pūnaewele hawina i kaʻulaʻula i ke kala a kuhikuhiʻia e hōʻike ana aia i loko o kahi loulou. I ka wā e kiliʻia ai, e weheʻia ka papaʻoihana Excel i kohoʻia.

Ke hoʻokumuʻana i nā kaha kuhikuhi i ka Pepa Haʻawina Same Excel

ʻO kahi pakuhi i Excel e like me kahi pūkahakahaka koe ke hoʻohanaʻia e hana i kahi loulou i kekahi wahi ma ka pepa hana a iʻole i kahi pepa haʻawina'ē aʻe ma loko o ka pūnaewele Excel like.

ʻOiai nā loulou pūnaewele e hoʻohana i nā inoa inoa e haku i nā loulou i nā waihona'ē aʻe Excel, nā pūlima e hoʻohana i nā kuhikuhiʻana o nā pūnaewele a me nā inoa hana e hana i nā loulou.

Pehea e hana ai i kahi kahakai i ka hoʻokahi hana

ʻO keʻano ma lalo nei e hana i kahi kahakiʻi i kahiʻokoʻa ma ka pepa haʻawina Excel like.

1. Kākau i kahi inoa i loko o kahi pūnaewele e hana ana e like me ka'ōlelo o kahi heleuma no ka kahamaina a pēhi i ke komo .
2. Kaomi ma kēlā pūnaewele e lilo ia i ke kamela paʻamau.
3. E wehe i ka pūkuhi pūnaeweleʻo kahi pūnaewele.
4. Kaomi ma kēiaʻaoʻao Palapala .
5. Ma lalo o keʻano o ka noʻonoʻo pūnaewele , e hoʻokomo i kahi kuhi pūnaewele i kekahi wahi'ē aʻe ma ka pepa hana hoʻokahi - e like me "Z100."
6. E kaomi iā OK e hoʻopiha i ka pakuhi a kāpuni i ka pahu pahu.
7. Pono ka'ōmole o ka pūnaewele ma keʻanoʻulaʻula i kaʻili a kuhikuhiʻia e loaʻa ana kahi kahakai.
8. E kaomi i ka markima a hoʻoneʻe ke kiʻi pūnaewele paʻa i ka mahele pūnaewele i hoʻokomoʻia no ka pakuhi.

Ke hoʻokumuʻana i nā kaha pūnaewele i nā papahana likeʻole

Ke hoʻokumuʻana i nā manaʻalima i nā waihona hana likeʻole ma loko o ka pūnaewele Excel likeʻole a iʻole ka papa hana lima he papa hou aʻe no kaʻikeʻana i ka pepa hana holomua no ka kahakai. Hiki i nā hana hana hōʻano hou ke maʻalahi i ka hoʻokumuʻana i nā kaha pūnaewele i nā waihona me kahi nui o nā pepa hana.

1. E wehe i kahi papa hana Excel-nui a iʻole e hoʻohui i nā pepa hou i kahi pūnaewele hoʻokahi.
2. Ma kahi o nā pepa, e kākau i kahi inoa i loko o ke kelepili e hana ma keʻano he heleuma no ka puke kaha.
3. Kaomi ma kēlā pūnaewele e lilo ia i ke kamela paʻamau.
4. E wehe i ka pūkuhi pūnaeweleʻo kahi pūnaewele.
5. Kaomi ma kēiaʻaoʻao Palapala .
6. E hoʻokomo i kahi kuhi pūnaewele ma ka māhele ma lalo o keʻano i loko o ke kūmole pūnaewele .
7. I ka Or a i koho i kekahi wahi ma kēia kahua kahua, e kaomi i ka inoa o ka destination. ʻO nā pepa inoaʻole i kapaʻiaʻo Sheet1, Sheet2, Sheet3, a pēlā aku.
8. E kaomi iā OK e hoʻopiha i ka pakuhi a kāpuni i ka pahu pahu.
9. Pono ka'ōmole o ka pūnaewele ma keʻanoʻulaʻula i kaʻili a kuhikuhiʻia e loaʻa ana kahi kahakai.
10. E kaomi i ka markima a pono e neʻe ka poho pūnaewele paʻa i ka mahele pūnaewele ma luna o ka pepa i komo no ka kahakala.

E hoʻokomo i kahi pūnaewele Mailto i loko o kahi Kōnae Excel

Hoʻohuiʻia kaʻike pilikino i kahi hana hana Excel i maʻalahi e hoʻouna i kahi leka uila mai loko o ka palapala.

1. Kākau i kahi inoa i loko o kahi pūnaewele e hanaʻia ma keʻano o ka heleuma hele no ka link mailto. Kuomi kaomi.
2. Kaomi ma kēlā pūnaewele e lilo ia i ke kamela paʻamau .
3. E wehe i ka pūkuhi pūnaeweleʻo kahi pūnaewele.
4. Kaomi ma ka pākuhi Leka uila .
5. Ma ka māka inoa o ka leka uila, e hoʻokomo i ka leka uila o ka mea lawe mai o ka loulou. Hoʻopaʻaʻia kēia helu i ka laina o kahi leka uila hou i ke kaomiʻana o ka loulou.
6. Ma lalo o ka Māmala'ōlelo , e hoʻokomo i ke kumuhana no ka leka uila. Ua hoʻokomoʻia kēia kikokikona i ka laina kumu ma ka memo hou.
7. E kaomi iā OK e hoʻopiha i ka loulou mailto a hoʻopau i ka pahu pahu.
8. Pono ka'ōkuhi ma ka pūnaewele hawina i kaʻulaʻula i ke kala a kuhikuhiʻia e hōʻike ana aia i loko o kahi loulou.
9. Kaomi ma ka pūnaewele mailto, aʻo ka papahana leka uila e pono e wehe i kahi leka uila me ka helu a me nā kikokikona i kākauʻia.

Ke wehe nei i kahi louwili pūnaewele me ka laweʻole i ka kikokikona

Keʻoleʻoe e pono hou i kahi loulou loulou, hiki iāʻoe ke wehe i kaʻike o ka loulou me ka weheʻole i kahi kikokikona i hanaʻia ma keʻano he heleuma.

1. E hoʻonohonoho i ka poʻomina kume i ka pūnaeka e hoʻoneʻeʻia. Hiki ke hoʻololi i ka hōʻailona arrow i ka hōʻailona lima.
2. E kaomi'ākau i ka kikokikona pilina liʻiliʻi e wehe i ka papa iho iho o ka Hōʻanoho Kūpili.
3. Kaomi ma ka weheʻana i ka'ōnaehana Hyperlink ma ka papa inoa.
4. Pono e weheʻia ka'ōuli polū a me ke kahakuhi mai ka'ōlelo o ka heleuma e hōʻike ana i ka weheʻia o kahi loulou.