In 2003 how do I show the Header (the Custom Header -- NOT the column 
headings) on all pages?  I KNOW I've done this in the past, but cannot 
remember how I did that.  Thanks in advance---I KNOW one of you geniuses will 
know the answer to this! 

click on file, page setup, header/footer, make the desired changes and u r at 
home.


-- 
learn - n - enjoy
-------------------------------------
click yes below, if it works for you


"Bons" wrote:

> In 2003 how do I show the Header (the Custom Header -- NOT the column 
> headings) on all pages?  I KNOW I've done this in the past, but cannot 
> remember how I did that.  Thanks in advance---I KNOW one of you geniuses will 
> know the answer to this! 

if u want to format header and/or footer for all sheets in an given workbook,
open the file, on the sheet tab right click and click on "select all sheets" 
and the n do as already explained i.e. click on file, page setup, 
header/footer, carry out necessary changes and u r at home, i think.


-- 
learn - n - enjoy
-------------------------------------
click yes below, if it works for you


"Bons" wrote:

> In 2003 how do I show the Header (the Custom Header -- NOT the column 
> headings) on all pages?  I KNOW I've done this in the past, but cannot 
> remember how I did that.  Thanks in advance---I KNOW one of you geniuses will 
> know the answer to this! 

Just note that most print settings for all sheets will take on the format of
the active sheet when sheets are grouped.

Not just the header/footer.


Gord Dibben  MS Excel MVP




On Thu, 4 Mar 2010 10:07:01 -0800, YESHWANT
<YESHWANT@discussions.microsoft.com> wrote:

>if u want to format header and/or footer for all sheets in an given workbook,
>open the file, on the sheet tab right click and click on "select all sheets" 
>and the n do as already explained i.e. click on file, page setup, 
>header/footer, carry out necessary changes and u r at home, i think.

Thank you very much for responding!!!!.....but it isn't working....I know how 
to set up the Header under file--page set up---but I'm not finding any 
"select all sheets" anywhere.......  I've tried right clicking all over the 
place and cannot find the select all sheets....... what am i missing???  I 
use Excel all the time and am pretty literate in it, but am totally stymied 
by this.  Thanks again for trying to help me!! 

"YESHWANT" wrote:

> if u want to format header and/or footer for all sheets in an given workbook,
> open the file, on the sheet tab right click and click on "select all sheets" 
> and the n do as already explained i.e. click on file, page setup, 
> header/footer, carry out necessary changes and u r at home, i think.
> 
> 
> -- 
> learn - n - enjoy
> -------------------------------------
> click yes below, if it works for you
> 
> 
> "Bons" wrote:
> 
> > In 2003 how do I show the Header (the Custom Header -- NOT the column 
> > headings) on all pages?  I KNOW I've done this in the past, but cannot 
> > remember how I did that.  Thanks in advance---I KNOW one of you geniuses will 
> > know the answer to this! 

Right-click on the Tab of the sheet (the one at the bottom showing the name 
of the sheet). It gives you the Select All Sheets option.

Regards,
Fred

"Bons" <Bons@discussions.microsoft.com> wrote in message 
news:D522B4AE-2198-40B8-A8C5-2669B552303F@microsoft.com...
> Thank you very much for responding!!!!.....but it isn't working....I know 
> how
> to set up the Header under file--page set up---but I'm not finding any
> "select all sheets" anywhere.......  I've tried right clicking all over 
> the
> place and cannot find the select all sheets....... what am i missing???  I
> use Excel all the time and am pretty literate in it, but am totally 
> stymied
> by this.  Thanks again for trying to help me!!
>
> "YESHWANT" wrote:
>
>> if u want to format header and/or footer for all sheets in an given 
>> workbook,
>> open the file, on the sheet tab right click and click on "select all 
>> sheets"
>> and the n do as already explained i.e. click on file, page setup,
>> header/footer, carry out necessary changes and u r at home, i think.
>>
>>
>> -- 
>> learn - n - enjoy
>> -------------------------------------
>> click yes below, if it works for you
>>
>>
>> "Bons" wrote:
>>
>> > In 2003 how do I show the Header (the Custom Header -- NOT the column
>> > headings) on all pages?  I KNOW I've done this in the past, but cannot
>> > remember how I did that.  Thanks in advance---I KNOW one of you 
>> > geniuses will
>> > know the answer to this!