ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Workbook Headers (https://www.excelbanter.com/excel-worksheet-functions/159459-workbook-headers.html)

[email protected]

Workbook Headers
 
If you have several sheets in a workbook, is there a way to copy your header
information to all pages without having to manually enter it in everyone one
of them?

Bernard Liengme

Workbook Headers
 
You could group the worksheets and then enter the headers.
To group: Click the fist worksheet's tab; hold SHIFT; click the last tab
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"
osoft.com wrote in
message ...
If you have several sheets in a workbook, is there a way to copy your
header
information to all pages without having to manually enter it in everyone
one
of them?





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

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