How to Apply Format Changes to All Tabs in an Excel Spreadsheet

Microsoft Excel has a feature that allows you to make changes to multiple sheets within a workbook simultaneously. This feature is useful for filling in or creating a form in Excel, or quickly ensuring that formatting is consistent throughout the workbook.

Businesswoman typing on computer
credit: BananaStock/BananaStock/Getty Images

Step

Right-click on the tab of any of the sheets within the workbook you intend to change.

Step

Click “Select All Sheets.” You can confirm that the sheets are selected as a group because “Group” will appear in the title bar at the top of the worksheet. Additionally, the color of the tabs of the sheets that are selected will be different than the sheets that are not selected.

Step

Make changes to the format on the active sheet. For example, if you want to have bold text throughout all of the sheets, once you have selected all of the sheets, select all of the cells on one sheet and hold down Ctrl + B, or alternatively select “Bold” from the Format menu. When the sheets are grouped together, any changes you make to one sheet will be mirrored in all of the other sheets.

Step

Right-click on any one of the sheets that are already selected and select “Ungroup Sheets” when you are finished with your changes. This ensures that you do not continue to make changes to the workbook when you do not intend to.