Create a List of Hyperlinked Sheet Names in Excel

Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
In this video I am going to show you 2 things
1. How to easily create a list of sheet names (you may also call it index of sheets)
2. And then how to create a hyperlink for each sheet name
And for this we'll be using a mix of Power Query and Excel Formulas to get it done fast and easy
You can download the excel file here - www.goodly.co.in/hyperlinked-...
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
www.goodly.co.in/blog

[@GoodlyChandeep]

Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/

[@user-el2ls5bp4j]

FINALLY!! Chandeep - the text was big enough for me to finally understand the hyperlink structure - I kept getting lost in the punctuation!

[@user-fb1ni1vr7i]

Thank you so much, this helped me a lot to link 50+ sheets in one tab.

[@GoodlyChandeep]

Glad it helped!

[@user-fb1ni1vr7i]

I have a quick question, once this has been created how do I link them if I add more sheets to my existing workbook@@GoodlyChandeep

[@afshindejbodi6702]

You are amazing. Thanks for sharing this

[@excel-k-sir]

Good one.

[@sureshshah8508]

Sir, This works beautifully thank for thank video

[@reshminair5502]

Thank you.... it helped a lot :)

[@vineetyoutubr5]

Thank you, Chandeep 😊

[@mahalingayyahiremath2505]

made my life easy - thank u so much

[@GoodlyChandeep]

Glad it helped!

[@urosmaksimovic]

Thanks for this one

[@GoodlyChandeep]

Glad you like it!

[@cherinehaddad5386]

Hi, thank you so much this is great! I do have a questions. I added sheets at the end but it is not populating; I tried to refresh went back to edit query. The new sheets cannot be seen. Can you please help. thank you

[@vitarathiel]

hi ... thx for the tutorial. make the list sheets horizontaly ?

[@thebhaskarjoshi]

great video

[@GoodlyChandeep]

Thanks 💚

[@pranaysai3302]

great video Sir...the ones with vba and macros are very messy. this method is much easier to follow

[@GoodlyChandeep]

Glad you like it 💚

[@johnabram4159]

Great trick referring to the same workbook from within the workbook. However, there's a problem with self-connecting to the active workbook saved on OneDrive Business or Sharepoint. Even with the File>Info>Copy Path route. Error says "... in use by another process." Any solutions guys?

[@whatkellyfound]

I've just managed to make it work by using the Copy Path and "From Web", paste path (delete all characters after the .xlsx), then I used Organisational Authentication to gain access to the data. Follow the remaining steps from there.

[@pib5699]

@@whatkellyfoundcheers legend this worked!

[@sunitabhardwaj856]

Does this work for longer names of sheets with spaces

[@GoodlyChandeep]

Yes it does

[@suryaadiwijaya685]

i just using CTRL + G + Enter

[@baybay7898]

If I change one of the sheet tab name, the index list won't get update? for example, If I change sheet West to sheet Corner, the index list still has West not Corner. What is the solution to that?

[@danielle03201]

How to update the Index list if the tab order changes?

[@GoodlyChandeep]

The tab order should autoupdate!

[@vishalbichakar3300]

I can not see get data option .what can I do?

[@GoodlyChandeep]

If you are working with Excel 2016, you must have a New Query drop down in the Data Tab

[@Jehremy7]

This works, but when I change a tab name the hyperlink in the Index/Query page breaks. Refreshing the Query does not update the tab name for me.

[@raimundojs9547]

Try this: save the file (the workbook) and then refresh all. If it doesn't work, close the file, open it again and then refresh all.

[@ankursharma6157]

Date I post My comment - 6-Jul-2024. I will be Grateful if Someone assists. I am using a MS365 Version. I am unable to connect to the same Workbook. Error message: "We encountered an error while trying to connect . . . because it is being user by another process." Thank You!