What are the other uses of Excel format brushing?

The original title: "after using Excel for such a long time, you still don't know that the format has these uses?" "

Everyone must have used "format brush". In fact, it is not as simple as we thought. It is used so many that even friends who often use Excel may not know it. Let's have a look together.

1, copy format Click format brush can be copied to use the format, double-click can be unlimited copy format, press the "Esc" key to exit the format brush state.

2. Copy the whole row and column format. Sometimes, we can also copy the formatting effect of filling the whole row and column.

3. Copy format and data format brush in Excel can not only copy format, but also copy data. Select the table area, then double-click format Brush, position the cursor in the target cell, click, and then enter.

4, batch copy wage bar format Excel format brush can also fill all the forms interlaced at once. Take the payroll form as an example, if you want to fill the interlaced pattern, you can use the format brush to do it at once.

5, copy the entire worksheet style there are multiple worksheets need to be set the same format, we can select the entire worksheet, and then double-click the format brush, and then click in other worksheets.

6. Find and replace can also use format brush. sometimes, if you want to fill the format with the content you want, we can use "find and replace" and "format brush" to do it together. First select a cell, add the effect you want, and then double-click "format brush", "Ctrl + H" to open search and replace, enter the search content, click "find all", and then "Ctrl + A" can add effects to all the content.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi