Formatting Multiple Sheets / Worksheets in Excel at once.

How to apply same formatting or conditional formatting to multiple excel sheets / worksheets at once? Change formatting multiple worksheets at once / in one attempt in Excel 2007 or MS Excel. How to insert same data in multiple sheets / worksheets in Excel at once. (+Microsoft Excel Tips and Tricks )

Sometimes we need to apply same format to all existing Microsoft Excel worksheets in a Workbook. So, here is a question, how to change or apply same format to all the excel sheets in one attempt / at once.
Suppose you have a four worksheets in your excel workbook, Sheet1 / sheet 1 has some formatting cells / range and you want to apply the same formatting to all the excel sheets in only one attempt. It's very simple, to give same formatting as Sheet1 contains follow the give below steps and you can formatting your all excel sheets same formatting at once.

1) Right click on one of the worksheets tabs (Sheet 1 here).

2) Choose select all sheets.

3) After choosing all sheets, any formatting you apply or any text you enter, will show up on all the worksheets in your excel workbook.

If you want to eliminate or exclude any / certain sheets from the changes, Deselect those sheets by Holding down the CTRL key and click on the sheet tab of your worksheet you want to exclude from the others.

NOTE:- By holding the SHIFT key and selecting the worksheet tab, you can also group excel sheets / worksheets.