4 Txoj hauv kev los ntxig Hyperlinks hauv Excel

Cov txheej txheem:

4 Txoj hauv kev los ntxig Hyperlinks hauv Excel
4 Txoj hauv kev los ntxig Hyperlinks hauv Excel

Video: 4 Txoj hauv kev los ntxig Hyperlinks hauv Excel

Video: 4 Txoj hauv kev los ntxig Hyperlinks hauv Excel
Video: Ntxhais Qaun ntuj txoj kev Hlub part 1 1 2024, Kaum ib hlis
Anonim

Qhov wikiHow no qhia koj li cas los tsim qhov txuas rau ib daim ntawv tshiab, ntawv tais ceev tseg, nplooj ntawv web, lossis ntawv hauv Microsoft Excel. Koj tuaj yeem txuas rau Microsoft Excel, ob qho tib si Windows thiab Mac.

Kauj ruam

Txoj Kev 1 ntawm 4: Txuas Cov Ntawv rau Cov Ntaub Ntawv Tshiab

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 1
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 1

Kauj Ruam 1. Qhib daim ntawv Excel

Nyem ob npaug rau daim ntawv uas koj xav ntxiv qhov txuas.

Koj tseem tuaj yeem qhib daim ntawv tshiab los ntawm ob npaug nias rau lub cim Excel thiab xaiv " Phau ntawv ua haujlwm dawb paug ”.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 2
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 2

Kauj Ruam 2. Xaiv lub npov

Nyem rau lub npov uas koj xav ntxiv qhov txuas.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 3
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 3

Kauj Ruam 3. Nyem Ntxig

Cov ntawv no yog nyob ntawm kab ntsuab nyob rau sab saud ntawm Excel qhov rai. Thaum nyem, lub cuab yeej yuav tshwm nyob hauv qab kab ntawv.

Yog tias koj siv Mac computer, nco ntsoov tias " Ntxig "txawv ntawm cov ntawv qhia zaub mov" Ntxig "Tso tawm ntawm lub khoos phis tawj cov ntawv qhia zaub mov.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 4
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 4

Kauj Ruam 4. Nyem Hyperlinks

Qhov kev xaiv no yog nyob rau sab xis ntawm lub cuab yeej " Ntxig "Hauv ntu" Txuas ". Tom qab ntawd, lub qhov rai tshiab yuav qhib.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 5
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 5

Kauj Ruam 5. Nyem Tsim Daim Ntawv Tshiab

Cov ntawv no yog nyob rau sab laug ntawm lub qhov rai pop-up.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 6
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 6

Kauj Ruam 6. Nkag mus rau kab ntawv txuas

Ntaus cov ntawv koj xav tso rau hauv "Text to display" field.

Yog tias koj tsis sau cov ntawv sib txawv, lub npe ntawm daim ntawv tshiab yuav raug siv ua cov kab ntawv txuas

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 7
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 7

Kauj Ruam 7. Ntaus lub npe ntawm daim ntawv tshiab

Sau lub npe nyob rau hauv "Lub npe ntawm cov ntaub ntawv tshiab" teb.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 8
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 8

Kauj ruam 8. Nyem OK

Nws nyob hauv qab ntawm lub qhov rais. Los ntawm lub neej ntawd, daim ntawv nthuav tawm daim ntawv tshiab yuav raug qhib thiab qhib, thiab txuas rau daim ntawv ntawd yuav raug ntxiv rau hauv lub thawv uas koj tau xaiv ua ntej hauv thawj daim ntawv.

Koj tseem tuaj yeem xaiv qhov "Kho cov ntaub ntawv tshiab tom qab" xaiv ua ntej nyem " OK "Los tsim daim ntawv nthuav qhia thiab nws qhov txuas, yam tsis tau qhib nws.

Txoj Kev 2 ntawm 4: Txuas Cov Ntawv rau Cov Ntaub Ntawv Uas Muaj lossis Lub Vev Xaib

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 9
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 9

Kauj Ruam 1. Qhib daim ntawv Excel

Nyem ob npaug rau daim ntawv uas koj xav ntxiv qhov txuas.

Koj tseem tuaj yeem qhib daim ntawv tshiab los ntawm ob npaug nias rau lub cim Excel thiab xaiv " Phau ntawv ua haujlwm dawb paug ”.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 10
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 10

Kauj Ruam 2. Xaiv lub npov

Nyem rau lub npov uas koj xav ntxiv qhov txuas.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 11
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 11

Kauj Ruam 3. Nyem Ntxig

Cov ntawv no yog nyob ntawm kab ntsuab nyob rau sab saud ntawm Excel qhov rai. Thaum nyem, lub cuab yeej yuav tshwm nyob hauv qab kab ntawv.

Yog tias koj siv Mac computer, nco ntsoov tias " Ntxig "txawv ntawm cov ntawv qhia zaub mov" Ntxig "Tso tawm ntawm lub khoos phis tawj cov ntawv qhia zaub mov.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 12
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 12

Kauj Ruam 4. Nyem Hyperlinks

Qhov kev xaiv no yog nyob rau sab xis ntawm lub cuab yeej " Ntxig "Hauv ntu" Txuas ". Tom qab ntawd, lub qhov rai tshiab yuav qhib.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 13
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 13

Kauj Ruam 5. Nyem Cov Ntawv Teev Npe lossis Lub Vev Xaib

Nws nyob sab laug ntawm lub qhov rais.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 14
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 14

Kauj Ruam 6. Nkag mus rau kab ntawv txuas

Ntaus cov ntawv koj xav tso rau hauv "Text to display" field.

Yog tias koj tsis nkag mus rau lwm cov ntawv, kab ntawv txuas yuav raug nthuav tawm raws li cov npe/nplaub tshev chaw nyob rau cov ntsiab lus

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 15
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 15

Kauj Ruam 7. Xaiv cov ntsiab lus rau lo lus uas peb

Nyem ib qho ntawm cov tab hauv qab no:

  • Tam Sim No " - Nrhiav cov ntaub ntawv hauv daim nplaub tshev" Cov ntaub ntawv "los yog" Duab ”.
  • Qhib nplooj ntawv ” - Xauj tsis ntev los no tau mus saib nplooj ntawv web.
  • Cov Ntaub Ntawv Tsis ntev los no " - Xauj rau cov ntaub ntawv qhib Excel tam sim no.
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 16
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 16

Kauj Ruam 8. Xaiv cov ntawv lossis nplooj ntawv web

Nyem cov ntaub ntawv, nplaub tshev, lossis nplooj ntawv web uas koj xav txuas rau. Cov npe/npe chaw nyob yuav tshwm nyob rau hauv "Chaw Nyob" hauv qab ntawm lub qhov rais.

Koj tseem tuaj yeem luam qhov URL los ntawm internet thiab muab tshuaj txhuam rau hauv "Chaw Nyob" teb

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 17
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 17

Kauj ruam 9. Nyem OK

Nws nyob hauv qab ntawm nplooj ntawv. Tom qab ntawd, qhov txuas yuav raug tsim hauv lub thawv koj xaiv.

Nco ntsoov tias yog tias koj txav cov ntawv txuas, qhov txuas yuav tsis ua haujlwm ntxiv lawm

Txoj Kev 3 ntawm 4: Txuas Cov Ntawv rau Cov Ntaub Ntawv hauv Cov Ntawv

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 18
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 18

Kauj Ruam 1. Qhib daim ntawv Excel

Nyem ob npaug rau daim ntawv uas koj xav ntxiv qhov txuas.

Koj tseem tuaj yeem qhib daim ntawv tshiab los ntawm ob npaug nias rau lub cim Excel thiab xaiv " Phau ntawv ua haujlwm dawb paug ”.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 19
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 19

Kauj Ruam 2. Xaiv lub npov

Nyem rau lub npov uas koj xav ntxiv qhov txuas.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 20
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 20

Kauj Ruam 3. Nyem Ntxig

Cov ntawv no yog nyob ntawm kab ntsuab nyob rau sab saud ntawm Excel qhov rai. Thaum nyem, lub cuab yeej yuav tshwm nyob hauv qab kab ntawv.

Yog tias koj siv lub khoos phis tawj Mac, nco ntsoov tias " Ntxig "txawv ntawm cov ntawv qhia zaub mov" Ntxig "Tso tawm ntawm lub khoos phis tawj cov ntawv qhia zaub mov.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 21
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 21

Kauj Ruam 4. Nyem Hyperlinks

Qhov kev xaiv no yog nyob rau sab xis ntawm lub cuab yeej " Ntxig "Hauv ntu" Txuas ". Tom qab ntawd, lub qhov rai tshiab yuav qhib.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 22
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 22

Kauj Ruam 5. Nyem Qhov Chaw Hauv Daim Ntawv No

Nws nyob sab laug ntawm lub qhov rais.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 23
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 23

Kauj Ruam 6. Nkag mus rau kab ntawv txuas

Ntaus cov ntawv koj xav tso rau hauv "Text to display" field.

Yog tias tsis nkag mus, kab ntawv txuas yuav tshwm raws li lub npe ntawm lub npov txuas

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 24
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 24

Kauj Ruam 7. Nyem OK

Ib qhov txuas yuav raug tsim hauv lub thawv xaiv. Yog tias koj nyem rau ntawm kab ntawv txuas, Excel yuav txiav lub npov txuas.

Txoj Kev 4 ntawm 4: Tsim Email Chaw Txuas

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 25
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 25

Kauj Ruam 1. Qhib daim ntawv Excel

Nyem ob npaug rau daim ntawv uas koj xav ntxiv qhov txuas.

Koj tseem tuaj yeem qhib daim ntawv tshiab los ntawm ob npaug nias rau lub cim Excel thiab xaiv " Phau ntawv ua haujlwm dawb paug ”.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 26
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 26

Kauj Ruam 2. Xaiv lub npov

Nyem rau lub npov uas koj xav ntxiv qhov txuas.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 27
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 27

Kauj Ruam 3. Nyem Ntxig

Cov ntawv no yog nyob ntawm kab ntsuab nyob rau sab saud ntawm Excel qhov rai. Thaum nyem, lub cuab yeej yuav tshwm nyob hauv qab kab ntawv.

Yog tias koj siv Mac computer, nco ntsoov tias " Ntxig "txawv ntawm cov ntawv qhia zaub mov" Ntxig "Tso tawm ntawm lub khoos phis tawj cov ntawv qhia zaub mov.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 28
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 28

Kauj Ruam 4. Nyem Hyperlinks

Qhov kev xaiv no yog nyob rau sab xis ntawm lub cuab yeej " Ntxig "Hauv ntu" Txuas ". Tom qab ntawd, lub qhov rai tshiab yuav qhib.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 29
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 29

Kauj Ruam 5. Nyem rau E-mail Address

Nws nyob sab laug ntawm lub qhov rais.

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 30
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 30

Kauj Ruam 6. Nkag mus rau kab ntawv txuas

Ntaus cov ntawv koj xav tso rau hauv "Text to display" field.

Yog tias tsis hloov lossis nkag mus, cov ntawv ntawm qhov txuas yuav tshwm raws li email chaw nyob uas koj yuav txuas

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 31
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 31

Kauj Ruam 7. Nkag mus rau email chaw nyob

Ntaus qhov chaw nyob uas koj xav txuas rau hauv "E-mail address" teb.

Koj kuj tseem tuaj yeem ntxiv cov ncauj lus xav tau hauv email hauv "Subject" teb. Qhov no txhais tau tias qhov txuas yuav tso saib lub email tshiab nrog rau lub ncauj lus uas twb tau sau lawm

Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 32
Ntxig Hyperlinks hauv Microsoft Excel Kauj Ruam 32

Kauj ruam 8. Nyem OK

Nws nyob hauv qab ntawm lub qhov rais.

Lub tswv yim

Koj kuj tseem tuaj yeem nkag mus txuas nrog siv "HYPERLINK" ua haujlwm lossis mis. Hom " = HYPERLINK (link_location, npe)"Nyob rau hauv lub thawv xav tau. Txoj cai "link_location" hais txog cov npe chaw nyob ntawm cov ntaub ntawv, ntawv tais ceev tseg, lossis nplooj ntawv web, thiab "npe" code yog cov ntawv pom ua kab ntawv txuas.

Pom zoo: