Excel Tips : How to Make your Worksheet Name To Appear Into the Cell

Posted by : Dexter Panganiban on May 31, 2009 | ; Filed Under microsoft excel

If you don’t use Microsoft Excel forget just go to my other post

Question : How to Make your Worksheet name to appear on your Microsoft Excel Sheet ?

Answer : You can use the formula shown below, just copy and paste this formula in any of the cell where ou want to Worksheet name to appear.

=MID(CELL(“filename”,A1),(FIND(“]”,CELL(“filename”))+1),50)

I am just blogging about this since this helps me alot today and it might help you in the future. Hmmm and by the way I also found it by Googling

Excel Tricks : Hide Those %&@# Formula Errors
Errors in Microsoft excel may sometimes occurs while doing calculation, such us multiplying a word to a number, and many more, This post will help you to drop the unwanted characters that will result to errors in calculation, But you have to use this trick with caution. I recommend using this trick ...
Excel Trick : What is the use of $ sign?
Did you know "$" sign is an important part of excel formula? I would try to teach how you could use this sign. Problem : How can I fix the pick up point in one Excel Cell reference only? ( For this example it is Cell reference A1 ) See it here Technorati tags: Excel Tricks, Excel Tips, Microsoft...
How to Print Row and Column Heading in Excel
There are times that we want to print those letters and numbers seen in Microsoft Excel Worksheet. So here is an instruction on how to do this things in an easy way, Row headings are the row numbers to the left of the worksheet; column headings are the letters or numbers that appear at the top of...

Incoming search terms:

Tags: Microsoft Excel Tips

About the author

Dexter is a person that love technology,new gadget, SEO, Social Media and Christianity. Follow him at twitter via @techathand and add him @ Google+ and contact us at admin@techathand.net

Interesting Comments

4 Responses to “Excel Tips : How to Make your Worksheet Name To Appear Into the Cell”

Chris | Crisiboy.com on May 31st, 2009 8:14 am

dex patulong naman ako..di ko maayos ng kasing ganda ng footer mo ung footer ko..sa editor lang ba un or kelangan ng kong mag widget na footer???

Chris | Crisiboy.coms last blog post..Google Wave Introduces a High Standard Form of Communication

Reply
Dexter Panganiban Reply:
May 31st, 2009 at 8:17 am

@Chris | Crisiboy.com,

Editor lang yun… Send me your footer and I will check

Reply
GarykPatton on June 15th, 2009 6:28 pm

I have been looking looking around for this kind of information. Will you post some more in future? I’ll be grateful if you will.

Reply
Dexter Panganiban Reply:
June 15th, 2009 at 9:39 pm

@GarykPatton,
Thanks for appreciating the post that I made, No problem soon I will add up How To Tips for excel in this blog

Reply