|
Common header/footer in Excel
An option should exist to create a uniform header/footer format across
worksheets in Excel. I shouldn't have to create the same header/format format across multiple sheets. I should be able to create one header format and then just change the text/content across the sheets. This is a big hassle when trying to create print-ready, multiple worksheet files in Excel that have similar formatting. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Common header/footer in Excel
This similar to a problem I have trying to use the secure print feature of
printers so equipped. Since Excel sends each worksheet as a separate print document using the properties box for printing options to secure the document only works on the selected worksheet. The others print regularly. I have changed my default printer setting to use secure print to work around and deselect the secure option as needed. You can also change each worksheet individually or create a second printer with different default values for the same device. This solves the problem but leaves me with the task of releasing each worksheet individually. Anyone found a different/better workaround? "James" wrote: An option should exist to create a uniform header/footer format across worksheets in Excel. I shouldn't have to create the same header/format format across multiple sheets. I should be able to create one header format and then just change the text/content across the sheets. This is a big hassle when trying to create print-ready, multiple worksheet files in Excel that have similar formatting. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Common header/footer in Excel
Not only do I agree with James, but I must emphasize what a colossal waste of
time this is, typing a custom header on 20 or 30 worksheets for a client. Ridiculous. This has been a problem for years and just because most users don't bother complaining, doesn't mean you shouldn't fix it. "James" wrote: An option should exist to create a uniform header/footer format across worksheets in Excel. I shouldn't have to create the same header/format format across multiple sheets. I should be able to create one header format and then just change the text/content across the sheets. This is a big hassle when trying to create print-ready, multiple worksheet files in Excel that have similar formatting. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Common header/footer in Excel
Select ALL sheets BEFORE you put in the header. Perhaps most users know
this already, and so there is no NEED to complain. Pan1 wrote: Not only do I agree with James, but I must emphasize what a colossal waste of time this is, typing a custom header on 20 or 30 worksheets for a client. Ridiculous. This has been a problem for years and just because most users don't bother complaining, doesn't mean you shouldn't fix it. "James" wrote: An option should exist to create a uniform header/footer format across worksheets in Excel. I shouldn't have to create the same header/format format across multiple sheets. I should be able to create one header format and then just change the text/content across the sheets. This is a big hassle when trying to create print-ready, multiple worksheet files in Excel that have similar formatting. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
| All times are GMT +1. The time now is 12:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com