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
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –
✅ Free Excel Course (Basic to Advanced) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Free Power Query Course –
✅ Best Excel Books:
Subscribe to get awesome Excel Tips every week:
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
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:
✅ 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://bit.ly/excel-vba-course
✅ Free Power Query Course – https://bit.ly/power-query-course
how to calculate number of sheets in a workbook(excel file)
Why your not using MID formula?
I am having the same problem as Vicki, each time I copy the formula to a new worksheet, it changes the formula in all previous entries to that of the last copied formula, – that is – if I initially enter the formula in Sheet1, then copy the formula in worksheet Sheet2, this changes the result in Sheet1 to Sheet2
Wow nice, i can think of many ideas just from this hint… Many thanks sir
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!
Kudos Sir
Thank you Trump excel for sharing your knowledge with us
Great tutorial Sumit. Thank you!!
Excellent زبردست. From Pakistan
Thank you so much for the great excel trick.
Thank you for all you do.
very good trick, perfectly explained.
Good one, thanks. Do you know the formula to get all the sunday date of January 2022 for eg (2,9.16,23 & 30) in different cell?
The way you nest functions is amazing🔥
helpful, thanks a lot!