30 Excel ua haujlwm hauv 30 hnub: HYPERLINK

Nag hmo hauv marathon 30 Excel ua haujlwm hauv 30 hnub peb tau ua cov ntawv hloov pauv siv cov haujlwm RAWS LI (SUBSTITUTE) thiab ua cov ntaub ntawv hloov pauv nrog nws.

Hnub 28 ntawm lub marathon, peb yuav kawm txog kev ua haujlwm HYPERLINK (HYPERLINK). Es tsis txhob manually tsim hyperlinks siv Excel Ribbon hais kom ua ntawm tib lub npe, koj tuaj yeem siv qhov no.

Yog li cia peb nkag mus rau hauv cov ntsiab lus ntawm kev ua haujlwm HYPERLINK (HYPERLINK) thiab piv txwv ntawm nws siv. Yog tias koj muaj lus qhia ntxiv lossis piv txwv, thov qhia rau lawv hauv cov lus pom.

muaj nuj nqi HYPERLINK (HYPERLINK) tsim ib qhov txuas uas qhib cov ntaub ntawv khaws cia hauv lub computer, network server, network hauv zos, lossis Is Taws Nem.

muaj nuj nqi HYPERLINK (HYPERLINK) tso cai rau koj qhib cov ntaub ntawv lossis mus rau qhov chaw tshwj xeeb hauv daim ntawv. Nrog nws koj tuaj yeem:

  • Tsim ib qhov txuas uas mus rau qhov chaw tshwj xeeb hauv tib cov ntaub ntawv.
  • Tsim ib qhov txuas mus rau ib daim ntawv Excel hauv tib lub nplaub tshev.
  • Tsim ib qhov txuas rau lub vev xaib.

muaj nuj nqi HYPERLINK (HYPERLINK) muaj cov syntax hauv qab no:

HYPERLINK(link_location,friendly_name)

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

  • link_location (chaw nyob) - Ib txoj hlua ntawm cov ntawv uas qhia qhov chaw ntawm qhov chaw xav tau lossis cov ntaub ntawv.
  • phooj ywg_npe (lub npe) yog cov ntawv nyeem uas yuav muab tso rau hauv lub cell.

Yog tias koj tsis paub meej tias koj tuaj yeem tsim cov ntaub ntawv raug rau kev ua haujlwm HYPERLINK (HYPERLINK), ntxig nws manually siv cov lus txib hyperlink (Hyperlink), uas nyob ntawm lub tab Insert Excel ribbons. Qhov no koj yuav kawm tau qhov tseeb syntax, uas koj mam li rov qab rau qhov kev sib cav link_location (chaw nyob).

Piv txwv 1: Hais txog qhov chaw nyob hauv tib cov ntaub ntawv

Muaj ntau ntau txoj hauv kev los tsim cov kab ntawv rau kev sib cav link_location (chaw nyob). Hauv thawj qhov piv txwv, muaj nuj nqi CHAW NYOB (ADDRESS) xa rov qab qhov chaw nyob rau thawj kab thiab thawj kab hauv daim ntawv ua haujlwm uas nws lub npe tau teev tseg hauv cell B3.

cim # (phaus kos npe) thaum pib ntawm qhov chaw nyob qhia tias qhov chaw nyob hauv cov ntaub ntawv tam sim no.

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

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

30 Excel ua haujlwm hauv 30 hnub: HYPERLINK

Tsis tas li, koj tuaj yeem siv tus neeg teb xov tooj & (concatenation) kom dig muag qhov chaw nyob txuas. Ntawm no daim ntawv npe yog nyob rau hauv cell B5 thiab cell chaw nyob yog nyob rau hauv C5.

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

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

30 Excel ua haujlwm hauv 30 hnub: HYPERLINK

Txhawm rau xa mus rau cov npe muaj npe hauv tib phau ntawv ua haujlwm Excel, tsuas yog muab cov npe ntau yam raws li kev sib cav link_location (chaw nyob).

=HYPERLINK("#"&D7,D7)

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

30 Excel ua haujlwm hauv 30 hnub: HYPERLINK

Piv txwv 2: Xa cov ntaub ntawv Excel hauv tib lub nplaub tshev

Txhawm rau tsim qhov txuas mus rau lwm cov ntaub ntawv Excel hauv tib lub nplaub tshev, tsuas yog siv lub npe filename los ntawm kev sib cav link_location (chaw nyob) hauv kev ua haujlwm HYPERLINK (HYPERLINK).

Txhawm rau qhia txoj hauv kev rau cov ntaub ntawv uas yog ib lossis ntau qib siab dua hauv hierarchy, siv ob lub sijhawm thiab backslash (..) rau txhua qib.

=HYPERLINK(C3,D3)

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

30 Excel ua haujlwm hauv 30 hnub: HYPERLINK

Piv txwv 3: Txuas rau lub vev xaib

Siv cov haujlwm HYPERLINK (HYPERLINK) Koj tuaj yeem txuas mus rau nplooj ntawv ntawm cov vev xaib. Hauv qhov piv txwv no, lub vev xaib txuas tau sib sau los ntawm cov kab ntawv, thiab lub vev xaib lub npe yog siv los ua tus nqi sib cav. phooj ywg_npe (npe).

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

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

30 Excel ua haujlwm hauv 30 hnub: HYPERLINK

Sau ntawv cia Ncua