ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I customize Excel to always print the name of the spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/227730-can-i-customize-excel-always-print-name-spreadsheet.html)

UB Mike

Can I customize Excel to always print the name of the spreadsheet
 
Is it possible to customize Excel so that the name of the spreadsheet always
prints on a hard copy?

Dave Peterson

Can I customize Excel to always print the name of the spreadsheet
 
Yes.

But the solution depends on the version of excel.

In xl2002+, you can specify the worksheet name or workbook name (path or path
and file name) in the File|page setup|header and footer tab (custom buttons).

In xl2k and earlier, you'd need a macro.

But that would depend on what you mean by "name of spreadsheet". Worksheet name
or filename or what.

UB Mike wrote:

Is it possible to customize Excel so that the name of the spreadsheet always
prints on a hard copy?


--

Dave Peterson


All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com