ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/21693-excel-workbooks.html)

carrollking

Excel workbooks
 
In a workbook, how do I set up the same header across worksheets without
having to create each one individually?

Gord Dibben

Select first sheet then right-click on sheet tab and "select all sheets"

Enter your header and will be done to all sheets.

DO NOT FORGET to ungroup the sheets when setting the header is complete.


Gord Dibben Excel MVP

On Tue, 12 Apr 2005 16:27:01 -0700, "carrollking"
wrote:

In a workbook, how do I set up the same header across worksheets without
having to create each one individually?




All times are GMT +1. The time now is 02:23 AM.

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