The main role of the format brush in Excel is to copy a format (or region) format (font, font, row, column width, etc.) applied to other areas, and select the above cells, click the format brush to take out Location or text format of the selected content, the cells that use this brush to brush a wording of the text format.
However, each time the brush is finished, the format brush becomes unavailable. If you want to repeat the replication format, you must repeat the above process. There is a method to avoid the above-mentioned cumbersome steps: By double-click format, you can copy the selected format to multiple locations. To close the format brush, press the "ESC" button or click the Format Brush again (this method also applies to Word). http://www.5238001.com/jqzj/czjq/excel.htm