How to create a table of contents in excel with hyperlinks

Опубликовано: 12 Октябрь 2024
на канале: Karina Adcock

66,475

456

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 • How to make hyperlinks to multiple fi...