Hng dn cch chn Link vo filel Excel
Chn links chn ng dn vo mt trong file Excel l 1 th thut rt cn thit khi bn cn phi son tho vn bn v d liu trong bng tnh Excel. PKMacBook.com s ch dn cc bn cch chn links vo Excel mt cch d dng v c th chi tit nht.
Hng dn cch chn link vo file Excel
C 4 kiu chn link vo Excel, trong s y bao gm chn mt ng dn link trang web hoc bt m mt file trong my tnh vo d liu c sn, chn mt im tt vn ng v di chuyn con tr chn la ti mt a im khc trong chnh file Excel , chn ng dn ti mt file Excel mi, chn mt ng dn gi Email ti folder b nhim.
1. Cch chn link vo Excel
chn lin kt website vo file Excel, th nht cc bn nhp chut phi vo d liu mun chn. Tip bn chn link nm sau cui danh sch ty chn.
Chn Link
hnh lang ca s chc nng Insert Hyperlink s tin hnh bt m, khi ny nhng bn gi nguyn mc link to l Existing File or Web Page.
Tip nhng bn in mt ng links trang web khay Address. k tip cc bn click vo nt OK xc nhn thit lp.
Hoc nu cc bn c nhu cu mun chn ng dn ti mt file trong my tnh tnh ch vic la chn th mc mc Look in bn trn. sau cng bn cng bm OK xc thc thit t.
Chn Existing File or Web Page
khi y ti liu ca bn c setup ng links m bn va in. Mun truy cp ch vic nhp chut vo l bn s m c website ln.
d liu ca bn c ci t ng link m bn va in
khi ng lin kt truy cp s tin hnh l din trong trnh duyt mc nh ca bn.
ng link truy cp s c m ra trong trnh duyt mc nh ca bn
2. Chn ng tt ti mt a im khc trong file Excel
cng tng t nh vi m u ca cch chn ng link cc bn cng cn phi click chut phi vo ti liu cn chn ng tt.
tip n bn chn links trong danh sch ty chn va hin th.
Chn Link trong danh sch ty chn va hin th
Tip ca s cng dng Insert Hyperlink s hin th, cc bn chuyn mc links to sang Place in This Document.
tip n cc bn chn Showroom ca a im mun dn ti bng cch chn tn sheet & in tn k hiu ti liu vo Type the cell reference.
Chn tn sheet v in tn k hiu d liu vohttps://pkmacbook.com/huong-dan-cach-chen-link-vao-filel-excel/
sau cui bn bm OK chng thc thit t, d liu ca bn c ci ng dn n v tr ch nh.
Bm OK xc nhn ci t, d liu ca bn c ci ng dn n v tr ch nh
ch cn bn click vo ng link, con tr chut ca cc bn s vn ng v di chuyn ti ADD bn thit lp.
Con tr chut ca bn s chuyn di ti a ch bn ci t
3. Chn ng tt ti mt file Excel mi
chn ng tt ti mt file Excel mi cng bt u y ht hai phng thc trn, nhng bn nhp chut phi vo cn chn v chn link.
sau khi hnh lang ca s chc nng Insert Hyperlink bt ln, nhng bn chuyn link to sang mc Create New Document.
Vi mc Name of new document cc bn cng c th t tn cho file Excel mi sp c to ln.
Click vo Change chn v tr lu cho file Excel mi.
Chn mt trong nhng hai mc ca When to edit trong :
- Edit the new document later: s cn chnh file Excel mi sau
- Edit the new document now: s bt file Excel ln ngay lp tc chnh sa.
Chuyn sang mc Create New Document
sau cui bn bm OK xc thc, tip n bn s thy ti th mc ch nh c to nn mt folder Excel mi.
Bn s thy ti th mc ch nh c to ra mt th mc Excel mi
4. Chn a Ch Th in t vo file Excel
chn a ch ca hng Th in t vo file Excel cng ging nh vi nhng phn bn trn, cc bn cn phi bm chut phi vo ti liu mun chn.
Tip khi hnh lang ca s tc dng Insert Hyperlink c mt, nhng bn chuyn mc links to thnh E-Mail Address.
in cc thng tin nh a ch ca hng mail cn gi Email address, tiu cho bc th Subject.
in cc thng tin nh a ch mail cn gi E-mail address, tiu cho bc th Subject
cui cng bm OK xc thc l bn chn xong ADD mail vo d liu va chn.
Bm OK xc nhn l bn chn xong a ch mail vo d liu va chn
Cm n cc bn theo di ni dung bi vit mo nh ch dn ca PKMacBook.com chng ti v cch chn link vo file Excel. Chc cc bn c th thc hin thnh cng th php ny v hiu r nhng cch thc hot ng ca n.
Xem thm:
Hng dn cch chn link vo file Excel
C 4 kiu chn link vo Excel, trong s y bao gm chn mt ng dn link trang web hoc bt m mt file trong my tnh vo d liu c sn, chn mt im tt vn ng v di chuyn con tr chn la ti mt a im khc trong chnh file Excel , chn ng dn ti mt file Excel mi, chn mt ng dn gi Email ti folder b nhim.
1. Cch chn link vo Excel
chn lin kt website vo file Excel, th nht cc bn nhp chut phi vo d liu mun chn. Tip bn chn link nm sau cui danh sch ty chn.
Chn Link
hnh lang ca s chc nng Insert Hyperlink s tin hnh bt m, khi ny nhng bn gi nguyn mc link to l Existing File or Web Page.
Tip nhng bn in mt ng links trang web khay Address. k tip cc bn click vo nt OK xc nhn thit lp.
Hoc nu cc bn c nhu cu mun chn ng dn ti mt file trong my tnh tnh ch vic la chn th mc mc Look in bn trn. sau cng bn cng bm OK xc thc thit t.
Chn Existing File or Web Page
khi y ti liu ca bn c setup ng links m bn va in. Mun truy cp ch vic nhp chut vo l bn s m c website ln.
d liu ca bn c ci t ng link m bn va in
khi ng lin kt truy cp s tin hnh l din trong trnh duyt mc nh ca bn.
ng link truy cp s c m ra trong trnh duyt mc nh ca bn
2. Chn ng tt ti mt a im khc trong file Excel
cng tng t nh vi m u ca cch chn ng link cc bn cng cn phi click chut phi vo ti liu cn chn ng tt.
tip n bn chn links trong danh sch ty chn va hin th.
Chn Link trong danh sch ty chn va hin th
Tip ca s cng dng Insert Hyperlink s hin th, cc bn chuyn mc links to sang Place in This Document.
tip n cc bn chn Showroom ca a im mun dn ti bng cch chn tn sheet & in tn k hiu ti liu vo Type the cell reference.
Chn tn sheet v in tn k hiu d liu vohttps://pkmacbook.com/huong-dan-cach-chen-link-vao-filel-excel/
sau cui bn bm OK chng thc thit t, d liu ca bn c ci ng dn n v tr ch nh.
Bm OK xc nhn ci t, d liu ca bn c ci ng dn n v tr ch nh
ch cn bn click vo ng link, con tr chut ca cc bn s vn ng v di chuyn ti ADD bn thit lp.
Con tr chut ca bn s chuyn di ti a ch bn ci t
3. Chn ng tt ti mt file Excel mi
chn ng tt ti mt file Excel mi cng bt u y ht hai phng thc trn, nhng bn nhp chut phi vo cn chn v chn link.
sau khi hnh lang ca s chc nng Insert Hyperlink bt ln, nhng bn chuyn link to sang mc Create New Document.
Vi mc Name of new document cc bn cng c th t tn cho file Excel mi sp c to ln.
Click vo Change chn v tr lu cho file Excel mi.
Chn mt trong nhng hai mc ca When to edit trong :
- Edit the new document later: s cn chnh file Excel mi sau
- Edit the new document now: s bt file Excel ln ngay lp tc chnh sa.
Chuyn sang mc Create New Document
sau cui bn bm OK xc thc, tip n bn s thy ti th mc ch nh c to nn mt folder Excel mi.
Bn s thy ti th mc ch nh c to ra mt th mc Excel mi
4. Chn a Ch Th in t vo file Excel
chn a ch ca hng Th in t vo file Excel cng ging nh vi nhng phn bn trn, cc bn cn phi bm chut phi vo ti liu mun chn.
Tip khi hnh lang ca s tc dng Insert Hyperlink c mt, nhng bn chuyn mc links to thnh E-Mail Address.
in cc thng tin nh a ch ca hng mail cn gi Email address, tiu cho bc th Subject.
in cc thng tin nh a ch mail cn gi E-mail address, tiu cho bc th Subject
cui cng bm OK xc thc l bn chn xong ADD mail vo d liu va chn.
Bm OK xc nhn l bn chn xong a ch mail vo d liu va chn
Cm n cc bn theo di ni dung bi vit mo nh ch dn ca PKMacBook.com chng ti v cch chn link vo file Excel. Chc cc bn c th thc hin thnh cng th php ny v hiu r nhng cch thc hot ng ca n.
Xem thm:
