30 Excel mahi i roto i te 30 ra: HYPERLINK

Inanahi i te marathon 30 Excel mahi i roto i te 30 ra i mahia e matou te whakakapi kuputuhi ma te whakamahi i te mahi HEPETOPA (KAUPAPA) me te hanga purongo ngawari ki a ia.

Hei te 28 o nga ra o te marathon, ka ako tatou i te mahi HIPERLINK (HYPERLINK). Engari ki te hanga honongaitua ma te whakamahi i te tono Ribbon Excel o taua ingoa, ka taea e koe te whakamahi i tenei waahanga.

Na kia uru tatou ki nga korero mo te mahi HIPERLINK (HYPERLINK) me nga tauira o tana whakamahinga. Mena kei a koe etahi atu korero, tauira ranei, tohaina ki nga korero.

taumahi HIPERLINK (HYPERLINK) ka hanga hononga hei whakatuwhera i tetahi tuhinga kua rongoa ki runga rorohiko, tūmau whatunga, whatunga paetata, ki te Ipurangi ranei.

taumahi HIPERLINK (HYPERLINK) ka taea e koe te whakatuwhera tuhinga, te whakatere ranei ki nga waahi motuhake i roto i tetahi tuhinga. Ma tenei ka taea e koe:

  • Waihangahia he hononga e whakatere ana ki tetahi waahi motuhake i roto i te konae kotahi.
  • Waihangahia he hononga ki tetahi tuhinga Excel i roto i te kōpaki kotahi.
  • Waihanga hononga ki te paetukutuku.

taumahi HIPERLINK (HYPERLINK) te wetereo e whai ake nei:

HYPERLINK(link_location,friendly_name)

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

  • hono_tauwāhi (Wāhitau) – He aho kuputuhi e tohu ana i te waahi o te waahi, tuhinga ranei e hiahiatia ana.
  • ingoa_hoa Ko (ingoa) te kuputuhi ka whakaatuhia ki te pūtau.

Mena kaore koe i te tino mohio ka taea e koe te hanga tohutoro tika mo tetahi mahi HIPERLINK (HYPERLINK), whakauruhia a ringa ma te whakamahi i te whakahau Honongaitua (Hyperlink), kei runga i te ripa Kōkuhu Ripene Excel. Ma tenei ka ako koe i te wetereo tika, ka whakahoki ano koe mo te tohenga hono_tauwāhi (wāhitau).

Tauira 1: Te tohutoro i tetahi waahi kei roto i te konae kotahi

He maha nga huarahi rereke hei hanga i tetahi aho kuputuhi mo te tautohetohe hono_tauwāhi (wāhitau). I te tauira tuatahi, ko te mahi ADDRESS (ADDRESS) ka whakahoki i te wahitau mo te rarangi tuatahi me te tīwae tuatahi i te raumahi kua tohua tona ingoa ki te pūtau B3.

tohu # (tohu pauna) i te timatanga o te wahitau e tohu ana ko te waahi kei roto i te konae o naianei.

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

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

30 Excel mahi i roto i te 30 ra: HYPERLINK

Ano, ka taea e koe te whakamahi i te kaiwhakahaere & (concatenation) ki te matapo i te wahitau hono. Anei te ingoa rau kei te pūtau B5 me te wāhitau pūtau kei C5.

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

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

30 Excel mahi i roto i te 30 ra: HYPERLINK

Hei tohu ki tetahi awhe kua whakaingoatia i roto i te pukamahi Excel kotahi, homai noa te ingoa awhe hei tohenga hono_tauwāhi (wāhitau).

=HYPERLINK("#"&D7,D7)

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

30 Excel mahi i roto i te 30 ra: HYPERLINK

Tauira 2: Te tohutoro i te konae Excel i te kōpaki kotahi

Hei waihanga hononga ki tetahi atu konae Excel i roto i te kōpaki kotahi, whakamahia noa te ingoa kōnae hei tohenga hono_tauwāhi (wāhitau) i roto i te mahi HIPERLINK (HYPERLINK).

Hei tautuhi i te ara ki te konae he kotahi, neke atu ranei nga taumata teitei ake i roto i te arowhai, whakamahia nga wa e rua me te whakamuri (..) mo ia taumata.

=HYPERLINK(C3,D3)

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

30 Excel mahi i roto i te 30 ra: HYPERLINK

Tauira 3: Te hono ki te paetukutuku

Te whakamahi i nga mahi HIPERLINK (HYPERLINK) Ka taea e koe te hono atu ki nga wharangi kei runga paetukutuku. I tenei tauira, ka whakaemihia te hononga pae mai i nga aho kuputuhi, ka whakamahia te ingoa pae hei uara tautohe. ingoa_hoa (ingoa).

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

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

30 Excel mahi i roto i te 30 ra: HYPERLINK

Waiho i te Reply