Tech At Hand Dot Net

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

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 🙂

Exit mobile version