ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can a header be applied once to a workbook & print on each page? (https://www.excelbanter.com/excel-worksheet-functions/103818-can-header-applied-once-workbook-print-each-page.html)

Christine Sullivan

Can a header be applied once to a workbook & print on each page?
 
I would like to setup a custom header once for a workbook and have to applied
to each page.

David Billigmeier

Can a header be applied once to a workbook & print on each page?
 
<View
<Header and Footer...

--
Regards,
Dave


"Christine Sullivan" wrote:

I would like to setup a custom header once for a workbook and have to applied
to each page.


Gord Dibben

Can a header be applied once to a workbook & print on each page?
 
Christine

What do you consider as a "page"?

A printed page or a worksheet?

If you mean worksheets, right-click on the first sheet tab and "select all
sheets"

Set up the custom header for the active sheet and will be done to all.

DO NOT FORGET to right-click and "Ungroup sheets" when done the setup.

If page means printed pages from one worksheet, just place the header on that
sheet.

All pages will have the header.


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 10:08:01 -0700, Christine Sullivan <Christine
wrote:

I would like to setup a custom header once for a workbook and have to applied
to each page.




All times are GMT +1. The time now is 05:34 AM.

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