30 Excel inoshanda mumazuva makumi matatu: HYPERLINK

Nezuro mumarathon 30 Excel inoshanda mumazuva makumi matatu takaita kutsiva kwemavara tichishandisa basa SUBSTITUTE (SUBSTITUTE) uye akaita mishumo inoshanduka nayo.

Pazuva rechi28 remarathon, tichadzidza basa racho HYPERLINK (HYPERLINK). Panzvimbo pekugadzira nemaoko hyperlink uchishandisa iyo Excel Ribbon murairo wezita rimwe chete, unogona kushandisa chimiro ichi.

Saka ngatipindei mune zvakadzama zvebasa racho HYPERLINK (HYPERLINK) uye mienzaniso yekushandiswa kwayo. Kana iwe uine rumwe ruzivo kana mienzaniso, ndapota igovera ivo mune zvakataurwa.

basa HYPERLINK (HYPERLINK) inogadzira chinongedzo chinovhura gwaro rakachengetwa pakombuta, network server, network yemuno, kana Internet.

basa HYPERLINK (HYPERLINK) inokutendera kuti uvhure magwaro kana kufamba uchienda kunzvimbo dzakati mugwaro. Nayo unogona:

  • Gadzira chinongedzo chinoenda kune imwe nzvimbo mune imwechete faira.
  • Gadzira chinongedzo kune iyo Excel gwaro mune imwecheteyo folda.
  • Gadzira chinongedzo kune webhusaiti.

basa HYPERLINK (HYPERLINK) ine chirevo chinotevera:

HYPERLINK(link_location,friendly_name)

ГИПЕРССЫЛКА(адрес;имя)

  • link_location (kero) - Tambo yemavara inotsanangura nzvimbo yenzvimbo yaunoda kana gwaro.
  • friendly_name (zita) ndiwo mavara acharatidzwa muchitokisi.

Kana iwe usina chokwadi chekuti unogona kugadzira referensi chaiyo yebasa HYPERLINK (HYPERLINK), iise nemaoko uchishandisa rairo Hyperlink (Hyperlink), iyo iri pane tab Insert Excel ribhoni. Nenzira iyi iwe unozodzidza iyo syntax chaiyo, iyo yaunozodzokorora yenharo link_location (kero).

Muenzaniso 1: Kurevera nzvimbo mune imwechete faira

Pane nzira dzakati wandei dzekugadzira tambo yemavara yenharo link_location (kero). Mumuenzaniso wekutanga, basa ADDRESS (ADDRESS) inodzosa kero yemutsara wekutanga nekoramu yekutanga papepa rebasa rine zita rinotsanangurwa muchitokisi B3.

chiratidzo # (chiratidzo chepondo) pakutanga kwekero inoratidza kuti nzvimbo iri mufaira razvino.

=HYPERLINK("#"&ADDRESS(1,1,,,B3),D3)

=ГИПЕРССЫЛКА("#"&АДРЕС(1;1;;;B3);D3)

30 Excel inoshanda mumazuva makumi matatu: HYPERLINK

Uyezve, unogona kushandisa opareta & (concatenation) kupofumadza kero yekubatanidza. Pano zita repepa riri muchitokisi B5 uye kero yesero iri muC5.

=HYPERLINK("#"&"'"&B5&"'!"&C5,D5)

=ГИПЕРССЫЛКА("#"&"'"&B5&"'!"&C5;D5)

30 Excel inoshanda mumazuva makumi matatu: HYPERLINK

Kuti utarise kune rakatumidzwa renji mubhuku rimwechete reExcel rebasa, ingopa iro zita rezita senharo link_location (kero).

=HYPERLINK("#"&D7,D7)

=ГИПЕРССЫЛКА("#"&D7;D7)

30 Excel inoshanda mumazuva makumi matatu: HYPERLINK

Muenzaniso 2: Kunongedza faira reExcel mune imwechete folda

Kugadzira chinongedzo kune imwe Excel faira mune imwecheteyo folda, ingo shandisa iro zita refaira senharo link_location (kero) mukushanda HYPERLINK (HYPERLINK).

Kuti utsanangure nzira yefaira iri imwe kana mamwe mazinga akakwirira muhutungamiri, shandisa nguva mbiri uye backslash (..) yezinga rega rega.

=HYPERLINK(C3,D3)

=ГИПЕРССЫЛКА(C3;D3)

30 Excel inoshanda mumazuva makumi matatu: HYPERLINK

Muenzaniso 3: Kubatanidza kune webhusaiti

Kushandisa mabasa HYPERLINK (HYPERLINK) Unogona kubatanidza kune mapeji pawebhusaiti. Mumuenzaniso uyu, saiti link inounganidzwa kubva kumavara tambo, uye zita resaiti rinoshandiswa seyeukoshi hwenharo. friendly_name (zita).

=HYPERLINK("http://www." &B3 & ".com",B3)

=ГИПЕРССЫЛКА("http://www."&B3&".com";B3)

30 Excel inoshanda mumazuva makumi matatu: HYPERLINK

Leave a Reply