Skip to main content

Conas hipearnasc a chruthú le fillteán ar leith in Excel?

Údar: Siluvia Athraithe Deiridh: 2020-04-23

Trí hipearnasc a chruthú le fillteán ar leith cabhraíonn sé leat an fillteán seo a oscailt go héasca gan ach cliceáil ar an nasc seo in Excel. San Airteagal seo, taispeánfaimid modh duit chun hipearnasc a chruthú chun fillteán céim ar chéim.

Cruthaigh hipearnasc le fillteán ar leith in Excel

Cruthaigh hipearnasc le fillteán ar leith in Excel

I ndáiríre, tá sé éasca go leor hipearnasc a chruthú le fillteán ar leith leis an bhfeidhm Hyperlink in Excel. Déan mar a leanas le do thoil.

1. Oscail an fillteán sonrach is mian leat a nascadh le cill Excel, cóipeáil cosán an fhillteáin sa bharra seoladh. Féach an pictiúr:

2. Téigh go dtí an scarbhileog, roghnaigh agus cliceáil ar dheis an chill ar mhaith leat hipearnasc a chruthú léi. Agus ansin cliceáil Hyperlink sa roghchlár cliceáil ar dheis.

3. Sa Cuir isteach Hyperlink dialóg, cliceáil Comhad nó Leathanach Gréasáin atá ann sa Nasc le roinn, ansin greamaigh cosán an fhillteáin a chóipeáil tú isteach sa Seoladh bosca, agus ar deireadh cliceáil ar an OK cnaipe. Féach an pictiúr:

Anois cruthaítear an hipearnasc go rathúil. Nuair a chliceálann tú an hipearnasc sa chill seo, osclófar an fillteán sonrach go huathoibríoch.

Scrios go tapa gach hipearnasc i raon roghnaithe, gníomhach / roghnaithe / gach bileog in Excel

Kutools le haghaidh Excel's Bain hipearnasc gan formáidiú a chailleadh is féidir le fóntais gach hipearnasc i raon séalaithe, bileog ghníomhach, bileoga roghnaithe nó gach bileog sa leabhar oibre reatha a scriosadh go tapa.
Íoslódáil Kutools le haghaidh Excel anois! (tras saor in aisce 30-lá)

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup  |   VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle   |  Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla   |  Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí:  12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (11)
No ratings yet. Be the first to rate!
Mark
Mark
This comment was minimized by the moderator on the site
How many folders for the path will hyperlink work for as one of my links will only go 5 folders into the path and I need it to go 9?
Reply
0
0
crystal
crystal     Mark
This comment was minimized by the moderator on the site
Hi Mark,
I have no way to confirm if there is a limit to the number of folders in the link, I tried it from my side and could access 10+ folders. Would you mind providing a screenshot of your data?
Reply
Report
0
0
ilaiyaraja
ilaiyaraja
This comment was minimized by the moderator on the site
excelent thank you so much

hyperlink to folder
Reply
0
0
Mari
Mari
This comment was minimized by the moderator on the site
I am trying to create a hyperlink that will open a file in a folder. Given I have the file name in the spreadsheet, I’d like to use that to identify the marching file name I want to open in the folder.
Reply
0
0
crystal
crystal     Mari
This comment was minimized by the moderator on the site
Hi Mari,
Supposing there is an Excel workbook named "test" saved in a folder (the path to the folder is C:\Users\Win10x64Test\Desktop\new). To create a hyperlink to open this workbook, plesae use the following path: C:\Users\Win10x64Test\Desktop\new\test.xlsx.
Reply
Report
0
0
Camila
Camila
This comment was minimized by the moderator on the site
hi! I have a Google Drive folder with my coworkers and I want the hyperlink to go to eg "COMPANY > CLIENT > NOVEMBER > OP12547" but when I follow the instructions the hyperlink goes to "COMPANY > CLIENT". Do you have an idea of what the problem is?
Reply
0
0
Maurizius
Maurizius
This comment was minimized by the moderator on the site
Hi. I share a Excel Document on Dropbox with my partner. When she opens it, she has an other file-path and all hyperlinks to the other file dosn't work anymore. Do you know how to handle this the best way? thank you
Reply
0
0
Chris
Chris
This comment was minimized by the moderator on the site
this is fine if the link is static - can you create a link if the underlying folder is changeing - eg. Marketing Jan 2019 which changes each month? Could you link this to a cell which has a formula for creating the appropriate path?
Reply
0
0
Julian
Julian     Chris
This comment was minimized by the moderator on the site
Yes, use the =HYPERLINK function.
Works like a charm.
Reply
0
0
crystal
crystal     Chris
This comment was minimized by the moderator on the site
Hi Chris,
Sorry can't help you with that yet. Sorry for the inconvenience.
Reply
Report
0
0
J
J
This comment was minimized by the moderator on the site
Excellent, thank you for sharing
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations