formatting all worksheets in a workbook identical
 

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

formatting all worksheets in a workbook identical
 

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

On Thu, 25 Dec 2008 20:15:00 -0800, aamir
wrote:

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
 

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


On Fri, 26 Dec 2008 14:54:01 -0800, aamir
wrote:

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

formatting all worksheets in a workbook identical
 

How do I ungroup the sheets?

"Gord Dibben" wrote:

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

On Thu, 25 Dec 2008 20:15:00 -0800, aamir
wrote:

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

formatting all worksheets in a workbook identical
 

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


Gord

On Sun, 28 Dec 2008 19:20:00 -0800, Blkdymon
wrote:

How do I ungroup the sheets?

"Gord Dibben" wrote:

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

On Thu, 25 Dec 2008 20:15:00 -0800, aamir
wrote:

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