I have a workbook in excel 2007 which has 18 worksheets. I want to use the name of each worksheet in one of the cells on that worksheet without having to type it for each worksheet. How can I do this? example names of worksheets jam jelly milk mayo I want to put the name jam in a cell on the jam worksheet etc say in cell B45. I don't want to have to manually type all the names again since they are available in the worksheet instead of sheet1 , sheet2 etc.
Hello and welcome to the forum,
Put this in any cell and it will tell you the sheet name:
Formula:
Please Login or Register to view this content.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
what is all this formula doing? Thank you for the prompt reply.
In #2 abousetta say:
"Put this in any cell and it will tell you the sheet name:"
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
The formula CELL("filename",Range) returns the path, file name and name of a sheet where the 'range' lies. Therefore, A1 can literally be any cell in the worksheet (e.g. B1, Z123, etc.). The rest is just text manipulation to remove everything except the sheet name.
abousetta
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks