Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 176
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print 1st Page Multiple Sheets in Same Workbook Ben Dummar Excel Discussion (Misc queries) 8 May 22nd 07 09:18 PM
In excel print header on firt page only roberte Excel Discussion (Misc queries) 2 May 14th 06 09:07 PM
Problem with Page Numbering Aurora Excel Discussion (Misc queries) 0 November 21st 05 02:10 PM
Page Numbers Aurora Excel Discussion (Misc queries) 0 November 17th 05 08:04 PM
How do I print a one page spreadsheet multiple time, each with its own page number? lhsallwasser Excel Discussion (Misc queries) 4 August 17th 05 03:00 PM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"