Get the Sheet Name in Excel (Easy formula)

In this video, I will show you how to get the sheet name in a cell in Excel using a simple formula. The benefit of using a formula to get the sheet name is that it becomes dynamic and would automatically update in case you change the sheet name.

This could be useful for templatized reports where you can change the sheet name and the reports/dashboard would automatically update

00:00 Intro
00:10 CELL formula to get the full file name
00:56 Formula to extract the Sheet Name from Full File Name

#Excel #ExcelTips #ExcelTutorial

[trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.

Also, I have made all of my Excel courses available for free. You can check these out using the below links:

[paulmarsman]

=MID(CELL("filename", A1), FIND("]", CELL("filename", A1))+1, 255)
This formula will actually get the sheet name and not the ACTIVE sheet name as in the video (causing all sheets to show the same sheet name)

[wayneedmondson]

Great one Sumit! Thanks for demonstrating. Thumbs up!!

[danielhartjes]

Nice job. Easy to understand. Thank you!

[pyinoolwin]

Clever! Please answer some of the questions posed. My exact problem is for totalling data from monthly sheets into a summary sheet. I want to be able to copy/paste (say) January's data into the other 11 months' totals rows, referencing each month. Sumit's solution still does not let me do this.

[HomeChang-bygp]

Hi! Thank you! Your video is awesome! I had try it and it works on my computer. However, after I put it on office 365 the formula break. Can you please advice is it possible to do it for 365?

[vickievans]

Thank you for the clear tutorial. I've learned a lot from your videos!
You have great timing as I am trying to do this very thing in a current workbook. I'm having trouble though. Works perfectly on Sheet1, but when I paste into Sheet2, it changes the name on both Sheet2 and Sheet1 to "Sheet2". Subsequently, when I save in Sheet3, it changes the names on all three worksheets to "Sheet3", and again with Sheet4, now they all have "Sheet4" as the name in the cell. It looks like the same thing happened in your example, when you changed from tab "Q4 2022" back to tab "Q1 2021" the name showing on Q1 tab is "Q4 2022".
Is it supposed to do that? Is there a way to prevent changing the names on the previous sheets? Thank you!

[jonminer]

Hi, TE. Very clever. Thanks for sharing! Stay Healthy!

[nareshnautiyal]

Perfect trick when we use multiple worksheet in a workbook👍👌

[oemarprawirosadi]

Wow nice, i can think of many ideas just from this hint... Many thanks sir

[zafarrizvi]

Dear Sumit, thanks for your excellent videos...I have learnt a lot from them. I am having a small issue when I use your formula for getting the sheet names. The formula works very nicely, but if I copy it to other sheets in the same workbook, all worksheets change to display the name of the last sheet I copied the formula to. Why do you think I am getting this problem. Thanks in advance. Zafar

[IQ_Investment]

Thank you for such useful video. One of my summary file is connected to multiple source files kept in shared drive. Vales in these source files keep on changing daily basis. So I used '=' in my summary file to bring the values from source files. The problem is that every time I have to edit each link to derive the new values even after changing the settings under option. Update option under Data > edit links doesn't work. Sometimes it shows warning. Would be great to have your suggestions. Thanks

[sweetmask]

Hey how about if it's vice versa?

Like the name of the sheet can be changed through cell data

[tarentrew]

such a helpful and easy to follow video. thank you so so much!

[shaileshcastelino]

Great video..thank you for sharing this

[didotbasmayor]

dude ur the best, u earned a subscriber

[BinodKumar-dech]

Hi Sumit Bansal Sir,

Thanks for the above useful video tutorial.

I am using the above formula described in the video, I get same sheet name in all sheets of the workbook.
Every time I have to refresh the cell to get the correct sheet name.

Any suggestions to resolve this problem.

[shiffamohammed]

Thank you so much for the great excel trick.

[sujithortan]

The way you nest functions is amazing🔥

[TheExcelism]

Great Video, Sumit 👍

May be LET() helps us to reduce the formula size by keeping CELL() as variable.