ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Custom header (https://www.excelbanter.com/setting-up-configuration-excel/57765-custom-header.html)

Carmel

Custom header
 
How do I apply a custom header or footer to multiple worksheets in an Excel
workbook? I'm in XP if that matters.

Dave Peterson

Custom header
 
Click on the first worksheet tab and ctrl click on the subsequent tabs.

Then do your page setup.

Remember to ungroup the sheets when you're done--if you make a change to a
worksheet that's grouped, you'll be changing the others in that group.

Just rightclick on one of the grouped worksheet tabs and select ungroup sheets.



Carmel wrote:

How do I apply a custom header or footer to multiple worksheets in an Excel
workbook? I'm in XP if that matters.


--

Dave Peterson


All times are GMT +1. The time now is 07:00 AM.

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