Nigute ushobora gukora cyangwa gukuraho hyperlinks muri excel

Hamwe nubufasha bwa hyperlinks muri Excele, urashobora kwerekeza ku zindi selile, ameza, impapuro, ibitabo, amadosiye andi mashusho (amashusho, ibikoresho byinshi, nibindi. Bakora vuba ku kintu cyagenwe iyo bakanze ku kagari binjizwamo. Nibyo, muburyo bugoye butubatswe, gukoresha iki gikoresho birakaze gusa. Kubwibyo, umukoresha ushaka kwiga gukora neza muri Excele arakenewe gusa kumenya ubuhanga bwo gukora no gukuraho hyperlinks.

Birashimishije: Gukora hyperlink mu Ijambo rya Microsoft

Ongeraho hypersril

Mbere ya byose, suzuma uburyo bwo kongeramo hyperlink kuri inyandiko.

Uburyo 1: Shyiramo hyperlink

Inzira yoroshye yo gushyiramo ihuza urubuga cyangwa aderesi imeri. Hyperlink - iyi link, aderesi yacyo iteganijwe mu kagari kandi igaragara kurupapuro nta bindi bikoresho. Ikiranga cya gahunda ya Excel nuko havugwa ibitagenda neza mukagari bihinduka hyperlink.

Injiza ihuriro ahantu hose kurupapuro.

Noneho, iyo ukanze kuri iyi selile, mushakisha izatangira, ishyirwaho nuburyo busanzwe, ikajya kuri aderesi yagenwe.

Mu buryo nk'ubwo, urashobora gushira umurongo kuri aderesi imeri, kandi bizahita bikora.

Uburyo 2: Itumanaho hamwe na dosiye cyangwa urubuga kugeza kuri menu

Inzira izwi cyane yo kongeramo amahuza ni ugukoresha ibikubiyemo.

1. Turagaragaza selile tugiye gushyiramo isano. Kanda iburyo. Ibikubiyemo bifungura. Muri yo, hitamo ikintu "hyperlink ...".



2. Ako kanya nyuma yibyo idirishya ryinjije. Mu ruhande rw'ibumoso rw'idirishya, buto iherereye ukanze kuri imwe muri zo umukoresha agomba kwerekana hamwe nimpamvu yubwoko bwubwoko bushaka guhambira selile:
   • hamwe na dosiye yo hanze cyangwa urubuga;
   • hamwe n'ahantu mu nyandiko;
   • n'inyandiko nshya;
   • hamwe na imeri.

   Kubera ko dushaka kwerekana muri ubu buryo kugirango wongere hyperlink hamwe na dosiye cyangwa urubuga, duhitamo ikintu cya mbere. Mubyukuri, ntabwo ari ngombwa guhitamo, nkuko bigaragara mubitekerezo.



3. Mu gice cyo hagati yidirishya hari agace kayobora kugirango uhitemo dosiye. Mburabuzi, umuyobozi arakinguye mububiko bumwe aho igitabo cyitwa Extl giherereye. Niba ikintu cyifuzwa kiri mububiko, ugomba gukanda kuri buto ya "dosiye Shakisha", iherereye hejuru ya ferris.



4. Nyuma yibyo, idirishya risanzwe ryo gutoranya dosiye rifungura. Jya mububiko ukeneye, dusangamo dosiye dushaka guhuza selile, kugenera hanyuma ukande kuri buto "OK".

   

   Icyitonderwa! Kugirango ushobore guhuza akagari hamwe na dosiye hamwe na office iyo ari yo yose mu gasanduku k'ishakisha, ugomba guhinduranya ubwoko bwa dosiye hindukira kuri "dosiye zose".

5. Nyuma yibyo, guhuza dosiye byagenwe kugwa muri "aderesi" yo kwinjiza hyperlink. Kanda buto ya "OK".

Noneho hyperlink yongewe nigihe ukanze kuri selile ikwiye, dosiye yagenwe izafungura muri porogaramu yashizwemo kugirango ibone.

Niba ushaka gushiramo umurongo kumurongo wurubuga, hanyuma mumwanya wa aderesi ukeneye kugirango winjire url cyangwa wandukureyo. Noneho ugomba gukanda kuri buto "OK".

Uburyo 3: Itumanaho hamwe na plabment mu nyandiko

Byongeye kandi, birashoboka guhuza selile ya hyperlink hamwe numwanya uwo ariwo wose mumyandiko iriho.

1. Nyuma yingirabuzimafatizo iratoranijwe kandi iterwa n'imiterere yidirishya ryinjiza rya hyperlink, duhindura buto kuruhande rwibumoso rwidirishya kuri idirishya "umwanya.



2. Mu gice "Injira Aderesi ya selile" Ugomba kwerekana guhuza selile zerekeza.

   

   Ahubwo, urupapuro rwiyi nyandiko rushobora kandi gutorwa mumurima wo hasi aho inzibacyuho iyo ukanze ku kagari. Nyuma yo guhitamo byakozwe, ugomba gukanda kuri buto "OK".

Noneho selile izaba ifitanye isano n'ahantu runaka hateganijwe igitabo kiriho.

Uburyo 4: Hyperlink ku nyandiko nshya

Ubundi buryo ni hyperlink kuri inyandiko nshya.

1. Muri "shyiramo hyperlinks" idirishya, hitamo ikintu "gihuza inyandiko nshya".



2. Mu gice cyo hagati yidirishya muri "Izina ryinyandiko nshya", ugomba kwerekana uburyo igitabo cyaremwe kizahamagarwa.



3. Mburabuzi, iyi dosiye izashyirwa mububiko bumwe nkigitabo cyubu. Niba ushaka guhindura ahantu, ugomba gukanda kuri "guhindura ...".



4. Nyuma yibyo, idirishya risanzwe ryo kurema Idirishya rifungura. Uzakenera guhitamo ububiko bwayo no kumiterere. Nyuma yibyo, kanda kuri buto "OK".



5. Mu Igenamiterere rya Igenamiterere "Iyo winjiye mu nyandiko nshya", urashobora gushiraho kimwe mu bipimo bikurikira: ubungubu gifungure inyandiko yo guhinduka, cyangwa ubanza gukora inyandiko ubwayo na rimaze gufunga dosiye, hindura. Nyuma yimiterere yose ikorwa, kanda buto "OK".

Nyuma yo gukora iki gikorwa, selile kurupapuro ruzahuzwa na hyperlink hamwe na dosiye nshya.

Uburyo 5: Gutumanaho hamwe na imeri

Akagari ukoresheje umurongo urashobora guhuzwa na e-imeri.

1. Muri "shyiramo hyperlinks" idirishya, kanda kuri "karuvati hamwe na imeri".
2. Muri "aderesi imeri", andika e-imeri dushaka guhuza selile. Mu murima "insanganyamatsiko", urashobora kwandika ingingo yinzandiko. Nyuma yo gukora igenamiterere, kanda kuri buto "OK".

Noneho selile izaba ifitanye isano na aderesi imeri. Iyo ukanze kuri yo, umukiriya wa imeri yashyizweho na retault yatangijwe. Idirishya ryayo rizaba rimaze kuzuzwa muri e-imeri hamwe ningingo yubutumwa.

Uburyo 6: Kwinjiza hyperlinks binyuze kuri buto kuri lebbon

Hyperlink irashobora kandi kwinjizwa kuri buto idasanzwe kuri lente.

1. Jya kuri tab "shyiramo". Twakanze kuri buto "hyperlink", iherereye kuri kaseti mubikoresho bya "link".



2. Nyuma yibyo, "shyiramo hyperlinks" Idirishya ritangira. Ibindi bikorwa byose ni kimwe no kwinjiza binyuze muri menu. Bashingiye kubwoko bwihuza ushaka gusaba.

Uburyo 7: Imikorere ya Hyperlink

Byongeye kandi, hyperlink irashobora kuremwa hakoreshejwe imikorere idasanzwe.

1. Turagaragaza selile aho umurongo uzinjizwamo. Kanda kuri buto ya "Paste.



2. Mu idirishya rikora ryimikorere yimyikazi, nshakisha izina "hyperlink". Nyuma yo gufata amajwi tubisanga, turabigaragaza hanyuma ukande kuri buto ya "OK".



3. Imikorere irafungura. Hyperlink ifite impaka ebyiri: aderesi nizina. Iya mbere ni itegeko, nuwa kabiri utabishaka. Ikibuga "Aderesi" cyerekana aderesi yurubuga, imeri cyangwa aho dosiye iri kuri disiki ikomeye ushaka guhuza selile. Mu murima "izina", niba ushobora kwandika ijambo iryo ari ryo ryose rizagaragara mu Kagari, bityo ukaba ankeri. Niba uretse uyu murima ubusa, noneho umurongo uzerekanwa mu Kagari. Nyuma yigenamiterere ryakozwe, kanda kuri buto "OK".

Nyuma yibi bikorwa, selile izahuzwa nikintu cyangwa urubuga, rushyizwe kumurongo.

Isomo: Umukozi wa Wizard muri Excel

Gukuraho Hypersril

Ntabwo ari ngombwa nikibazo cyukuntu wakuraho hyperlinks, kuko zishobora kurakara cyangwa kubwizindi mpamvu uzakenera guhindura imiterere yinyandiko.

Birashimishije: Nigute ushobora gukuraho hyperlinks mumagambo ya Microsoft

Uburyo 1: Gusiba ukoresheje Ibikubiyemo

Inzira yoroshye yo gusiba umurongo nugukoresha menu. Kugirango ukore ibi, kanda gusa ku kagari, aho umurongo uherereye, kanda iburyo. Muri menu, hitamo "Gusiba hyperlink". Nyuma yibyo, bizavaho.

Uburyo 2: Kuraho imikorere ya hyperlink

Niba ufite umurongo mu kagari ukoresheje ikintu cyihariye cya hyperlink, noneho ntibizashoboka kubikuraho muburyo bwavuzwe haruguru. Gusiba, ugomba kwerekana selile hanyuma ukande kuri buto yo gusiba kuri clavier.

Muri iki gihe, ntabwo ari isano ubwayo izakurwaho gusa, ahubwo yanakorewe inyandiko, kubera ko zifitanye isano rwose muriyi mirimo.

Uburyo bwa 3: Gukuraho Misa ya Hyperlinks (Excel 2010 na Hejuru)

Ariko icyo gukora niba hari hyperlink nyinshi mubyangombwa, kuko gukuraho intoki bizatwara igihe kitari kinini? Muri Excel 2010 no hejuru, hari imikorere idasanzwe ushobora gukuraho amasano menshi icyarimwe muri selile.

Hitamo selile ushaka gusiba amahuza. Kanda iburyo kuri menu ya menu hanyuma uhitemo "Gusiba hyperlinks".

Nyuma yibyo, mumayira yatoranijwe ya hyperlunks azakurwaho, kandi inyandiko ubwayo izagumaho.

Niba ushaka gusiba mu nyandiko yose, ubanza guhamagara Ctrl + urufunguzo kuri clavier. BY, uragaragaza urupapuro rwose. Noneho, ukanze buto yimbeba iburyo, hamagara ibikubiyemo. Muri yo, hitamo "Siba Hyperlinks".

Icyitonderwa! Ubu buryo ntabwo bukwiye gukuraho amahuza niba uhambiriye ingirabuzimafatizo ukoresheje imikorere ya hyperlink.

Uburyo 4: Gukuraho Misa ya Hyperlinks (verisiyo mbere ya Excel 2010)

Byagenda bite niba ufite verisiyo yambere ya Excel 2010 kuri mudasobwa yawe? Ihuza ryose rigomba gusibwa intoki? Muri iki gihe, hariho nuburyo bwo gusohoka, nubwo bumwe bigoye kuruta inzira yasobanuwe muburyo bwabanje. By the way, uburyo bumwe burashobora gukoreshwa niba ubishaka nyuma.

1. Turagaragaza selile irimo ubusa kurupapuro. Dushyira imibare muri IT 1. Kanda kuri buto ya "Kopi" muri "urugo" cyangwa gutsinda gusa ctrl + c urufunguzo rwo guhuza clavier.



2. Hitamo selile aho hyperlinks iherereye. Niba ushaka guhitamo inkingi yose, hanyuma ukande kumazina yayo kuri panel itambitse. Niba ushaka kwerekana urupapuro rwose, andika Ctrl + clavier. Kanda kuri entometswe hamwe na buto yimbeba iburyo. Mubikubiyemo, kanda inshuro ebyiri kuri "Kwinjiza bidasanzwe ..." ikintu.



3. Idirishya ryihariye ryinjiza. Muri "imikorere" igenamiterere, dushyira ahagaragara umwanya wa "Kugwiza". Kanda kuri buto ya "OK".

Nyuma yibyo, hyperlunks zose zizasibwa, kandi imiterere ya selile zatoranijwe zisubirwamo.

Nkuko mubibona, hyperlinks irashobora kuba igikoresho cyoroshye cyo kugendana ntabwo ari incandara ninyandiko imwe gusa, ahubwo inakora itumanaho nibintu byo hanze. Kuraho amahuza biroroshye gukora muburyo bushya bwa excel, ariko no muri verisiyo zishaje za gahunda, hari kandi hari amahirwe akoresha manipulation kugiti cye kugirango usibe imirongo myinshi.