Excel Formula to List All Sheet Tab Names and include Hyperlinks

[abdulhaseeb]

This is something I have never seen anyone do. You continue to amaze us by bringing these hidden features as tutorials.

[davegoodo]

Thanks Mynda, I liked it, smooth presentation and it reminds me that I need to spend more time in Excel doing things like this! Keep up the great work.

[pjsmith]

Thank you so much Mynda, this was extremely helpful. I had previously found and used a MACRO that automatically creates a Table of Contents sheet within a large workbook, but it left some formatting issues that I haven't gotten around to tweaking within the VBA code. In light of that challenge, this was a great alternative.

[robrayborn]

I'm going to share this with all my Accounting friends! This is great! Thank you!

[KevD_]

Thanks for sharing this. I have worked with enormous spreadsheets in the past where this would have been useful. Always useful to have things like this stored away in case I might need the in the future.

[garrydhillon]

You are awesome! looked for this all over the net. Well narrated and complied.
Excellent Tutorial

[IvanCortinas_ES]

Excellent. Sparkly. Very solid work. Thanks Mynda!

[prashantdeokule]

Your videos are "WOW".... Truly very informative and helpful. Thank you

[countduckula]

Thanks Mynda, an extremely informative video!

[mariaalcala]

Great video Mynda! Thanks a lot! It’s exactly what i need led right now!

[hcandts]

Great functionality learned something new again, and it does beat macros for a quick look

[arunrai]

Awesome as always!!! Wishing you a great year ahead😊

[madhubhimanapelli]

Wow.... This was so helpful to jump in other sheet, it'll save much more time

[darrylmorgan]

Hi Mynda!Really Helpful Informative Tutorial..Thank You :)

[Divel]

This is great, just what i needed for my recipe search :) have an awesome day!

[naveedyousaf]

Wonderfully Explained! Thanks for sharing.

[HimanshuTandon]

Wonderfully explained. Thank you so much.

[ApteryxRex]

Thank you so much! I’ve been trying to make a right-hand dockable and/or floating form with dynamic list of sheet names with hyperlinks. So that sheet names are listed vertically ( wish this was an option in file settings) . Just to free up some vertical realestate and make it easier to see all sheet names. But this method could be just what I’m after.

[grahamparker]

Nice one Mynda, haven’t seen this functionality before.

[dashrathpanchal]

Thanks for sharing Mynda.
I am frequently using this technique to navigate between lots of sheets in the workbook.
But, Next complexity of this navigation is that; how to return at original cell where we clicked "Go to Sheet" because usually we will return back to "A1" cell on list of sheet which is by default.

Here I am using below technique to get return at original cell
1. For e.g creating a name as "Ref"="C"&MATCH(REPLACE(CELL("filename"), 1, FIND("]", CELL("filename"), 1), ""), listsheet!$C$3:$C$28, 0)+2"
(Above "listsheet" is main sheet of hypderlinks)
2. Create a hyperlink "Back" using above name "=HYPERLINK("#'listsheet'!"&Ref&"", "Back")

Please let me know how it looks and advise if any other way to return at the cell where we clicked "Go to sheet" without VBA

Great learning from your tutorial videos !!