formatting all worksheets in a workbook identical

[aamir]

i have eight sheets in a worbook---they have headers, footers, row heights,
column widths, font sizes, etc. can I format these so that everything
appearance, layout, margins, etc. are identical on the eight sheets. Of
course, the text or figures un the cells would be different

thank you very much

 

[Gord Dibben]

Select a sheet.

Right-click on sheet tab and "select all sheets"

Do what you wish for formatting to active sheet and will be done to all.

DO NOT FORGET to ungroup the sheets when formatting is done.


Gord Dibben MS Excel MVP

 

[aamir]

Thank you very much.One thing I noted---it is importent that the nimber of
rows on each sheet need to be the same. if sheet 1 has 45 rows ,and sheets 3
and 4 have 59, that messes things a tle. Then you have to do a page break to
again bring the number rows as equal as possible in the different sheets

Regards
Aamir

 

[Gord Dibben]

If you are talking about setting the Print Range the same on all sheets you
will have to use VBA to achieve that.

There are some print setups that cannot be done on grouped sheets.

Print Range, rows to repeat at top are included in these "some"

Page Breaks would be a function of your print range being replicated..

You must use VBA code to do that.

For anyone interested in the code see this google search result with Dave
Peterson and myself posting. The print area code is from Bob Flanagan.

http://snipurl.com/106kz


Gord Dibben MS Excel MVP

 

[Blkdymon]

How do I ungroup the sheets?

Select a sheet.

Right-click on sheet tab and "select all sheets"

Do what you wish for formatting to active sheet and will be done to all.

DO NOT FORGET to ungroup the sheets when formatting is done.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Click on any non-active sheet tab or right-click and "Ungroup sheets"


Gord