Create defined names, edit and finally delete it By using names, you can make your formulas much easier to understand and maintain You can define a name foInsert current file name or path in cell / header or footer with Kutools for Excel Kutools for Excel's Insert Workbook Information is a mutifunctional tool, it can help you insert worksheet name, workbook name, workbook path or workbook path & name into the Excel cells, header or footer quickly and conveniently For Excel 07, after you've selected the cell or range of cells, click on Insert, then Formulas , then select Define Name in the Name Manager section For the "Names in workbook" field put the name you wish to use The "Refers to" field will automatically have the worksheet and cell location you were on when you started defining the name, eg
Enter A Constant Value In A Defined Name In Excel Text Numbers Formulas Etc Teachexcel Com