Excel Formula to List All Sheet Tab Names and include Hyperlinks - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
Ian
This is very useful, Mynda. Many thanks. I have a couple of questions, if you don't mind?
1. Does the # symbol as you've used it there always represent a shorthand for the workbook in formulae? I've not seen that before.
2. I prefer using the .xlsb (binary) format over .xlsm for macro-enabled files, as they are about 80% of the file size, which can make a difference for large files. Do you recommend using .xlsm? In fact, I always use .xlsb as the default for -all- of my files (rather than using .xlsx for non-macro-enabled) as they are always much smaller in size - the difference is even more marked than it is between .xlsb and .xlsm. Do you know of any issues with this approach of always using the binary format?
Thank you.
reply
This is very useful, Mynda. Many thanks. I have a couple of questions, if you don't mind?
1. Does the # symbol as you've used it there always represent a shorthand for the workbook in formulae? I've not seen that before.
2. I prefer using the .xlsb (binary) format over .xlsm for macro-enabled files, as they are about 80% of the file size, which can make a difference for large files. Do you recommend using .xlsm? In fact, I always use .xlsb as the default for -all- of my files (rather than using .xlsx for non-macro-enabled) as they are always much smaller in size - the difference is even more marked than it is between .xlsb and .xlsm. Do you know of any issues with this approach of always using the binary format?
Thank you.
reply
John
Awesome tutorial! One question though. Is there a way to ignore or exclude specific spreadsheets? For example, I'm working on a workbook where the first tab (spreadsheet) is a summary page and I don't want that listed in my list of spreadsheets names. In fact, I'm using your above illustrations to create the list on the summary tab which gathers information from the other spreadsheets. Thank you in advance.
reply
Awesome tutorial! One question though. Is there a way to ignore or exclude specific spreadsheets? For example, I'm working on a workbook where the first tab (spreadsheet) is a summary page and I don't want that listed in my list of spreadsheets names. In fact, I'm using your above illustrations to create the list on the summary tab which gathers information from the other spreadsheets. Thank you in advance.
reply
70pjsmith
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.
reply
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.
reply
Rajiv
Hi Mynda,
This is quite innovative and just what I wanted! Thanks for the workaround for Excel 365 although it required an extra column. Curious to know how you discovered this and how were you creating something similar before discovering this method?
reply
Hi Mynda,
This is quite innovative and just what I wanted! Thanks for the workaround for Excel 365 although it required an extra column. Curious to know how you discovered this and how were you creating something similar before discovering this method?
reply
Earl
Do you have any one on one classes (I always run into issues with excel). It's guaranteed that I will run into a brick wall with excel. I quit taking live classes because my screen almost never looks like the instructor's screen. Please help me!!!
reply
Do you have any one on one classes (I always run into issues with excel). It's guaranteed that I will run into a brick wall with excel. I quit taking live classes because my screen almost never looks like the instructor's screen. Please help me!!!
reply
Alvaro
Great information.
I have a workbook with 20 worksheets in to.
I would like to have a main page with links to all the sheets, and hide the rest of the worksheets.
How can i hyperlink and go to a hidden sheet?
reply
Great information.
I have a workbook with 20 worksheets in to.
I would like to have a main page with links to all the sheets, and hide the rest of the worksheets.
How can i hyperlink and go to a hidden sheet?
reply
Jane
Hi Mynda! This is really cool! Thanks so much for sharing these features. Is it necessary to keep the GET.WORKBOOK Function column in the sheet? I only want to show the sheet names with links in the worksheet.
reply
Hi Mynda! This is really cool! Thanks so much for sharing these features. Is it necessary to keep the GET.WORKBOOK Function column in the sheet? I only want to show the sheet names with links in the worksheet.
reply
Nazrin
This is great Mynda. Now how do I extract cell reference from each sheet? Example, say I have 100 sheets, how do i get cell reference A3 in all the 100 sheets into Sheet1 ?
reply
This is great Mynda. Now how do I extract cell reference from each sheet? Example, say I have 100 sheets, how do i get cell reference A3 in all the 100 sheets into Sheet1 ?
reply
Madhu
Hi Mam,
Have a question
What it result?? if we put =GET.WORKBOOK(2), =GET.WORKBOOK(3), and so on....-
What are the uses of second argument in given function
reply
Hi Mam,
Have a question
What it result?? if we put =GET.WORKBOOK(2), =GET.WORKBOOK(3), and so on....-
What are the uses of second argument in given function
reply
Add a review, comment
Other channel videos
