Help!

howto put the same header on all worksheets of workbook

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  MS Office Word Doc1 opens too big  
Author Message
lemorse
External


Since: Sep 19, 2009
Posts: 3



PostPosted: Sat Sep 19, 2009 3:04 pm    Post subject: howto put the same header on all worksheets of workbook
Archived from groups: microsoft>public>excel>misc (more info?)

I wish to put the same header on all sheets of a workbook. I have checked
the help resources but could not find anything. Can anyone help me.
Thanks in advance.
Back to top
Francis
External


Since: May 15, 2009
Posts: 17



PostPosted: Sat Sep 19, 2009 3:36 pm    Post subject: RE: howto put the same header on all worksheets of workbook [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Try

Group all the sheets that you want similar header by pressing Shift
and click on the sheets' tab
Go to A1 and type in your header follow by other cells on the first row,
assuming
that you want your headers on the first row
press Enter
Deactivate Group sheets by clicking on one sheet
The same header/s now appear in all sheets you have selected
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis




"lemorse" wrote:

> I wish to put the same header on all sheets of a workbook. I have checked
> the help resources but could not find anything. Can anyone help me.
> Thanks in advance.
Back to top
Gord Dibben
External


Since: Feb 23, 2004
Posts: 9431



PostPosted: Sat Sep 19, 2009 3:44 pm    Post subject: Re: howto put the same header on all worksheets of workbook [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Right-click on a sheet tab and "Select all sheets"

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

This can lead to some problems if you want other print settings different
for each sheet.

I would tend to use a macro so other print settings do not get altered.

Sub AllHeaders()
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Sheets
WS.PageSetup.CenterHeader = "&""Algerian,Regular""&16" _
& "This is my header text"
Next
End Sub


Gord Dibben MS Excel MVP


On Sat, 19 Sep 2009 11:04:02 -0700, lemorse
wrote:

>I wish to put the same header on all sheets of a workbook. I have checked
>the help resources but could not find anything. Can anyone help me.
>Thanks in advance.
Back to top
lemorse
External


Since: Sep 19, 2009
Posts: 3



PostPosted: Sat Sep 19, 2009 3:48 pm    Post subject: RE: howto put the same header on all worksheets of workbook [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Francis,
Thanks for the reply. I will try that but what I wanted was to use the
headers and footers tab under View rather than an individual cell. Will your
method work this way? I've got to try it.

"Francis" wrote:

> Try
>
> Group all the sheets that you want similar header by pressing Shift
> and click on the sheets' tab
> Go to A1 and type in your header follow by other cells on the first row,
> assuming
> that you want your headers on the first row
> press Enter
> Deactivate Group sheets by clicking on one sheet
> The same header/s now appear in all sheets you have selected
> --
> Hope this is helpful
>
> Pls click the Yes button below if this post provide answer you have asked
>
> Thank You
>
> cheers, francis
>
>
>
>
> "lemorse" wrote:
>
> > I wish to put the same header on all sheets of a workbook. I have checked
> > the help resources but could not find anything. Can anyone help me.
> > Thanks in advance.
Back to top
lemorse
External


Since: Sep 19, 2009
Posts: 3



PostPosted: Sat Sep 19, 2009 3:54 pm    Post subject: Re: howto put the same header on all worksheets of workbook [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you to all that replied. I have tried the suggestions and they work
great. I am embarrassed that I couldn't figure it out myself. This is the
first time I have used this forum, always used USENET before, and it has
worked great. Thank you so much.

"Gord Dibben" wrote:

> Right-click on a sheet tab and "Select all sheets"
>
> Set up the header on active sheet and will be done to all.
>
> This can lead to some problems if you want other print settings different
> for each sheet.
>
> I would tend to use a macro so other print settings do not get altered.
>
> Sub AllHeaders()
> Dim WS As Worksheet
> For Each WS In ActiveWorkbook.Sheets
> WS.PageSetup.CenterHeader = "&""Algerian,Regular""&16" _
> & "This is my header text"
> Next
> End Sub
>
>
> Gord Dibben MS Excel MVP
>
>
> On Sat, 19 Sep 2009 11:04:02 -0700, lemorse
> wrote:
>
> >I wish to put the same header on all sheets of a workbook. I have checked
> >the help resources but could not find anything. Can anyone help me.
> >Thanks in advance.
>
>
Back to top
Gord Dibben
External


Since: Feb 23, 2004
Posts: 9431



PostPosted: Sat Sep 19, 2009 6:37 pm    Post subject: Re: howto put the same header on all worksheets of workbook [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Francis' method is used to replicate titles in row 1 across all sheets.

Not for Headers and Footers.


Gord

On Sat, 19 Sep 2009 11:48:01 -0700, lemorse
wrote:

>Francis,
>Thanks for the reply. I will try that but what I wanted was to use the
>headers and footers tab under View rather than an individual cell. Will your
>method work this way? I've got to try it.
>
>"Francis" wrote:
>
>> Try
>>
>> Group all the sheets that you want similar header by pressing Shift
>> and click on the sheets' tab
>> Go to A1 and type in your header follow by other cells on the first row,
>> assuming
>> that you want your headers on the first row
>> press Enter
>> Deactivate Group sheets by clicking on one sheet
>> The same header/s now appear in all sheets you have selected
>> --
>> Hope this is helpful
>>
>> Pls click the Yes button below if this post provide answer you have asked
>>
>> Thank You
>>
>> cheers, francis
>>
>>
>>
>>
>> "lemorse" wrote:
>>
>> > I wish to put the same header on all sheets of a workbook. I have checked
>> > the help resources but could not find anything. Can anyone help me.
>> > Thanks in advance.
Back to top
Bernard Liengme
External


Since: Feb 15, 2007
Posts: 67



PostPosted: Sat Sep 19, 2009 9:10 pm    Post subject: Re: howto put the same header on all worksheets of workbook [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You can access the message/answers using either a web browser (forum), OR
with an email client by setiing up a newsgroup account. Many nof us find the
latter to be more convenient.
Set up new newsgoup account specifying: msnews.microsoft.com as the server
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"lemorse" wrote in message

> Thank you to all that replied. I have tried the suggestions and they work
> great. I am embarrassed that I couldn't figure it out myself. This is
> the
> first time I have used this forum, always used USENET before, and it has
> worked great. Thank you so much.
>
> "Gord Dibben" wrote:
>
>> Right-click on a sheet tab and "Select all sheets"
>>
>> Set up the header on active sheet and will be done to all.
>>
>> This can lead to some problems if you want other print settings different
>> for each sheet.
>>
>> I would tend to use a macro so other print settings do not get altered.
>>
>> Sub AllHeaders()
>> Dim WS As Worksheet
>> For Each WS In ActiveWorkbook.Sheets
>> WS.PageSetup.CenterHeader = "&""Algerian,Regular""&16" _
>> & "This is my header text"
>> Next
>> End Sub
>>
>>
>> Gord Dibben MS Excel MVP
>>
>>
>> On Sat, 19 Sep 2009 11:04:02 -0700, lemorse
>> wrote:
>>
>> >I wish to put the same header on all sheets of a workbook. I have
>> >checked
>> >the help resources but could not find anything. Can anyone help me.
>> >Thanks in advance.
>>
>>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum