Maitiro ekugadzira kana kubvisa hyperlinks muExcel

Nerubatsiro rwe hyperlinks muExle, iwe unogona kureva mamwe masero, matafura, mashizha, mafaira ezvimwe mifananidzo (mifananidzo, akasiyana-siyana, zvinhu zvakasiyana-siyana, webhusaiti, etc. Ivo vanoshanda kukurumidza kuenda kuchinhu chakataurwa kana uchidzvanya muchitokisi umo ivo vakaiswa. Ehe, gwaro rakaomeswa, kushandiswa kwechishandiso ichi kunongogamuchirwa chete. Naizvozvo, mushandisi anoda kudzidza kuti ashande zvakanaka mukubudira mune zvinongodiwa kunyatsoita hunyanzvi hwekugadzira uye kubvisa hyperlinks.

Zvinonakidza: Kugadzira hyperlink muMicrosoft Word

Kuwedzera hyperssril

Chekutanga pane zvese, funga nezvenzira dzekuwedzera hyperlink kune gwaro.

Nzira 1: Kuisa iyo isina kusarudzika hyperlink

Nzira iri nyore yekuisa nonsense link kune peji rewebhu kana email kero. Hypense hyperlink - ichi chakadai chinongedzo, kero iyo yakanyorwa zvakananga muchitokisi uye inoonekwa pane pepa pasina kuwedzera manipulations. Chinyorwa cheiyo Excel chirongwa ndechekuti chero zvisirizvo kutaura kwakabatanidzwa muchitokisi chinoshanduka kuita hyperlink.

Isa chinongedzo kune chero nzvimbo yepepa.

Zvino, paunotanga pachiteshi ichi, bhurawuza ichatanga, iyo yakaiswa nekusarudzika, uye inoenda kukero yakatarwa.

Saizvozvo, iwe unogona kuisa chinongedzo kune iyo email kero, uye ichangobva kushanda.

Nzira yechipiri: Kukurukurirana nefaira kana peji rewebhu kuburikidza nemusoro menyu

Nzira inonyanya kufarirwa yekuwedzera link link ndeye kushandisa mamiriro menyu.

1. Isu tinosimbisa iyo sero mati isu tiri kuenda kunoisa kubatana. Rudyi-tinya pairi. Mamino menyu anovhura. Mariri, sarudza chinhu "hyperlink ...".



2. Pakarepo mushure meizvozvo windo rinovhura. Mukuruboshwe kwehwindo, mabhatani anowanikwa nekudzvanya pane iyo iyo mushandisi anofanira kutsanangurira chinhu cherudzi rwacho rwunoda kusunga sero:
   • nefaira rekunze kana peji rewebhu;
   • nenzvimbo mugwaro;
   • negwaro idzva;
   • neemail.

   Sezvo isu tichida kuratidza nenzira iyi kuti tiwedzere hyperlink nechinongedzo nefaira kana peji rewebhu, tinosarudza chinhu chekutanga. Chaizvoizvo, hazvidikanwe kuzvisarudzira, sezvazvinoratidzwa nekukanganisa.



3. Muchikamu chepakati chehwindo kune iyo conductor nharaunda kusarudza faira. Nekusarudzika, muitisi anovhurwa mune imwecheteyo dhairekitori uko iro razvino Excel bhuku riripo. Kana chinhu chaunoda chiri mune imwe folda, iwe unofanirwa kudzvanya pane "faira yekutsvaga", inowanikwa pamusoro penzvimbo yeFerris.



4. Mushure meizvozvo, iyo yakajairwa faira rekusarudza hwindo rinovhura. Enda kune dhairekitori iwe yaunoda, tinowana iyo faira yatinoda kubatanidza sero, kugovera uye tinya pane "ok" bhatani.

   

   Tarisa! Kuti ugone kubatanidza sero nefaira neyekuwedzera mune chero yekuwedzera mubhokisi rekutsvaga, iwe unofanirwa kurongedza maficha faira switch ku "mafaera ese".

5. Mushure meizvozvo, iwo marongero efaira rakataurwa anowira mu "Kero" yeKuisa kweiyo hyperlink. Ingo tinya bhatani re "OK".

Iye zvino hyperlink yakawedzerwa uye kana iwe ukadzvanya pachiteshi chakakodzera, iyo faira yakataurwa ichavhura muchirongwa chakaiswa kuti uzvione nekumwe.

Kana iwe uchida kuisa chinongedzo kune yewebhu bhuku, ipapo mune iyo kero yekero iwe yaunoda kuti uise iyo URL kana kutevedzera ipapo. Ipapo iwe unofanirwa kudzvanya pane "OK" bhatani.

Nzira 3: Kukurukurirana nenzvimbo mugwaro

Mukuwedzera, zvinokwanisika kushamwaridzana nehasha cell ne chero nzvimbo mugwaro razvino.

1. Mushure mekunge sero raunoda rinosarudzwa uye rakakonzerwa nemusoro menyu yekuisa hwindo rekuisa hwindo reiyo hyperlink, isu tinoshandura bhatani kuruboshwe rwehwindo kune iyo "tete nenzvimbo mugwaro riri mugwaro" chinzvimbo.



2. Muchikamu "pinda kero yemusha" iwe unofanirwa kutsanangura marongero emasero ekuratidzwa.

   

   Panzvimbo iyoyo, pepa regwaro iri rinogona zvakare kusarudzwa mumunda wepazasi panogona kushandurwa kana kudzvanya muchitokisi. Mushure mekusarudza kuitwa, iwe unofanirwa kudzvanya pane "OK" bhatani.

Iye zvino sero rinobatanidzwa neine nzvimbo yebhuku razvino.

Nzira 4: Hyperlink kune gwaro idzva

Imwe sarudzo ndeye hyperlink kune gwaro idzva.

1. Mu "Insert Hyperlinks" hwindo, sarudza chinhu "tie negwaro nyowani".



2. Muchikamu chewindo repahwindo mu "Zita regwaro idzva" munda, iwe unofanirwa kudoma kuti bhuku racho rakagadzirwa richadanwa.



3. Nekudzikiswa, iyi faira ichaiswa mune iyo dhairekitori sebhuku razvino. Kana iwe uchida kuchinja nzvimbo, iwe unofanirwa kudzvanya pane "edit ..." bhatani.



4. Mushure meizvozvo, iyo standard gwaro rekusarudza hwindo rinovhura. Iwe unofanirwa kusarudza iyo folda yekuisa kwayo uye chimiro. Mushure meizvozvo, tinya pane "OK" bhatani.



5. Muzvirongwa zvacho "paunopinda negwaro nyowani", unogona kuvhura gwaro rekuchinja, Mushure mekunge marongero ese akagadzirwa, tinya bhatani re "OK".

Mushure mekuita chiito ichi, sero pane razvino pepa rinobatanidzwa nehynline nefaira idzva.

Nzira 5: Kukurukurirana neemail

Sero uchishandisa iyo link inogona kubatana kunyange ne-e-mail.

1. Mu "Insert Hyperlinks" Window, tinya pane "Tie neemail" bhatani.
2. Mu "email kero" munda, pinda iyo e-mail yatinoda kusanganisa sero. Mu "dingindira" munda, unogona kunyora musoro wenyaya. Mushure mekunge marongero aitwa, tinya pane "OK" bhatani.

Iye zvino sero rinobatanidzwa nekero yeemail. Paunodzvanya pairi, iyo email mutengi yakaiswa ne default inotangwa. Iwindo rayo richazadzwa mu-e-mail link uye chinyorwa cheshoko.

Nzira 6: Kuisa iyo hyperlinks kuburikidza nebhatani pane ribbon

Iyo hyperlink inogona zvakare kuiswa kuburikidza neiyo yakakosha bhatani pane ribhoni.

1. Enda kune "Insert" tab. Isu tinodzvanya pane "hyperlink" bhatani, iri patepi mu "zvinongedzo" zvishandiso.



2. Mushure meizvozvo, iyo "isa hyperlinks" hwindo rinotanga. Zvese zvekare chiito zvakanyatsofanana nekwakaisa kuburikidza nemukati memenyu. Ivo vanotsamira pane rudzii rwechinongedzo chaunoda kushandisa.

Nzira 7: Hyperlink Basa

Uye zvakare, iyo hyperlink inogona kugadzirwa uchishandisa yakakosha basa.

1. Isu tinosimbisa sero umo chinongedzo chichaiswa. Dzvanya pane "paste basa" bhatani.



2. Mune hwindo rekushanda rekushanda reWizard mabasa, kutsvaga zita rekuti "hyperlink". Mushure mekurekodha kukawanikwa, tinozviratidza uye tinya pane "OK" bhatani.



3. Nhaurwa dzebasa dzinovhura. Iyo hyperlink ine nharo mbiri: kero uye zita. Yekutanga inosungirwa, uye yechipiri sarudzo. Iyo "Kero" munda unoratidza kero yenzvimbo, email kana nzvimbo yefaira pane iyo hard disk yaunoda kubatanidza sero. Mu "zita" munda, kana zvichidikanwa, unogona kunyora chero izwi rinozoonekwa muchitokisi, nekudaro kuve anchor. Kana iwe ukasiya iyi munda usina chinhu, saka chinongedzo chicharatidzwa muchitokisi. Mushure mekunge marongero akagadzirwa, tinya pane "OK" bhatani.

Mushure meizvi zviito, sero rinobatanidzwa nechinhu kana nzvimbo, iyo yakanyorwa mune iyo link.

Chidzidzo: Wizard mabasa muExcel

Kubvisa hyperssril

Hakuna kukosha kukosha mubvunzo wekuti wokubvisa hyperlinks, nekuti dzinogona kutsamwiswa kana kuzvitsvakira zvimwe zvikonzero zvauchazoda kuchinja chimiro chegwaro.

Zvinonakidza: Maitiro ekubvisa hyperlinks muMicrosoft Word

Nzira 1: Kubvisa uchishandisa mamiriro emenyu

Nzira iri nyore yekudzima iyo link ndeye kushandisa mamiriro menyu. Kuti uite izvi, ingo tinya muchitokisi, umo chinongedzo chiri kuwanikwa, kurudyi-tinya. MuChamati Menyu, sarudza iyo "Delete hyperlink" chinhu. Mushure meizvozvo, ichabviswa.

Nzira yechipiri: Kubvisa basa reiyo hyperlink

Kana iwe uine chinongedzo muchitokisi uchishandisa chakakosha chimiro cheiyo hyperlink, saka hazvizoitiki kuti ubvume nenzira iri pamusoro apa. Kuti ubvise, iwe unofanirwa kuratidza sero uye tinya pane iyo Delete bhatani pane iyo keyboard.

Mune ino kesi, kwete chete kubatana pachayo kuchabviswa, asi zvakare zvinyorwa, sezvo zvanyatsobatanidzwa mune iri basa.

Nzira 3: Misa Kubviswa kweHyperlinks (Excel 2010 Shanduro uye Pamusoro)

Asi zvekuita kana paine yakawanda hyperlink mugwaro, nekuti kubvisa bhuku resaisikopo kunotora nguva yakawanda? MuExcel 2010 uye pamusoro, pane basa rinokosha raunogona kubvisa zvakati wandei zvakabatana panguva imwechete mumasero.

Sarudza masero aunoda kudzima zviungo. Rudyi-tinya mamiriro menyu uye sarudza "Delete hyperlinks".

Mushure meizvozvo, mumasero akasarudzwa wezvekunyora anozobviswa, uye rugwaro irwo richaramba riripo.

Kana iwe uchida kudzima mugwaro rose, iwe unotanga kufonera ctrl + kiyi pane kiyi. Naizvozvi, unosimbisa iyo yakazara pepa. Wobva wadzvanya bhatani rebushi re mbeva, fonera mamiriro emenyu. Mariri, sarudza "Delete hyperlinks".

Tarisa! Iyi nzira haina kukodzera kubvisa zvinongedzo kana iwe uchisunga masero uchishandisa iyo hyperlink basa.

Nzira yechina: Misa Kubviswa kweHyperlinks (shanduro yakambosvitswa 20)

Ko kana iwe uine yekutanga vhezheni yeExcel 2010 pakombuta yako? Ko zvese zvinongedzo zvinofanirwa kubviswa pamunhu here? Mune ino kesi, kune zvakare nzira yekubuda, kunyangwe ichiwedzera kuomarara kupfuura maitiro anotsanangurwa munzira yapfuura. Nenzira, iyo sarudzo imwechete inogona kuiswa kana iwe uchida mumhando dzinozotevera.

1. Isu tinoratidza chero sero risina chinhu pane pepa. Isu tinoisa manhamba manhamba 1. Dzvanya pane iyo "Kopa" bhatani mu "Imba" Tab kana Ingoita Score A CTRL + C Key musanganiswa paChidimbu paChidimbu.



2. Sarudza masero mune iyo hyperlinks inowanikwa. Kana iwe uchida kusarudza iyo ikhoramu, wobva wadzvanya pazita rayo pane rakakomberedza panel. Kana iwe uchida kuratidza iyo yakazara pepa, nyora iyo ctrl + keyboard. Dzvanya pane chakaratidzwa chinhu chine bhatani rekurudyi bhatani. Mune mamiriro ezvinhu menyu, tinya-mbiri pane "Special Insert ..." Item.



3. Hwaro hwakakosha isahwina hunovhura. Mu "kuvheva" marongero block, tinoisa chinja kune "kuwanda" chinzvimbo. Dzvanya pane "OK" bhatani.

Mushure meizvozvo, zvese hyperlinks zvichabviswa, uye chimiro chemasero akasarudzwa akagadzirwazve.

Sezvauri kuona, hyperlinks inogona kuve chishandiso chakanakira chekubatanidza kwete chete masero akasiyana egwaro rimwe chete, asi zvakare kuita kutaurirana nezvinhu zvekunze. Kubvisa zvidhinha kuri nyore kuita mumhando itsva dzebudiriro, asi zvakare mune shanduro dzechirongwa, kunewo mukana uchishandisa manipulation imwe chete yekuburitsa misa.