Subscribe to our YouTube Channel for more Videos

How to insert the current file name in a cell in Microsoft Excel ?


Assume that you want to display the name of the current file in a cell of your worksheet , you can easily do it using the formulas in Microsoft Excel 2016.

How to insert the current file name in a cell in Microsoft Excel ?

1. Open your saved Excel workbook in Microsoft Excel 2016.

2. Select a cell where you want to display the name of the file and enter the following formula and press the enter key.

=MID(CELL(“filename”),SEARCH(“[“,CELL(“filename”))+1, SEARCH(“]”,CELL(“filename”))-SEARCH(“[“,CELL(“filename”))-1)

3. The Selected cell should display the name of the excel file in it.

image

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.