![]() ![]() On the Ribbon, click Insert > Header & Footer.Ģ. If you want to insert the filename or filepath into the wotksheet header or footer, you can use the Header & Footer function.ġ. Copy any above formula that you need to a specified cell, and you will get the result you need.Ģ. =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"),1))Ĭurrent filename, filepath and active sheetnameĬ:\Users\dt\Desktop\New folder\Sheet7ġ. With the following formulas, you can quickly insert file name or path or sheetname in a speicfied cell. ![]() Insert current file name or path in cell / header or footer with Kutools for Excel Insert current file name or path in header/footer with Header & Footer function Insert current file name or path in a cell with Formula Supposing you want to insert the file name or file path into Excel cell, header or footer, how could you quickly do this operation? How to insert file name or path into cell / header or footer in Excel? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |