How to selecting and formatting all sheets together

[Sarfraz Khan]

dear sir,

In my workbook I have 30 worksheets I wanted to select all together and format in a same way.

eg : unmerged all data, color 1st line etc.

 

[Ajesh]

If all the sheets are identical, just click on the first sheet tab>>Hold down Ctrl Key>>Click on Last sheet (Or click on sheet tab of the ones you want to be grouped)
This will group all the selected sheets and any changes you make to the Active sheet will be done on all the sheets grouped.

To ungroup, just click on any sheet outside the group. If all the sheets are in group, click on sheet other than the active sheet.

Thanks,
Ajesh

 

[Asheesh]

Check the below link

http://chandoo.org/wp/2010/11/15/formatting-multiple-sheets/