MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Andrew Miller on September 18, 2001 11:52 AM

Is there any way to create a uniform header for multiple sheets in a workbook? I have a workbook with 37 sheets in it and I can't figure out how to change the headers without doing it one by one to every individual sheet which is very time consuming. Hopefully there is something I'm missing.

Posted by Aladin Akyurek on September 18, 2001 12:03 PM

Click on the tab of the first sheet then shift+click on the tab of the last sheet. What you enter on the first sheet will also appear on every other sheet automatically.