--- title: "How can you apply the same formatting to every sheet in a workbook in MS-Excel?" description: "How can you apply the same formatting to every sheet in a workbook in MS-Excel?" author: "Steilla Mitchel" published: 2022-03-25 canonical: https://answers.mindstick.com/qa/96538/how-can-you-apply-the-same-formatting-to-every-sheet-in-a-workbook-in-ms-excel category: "troubleshooting" tags: ["troubleshooting", "excel"] reading_time: 2 minutes --- # How can you apply the same formatting to every sheet in a workbook in MS-Excel? How can you [apply](https://www.mindstick.com/articles/13148/discover-to-apply-make-up-like-a-professional-supermodel) the same formatting to every sheet in a workbook in MS-Excel? ## Answers ### Answer by Hitesh Vohra - A feature in Microsoft [**Excel**](https://answers.mindstick.com/qa/96517/what-is-ribbon-and-where-does-it-appear-in-excel) allows you to make changes to several sheets in a workbook at the same time. This function is important for quickly filling out or constructing a form in Excel, as well as ensuring that formatting is uniform across the entire file. - Right-click on the tab of any of the sheets you want to alter in the workbook. - Select all sheets by clicking **'Select All Sheets.**' The word 'Group' will show in the title bar at the top of the worksheet, indicating that the sheets are selected as a group. Additionally, the tabs of the selected sheets will be a different colour from the tabs of the pages that are not selected. - Make modifications to the active sheet's format. When you're satisfied with your adjustments, right-click on any of the sheets that are already chosen and select 'Ungroup Sheets.' This prevents you from making modifications to the worksheet that you didn't mean to make. \ **Read More: [What is the quick way to return to a particular area of a excel worksheet?](https://answers.mindstick.com/qa/96539/what-is-the-quick-way-to-return-to-a-particular-area-of-a-excel-worksheet)** --- Original Source: https://answers.mindstick.com/qa/96538/how-can-you-apply-the-same-formatting-to-every-sheet-in-a-workbook-in-ms-excel Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.