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
|