SUPPOSE you'd like to put a company heading on all the sheets in your Microsoft Excel workbook. You can do this all at the same time. Simply follow these steps:

1) Right-click on a tab and choose "Select All Sheets"

2) Type the company heading on the first sheet

3) Right-click on the current tab, and choose "Ungroup Sheets"

4) The heading will appear in the same place on all the sheets in the workbook.