Ken Fernandez

A: When you print a worksheet, you might want the sheet's name displayed in a cell in case you need to refer to the original sheet. Oddly, Excel does not offer a function that displays the sheet's name. As you noted, the CELL() function comes close. The formula =CELL("filename") displays the workbook's full path, along with the worksheet name.

The actual string "filename" is the required parameter.

For example, this formula might return something like C:\WINDOWS\Desktop\[Budget.xls]Sheet2. Getting Excel to return only the sheet name requires a more complex formula that strips off everything except the name of the sheet:

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename"))-FIND("]",CELL("filename")))