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.