Shulou(Shulou.com)06/01 Report--

Editor to share with you how to use the excel format brush, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

When using excel to deal with some data, we often have to copy and paste the external data into the excel, but the external data will sometimes have different formats, destroying the overall cleanliness of the table, so we can use format brushing to remove the format and complete the unification. How to use excel format brush? Let's get to know it.

The first one: click the format brush tool. Select the cell you have set up, for example, look at the picture below. I choose the cell E148, that is, the sales volume of "Zhang San". Then click "format Painter tool", which will change the cursor to a "small brush", directly click on the cell you want to change, and that cell will become the same format as E148.

Note: after brushing this cell, the light change will return to its original state. Oh, you can't brush other cells any more.

The second kind: double-click the format brush tool. Use it in the same way as aspects, except that it double-clicks the format brush tool. You will see that after you have brushed a cell in the format, the cursor still looks like a "small brush", and you can brush as many cells as you want, no limit.

Note: at this time, if you do not want to brush, you can choose to click the format brush tool to restore the normal cursor.

The above is all the contents of the article "how to use excel format Brush". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.