{"id":111,"date":"2013-12-16T23:06:56","date_gmt":"2013-12-16T15:06:56","guid":{"rendered":"http:\/\/excelchamp.net\/?p=111"},"modified":"2022-07-11T06:27:42","modified_gmt":"2022-07-10T22:27:42","slug":"display-the-filename-filepath-in-excel","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/display-the-filename-filepath-in-excel\/","title":{"rendered":"Display the File Name & File Path in Excel (PC & Mac)"},"content":{"rendered":"

Many a time, it is good to Display the location of the file in Excel.<\/p>\n

Not just the file name, but the entire path of the file. It is a good reference to make sure you are working on the correct file and is also good if you print out the Excel. With this option, the file path always gets printed on paper..<\/p>\n

How to Write a Formula that will Display the File Path in Excel, automatically.\u00a0<\/strong><\/h2>\n

One useful formula that can assist us is the CELL<\/strong> formula. I bet you didn’t know about this in-built Excel Function…<\/p>\n

The CELL function can help us to display the address, colour, format, type or width of any cell.<\/strong><\/em><\/p>\n

The CELL Function takes a maximum of 2 arguments, and only the first one is mandatory.<\/p>\n

=CELL(info_type, [reference])<\/strong><\/em><\/p><\/blockquote>\n

So, if you write =CELL(“filename”)<\/strong> in any cell, you will get the Full Pathname of this Excel file<\/strong>, along with the Sheet Name.<\/strong><\/p>\n

For example, I got the filename displayed as below:<\/p>\n\n\n<\/colgroup>\n\n\n
D:\\[email-blasting-migration.xlsx]Sheet1<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

According to the Excel Help, the CELL function \u00a0has the following arguments:<\/a><\/strong><\/p>\n