Links arent just something for interlinking websites.
Many users also need to incorporate links within document files like Excel spreadsheets.
Adding hyperlinks to Excel spreadsheets enables users to cross-reference and cite external online data sources.
There are various ways you’re free to incorporate links in Excel spreadsheets.
Excel users can add external hyperlinks for opening sites and internal links for navigating sheets.
This is how it’s possible for you to add external and internal links to spreadsheets in Excel.
Click a cell in your Excel spreadsheet and then input a URL.
The URL entered must include the “www” subdomain, but the HTTP part is not essential.
For example, enteringwww.google.comwill automatically link to that search engine.
Ourguide to URLs, and how to edit themexplains how you might modify website addresses entered.
PressCtrl+Cto copy the URL.
Then choose a cell within your Excel spreadsheet and pressCtrl+Vto paste in the URL.
Youll probably need to resize your spreadsheet columns to fit long website addresses.
Websites use anchor text for the links they include.
However, you cant incorporate anchor text in your links by manually entering addresses.
For that reason, its better to utilize Excels Link tool.
That tool enables users to insert hyperlinks into spreadsheets with meaningful anchor text.
Keeping the anchor text reasonably short will enable you to fit the links in cells better.
Clicking that link will pop swing open the linked page in your default net web client software.
you’re able to modify an inserted hyperlink by selecting its cell and clicking theLinkbutton.
Aside from websites, you could link to documents and directories in your Excel spreadsheets.
ClickCurrent Folder>Browse for Fileand select a document to create a link for.
Or you’re free to select a folder for a link to open.
Then poke the file or folder link in the spreadsheet to open it.
Clicking a document link will pop pop the file with its default software.
All links to folders will open directories in Explorer.
you might also set up internal links within theEdit Hyperlinkwindow.
Internal links take you to specific cells in Excel spreadsheets.
Such links can be useful for enhancing navigation in large spreadsheets with many data tables and sheets.
it’s possible for you to create tables of contents for larger worksheets with internal linking.
hit the+button forCell Referenceto select a sheet number.
Now smack the internal link youve added to the spreadsheet.
The link will select whatever cell reference you set it to.
The anchor text for an internal link can be anything you wish.
you’re free to also create document file links with the HYPERLINK function.
To do that, input the full folder path for a file within theLink_locationbox inside the Function Arguments window.
That path must include the files full title and its format extension.
That method involves dragging a destination cell for a link into a location to insert it.
However, note that this method only works within saved Excel workbooks.
Then release theAltkey when youve switched sheets.
How to Remove Links in Excel Spreadsheets
Its easy to remove links added to Excel spreadsheets.
you might do so by right-clicking a cell that includes a link and selectingRemove hyperlink.
Alternatively, select a cell and click theLinkbutton.
Then select theRemove Linkoption in the window.
PressCtrl+Ato select all the cells in a sheet.
Then right-clicking a sheet and selecting Remove hyperlink will erase all links on it.
Adding internal links to other cells is also a good way to facilitate navigation within Excel workbooks.
