How to Get A List of All Worksheet Names In Excel

*How to Get A List of All Worksheet Name In Excel*
In this advanced excel tutorial, I’ll explain a tremendous method of getting a list of all worksheet name automatically from your excel workbook without any use of VBA or complex procedure. I’ll be using named ranges and a formula to solve this. In this tutorial you’ll learn how powerful named range can be. Without further ado let’s follow the procedure and get a list of all the worksheets you have in your workbook.
To get a list of all worksheet names automatically in excel you need to create a named range. For that click on the formula tab and then click on the “Name manager” and then click on “New”. Give a name for your named range, in our case I gave it Worksheet_Name_List. Once you’ve given the name you need to write this formula in the “Reffers to” Section and then click ok.
=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")

Now write this formula where you want to list all your worksheet names in excel.
=IfError(INDEX(Worksheet_Name_List,Row(A1)),"")

This is how we list worksheet names in excel using named ranges and a formula. Thanks for watching.

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media: