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

Learn how to get a list of all worksheet names automatically in Excel. Have a very large Excel workbook with a high number of worksheets? If somebody wants a list of all those named sheets copying those names manually could take some time. There is a more efficient solution.

Follow this simple video Excel tutorial and learn the most efficient solution to copying names of all worksheets in any Excel workbook.

Here is the formula used in the video:
=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")

#excel #worksheet #tutorial

If you are interested in more advanced Excel videos then I highly recommend @MrXL

Remember to subscribe to Usemybox for computer how to videos in Excel, Word, Powerpoint, Windows, internet browsers and more.

Subscribe for More IT & Software How To Videos:

[gapncaps]

Really Useful!!! thanks for the lay down of the instructions!

[GiSquared]

MIND BLOWN - That was SOOO EASY and it works fantastically... Thank you. I had VBA Code for this but it got cumbersome to keep it up.

[benrobinson]

Thanks mate. Easy and straight to the point!

[hshs]

Great, it worked. Thank you verryyyy much

[AngusVW]

This has saved me so much time thank you!!

[emilylaney]

I love it. Works a treat. Does a similar function like this exist for Google Sheets to sum up 50 sheets in an index tab with named ranges?

[jessiemccollum]

Hi, you are a hero. Thank you so much for this video

[oussamathedjfreeman]

Hi how to retrive worksheetbon excel, how to refee cell into another cell from previous workshertsonif ibrename that wlrksheet it will not lose data ''like refer to position of worksheet''

[bkkbapmalang]

Thank you very much for your help, but I have a question. Why does it only work for excel 2013, with other version it does not work.

[syanlee]

Awesome, the index list.
Any method to have the index list with additional columns to copy the data from the same cell from respective worksheets?

[donbass]

I find that the statement works great when first run but when I need to add a sheet and go from the first line in B to pull down to update the names B1 is Ok but any line after that changes the cell to #NAME? .

[vishalgupta-wyun]

Can we use this formula when it is combined with vlookup

I tried getting NA

[VibhutiGaneshG]

At 0:28 it would be better to use 'IFERROR' in the formula. The formula =IFERROR(INDEX(ListSheets, A1), "") when used will eliminate the #REF! error issue when the numbers in column are more than the no. of sheets in the workbook.

[shriss]

Can I save sheet name more then 32 characters or letters if yes can you please help me with that

[dearuniverse]

Sir I forgot XL sheet file name, but I named all sheets how to find that file by sheet names

[AbdullahMahmood-yrxo]

Got #Name? & now #VALUE! error When I Put =INDEX(ListSheets, A1)

[motlik]

Great video. But as soon as I save the workbook and open it again, it doesn't work anymore.

[deltawing]

Hi, in Excel 365 this definition of the name is refused.

[radhakrishnakencha]

If I delete any sheet or add new sheet, the list is not getting updated until I go to the cell and do enter manually... It is not working through Calculate sheet option which refresh the formulas in the respective sheet

[soglowbus]

IT SHOW #BLOCKED DON'T KNOW WHY PLEASE HELP