How Excel applies one worksheet format to all worksheets in batch

When setting and formatting worksheets, you should all meet the need to set the same format for all worksheets once. I believe your settings are basically one by one. Today, the Excel Tutorial Network will share with you how Excel applies a worksheet format to all worksheets in batches. Let's have a look!
Tutorial method:
1. Open a worksheet
2. We select the area with data
3. Move the mouse down to the position of the worksheet label, and click the right mouse button to pop up the effect as shown in the figure
4. Select, select all sheets
5. We will find that all three worksheets have been selected
6. Move the mouse up and select the Start tab on the ribbon
7. In the editing area, select, fill, and pop up as shown in the figure
8. In a new dialog box, I select a group worksheet
9. A new alignment box pops up, and we select the format
10. Yes, our work is finished