Kuwedzera Excel Hyperlinks, Bookmarks, uye Mailto Links

Wamboshamisika kuti ungawedzera sei hyperlinks, bookmarks uye / kana mailto links mu Excel? Mhinduro dziri pano.

Chokutanga, ngatitsanangurire zvatinoreva nega rega.

A hyperlink inogona kudonhedzwa kuti idzike kubva pane pepa rekushandisa kune webpage, uye inogona kushandiswa zvakare muExcel kuti ipe nekukurumidza nekuwana nyore kune mamwe mabhuku ekushanda Excel.

Bhuku rinogona kushandiswa kugadzira chibvumirano kune imwe nzvimbo munzvimbo ino yepajiro yepaji kana kuti pane rimwe pepaji rebasa mukati memabhii eExcel imwecheteyo uchishandisa magwaro.

A mailto link is a link to an email. Kushanda pa mailto link kunozarura firiji itsva yemuvharimi mu program ye email yega yega uye inoisa email yekuseri kweiyo link kusvika kuMutsetse wemashoko.

MuExcel, zvose ma-hyperlink uye mabhukimeni zvakagadzirirwa kuita kuti zvive nyore kune vashandisi kuti vaende pakati pezvinhu zvakabatana. Mailto links zvinoita kuti zvive nyore kutumira mharidzo yeimeri kune mumwe munhu kana sangano. Muzviitiko zvose:

• Hazvina mhosva kuti mhando ipi yekubatana yakasikwa - hyperlink, bookmark, kana link mailto link - inopinda muIndaneti Hyperlink dialog box.
• Kufanana nehutano mumapeji ewebhu, hukama huri muExcel hunobatanidzwa kumagwaro ekugadzirisa ari mukati memusero webasa.
• Kuwedzera iyi magwaro anchor asati avhura bhokisi rebhokisi rinotsanangurira basa rekusika chibatanidza, asi rinogonawo kupinda mushure mekunge bhokisi rebhokisi razaruka.

Vhura bhokisi reDhialogyo reInternet Hyperlink

Iko kusanganiswa kwekuvhara iyo Insert Hyperlink dialog box ndiyo Ctrl + K pane PC kana Command + K pane Mac.

1. Muchikamu chekushanda che Excel, chengeta pane sero inofanira kuva ne hyperlink kuti iite sero rinoshanda.
2. Tora shoko kuti uite seanchor text se "Spreadsheets" kana kuti "June_Sales.xlsx" uye pinda paImpikicha pabhodhi.
3. Dzvanya pane sero nemashoko anchor yechipiri.
4. Dhinda uye ubatisise kamba Ctrl pane keyboard.
5. Dhinda uye ubudise tsamba K kadhi pabhokisi kuti uzarure Insert Hyperlink dialog box.

Nzira Yokuzarura Sei Insert Hyperlink Bhokisi Rekushandisa Kushandisa Imuteri Menyu

1. Muchikamu chekushanda che Excel, chengeta pane sero inofanira kuva ne hyperlink kuti iite sero rinoshanda.
2. Pinda mutsetse wekunyorera mukati memutokisi uye diya kuIta yeki yekibhokisi.
3. Dzvanya pane sero nemashoko anchor yechipiri.
4. Dzvanya kuNyorera pane bhari yemenyu.
5. Dzvanya paIxperlink icon kuti uzarure Insert Hyperlink dialog box.

Kuwedzera Hyperlinks mu Excel

Iwe unogona kuisa hyperlink kusvetuka kune webpage kana kuti kune Excel file. Heino nzira:

Kuwedzera Hyperlink kune Webpage

1. Vhura Insert Hyperlink dialog box uchishandisa imwe yenzira dzakataurwa pamusoro apa.
2. Dzvanya paIndaneti Page kana Faira tab.
3. Mune Address Address , tora mazita e-URL yakazara.
4. Dzvanya OK kuti upedze hyperlink uye uvhare bhokisi rebhokisi.
5. Mutsara wekunyorera mumusero we worksheet unofanira kunge uri bhuruu muvara uye wakatsanangurwa unoratidza kuti une hyperlink. Chero pese pazvinenge zvanyorwa, zvichazarura webusaiti yakatarwa mumusikana wekutsvaga.

Kuwedzera Hyperlink kune An Excel File

1. Vhura Insert Hyperlink dialog box.
2. Dzvanya paDhiyabhorosi iripo kana kuti Peji Peji tab.
3. Dzvanya pane Sarudza uye shandisa kuti uwane iyo Excel file yezita. Kushandura zita refaira rinowedzera kuIndaneti mubhokisi rebhokisi.
4. Dzvanya OK kuti upedze hyperlink uye uvhare bhokisi rebhokisi.
5. Mutsara wekunyorera mumusero we worksheet unofanira kunge uri bhuruu muvara uye wakatsanangurwa unoratidza kuti une hyperlink. Pose pazvinenge zvanyorwa, ichazarura bhuku rakasarudzwa reAcelcel.

Kuumba mabhokiti kuSame Excel Worksheet

Bhukukiti muExcel rakafanana ne hyperlink kunze kwekuti inoshandiswa kugadzira chibvumirano kune imwe nzvimbo pane pepa rekushanda irizvino kana kuti pane rimwe pepaji rekushandisa mukati meefomu yeExcel imwecheteyo.

Kunyange zvazvo hyperlinks kushandisa mazita ekufaira kuti zvive nehukama kune dzimwe mafaira eExpcel, mabhukimakhi anoshandisa zvikwereti zvemasero uye mazita ekushandura mapeji ekuumba hukama.

Nzira Yokugadzira Chikwangwani Pamwe Pepa Rokushanda

Muenzaniso unotevera unoita bhukimeni kune imwe nzvimbo munzvimbo imwechete yekushanda ye Excel.

1. Tora zita mune imwe sero iyo ichaita semagwaro anchor ebhukumakiti uye diya Enter .
2. Dzvanya pane iyo sero kuitira kuti iite sero rinoshanda.
3. Vhura Insert Hyperlink dialog box.
4. Dzvanya pane iyi Nyumburu tab.
5. Pasi Paya Tora cell reference , pinda se cell reference pane imwe nzvimbo pane peji rimwechete - se "Z100."
6. Dzvanya OK kuti upedze bhakisiro uye uvhare bhokisi rebhokisi.
7. Mutsara wekunyorera mumusero we worksheet unofanira kunge uri bhuruu muvara uye wakatsanangurwa unoratidza kuti une bhakisikiti.
8. Dzvanya pa bhakisikiti uye iyo inoshanda se cell cursor inotamira kune seferensi yakaiswa yakaiswa yebhukiti.

Kuumba mabhokiti kune mamwe mapepa eMabasa

Kuumba mabhukimiti kune mamwe mahwhepa emabasa mukati memamwechete Excel file kana bhuku rebhuku rine danho rinowedzera rekutsvaga bhasiro rekuenda kwebhukiti. Kudzokorora mapepa ebasa kunogona kuita kuti zvive nyore kugadzira mabhukukiti mumafaira ane nhamba yakawanda yemashizha.

1. Vhura bhuku remabhuku akawanda reExpcel kana kuwedzera mamwe mahwiti kune imwe pepa faira.
2. Pane imwe yemashizha, chengeta zita mune imwe sero kuti uite semagwaro ekugadzirisa mabhuku.
3. Dzvanya pane iyo sero kuitira kuti iite sero rinoshanda.
4. Vhura Insert Hyperlink dialog box.
5. Dzvanya pane iyi Nyumburu tab.
6. Pinda sero rinotarisa mumunda pasi Pechidimbu mumutsetse .
7. MuneOri sarudza nzvimbo mundima iyi yedhadhi , tanga pane zita rekuenda kwepepa. Mazita asina mazita anozivikanwa seSheet1, Sheet2, Sheet3 nezvimwewo.
8. Dzvanya OK kuti upedze bhakisiro uye uvhare bhokisi rebhokisi.
9. Mutsara wekunyorera mumusero we worksheet unofanira kunge uri bhuruu muvara uye wakatsanangurwa unoratidza kuti une bhakisikiti.
10. Dzvanya pa bhakisikiti uye inoshandiswa se cell cursor inofanira kuendesa kusero rinoshandiswa pane peji rakapinda bhukimaki.

Isa Mailto Yakabatanidza MuExcel File

Kuwedzera ruzivo rwemashoko kune imwe Excel worksheet kunoita kuti zvive nyore kutumira email kubva mukati mebhuku.

1. Tora zita mune imwe sero iyo ichaita semashoko anchor ekutumira mailto. Dhinda Press.
2. Dzvanya pane iyo sero kuitira kuti iite sero rinoshanda .
3. Vhura Insert Hyperlink dialog box.
4. Dzvanya pa Email Address Address tab .
5. Mune email address address , shandisa idiresi ye email yewaini yekugamuchira. Iri kero inopindwa muIndaneti yemumwe mutsara we email kana hubatanidza hunoiswa.
6. Pasi Pechidzidzo cheNyaya, shandisa nyaya ye email. Uyu rugwaro rwakapinda mumutsara wehurukuro mumutumwa mutsva.
7. Dzvanya OK kuti upedze mailto link uye uvhare bhokisi rebhokisi.
8. Mutsara wekunyorera mumusero we worksheet unofanira kunge uri bhuruu muvara uye wakatsanangurwa unoratidza kuti une hyperlink.
9. Dzvanya pa mailto link, uye purogiramu ye email yega yega inofanira kuzarura mutsva mutsva nekero uye zvinyorwa zvakanyorwa.

Kubvisa Hyperlink Pasina Kubvisa Anchor Text

Paunenge usisada hyperlink, unogona kubvisa ruzivo rwemashoko pasina kubvisa mashoko akashanda sechombo.

1. Isa nzvimbo inonzi mouse pointer pane hyperlink kuti ibvise. Mushonga unobva mumuseve unofanirwa kuchinja kusvika muruoko rwechiratidzo.
2. Tsva-kora pamagwaro ekutsanangurira anchor kuti uzarure mamiriro ekuderera pasi.
3. Dzvanya paIbvisa Hyperlink sarudzo mumenyu.
4. Rudzi ruvara rwebhuruu uye tsananguro inofanira kubudiswa kubva pamashoko anchokwe anoratidza kuti hyperlink yakabviswa.