ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I show the Header on all pages? (https://www.excelbanter.com/excel-discussion-misc-queries/257986-how-do-i-show-header-all-pages.html)

Bons

How do I show the Header on all pages?
 
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!

Gord Dibben

How do I show the Header on all pages?
 
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
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.




All times are GMT +1. The time now is 09:19 AM.

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