The value 1 if the cell is formatted in color for negative values otherwise returns 0 (zero). Reference of the first cell in reference, as text. The following list shows some of the possible values of the info_type argument and the corresponding results. A text value that specifies what type of cell information you want to return. So, if you write =CELL(“filename”) in any cell, you will get the Full Pathname of this Excel file, along with the Sheet Name.įor example, I got the filename displayed as below: D:\Sheet1Īccording to the Excel Help, the CELL function has the following arguments: The CELL Function takes a maximum of 2 arguments, and only the first one is mandatory. The CELL function can help us to display the address, colour, format, type or width of any cell. I bet you didn’t know about this in-built Excel Function… One useful formula that can assist us is the CELL formula. How to Write a Formula that will Display the File Path in Excel, automatically. With this option, the file path always gets printed on paper.
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. Not just the file name, but the entire path of the file. Many a time, it is good to Display the location of the file in Excel.