Bob

Select first sheet then right-click on sheet tab and "Select all sheets"

Do the formatting on active sheet and will be done to all.

DO NOT FORGET to right-click and "ungroup sheets" when your formatting operation
is done.


Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 07:23:00 -0800, Bob wrote:

How do I format multiple Excel worksheets simultaneously? I want to format
the first worksheet and have those format settings applied to all worksheets
in the workbook.