The first part just says “filename”. It is important to add the quotation marks. The second part is optional and can link to any cell or workbook. If you leave it blank the current cell and workbook will be used. The basic version of the CELL formula (= CELL ('filename', A1) ) returns the full path, file name and sheet name. Note that =CELL('filename') gives you the path to the last workbook/worksheet changed so if you have 2 workbooks open, abc and xyz and your formula is in abc, if you last changed a value in xyz the formula in abc will reflect that and return xyz.xlsx.

Contents • • • • • Introduction: Get all the names you need Fortunately, you don’t have to use VBA. There are formulas for each variation of the sheet name, file name and path. The main part of the formula is the =CELL() formula. The looks something like this: =CELL(“filename”,A1). That means that the CELL formula we have to use has two parts: • The first part just says “filename”. It is important to add the quotation marks. • The second part is optional and can link to any cell or workbook. If you leave it blank the current cell and workbook will be used.

The basic version of the CELL formula ( = CELL ( 'filename', A1 ) ) returns the full path, file name and sheet name. You can use this formula and cut it into the parts you need. Therefore you use string formulas like, and so on.

We won’t go into detail now as those formulas are highly specific and complex but rather provide the formulas for you to copy. Note: We’ve published an about three methods of how to get the sheet name. Maybe this one is interesting for you as well. The formulas for sheet name, file name, path etc. How to search for printer mac.

The formulas for inserting file names, sheet names or the path (with and without the extension) are very different. This table gives you an overview. If you want to copy the formulas, you can find them underneath again. Copy these formulas for any linked cell or sheet: If you want to get the file name, sheet name or path from another cell or workbook, you can use one of the following formulas. Instead of “A1” you insert your cell reference. I get my filename and path by inserting =cell(“filename”) and it put it right where I want it (next to bottom row in spreadsheet so it shows when I print). However, as I am working with several spreadsheets, the filename changes to the last spreadsheet worked with, so I constantly need to re-insert the correct filename.

Very frustrating. Any solutions to stop my filename from changing.

It should always reflect the corret filename for the spreadsheet I am working on, once I have inserted after the first time. Kindest, Bob.

How to quickly insert file path into Excel? If there are numerous files or folders in your computer, and you want to use an Excel worksheet next time, but it is difficult for you to find the specified excel file you need. In this situation, you can copy the full path of the specified excel file and paste it to any other places you can quickly find.