Tare da taimakon hyperlinks a cikin excele, zaku iya nufin wasu sel, allunan, fice, fayiloli na wasu aikace-aikacen (hotuna, da sauransu), abubuwa daban-daban, da sauransu. Suna ba da damar hanzarta zuwa wani abu da aka ƙayyade lokacin danna kan tantanin a cikin abin da aka saka an saka su. Tabbas, a cikin tsari mai wuya tsari, amfani da wannan kayan aikin kawai maraba ne. Saboda haka, mai amfani wanda yake son koyo da aiki sosai a cikin yadda ya faru kawai don sanin gwanin kirkirar da cire hyperlinks.
Mai ban sha'awa: Irƙirar hyperlink a Microsoft Word
Daraja Hyspershril
Da farko dai, yi la'akari da hanyoyin da za a ƙara hyperlink a cikin takaddun.Hanyar 1: Sanya Hyperlink mara amfani
Hanya mafi sauki don saka hanyar haɗi zuwa shafin yanar gizo ko adireshin imel. Wani hyperlink mai ban mamaki - Wannan hanyar haɗin, adireshin da aka wajabta da aka wajabta kai tsaye a cikin sel kuma yana bayyane akan takardar ba tare da ƙarin magudi ba. Abun fasalin na Excel Shirin shine cewa duk wata kalma wacce ba a haɗa ta a cikin tantanin halitta ba.
Shigar da hanyar haɗin zuwa kowane yanki na takardar.
Yanzu, lokacin da ka danna nan Cell, mai binciken zai fara, wanda aka saita ta hanyar tsoho, kuma yana tafiya a adireshin da aka ƙayyade.
Hakazalika, zaku iya sanya hanyar haɗi zuwa adireshin imel, kuma zai iya zama nan da nan aiki.
Hanyar 2: Sadarwa tare da fayil ko shafin yanar gizo ta menu na mahallin
Hanya mafi mashahuri don ƙara haɗi na hanyar haɗi shine amfani da menu na mahallin.
- Muna haskaka tantanin halitta wanda za mu shigar da haɗi. Danna kan shi. Menu na mahallin yana buɗewa. A ciki, zaɓi abu "hyperlink ...".
- Nan da nan bayan abin da aka buɗe taga ya buɗe. A gefen hagu na taga, maballin suna ta danna ɗayan wanda mai amfani ya bayyana tare da abin da ke so ya ɗaure tantanin halitta:
- tare da fayil na waje ko shafin yanar gizo;
- tare da wuri a cikin Dakin;
- tare da sabon takaddar;
- tare da imel.
Tun da muna son nuna ta wannan hanyar don ƙara hyperlink tare da hanyar haɗi tare da fayil ko shafin yanar gizo, muna zaɓar abu na farko. A zahiri, ba lallai ba ne don zaɓar shi, kamar yadda aka nuna ta hanyar tsohuwa.
- A tsakiyar taga akwai yankin mai jagorar don zaɓar fayil. Ta hanyar tsoho, mai jagorar yana buɗe a cikin tsarin wannan jagorar inda littafin na yanzu yake. Idan abin da ake so yana cikin wani babban fayil, ya kamata ka danna maballin "fayil ɗin bincike", wanda ke saman yankin ferris.
- Bayan haka, taga zaɓi zaɓi fayil ɗin zaɓi. Je zuwa shugabanci da kake buƙata, mun sami fayil ɗin da muke son danganta tantanin halitta, ware shi kuma danna maɓallin "Ok".
Hankali! Don samun damar yin tarayya da sel tare da fayil tare da kowane tsawa a cikin akwatin binciken, kana buƙatar sake shirya nau'in fayil ɗin zuwa "duk fayiloli".
- Bayan haka, da daidaitawar fayil ɗin da aka ƙayyade ya faɗi a filin "adireshin" filin shigar da hyperlink. Kawai danna maɓallin "Ok".
Yanzu an ƙara hanyar hyperlink kuma lokacin da ka danna sel da ya dace, fayil ɗin da aka ƙayyade zai buɗe a cikin shirin don duba shi ta tsohuwa.
Idan kana son saka hanyar haɗi zuwa hanyar yanar gizo, to, a filin adreshin kana buƙatar shigar da URL ɗin ko kwafe shi a can. Sannan ya kamata ka danna maballin "Ok".
Hanyar 3: sadarwa tare da wuri a cikin daftarin aiki
Bugu da kari, yana yiwuwa a yi tarayya da tantanin hannu tare da kowane wuri a cikin takaddar na yanzu.
- Bayan an zaɓi tantanin halitta kuma wanda ya haifar da menu na menu na hanyar saƙo, za mu kunna maɓallin a gefen hagu na taga zuwa "ɗaure tare da wuri a cikin takaddar" matsayi.
- A cikin sashen "Shigar da adireshin tantanin halitta" kana buƙatar tantance daidaitawar sel da za a ambaci.
A maimakon haka, takardar wannan takaddar kuma za'a iya zartar a cikin filin filin inda sauyawa yayin danna tantanin halitta. Bayan an yi zabi, ya kamata ka danna maballin "Ok".
Yanzu tantanin halitta za'a danganta shi da takamaiman wuri littafin yanzu.
Hanyar 4: Hyperlink zuwa sabon takaddar
Wani zaɓi shine hyperlink zuwa sabon takaddar.
- A cikin "Saka bayanai-rafi" taga, zaɓi abu "ƙulla tare da sabon takaddar".
- A cikin tsakiyar taga a cikin "sunan sabon takaddar", ya kamata ka saka yadda aka kirkira.
- Ta hanyar tsoho, ana sanya wannan fayil a cikin tsarin wannan adireshin kamar littafin yanzu. Idan kana son canja wurin, kana buƙatar danna maɓallin "Shirya ..." maɓallin.
- Bayan haka, taga samar da daftarin daftarin daftarin da ke buɗewa. Kuna buƙatar zaɓar babban fayil na wurin zama da tsari. Bayan haka, danna maɓallin "Ok".
- A cikin Saiti Block "Lokacin da ka shigar da sabon takaddar", za ka iya saita ɗaya daga cikin sigogi da kanta, ko kuma a fara ƙirƙirar takardu da kanta da hanyar haɗi, shirya shi. Bayan an yi duk saiti, danna maɓallin "Ok".
Bayan aiwatar da wannan aikin, tantanin halitta akan takardar na yanzu za a haɗa shi ta hanyar hyperlink tare da sabon fayil.
Hanyar 5: Sadarwa tare da Imel
Ana amfani da sel ta amfani da hanyar haɗin yanar gizon ko da e-mail.
- A cikin "Saka Hyperlinks" taga, danna kan "ƙulla tare da imel" button.
- A cikin "Adireshin Imel" filin, shigar da e-mail wanda muke son yin shirka da sel. A fagen "taken", zaka iya rubuta batun haruffa. Bayan an yi saitunan, danna maɓallin "Ok".
Yanzu tantanin halitta za a danganta shi da adireshin imel. Lokacin da ka danna kan shi, ana saita abokin ciniki na imel da aka gabatar da tsoffin an ƙaddamar. An riga an cika taga a cikin hanyar e-mail da batun sakon.
Hanyar 6: Saka da hyperlinks ta maballin akan kintinkiri
Hakanan za'a iya shigar da hyperlink ta hanyar maɓallin musamman akan kintinkiri.
- Je zuwa shafin "Saka" shafin. Muna danna maballin "hyperlink", wanda ke kan tef a cikin "Hanyoyin" ".
- Bayan haka, "saka hyperlinks" taga yana farawa. Duk sauran ayyukan suna daidai kamar yadda lokacin da aka saka ta menu na mahallin. Sun dogara da nau'in hanyar haɗin da kake son amfani.
Hanyar 7: aikin hyperlink
Bugu da kari, za a iya ƙirƙirar hanyar hyperlink ta amfani da aiki na musamman.
- Muna haskaka tantanin halitta wanda za'a saka hanyar haɗin. Danna kan "Manna Active".
- A cikin Wurin aiki na Wurin Wizard Ayyuka, neman sunan "hyperlink". Bayan an samo rikodin, muna haskaka shi kuma danna maɓallin "Ok".
- Ayyukan muhawara sun buɗe. Hyperlink yana da hujjoji guda biyu: adireshi da suna. Na farko shine badili, kuma na biyu zaɓi. Adireshin "Adireshin" yana nuna adireshin shafin, imel ko wurin fayil a kan faifai mai wuya wanda kuke so ku danganta tantanin halitta. A cikin "Suna" filin, idan ana so, zaku iya rubuta kowace kalma da za a iya gani a cikin tantanin, don haka kasancewa wanƙa. Idan ka bar wannan filin ba komai, to za a nuna hanyar haɗin a cikin tantanin halitta. Bayan an samar da saitunan, danna maɓallin "Ok".
Bayan waɗannan ayyukan, za a haɗa salula da alaƙa da abu ko shafin, wanda aka jera shi a cikin hanyar.
Darasi: Ayyukan Wizard a Excel
Cire Hypersrosril
Babu mahimmancin mahimmancin yadda za a cire hanyar hyperlinks, saboda suna iya m ko ga wasu dalilai da kuke buƙatar canza tsarin daftarin aiki.Mai ban sha'awa: Yadda Ake Cire Hyperlinks a Microsoft Word
Hanyar 1: Share Amfani da Menu na Menu
Hanya mafi sauki don share mahaɗin shine amfani da menu na mahallin. Don yin wannan, danna tantanin halitta, wanda mahadar take, danna-dama. A cikin menu na mahallin, zaɓi "Share hyperlink" abu. Bayan haka, za a cire shi.
Hanyar 2: cire aikin hyperlink
Idan kuna da hanyar haɗi a cikin sel ta amfani da fasali na musamman na hyperlink, to ba zai yuwu a cire shi a cikin wannan hanyar ba. Don share, kuna buƙatar haskaka wayar da kuma danna maɓallin Share akan maɓallin keyboard.
A wannan yanayin, ba kawai mahadar da kanta za a cire, amma kuma rubutun, tunda an haɗa su gaba ɗaya cikin wannan aikin.
Hanyar 3: Cire taro na Hyperlinks (Excel version da sama)
Amma abin da za a yi idan akwai abubuwa da yawa a cikin takaddar, saboda cire hannu zai ɗauki adadin adadin? Are Excel 2010 kuma a sama, akwai aiki na musamman wanda zaku iya cire hanyoyi da yawa a kan sel.
Zaɓi ƙwayoyin da kuke son share hanyoyin haɗi. Kaɗa menu na mahallin ka zaɓi "Share hyperlinks".
Bayan haka, a cikin sel da aka zaɓa za a cire shi, kuma rubutun da kansa zai kasance.
Idan kana son share a cikin duka daftarin aiki, ka fara buga lambar Ctrl + Maɓallan a cikin keyboard. Ta wannan, zaku haskaka duka takardar. Sannan, danna maɓallin linzamin kwamfuta da dama, kira menu na mahallin. A ciki, zaɓi "Share Hyperlinks".
Hankali! Wannan hanyar ba ta dace da cire hanyoyin haɗi ba idan kuna ɗaure ƙwayoyin ta amfani da aikin hyperlink.
Hanyar 4: Cire taro na Hyperlinks (sigar a baya Excelned 2010)
Idan kana da sigar farko ta Excel 2010 akan kwamfutarka? Shin an share hanyoyin haɗin da hannu? A wannan yanayin, kuma akwai kuma hanyar fita, kodayake yana da ɗan rikitarwa fiye da hanyar da aka bayyana a hanyar da ta gabata. Af, za a iya amfani da zaɓi iri ɗaya idan kuna so a sigogin baya.
- Muna haskaka kowane kwayar komai a kan takardar. Mun sanya lambar ta a ciki 1. Latsa maɓallin "Kwafi" ko shafin maɓallin Ctrl + C na haɗin Ctrl + C akan keyboard.
- Zaɓi sel a cikin abin da hyperlinks ke located. Idan kana son zabi duk shafi gaba daya, sannan ka latsa sunan sa a kwance na kwance. Idan kana son haskaka duka takardar, buga Ctrl + alama keyboard. Danna kan babban abu tare da maɓallin linzamin kwamfuta na dama. A cikin menu na mahallin, danna sau biyu akan "Intanet na musamman ..." abu.
- An buɗe sabon taga na musamman. A cikin "Aikin" saitunan saiti, mun sanya canjin zuwa matsayin "ninka". Latsa maɓallin "Ok".
Bayan haka, za a share duk hanyoyin sadarwa, kuma za a sake tsara tsarin sel da aka zaɓa.
Kamar yadda kake gani, hyperlinks na iya zama kayan aiki mai dacewa don haɗawa ba sel daban-daban takarda ɗaya, har ma yana yin sadarwa tare da abubuwan waje. Cire hanyoyin sadarwa yana da sauƙin yin a cikin sabbin juyi na Excel, har ma a cikin tsoffin juyi na shirin, akwai kuma damar ta amfani da ƙirar mutum don samar da ƙwararrun hanyoyin haɗin.