Yuav Kho Li Cas Hyperlink hauv Excel: 12 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav Kho Li Cas Hyperlink hauv Excel: 12 Kauj Ruam (nrog Duab)
Yuav Kho Li Cas Hyperlink hauv Excel: 12 Kauj Ruam (nrog Duab)

Video: Yuav Kho Li Cas Hyperlink hauv Excel: 12 Kauj Ruam (nrog Duab)

Video: Yuav Kho Li Cas Hyperlink hauv Excel: 12 Kauj Ruam (nrog Duab)
Video: nyiag nkag koj tus hluas nkauj tus messenger ua koj twb g paub password 2024, Lub peb hlis ntuj
Anonim

Qhov wikiHow no qhia koj li cas txhawm rau kho cov hyperlinks tawg hauv koj phau ntawv Excel. Qhov hyperlink yog qhov txuas txuas uas coj koj mus rau lwm qhov chaw, uas tuaj yeem yog lwm lub xov tooj, lwm phau ntawv ua haujlwm, lossis txawm tias lub vev xaib. Yog tias nyem qhov hyperlink hauv koj daim ntawv Excel tsis coj koj mus rau qhov chaw raug, muaj ntau yam uas koj tuaj yeem sim.

Cov kauj ruam

Txoj Kev 1 ntawm 2: Kho Kom Zoo Hyperlinks

Kho Hyperlink hauv Excel Kauj Ruam 1
Kho Hyperlink hauv Excel Kauj Ruam 1

Kauj Ruam 1. Qhib phau ntawv ua haujlwm nrog cov ntawv txuas uas tawg lawm

Feem ntau koj tuaj yeem qhib cov ntawv hauv Excel los ntawm ob npaug nias nws lub npe.

Kho Hyperlink hauv Excel Kauj Ruam 2
Kho Hyperlink hauv Excel Kauj Ruam 2

Kauj Ruam 2. Txoj cai-nias qhov hyperlink thiab xaiv Kho kom raug Hyperlink

Qhov no qhia tag nrho cov ntsiab lus hais txog qhov hyperlink hauv lub thawv sib tham yooj yim.

Kho Hyperlink hauv Excel Kauj Ruam 3
Kho Hyperlink hauv Excel Kauj Ruam 3

Kauj Ruam 3. Txheeb xyuas qhov chaw txuas

Yog tias, thaum koj nyem qhov hyperlink, koj pom qhov yuam kev uas hais tias "Kev siv tsis raug" (lossis lwm qhov yuam kev qhia tias qhib tsis tau cov ntaub ntawv), feem ntau nws yog vim cov ntawv, lub vev xaib, lossis xovtooj ntawm tes txuas mus rau tau hloov pauv lossis hloov chaw. Txheeb xyuas cov hauv qab no:

  • Ua ntej, txheeb xyuas seb hom ntaub ntawv twg koj txuas rau-yog tias koj txuas rau lub vev xaib lossis lwm cov ntawv, Cov Ntaub Ntawv Los Yog Lub Vev Xaib yuav tsum xaiv.
  • Yog tias koj txuas rau lub vev xaib, luam qhov URL los ntawm "Chaw Nyob" bar hauv qab thiab muab tshuaj txhuam rau hauv lub vev xaib. Koj puas tuaj yeem nkag mus rau ntawm qhov chaw ntawd? Yog tias tsis yog, qhov txuas tawg yog vim qhov URL tsis raug. Yog tias yog, mus rau qhov kawg ntawm URL hauv kab ntawv chaw nyob hauv Excel thiab nias lub spacebar-qhov no tuaj yeem kho qhov teeb meem.
  • Yog tias koj tab tom txuas rau cov ntawv tshwj xeeb, nco ntsoov tias cov ntawv nyob hauv qhov chaw raug. Yog tias cov ntaub ntawv tau raug hloov lossis hloov npe, hyperlink yuav tsis ua haujlwm tshwj tsis yog tias koj hloov kho txoj hauv kev hauv qhov hyperlink lossis tso cov ntawv rov qab rau hauv nws qhov chaw qub.
  • Yog tias koj txuas rau lwm lub xovtooj hauv tib cov ntawv, Muab tso rau hauv daim ntawv no yuav tsum tau hais nyob rau sab laug vaj huam sib luag. Xyuas kom tseeb tias kev siv xov tooj ntawm tes nyob ntawm ib daim ntawv uas muaj.
  • Nyem OK thaum koj ua tiav los cawm koj qhov kev hloov pauv.
Kho Hyperlink hauv Excel Kauj Ruam 4
Kho Hyperlink hauv Excel Kauj Ruam 4

Kauj Ruam 4. Txheeb ob kab lus yog tias koj siv HYPERLINK ua haujlwm

Yog tias koj tso qhov hyperlink rau hauv koj phau ntawv ua haujlwm siv cov qauv uas suav nrog HYPERLINK ua haujlwm, cov syntax yuav tsis raug. Nco ntsoov cov syntax ntawm koj cov mis sib xws rau cov hauv qab no:

  • Txuas mus rau ib nplooj ntawv hauv tib phau ntawv ua haujlwm: = HYPERLINK ("#Sheet2! A1", "Sheet2")
  • Nyem rau ntawm tes uas muaj cov qauv no yuav coj koj mus rau cell A1 ntawm daim ntawv hu ua Sheet2.

    • Yog tias daim ntawv npe lub npe suav nrog tus lej tsis yog tus lej lossis tus lej, koj yuav tsum nyob ib puag ncig ntawm daim ntawv npe nrog cov cim cim cim. = HYPERLINK ("#'Daim Ntawv Teev Npe'! A1", "Daim Ntawv Teev Npe").
    • Yog tias koj txuas rau ib lub xovtooj ntawm ib daim ntawv, cov qauv yuav tsum zoo li no: = HYPERLINK ("#A1", "Mus rau ntawm cell A1").
  • Txuas mus rau phau ntawv sib txawv: = HYPERLINK ("D: / wikikHow / Book2.xlsx", "Book2")

    • Nyem rau ntawm tes no yuav qhib cov ntawv Book2.xlsx nyob ntawm D: / wikiHow.
    • Txhawm rau mus rau ib daim ntawv tshwj xeeb hauv phau ntawv ua haujlwm nyob deb, koj yuav siv = HYPERLINK ("[D: / wikiHow / Book2.xlsx] Sheet2! A1", "Book2") (nco ntsoov cov kab zauv).
    • Yog tias phau ntawv ua haujlwm nyob deb ntawm lub network tsav, siv = HYPERLINK ("[SERVERNAME / USERNAME / Book2.xlsx] Sheet2! A1", "Book2")
  • Txuas mus rau lub vev xaib: = HYPERLINK ("https://www.wikiHow.com", "Mus rau wikiHow.com")

Txoj Kev 2 ntawm 2: Xiam Hloov Chaw Txuas Txuas ntawm Txuag

Kho Hyperlink hauv Excel Kauj Ruam 5
Kho Hyperlink hauv Excel Kauj Ruam 5

Kauj Ruam 1. Qhib phau ntawv ua haujlwm nrog cov ntawv txuas uas tawg lawm

Feem ntau koj tuaj yeem qhib cov ntawv hauv Excel los ntawm ob npaug nias nws lub npe.

Siv txoj hauv kev no yog tias koj twb tau tshuaj xyuas koj li hyperlinks rau qhov raug thiab qhov txuas tseem tsis ua haujlwm. Excel tshuaj xyuas koj cov hyperlinks thaum koj khaws cov ntaub ntawv-yog tias cov hyperlinks tsis ua haujlwm thaum lub sijhawm koj khaws tseg (piv txwv li, yog tias koj txuag thaum koj tsis txuas nrog internet), nws tuaj yeem cuam tshuam cov txuas ntawd

Kho Hyperlink hauv Excel Kauj Ruam 6
Kho Hyperlink hauv Excel Kauj Ruam 6

Kauj ruam 2. Nyem rau File menu

Nws nyob ntawm lub ces kaum sab saud.

Kho Hyperlink hauv Excel Kauj Ruam 7
Kho Hyperlink hauv Excel Kauj Ruam 7

Kauj Ruam 3. Nyem rau Options hauv cov ntawv qhia zaub mov

Koj qhov kev xaiv Excel yuav tshwm sim.

Kho Hyperlink hauv Excel Kauj Ruam 8
Kho Hyperlink hauv Excel Kauj Ruam 8

Kauj Ruam 4. Nyem rau Advanced tab

Nws nyob rau sab laug vaj huam sib luag.

Kho Hyperlink hauv Excel Kauj Ruam 9
Kho Hyperlink hauv Excel Kauj Ruam 9

Kauj Ruam 5. Scroll cia thiab nyem lub pob Web Options

Nws nyob hauv ntu "General".

Kho Hyperlink hauv Excel Kauj Ruam 10
Kho Hyperlink hauv Excel Kauj Ruam 10

Kauj Ruam 6. Nyem Cov Ntaub Ntawv tab

Nws yog qhov thib peb tab nyob saum lub qhov rai.

Kho Hyperlink hauv Excel Kauj Ruam 11
Kho Hyperlink hauv Excel Kauj Ruam 11

Kauj Ruam 7. Tshem qhov cim tseg los ntawm "Hloov kho qhov txuas ntawm txuag

Nws yog nyob rau sab saum toj.

Kho Hyperlink hauv Excel Kauj Ruam 12
Kho Hyperlink hauv Excel Kauj Ruam 12

Kauj Ruam 8. Nyem OK kom txog thaum koj tau tawm mus rau txhua qhov Options windows

Tam sim no koj tau xiam qhov kev xaiv no, Excel yuav tsis txheeb xyuas qhov txuas ntxiv thaum koj khaws cov ntawv.

Pom zoo: