Create Hyperlinks to Files & Folders in Excel

Learn how to create links to all files and sub-folders in an Excel folder for quick access. πŸ‘

Create Hyperlinks to Files & Folders in Excel
Chester Tugwell
86.8K views β€’ Feb 8, 2023
Create Hyperlinks to Files & Folders in Excel

About this video

πŸ‘πŸ‘If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! πŸ‘πŸ‘
In this Microsoft Excel video tutorial I explain how to create hyperlinks to files and folders in Microsoft Excel. The tutorial features the HYPERLINK function and Power Query. Power Query can be used to list all the files and sub-folders within a folder.

Table of Contents:

00:00 - Introduction
00:21 - Link to a specific folder
00:57 - Link to specific file (Excel, Word pdf etc)
01:24 - Link to a specific sheet in an Excel workbook
02:15 - Link to a particular cell in another Excel workbook
03:52 - Link to a particular place in a Word document
05:00 - Create links to all files in a folder and its subfolders using Power Query and the HYPERLINK function
08:26 - Create links to all subfolders within a folder using Power Query and the HYPERLINK function
------------------------

Video Information

Views

86.8K

Likes

593

Duration

11:14

Published

Feb 8, 2023

User Reviews

4.2
(17)
Rate:

Related Trending Topics

LIVE TRENDS

Related trending topics. Click any trend to explore more videos.