How to Get a List of All Worksheet Names Automatically in Excel.

In this video, learn how to list all your worksheet names. Do you have a large Excel workbook and need to generate a list of all worksheet names? Instead of manually copying the names of your Excel worksheets, here is a super simple way to do it.

Here is the first formula in the video to generate your named range.
=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")

Here is the second INDEX formula to list the worksheet names.
=INDEX(ListNames,A1)

**Replace ListNames with your named range, and A1 with the first cell in your sequence

Watch next video tutorial:

Excel Tips Playlist

Subscribe and watch more videos that help you use Microsoft Excel.

Be Social & Let's Connect



Keep Excelling!.

[danielmarpaung]

Hi Barbara, could it be make like a filter list? so like if we filter and choose the list, we move to the sheet or could it be like if we filter and click one of the list, all the cell is change as the data on the sheet but the filter is still in there. Thank you