Create Excel Table of Contents with Hyperlinks
Learn to generate a sheet list with clickable links in Excel using Power Query and HYPERLINK formula. 📄
Karina Adcock
83.5K views • Feb 17, 2021
About this video
Using Power Query to make a list of sheets in an excel spreadsheet.
=HYPERLINK("#'"&[@Name]&"'!A1",[@Name])
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelformulas
SUBSCRIBE: https://goo.gl/c46YPs
Microsoft Office 365, Beta Channel, Version 2101
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to make hyperlinks to multiple files in excel https://youtu.be/XZSDTxTVjtc
=HYPERLINK("#'"&[@Name]&"'!A1",[@Name])
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelformulas
SUBSCRIBE: https://goo.gl/c46YPs
Microsoft Office 365, Beta Channel, Version 2101
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to make hyperlinks to multiple files in excel https://youtu.be/XZSDTxTVjtc
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
83.5K
Likes
544
Duration
4:12
Published
Feb 17, 2021
User Reviews
4.2
(16) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.
No specific trending topics match this video yet.
Explore All Trends