How to use cell function in excel

CA CS CIMA Prakash Somani (Landmark Group) (23502 Points)

22 November 2011  

Many a times we open the file but don’t know where the file was actually been saved or need complete location of the file… to able to do this pls rfer below formula
very simple formula which can be very useful for you..

Just type >>>>> =CELL("filename") <<<<< in any cell and
it will give you the complete address in the file itself


likewise you can use many functions with this formula (refer image below)