FILE NAMES

Put the formula; =CELL('filename') in any cell in the print range. If I put it in the bottom Right, I format the alignment to Right and change the font size to 8. JSW

IS THERE ANY KIND OF GLOBAL SETTING TO GET ALL SPREADSHEETS TO PRINT THE PATH NAMES.

THANKS FOR YOU HELP

You could use the "print header" function to display file name

This won't get the entire path statement, but you can get a header print out of the file name by going into File-->Print Preview and click on "Setup" then select the "Header/Footer" tab. Click on the drop down list for the header and you'll see that one of the options is the name of the file. I know that if you create one sheet and make these changes to the print settings, you can copy the sheet and the settings will copy as well, but I don't know if there is a global command to change all of the sheets in a workbook at once. Hope that helps.

Only four ways

The four ways are:
1. Cell('filename') in a sheet cell.
2. Header, footer page code.
3. Sheet Tab code, puts item #1 in automatically, in a preset sheet cell.
4.Macro to set #1 or #2 on print.

Excel has no global setting for this function! JSW

Thanks for your help!!!!!!!!!!!!