MrExcel Publishing
Your One Stop for Excel Tips & Solutions

FILE NAMES


Posted by JUDY on June 14, 2001 6:29 AM

IS THERE A SETTING TO GET THE FILE NAME AND PATH TO PRINT ON ALL SPREADSHEETS?


Posted by Joe Was on June 14, 2001 6:34 AM

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

Posted by JUDY on June 14, 2001 6:56 AM


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

THANKS FOR YOU HELP

Posted by Eric on June 14, 2001 7:18 AM

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.

Posted by Joe Was on June 14, 2001 8:45 AM

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

Posted by Judy on June 14, 2001 10:05 AM

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