This FORGOTTEN Excel Function Gives You a List of All Sheet Names (takes 5 Seconds)

In this video, I will show you an old macro-4 function in Excel that can be used to get the list of all the sheep names in the current workbook. While this function cannot be used directly inside the worksheet, it can be used within the named range and then that named range can be used to get the list of all the sheet names. Additionally, I will also show you how to get the list of all the sheet names using Power Query. ➡️ Download File: https://www.dropbox.com/scl/fi/yjjjskw83zikc1g10tuqg/Get-List-of-Sheet-Names.xlsm?rlkey=daxhyyprrl00kc321mfxragk6&dl=1 ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB ✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course ✅ Free VBA course - https://trumpexcel.com/excel-vba-course/ ✅ Free Power Query Course - https://trumpexcel.com/power-query-course/ ✅ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1 #Excel #ExcelTips #ExcelTutorial #SumitBansal