Microsoft Excel Interview Question:

Is there a way to apply the same formatting to every sheet in a workbook in Excel?

Submitted by: Administrator

Yes. To do this, you will need to right click on one of the worksheet tabs and then choose Select All Sheets. After you do this any formatting that you apply or text you enter will show up on all the sheets in your workbook. In order to eliminate certain sheets from the changes, hold down the Ctrl key and click on the tab of the worksheet you want excluded from the others. You can also group sheets by holding the shift key and selecting the worksheet tab.
Submitted by: Administrator