![]() ![]() When creating links to Excel files or other documents stored on your computer, you can use either absolute or relative addresses. For example, if you type "in a cell, Excel will automatically add the default "http" protocol and convert it into a hyperlink you can follow. Though, Microsoft Excel can understand URLs without a protocol. In your Excel hyperlinks, you should always supply full URLs for web-pages. On the web, it's a common practice to use relative URLs. Relative link to an Excel file: Source data\Book3.xlsx Relative URL: excel-lookup-tables/index.php For example:Ībsolute link to an Excel file: C:\Excel files\Source Data\Book1.xlsxĪ relative hyperlink contains a partial address. Microsoft Excel supports two types of links: absolute and relative, depending on whether you specify a full or partial address.Īn absolute hyperlink contains a full address, including the protocol and domain name for URLs, and the entire path and file name for documents. Hyperlinks in Excel are easily recognizable - generally this is text highlighted in underlined blue like shown in the screenshot below.Ībsolute and relative hyperlinks in Excel
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |