How to find and mark the same data in Excel How to find and mark the same data in Excel

When we use Excel tables to process data, we often need to find the same data and mark it in red to avoid confusion. If there is a lot of data, it is easy to get confused, so how should the operation be more convenient? Next, the editor will sort out the methods for finding and marking the same data in Excel. If you are interested, don’t miss it. Operation method 1. Open the Excel table that needs to find the same data and mark it, click on the same data that needs to be found, and click [Fill Color] under [Start].

2. After filling the background color of the data with red, double-click the [Format Painter] function, and a green dotted frame will appear.

3. Then find the [Find and Replace] function, you can also use the shortcut keys: Ctrl+F, Ctrl+H, enter the data you want to find in [Search], and click [Find All].

4. In the found data, click to mark the same data. Each time you click on an item, it will be marked.

The above is the detailed content of How to find and mark the same data in Excel How to find and mark the same data in Excel. For more information, please follow other related articles on the PHP Chinese website!