Hi,

Do the following:

1. Open the Workbook.
2. Click the first Worksheet and then press the Ctrl and click on other
sheet.
This will help you group all the worksheet.

Now if you perform any editing on the sheet, then all worksheet will be
edited simultaneously.

If youwant to ungroup all the worksheet, then press the Ctrl key and then
click each worksheet individually.

Challa Prabhu

"Daniel" wrote:

How can I format all worksheets in an excel file? I am tired of format every
worksheet and the format go to default when I refresh data!
Daniel