Format multiple Worksheets Simultaneously
 

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.

Format multiple Worksheets Simultaneously
 

Hold the CTRL key and select all the worksheet tabs to which you want to
apply the formatting. This groups the sheets. Apply your formatting.

Then when you are done, right-click on one of the tabs and select ungroup
sheets.
--
Brevity is the soul of wit.


"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.

Format multiple Worksheets Simultaneously
 

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.